Skip to main content

Posts

Showing posts from 2022

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 
Post a Comment
Read more

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))   ...
Post a Comment
Read more

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...
Post a Comment
Read more

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...
Post a Comment
Read more

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)  
Post a Comment
Read more

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                     ...
Post a Comment
Read more

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...
Post a Comment
Read more

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='';
Post a Comment
Read more

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...
Post a Comment
Read more

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...
Post a Comment
Read more