#1 13 Jul 2011 12:18

anitha
Member
Registered: 13 Jul 2011
Posts: 1

error code ora-12560 tns:protocol adapter error

hi,
    I installed oracle 8i.Installation is done properly. But while connecting i am getting the below error message.
       "ora-12560 tns:protocol adapter error "

    I tried the below command
         sqlplus /nolog
     After this i am getting sql command prompt(sql>). then i tried to connect as "conn scott/tiger" and "conn /as sysdba ". i am getting the same error.
     what's the solution for this? Is there any services needed to startup the database.  after three attempt the window will be closed automatically.

Last edited by anitha (13 Jul 2011 12:26)

Offline

#2 13 Jul 2011 19:01

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 873
Website

Re: error code ora-12560 tns:protocol adapter error

This usually just means you need to configure TNS

see examples here
http://ss64.com/ora/syntax-tnsnames.html

Offline

#3 17 Oct 2011 10:41

dibyapad
Member
Registered: 17 Oct 2011
Posts: 1

Re: error code ora-12560 tns:protocol adapter error

hi,
    I installed oracle 8i before 10 days in Windows XP and working properly. But now while I am going to   connect  i am getting the below error message.
       "ora-12560 tns:protocol adapter error "
    I tried the below command
         sqlplus /nolog
     After this i am getting sql command prompt(sql>). then i tried to connect as "conn scott/tiger" and "conn /as sysdba ". i am getting the same error.
     what's the solution for this?

Offline

#4 25 Oct 2011 12:15

Voislav Sauca
Member
Registered: 25 Oct 2011
Posts: 1

Re: error code ora-12560 tns:protocol adapter error

seems to be a errror of tnsnames ., go to ..client_1\network\admin open the tnsnames.ora and see if is like this:

  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.45)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = 'name')
    )
  )

Offline

#5 16 Dec 2011 00:27

Opus
Member
Registered: 15 Dec 2011
Posts: 17

Re: error code ora-12560 tns:protocol adapter error

If you are working on the machine where the database is running, you could just make sure the ORACLE_SID environment variable is set.

In *NIX  export (or set) ORACLE_SID=<your sid>

In Win64 set ORACLE_SID=<your sid>

Then, run SQLPLUS and voila.

Cheers,
Opus

Offline

Board footer

Powered by FluxBB