I can't seem to use SET INSTANCE to start an instance. I can
successfully shutdown the instance but starting it up gives me
different errors depending on whether I'm on the same machine or from
a remote machine. I can definitely do a startup if I do the standard
"oraenv" to SID2.
The screen output follows below.
What's the trick to this?
Thanks.
- When running on the same machine as SID2 from SID1
SVRMGR> set instance SID2
Oracle7 Server Release 7.3.3.4.0 - Production Release
With the distributed and parallel query options
PL/SQL Release 2.3.3.4.0 - Production
Instance SID2
SVRMGR> connect internal
Password:
Connected to an idle instance.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 31086708 bytes
Fixed Size 39812 bytes
Variable Size 13221104 bytes
Database Buffers 16777216 bytes
Redo Buffers 1048576 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
SVRMGR>
- When running on a different machine from SID2 from SID3
SVRMGR> set instance SID2
Oracle7 Server Release 7.3.3.4.0 - Production Release
With the distributed and parallel query options
PL/SQL Release 2.3.3.4.0 - Production
Instance SID2
SVRMGR> connect internal
Password:
Connected.
SVRMGR> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup
ORA-01031: insufficient privileges
SVRMGR>
Received on Sun Aug 02 1998 - 10:52:15 CDT