How to connect to DATABASE and ASM instance in RAC ?
Database for 2 node RAC:
set the environment variable for rdbms.
export ORACLE_SID=ORCLPROD1
sqlplus '/as sysdba'
or
export ORACLE_SID=ORCLPROD2
sqlplus '/as sysdba'
ASM for 2 node RAC:
set the environment variable for ASM instance.
export ORACLE_SID=+ASM1
sqlplus / as sysasm
or
export ORACLE_SID=+ASM2
sqlplus /as sysasm
No comments:
Post a Comment