ORA-12203

[Arda]

C:\>svrmgr30

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

ORA-12203: TNS:unable to connect to destination

SVRMGR> connect internal@prb1
Password:
Connected.
SVRMGR>

Why could I be getting the above error when starting Server Manager and am then able to connect?

TIA

[brhynold]

Correct me if I am wrong but when opening Server Manager, if you don't have a SID set or the SID you have set does not exist on the server you get the ORA-12203 error

When you are connecting you are using the @ in your connect string so it finds the SID you want to connect to from your TNSNAMES file

To stop this error is can do this before opening server manager

set ORACLE_SID=

then

svrmgrl

connect internal without the @