SCRIPT TO VIEW WHICH DATABASE INSTANCE IS RUNNING CURRENTLY
SCRIPT TO VIEW WHICH DATABASE INSTANCE IS RUNNING In this tutorial, we going to learn about to find which database instance is running now. Mostly we use “/etc/oratab” to view…
Read MoreEasy way to find SID in database using basic information
There are many scenarios, DBA struggling to identify the sessions running in database on sudden adhoc request. To capture the session quickly with the information what we get is really…
Read MoreORACLE EBS 12.1.3 JDBC CONNECTION LOCK ISSUE
Issue: This homepage feature got a new bug with 12.1.3. This bug only affects EBS 12.1.2 and 12.1.3 customers who have OAMainMenuRESTHandler.class version 120.0.12010000.18. $ strings -a $JAVA_TOP/oracle/apps/fnd/framework/webui/rest/OAMainMenuRESTHandler.class|grep Header [$Header:…
Read MoreCommVault Backup failed due to connectivity issues in RAC
Issue: The Commvault issue is reporting saying that first node connection is fine and rest all the 2 nodes is not connecting. Solution: The following are the key points that…
Read MoreORA-1653: unable to extend table SYS.AUD$ by 5314958 in tablespace SYSTEM
Issue: DB reported slowness with the following error in DB ORA-1653: unable to extend table SYS.AUD$ by 5314958 in tablespace SYSTEMORA-1653: unable to extend table SYS.AUD$ by 5314958 in tablespace…
Read MoreKey points to look about TDE Wallet on Bare metel during backup failure.
Database backups fail if the TDE wallet is not in the proper state. The following scenarios can cause this problem If the database was started using SQL*Plus, and the ORACLE_UNIQUENAME environment…
Read MoreTimeout Error Encountered for pasteBinary.sh While Running “adop phase=fs_clone”
When adop phase=fs_clone throws below error : Enabling EBS_LOGON trigger Error while executing [filesystem]/fs2/inst/apps/[context_name]/appltmp/alter_ebs_logon_trigger.sql Failed to enable EBS_LOGON trigger *******FATAL ERROR******* PROGRAM : ([filesystem]/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl) TIME : Mon Nov 11 15:47:51…
Read MoreCould not perform the Post Patch instructions of an ETCC recommended patch 26825525.. don’t worry !!
SPECIAL INSTRUCTION for formsapp.ear as part of 10.1.2 forms component in R12 : To complete the application of Patch, please follow these instructions for Application Server middle tier (including Forms/Reports…
Read MoreCloning With Adcfgclone.pl Fails While Creating New WLS Domain On Target
When attempting to run adcfgclone.pl, the following error occurs : ApplyAppsTier<<date>>.log shows: START: Creating new WLS domain. Running /U01/app/applmgr/UAT/fs2/FMW_Home/oracle_common/bin/pasteConfig.sh…… Script Executed in 30555 milliseconds, returning status 255 ERROR: Script failed,…
Read Moreadop prepare phase failed while running Autoconfig due to ADOP_VALID_NODES
ADOP Prepare phase failed with below error while running autoconfig on Patch Edition. Error: ERROR at line 1: ORA-20001: Synonym does not point to an editioning view: ADOP_VALID_NODES ORA-06512: at…
Read More