Steps to create RAC One Node with dbca in silent mode

Steps to create RAC one node with “dbca” in silent mode 1) runclufy to verify the environment ./runcluvfy.sh stage -pre crsinst 2) Run BBDA to install oracle software and create a regular RAC test DB on node 1 following the procedure provided by the engineering team. 3) Run BBDA to add RAC to node 2 […]

How to delete/add Oracle Home entry from central inventory(oraInventory)

How to delete/add Oracle Home entry from central inventory(oraInventory) How to delete/add Oracle Home entry from Central Inventory(oraInventory) We often encounter “OPatch failed with error code 73”. There might be other reason but one could be due to the corrupted inventory. Please follow the below guideline to resolve this issue. oracle@host1-/home/oracle/>$ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch […]

RAC Log File Locations

RAC Log File Locations If you are using Oracle RAC (doesn’t matter how many nodes you have) You need to know where log files are located. The Cluster Ready Services Daemon (crsd) Log Files Log files for the CRSD process (crsd) can be found in the following directories:               […]

Performance Tuning Functions

V$SQL_MONITOR displays SQL statements whose execution have been (or are being) monitored by Oracle. An entry is created in V$SQL_MONITOR every time the execution of a SQL statement is being monitored. SQL monitoring is automatically started when a SQL statement runs parallel or when it has consumed at least 5 seconds of CPU or I/O […]

Oracle 11gR2 GI ClusterWare Votedisk Explained

Votedisk Internals OracleInAction

Oracle11gR2 Linux install

This should be found in linux_common.ksh Preinstall requirements: Minimum RAM requirement: 1.5 GB for GRID Infrastructure and 2.5GB for GI plus RAC you can verify easily by: [code language=”sql”] # grep memTotal /proc/meminfo [/code] For Swap space checking [code language=”sql”] # grep SwapTotal /proc/meminfo [/code] For disk temp space [code language=”sql”] # df -h /tmp […]