TNSNAMES ORA-12560
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: TNSNAMES ORA-12560

  1. #1
    Join Date
    Aug 2001
    Location
    Brazil
    Posts
    3

    Exclamation

    Hi, I worked with Windows 200 and yesterday I installed the pack.
    The problem is tha when I try to start Oracle, he shows me a mensage ORA - 12560.
    The Oracle_SID is set.
    So, what will I do?
    Thanks

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by cleiton
    So, what will I do?
    Is your listener started?


  3. #3
    Join Date
    Aug 2001
    Location
    Brazil
    Posts
    3
    Yes, it started!!

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I assume you have Oracle 8i.

    Read the following:

    fact: Oracle Server - Enterprise Edition
    fact: RDBMS
    fact: MS Windows 2000
    fact: MS Windows NT
    symptom: Cannot connect to SVRMGRL
    symptom: ORA-12560: TNSrotocol adapter error
    symptom: Cannot connect to SVRMGR30
    symptom: ORA-12203: TNS:unable to connect to destination
    cause: Bequeath protocol is not supported with Microsoft Terminal Server Client.
    ORA-12203 is seen on Oracle 8.0.6.
    ORA-12560 is seen on Oracle8i.

    fix:

    Connecting to SVRMGRL is done by using the BEQUEATH protocol which is not available using an MS Windows 2000 Terminal Server Client.

    To startup the instance, use the the Windows 2000 console to connect to the SVRMGRL.


  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    The reason for the ORA-12560 error is that when you are connected via a terminal client there is a virtual machine reated on the server. Therefore you are not connected to the server but to your "own" machine. This requires that you use a valid connect string to connect to the "remote" machine.

    You should connect via a valid NET8 connect string.

    Example:

    SVRMGRL> connect internal/oracle@


  6. #6
    Join Date
    Aug 2001
    Location
    Brazil
    Posts
    3
    I'm in Server..
    The message is in Server

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