Database Blog

Untitled

Cannot identify any valid application tier nodes in ADOP_VALID_NODES  Issue: PROGRAM : (/u01/oracle/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ] ERRORMSG: Cannot identify any valid application tier nodes in…

Read More

Untitled

       Weblogic Server 12.1.2 Performance Issue Due To weblogic.socket.NIOSocketMuxer Weblogic server 12.1.2 in a runnable state consuming high CPU resources. Error: “LDAPConnThread-579 ldaps://ldapserver.us.oracle.com:636” daemon prio=10 tid=0x00000000041f6800 nid=0x56d7 runnable…

Read More

Untitled

                                 ERRORS During 12.2.4 Upgrade Error 1: If WF_DEFERRED_R Invalid then upgrade patch 12.2.4 failed…

Read More

Untitled

     OID EMCTL Agent not starting due to Daylight Savings Timezone Issue The issue was actually because of incorrect timezone daylight savings updates in the installed JDK and JRE…

Read More

Untitled

           OIDMOS status stop and OID not starting up after crash Our system has a system shutdown in which OID 11.1.1.9 was running and not starting…

Read More

Identical parameters in RAC

Parameters that must have identical in RAC database: In a RAC database there may contain several instances and the initialization parameters of all of the instances should not have identical…

Read More

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

During startup,ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance. SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 2147483648 bytes…

Read More

ORA-12541: TNS:no listener

ORA-12541: TNS:no listener ************************ Resolution: Now you have to follow below mentioned steps to resolve the ORA-12541 issue. STEP-1: First check your listener status. ********************************* C:>lsnrctl status The above command…

Read More

Ora-12560: TNS: protocol adapter error

Ora-12560: TNS: protocol adapter error ************************************************  Make sure that you have set the correct ORACLE_SID: C:>sqlplus system/manager@orcl SQL*Plus: Release 11.2.0.2.0 Production ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: C:>set ORACLE_SID=orcl…

Read More

Untitled

ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB” Error in Alert-Log : ORA-12012: error on auto execute of job “SYS”.”BSLN_MAINTAIN_STATS_JOB” ORA-06502: PL/SQL: numeric or value error ORA-06512: at “DBSNMP.BSLN_INTERNAL”, line…

Read More