Installing various Database Components
col COMP_ID for a20 col VERSION for a15 col STATUS for a10 col COMP_NAME for a40 select COMP_ID, COMP_NAME, VERSION, STATUS from DBA_REGISTRY order by STATUS ; @?/rdbms/admin/utlrp col OWNER…
Read MoreORA-00309: log belongs to wrong database
Message: ORA-00309: log belongs to wrong database Cause: The system cannot access the archived redo log because it belongs to another database. Action: Specify the correct redo log file, then…
Read MoreORA-17502: ksfdcre:4 Failed to create file “FILE NAME” / ORA-15173: entry ‘string’ does not exist in directory ‘string’
RMAN> restore spfile from ‘+FRA/SRPRIMT/AUTOBACKUP/2016_07_10/s_788290484.315.788290487’; Starting restore at 10-JUL-16 using channel ORA_DISK_1 channel ORA_DISK_1: restoring spfile from AUTOBACKUP +FRA/SRPRIMT/AUTOBACKUP/2016_07_10/s_788290484.315.788290487 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================…
Read MoreConverting into RAC instance
Converting into RAC instance Add separate Undo Tablespaces First, Create 2 UNDO tablespaces for the 2 instances.PLINKTST1 > create undo tablespace UNDOTBS1 datafile ‘+PWTEST_DATA’ size 100M autoextend on next 50M…
Read MoreORA-12720: operation requires database is in EXCLUSIVE mode
SQL> @create_ctrl.sql CREATE CONTROLFILE REUSE DATABASE “TEST” RESETLOGS FORCE LOGGING ARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-12720: operation requires database is in EXCLUSIVE mode SOLUTION After…
Read MoreChanging the heap size of the OMS in EM12c
The Java heap memory utilization for your Oracle Management Service (OMS) should be averaging at under 75%, and anything over this could mean the Garbage Collection starts impacting the performance of…
Read MoreTo change timeout settings in cluster
CSS ADMINISTRATION: crsctl get css diagwait The time limit is to update the respective output logfiles for every process. crsctl get css disktimeout Disk Latencies in seconds from node-to-votedisk. Default Value…
Read MoreTo check the master node in RAC environment
In 3 node RAC setup,In initial stage–node 3 is the master node. [oracle@host01 ~]$ cat $ORACLE_HOME/log/host01/cssd/ocssd.log |grep ‘master node’ |tail -1 2016-09-24 10:14:36.949: [ CSSD][2778696592]clssgmCMReconfig: reconfiguration successful, incarnation 248954981 with 3 nodes,…
Read MoreError: Primary database is in MAXIMUM PERFORMANCE mode
Error: RFS[4]: No standby redo logfiles of size 102400 blocks exist Fix: In standby database, standby redo logs on the standby database and the online redo logs on the primary database are…
Read MoreUnreachable Alerts in OEM with error meassage as ‘Agent to OMS Communication is broken’
Sometimes, we can see number of alerts stating that OEM is unable ping agent(Agent Unreachable) But when we the check the status of the agent ,it shows up and and…
Read More