Oracle RAC
JDBC URL for Oracle RAC
Use this url: jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=service)))
Shutting down 11.2 Clusterware
In 11gR2 RAC, you need to follow below steps to shutdown cluster 1. srvctl stop database -d dbname 2. srvctl stop nodeapps -n nodename 3. crsctl stop cluster (to shutdown asm and crs) 4. crsctl stop cluster -all (to shutdown cluster on all nodes) The command ‘crsctl stop crs’ will stop the databases, ASM, all […]