1 2 Previous Next 20 Replies Latest reply on May 25, 2012 7:34 AM by 894624

    ORA-12560: TNS:protocol adapter error

    A.D.
      Hi all,
      I'm unable to connect without host string.But when connecting through
      conn sys/sys@hoststring as sysdba...its getting connected.let have a look below..

      C:\Documents and Settings\insuranceuser>SET ORACLE_SID=DB4DES

      C:\Documents and Settings\insuranceuser>SQLPLUS /NOLOG

      SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 24 14:31:34 2006

      (c) Copyright 2000 Oracle Corporation. All rights reserved.

      SQL> CONN SYS/SYS AS SYSDBA
      ERROR:
      ORA-12560: TNS:protocol adapter error


      SQL>

      any suggestion??PLZ URGENT
        1 2 Previous Next