Hi,
I am administering three oracle instatnces. When the command shutdown is issued how does oralce detrmine what instance of the oracle to shutdown. Please help me
ThanX in advance
Raj
Printable View
Hi,
I am administering three oracle instatnces. When the command shutdown is issued how does oralce detrmine what instance of the oracle to shutdown. Please help me
ThanX in advance
Raj
Raj,
when you are in your unix shell ORACLE_SID determines which sid/instance you are connecting to...
once connected to svrmgr you can perform select * from v$database to determine which db you are connected to.
which O/S are you running on??? NT or Unix
set oracle_sid=INSTANCE_NAME on NT
export INSTANCE_NAME on UNIX
or you can connect as:
INTERNAL/MANAGER@DATABASE_NAME
good luck