HOW TO START A SINGLE INSTANCE OR ALL NODES OF A RAC DATABASE ? DEFINITION: IN RAC (REAL APPLICATION CLUSTERS), INSTEAD OF THE USUAL SETUP WITH ONE INSTANCE AND ONE DATABASE, WE HAVE MULTIPLE INSTANCES CONNECTING TO A SINGLE DATABASE. USAGE: LOAD BALANCING, HIGH AVAILABILITY ASSUMPTION : ASM AND CRS SERVICES ARE ALREADY UP AND RUNNING 1). STARTING ONLY ONE INSTANCE OF A RAC DATABASE SCENARIO : ASM and CRS SERVICES ARE UP, DATABASE AND INSTANCES ARE DOWN su - grid (or) su - root cd $GRID_HOME/bin ./crsctl check crs su - oracle srvctl status database -d db_name srvctl start instance -d db_name -i instance_name ...
Your one-stop destination for Oracle Database Administration and more. Join me as I share my knowledge with the world