Skip to main content

Posts

Add disk in virtual box vm

 Add disk in virtual box vm  In this post, we will check how to add disks in Virtual Box VM.  1. First add the disk from VM console as a new HDD as shown below: We have recently added oel76_db1.vdi disk. 2. Once the disk is added, it will be visible in fdisk -l command output.  3. create the partion using below command fdisk /dev/sdb  for new partion : type n,  to list partition : type p to write the partion : type w 4. Format the partition by below command: Now format the disk with  mkfs  command. # mkfs.ext4 /dev/sdb1 [root@oel76 etc]# mkfs.ext4 /dev/sdb1 mke2fs 1.42.9 (28-Dec-2013) Filesystem label= OS type: Linux Block size=4096 (log=2) Fragment size=4096 (log=2) Stride=0 blocks, Stripe width=0 blocks 15032320 inodes, 60108800 blocks 3005440 blocks (5.00%) reserved for the super user First data block=0 Maximum filesystem blocks=2208301056 1835 block groups 32768 blocks per group, 32768 fragments per group 8192 inodes per group Superblock backu...

Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/soft/ebs/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

Error while launching rapidwiz during EBS 12.2 Installation  Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/soft/ebs/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory [oracle@oel76 rapidwiz]$ Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/soft/ebs/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory         at java.lang.ClassLoader$NativeLibrary.load(Native Method)         at java.lang.ClassLoader.loadLibrary0(Unknown Source)         at java.lang.ClassLoader.loadLibrary(Unknown Source)         at java.lang.Runtime.load0(Unknown Source)         at java.lang.System.load(Unknown Source)         at java.lang.ClassLoader$NativeLibrary.load(Native Method) ...

/lib/ld-linux.so.2: bad ELF interpreter: No such file or directory - while building stage during 12.2

 /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory Cause The Linux box is on a 64-bit system, and does not have 32-bit library support installed. Resolution Make sure glibc.i686 and glibc.x86_64 is installed on the system. If glibc.i686 is not available on the Centos-6, try glibc.i386 To list all the package with prefix "glibc" Run: yum list glibc. To install the package: Run sudo yum install glibc.i686 or sudo yum install glibc.i386 If you do not have sudo setup in the environment, type "su" to accquire superuser authority first. Then run: yum install glibc.i686

ORA-12777: A non-continuable error encountered.

 ORA-12777: A non-continuable error encountered.  Check the error stack for additional information [ksm_check_ob_paths:1], [ORACLE_BASE], [], []. After moving the 19c Database Oracle Home to new location, i relinked the binaries and then tried to start up the database.  Got the below error: ORA-12777: A non-continuable error encountered.  Check the error stack for additional information [ksm_check_ob_paths:1], [ORACLE_BASE], [], []. Solution: Correct the path of Oracle Home in the  orabasetab file under $ORACLE_HOME/Install location e.g  oraprod@erpdbpreprod1:/u01/app/oracle/product/19.0.0/dbhome_3/install$ cat orabasetab #orabasetab file is used to track Oracle Home associated with Oracle Base /u01/app/oracle/product/19.0.0/dbhome_3:/u01/app/oracle/product/19.0.0:SPROD_DB__u01_app_oracle_product_19_0_0_dbhome_3:N: Note: dbhome_1 was corrected to dbhome_3 

19c RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

 19c RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Before doing an RMAN DUPLICATE DATABASE from an Active Database, we need to set up listener on the target environment with static registration.  Else when the RMAN shuts down the auxiliary database for creating spfile or making changes in it, it will not be able to connect the auxiliary and start the database (nomount) and throw the error : RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor To Solve this issue ensure that listener is configured with static registration using the below syntax : ========= LISTENER.ORA================== EBSUPG =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST =<hostname>)(PORT = 1536))       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1536))   ...

ORA-01111: name for data file 975 is unknown - rename to correct file MRP0: Background Media Recovery terminated with error 1111

 ORA-01111: name for data file 975 is unknown - rename to correct file  MRP0: Background Media Recovery terminated with error 1111 Issue:  Standby database throws below errors and stops the MRP.  MRP0: Background Media Recovery terminated with error 1111 Errors in file /u01/app/oraprod/diag/diag/rdbms/sprod/SPROD1/trace/SPROD1_pr00_23061.trc: ORA-01111: name for data file 975 is unknown - rename to correct file ORA-01110: data file 975: '/u01/app/oraprod/11.2.0.4/dbs/UNNAMED00975' ORA-01157: cannot identify/lock data file 975 - see DBWR trace file ORA-01111: name for data file 975 is unknown - rename to correct file ORA-01110: data file 975: '/u01/app/oraprod/11.2.0.4/dbs/UNNAMED00975' Recovery Slave PR00 previously exited with exception 1111 Solution: - Please cancel the managed recovery by SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; - Set standby_file_management=manual SQL>ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL; If the physical standb...

Fatal Error: TXK Install Service RW-50010: Error: - script has returned an error: /bin/sh: error importing function definition for `which'

Fatal Error: TXK Install Service   RW-50010: Error: - script has returned an error:  /bin/sh: error importing function definition for `which' Description: R12.2 Installation fails during Install web Tier.  ------------------------------------------------------ Fatal Error: TXK Install Service oracle.apps.fnd.txk.config.ProcessStateException: OUI process failed : Exit=1 See log for details. CMD= /u01/soft/ebs/TechInstallMedia/ohs11119/Disk1/runInstaller -waitForCompletion -ignoreSysPrereqs -force -silent  -responseFile /u01/oracle/tstebs/fs2/inst/apps/tstebs_ebs22/temp/cfgHome/response/APPS_OHS_HOME/txkOHS_11119.rsp     at oracle.apps.fnd.txk.config.OUIPatchActionNode.processState(OUIPatchActionNode.java:159)     at oracle.apps.fnd.txk.config.PatchActionNode.processState(PatchActionNode.java:187)     at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:338)     at oracle.apps.fnd.txk.config.PatchesNode.proces...

Oracle E-Business Suite Preinstallation RPM (Oracle Linux 8)

  Oracle E-Business Suite Preinstallation RPM (Oracle Linux 8) To install the Oracle E-Business Suite Preinstallation RPM (Oracle Linux 8), please follow below steps: For Oracle Linux 8, review the  documentation on DNF and repository configurations , perform the following commands to install the preinstallation rpm using the DNF utility, and then skip to Step 4: # dnf install oraclelinux-release -y # dnf config-manager --set-enabled ol8_addons # dnf install oracle-ebs-server-R12-preinstall.x86_64 Ref:  Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)  

RW-50010: Error: - script has returned an error: 2 Unable to execute cr9idata.pl while doing fresh installation of EBS 12.2 on Linux

 RW-50010: Error: - script has returned an error:   2 Unable to execute cr9idata.pl while doing fresh installation of EBS 12.2 on Linux  Description: Fresh Installation of EBS 12.2 on Linux using RapidWizard Unable to execute cr9idata.pl     RW-50010: Error: - script has returned an error:   2 RW-50004: Error code received when running external process.  Check log file for details. Running Database Install Driver for dev instance Solution: [root@ebs122 ~]# yum list perl-File-CheckTree* Last metadata expiration check: 20:30:22 ago on Thu 03 Mar 2022 12:47:32 AM +03. Available Packages perl-File-CheckTree.noarch                                                                       4.42-303.el8                     ...

12.2 Stage area creation fails with startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java: No such file or directory

 12.2 Stage area creation fails with startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java: No such file or directory While creating the stage area for 12.2 Installation, we face issue while running the buildstage.sh ....startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java: No such file or directory Solution:  Please go to the path provided in the error log and check if the java is working fine with below command: java -version Generally this java is having some issues.   Install the jre 7 or jre 8 and copy the the jre at the same path by renaming old folder. It should work fine.  Now if your run the build command again, it should succeed.  Running command: /u01/soft/ebs/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /u01/soft/ebs/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/u01/soft/ebs/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/u01/soft/ebs/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/u01/soft/ebs/star...

RMAN Duplicate Database fails with ORACLE error from auxiliary database: ORA-00600: internal error code, arguments: [krbi_init_fra_metadata_not_backup_ctl]

 RMAN Duplicate Database fails with ORACLE error from auxiliary database: ORA-00600: internal error code, arguments: [krbi_init_fra_metadata_not_backup_ctl] Issue: While using RMAN Duplicate Database from Standby Database to clone fails with below error: ORACLE error from auxiliary database: ORA-00600: internal error code, arguments: [krbi_init_fra_metadata_not_backup_ctl] This is known bug as per MOS  Bug 21641760 However the oracle support gave below suggestion to try and it worked.  Disable FRA ie alter system set db_recovery_file_dest='';

RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

  RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Issue:  Trying to clone a database using Duplicate Database from Active Database.  rman is not able to connect from active database and gives below error: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Solution:   1. Copy the password file from Active database and rename it to match the SID of the clone.  2. Create a static listener in the listner.ora as shown below  3 start the listener.  LISTENER_EBS_2PRE =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS_LIST =         (ADDRESS = (PROTOCOL = TCP)(HOST = erpdbpreprod1-vip)(PORT = 1571)(IP = FIRST)))       (ADDRESS_LIST =         (ADDRESS = (PROTOCOL = TCP)(HOST = erpdbpreprod1)(PORT = 1...

RMAN Backup fails with archivelog not found error ORA-19625: error identifying file

 RMAN  Backup fails with archivelog not found error ORA-19625: error identifying file Connect to RMAN promp $ rman target /  $ crosscheck archivelog all; $ delete obsolete Got following error :  RMAN-03002: failure of delete command at 01/06/2022 18:09:45 RMAN-06091: no channel allocated for maintenance (of an appropriate type) Solution: Allocate channel for maintenance type for each device type $ rman target / RMAN>  allocate channel for maintenance device  TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; using target database control file instead of recovery catalog allocated channel: ORA_MAINT_SBT_TAPE_1 channel ORA_MAINT_SBT_TAPE_1: SID=756 instance=prd1 device type=SBT_TAPE channel ORA_MAINT_SBT_TAPE_1: Veritas NetBackup for Oracle - Release 8.3.0.1 (2020081919) RMAN> allocate channel for maintenance device type disk; allocated channel: ORA_MAINT_DISK_2 channel ORA_MAINT_DISK_2: SID=883 instance=prd1 device type=DISK RMAN...

ORA-23515: Materialized Views and/or Their Indices Exist in the Tablespace

  ORA-23515: Materialized Views and/or Their Indices Exist in the Tablespace While dropping any Tablespace, you might get the errror  ORA-23515: Materialized Views and/or Their Indices Exist in the Tablespace This is due to the fact that the tablespace contains the indexes or Materialized views You may use the following queries to find out which materialized views and/or which indeces of materialized view container tables are on the tablespace you intend to drop. Once these objects are found you can move the tables, rebuild indeces in other tablespace.  select s.sowner MV_OWNER, s.tname MV_NAME, p.name TABLESPACE   from sys.obj$ o, sys.tab$ t, sys.user$ u, sys.snap$ s , sys.ts$ p   where t.ts#=p.ts# and p.name='<tablespace_name>'   and t.obj#=o.obj# and o.owner#=u.user# and u.name=s.sowner and o.name=s.tname   order by 1,2; select o.owner, o.object_name index_name, o.object_type, sq.mv_owner,sq.mv_name,sq.tablespace   from dba_objects o, ...

ORA-20000: Unable to set values for index does not exist or insufficient privileges while importing schema from 12c to 19c

  ORA-20000: Unable to set values for index <INDEX_NAME> does not exist or insufficient privileges while importing schema from 12c to 19c Importing statistics failed for 1 object(s);  While importing Schema objects from 12c Oracle Database to 19c Oracle Database, we face the above issue CAUSE  This problem is fixed by unpublished BUG 27761685. SOLUTION To avoid the issue use the workaround: - Add include=index while executing expdp   and - Add include=statistics while executing impdp expdp USER_A/USER_A directory=test_dir dumpfile=exp_data.dmp include=statistics,index tables=btree_tbl reuse_dumpfiles=y impdp USER_B/USER_B directory=test_dir dumpfile=exp_data.dmp remap_schema=user_a:user_b include=statistics Reference: ORA-20000 Unable to Set Values for Index XX: Does Not Exist or Insufficient Priv is Raised While Executing Impdp (Doc ID 2176364.1)