Home » RDBMS Server » Server Utilities » svrmgrl on windows 2000
svrmgrl on windows 2000 [message #71165] Wed, 18 September 2002 04:40 Go to next message
nigel
Messages: 7
Registered: April 2001
Junior Member
I have a windows 2000 PC with 2 database instances. Sometimes oracle DBA studio seems to lock and cannot start either of the instances. I seem to be able to get round this problem by using svrmgl from the dos command prompt, but this only seems to point to one of the instances. I have tried to set the oracle SID etc using the set command but it makes no difference. How do i point server manager at a particular instance on windows ??
Re: svrmgrl on windows 2000 [message #71180 is a reply to message #71165] Fri, 20 September 2002 18:20 Go to previous message
Helena
Messages: 42
Registered: February 2002
Member
did you try the following

set ORACLE_SID=dbname
sqlplus sys/password as sysdba
select * from v$database;

startup force

Regards
Helena
Previous Topic: DSN
Next Topic: Exporting to a file with date stamp...
Goto Forum:
  


Current Time: Sat May 04 08:13:32 CDT 2024