Database Solutions

 Today We come across an issue where we were unable to stop database using srvctl and session for the srvctl hands.  While checking the status for the instance, we found that STATE for Instance was "Monitor disable" and srvctl saying database is running.  srvctl status database -d dbm Instance dbm1 is running on node node1   Instance  dbm2  is running on node node2 ora.dbm.db      1        ONLINE  ONLINE        node1        MONITOR DISABLED,STABLE      2        ONLINE  ONLINE        node2         MONITOR DISABLED,STABLE Cause:  Seems the agent had issues in the past leaving the resource in MONITOR DISABLED, which is preventing to manage the DB. We do not have the information to understand the reason why the resource went into that state Solution: Kill...

Oracle RAC Grid Cluster Upgrade As 12c Database version coming to EOS , it become important for DBAs to upgrade Oracle database and Grid Clusters to 19c. In this blog , We have come up with the steps to upgrade the Oracle RAC Grid Cluster.  Follow below steps to upgrade Oracle RAC Grid Cluster. 1)  Take backup of ASM information and ASM metadata backup. set line 240 col path for a30 col compatibility for a40 select INST_ID,group_number,NAME,COMPATIBILITY,STATE,total_mb,free_mb from gv$asm_diskgroup order by name; set line 240 col path for a30 select group_number,NAME,COMPATIBILITY,STATE,total_mb,free_mb from v$asm_diskgroup; set lines 200 pages 200 col name for a30 col path for a40 select name,path,state,mount_status,header_status from v$asm_disk order by path; set lines 200 set pages 9999 col path for a40 SELECT inst_id,name, header_status,OS_MB,TOTAL_MB,path FROM GV$ASM_DISK WHERE header_status <> 'MEMBER' order by OS_MB; ASM Metadata backup : ASMCMD [+] > md_backup...

Oracle RAC - Apply patch with Standby in Configuration  DBAs have to apply patches quarterly as the PSU patch have been released. In order to make task easy, We have come up with steps to Patch RAC environment with standby in configuration.  Below are the steps and details:   Environment Details: Nodes to be Patched: Primary Node 1 - PRIMARYRAC01 Node 2 - PRIMARYRAC02 DB to be patched: test,abd Standby Node 3 - STDBYRAC01 Node 4 - STDBYRAC01 DB to be patched: ntulearndr,sbblearn Pre-Patch Installation Instruction: Validation of Oracle Inventory. a) Switch to Grid User # su – grid $ /u01/app/12.1.0.2/grid/OPatch/optach lsinventory >  /backup/patch/backup/Cluster_invn_bck.log b) Switch to Oracle User # su – oracle $ /u01/app/oracle/product/12.1.0.2/dbhome_1/OPatch/optach lsinventory > /backup/patch/backup/Cluster_invn_bck.log Collect each Database information using below command (Using sysdba): a) Create pfile for database SQL> create pfile='/b...

Oracle RAC -Node Addition For DBA some time due to capacity or load requirements , We need to add additional node to oracle RAC cluster. In this blog , We will discuss and show how to add a node to existing cluster. Following  are the  steps to add node to RAC cluster:   Step (1) Verify the hardware and operating system installations with the Cluster Verification Utility (CVU). Add Node Precheck, Compare Node 1 to Node 3 for existing node on cluster [oragrid@oraclerac01 bin]$ cluvfy comp peer -refnode oraclerac01 -n oraclerac03   -osdba dba -verbose   Verifying peer compatibility   Checking peer compatibility...   Compatibility check: Physical memory [reference node: oraclerac01]   Node Name      Status                     Ref. node status         ...