ORA-12560: TNS:protocol adapter error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • umesh049
    New Member
    • Dec 2007
    • 17

    ORA-12560: TNS:protocol adapter error

    Hi i install oracle on my system but getting this error

    Code:
    C:\Documents and Settings\umesh>sqlplus sys/123456 as sysdba
     
    SQL*Plus: Release 10.1.0.2.0 - Production on Tue Feb 19 11:51:32 2008
     
    Copyright (c) 1982, 2004, Oracle.  All rights reserved.
     
    ERROR:
    ORA-12560: TNS:protocol adapter error
     
     
    and
     
     
    C:\Documents and Settings\umesh>tnsping orcl
     
    TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 19-FEB-2008 12:15:21
     
    Copyright (c) 1997, 2003, Oracle.  All rights reserved.
     
    Used parameter files:
    E:\Oracle\product\10.1.0\Client_2\network\admin\sqlnet.ora
     
    TNS-03505: Failed to resolve name

    thanks
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    If you have multiple databases in the system ,need to specify the name of the database also to connect.

    Comment

    Working...