ORA-12203
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-12203

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Posts
    41
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    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 @
    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width