Problem:On a Linux 7, after system reboot I have an 11.2.0.3 RAC Database failed to start due to this error in the alertlog: USER (ospid: 13324): terminating the instance due to error 119Instance terminated by USER, pid = 13324 Cause:While investigating I figured out that the SCAN name “rac1-scan” which is used in “remote_listener” initialization […]

Problem:While patching 19.3 GRID_HOME with July2019 RU patch 19.4 I got this error: [root@fzppon06vs1n bin]#  export PATCH_LOCATION=/u01/oracle/RU_PATCHES/29708769[root@fzppon06vs1n bin]# $GRID_HOME/OPatch/opatchauto apply $PATCH_LOCATION -oh $GRID_HOMEOPatchauto session is initiated at Mon Sep  9 11:00:57 2019OPATCHAUTO-72083: Performing bootstrap operations failed.OPATCHAUTO-72083: The bootstrap execution failed because OPATCHAUTO-72146: Failed to load patchOPATCHAUTO-72146: Failed while collecting patch information for patch /u01/oracle/RU_PATCHES/29708769.OPATCHAUTO-72146: Check […]

Problem:While patching the GRID INFRASTRUCTURE home with July2019 RU patch I got this error: [root@fzppon06vs1n 29708769]# $GRID_HOME/OPatch/opatchauto apply $PATCH_LOCATION -oh $GRID_HOMEOPatchauto session is initiated at Mon Sep  9 11:14:23 2019System initialization log file is /u01/grid/12.2.0.3/cfgtoollogs/opatchautodb/systemconfig2019-09-09_11-14-29AM.log.Session log file is /u01/grid/12.2.0.3/cfgtoollogs/opatchauto/opatchauto2019-09-09_11-15-43AM.logThe id for this session is TV9UExecuting OPatch prereq operations to verify patch applicability on home /u01/grid/12.2.0.3Patch […]

During the installation of Grid Infrastructure Clusterware 12.1.0.2 on OEL 6.6 root.sh failed with the following error: [root]# /u01/12.1.0/grid/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/12.1.0/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin … Copying oraenv to /usr/local/bin … Copying coraenv to /usr/local/bin … Creating /etc/oratab file… Entries will be […]

RAC Configuration Audit Tool  This tool is a script provided by Oracle to help you perform a Health Check on your Database environment (specially RAC environments), it also checks the implementation of Maximum Availability Architecture (MAA) on your environment. This tool is very helpful specially for DBAs who deal with a lot of environments, it […]

RAC MOST USED COMMANDS: [10g] srvctl: For Database and Instances: Start / Stop a RAC database: —————————- srvctl start database -d  database_name -o open srvctl stop database -d database_name  -o immediate Start / Stop a RAC instance: —————————- srvctl start instance-d  database_name  -i instance_name-o open srvctl stop instance-d database_name  -i instance_name -o immediate Start/stop nodeapps: ——————- srvctl start nodeapps -n node_name srvctl […]