OraFAQ Forum: Precompilers, OCI & OCCI » Question : [ORA-12560 TNS:protocol adapter error]

Home » Developer & Programmer » Precompilers, OCI & OCCI » Question : [ORA-12560 TNS:protocol adapter error]

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question : [ORA-12560 TNS:protocol adapter error] [message #93755]

Fri, 20 December 2002 01:46

Daniel Woohee Yoon
Messages: 2
Registered: December 2002

Junior Member

Hello,
I'm Mr.Yoon from South Korea and a novice of all DBMS.

I am trying to run the sample SAMPLE1.pc on Windows 2000 but I keep getting
the ORA-12560: TNS:protocol adapter error. I have set the correct
username and password in SAMPLE1.pc before compiling.

I am using Oracle 8.1.6 Server on Solaris 8 and I have the Oracle Client installed on Windows 2000 with the selection Application Programmer.
I am able to connect to Oracle using the command line with the following
command sqlplus daniel/whyoon@eam and I am also able to connect to
Oracle using the Sqlplus Net8 client interface.

And I have also set the ORACLE_SID on the
Windows registry to EAM

Here is my tnsnames.ora file on the client.

EAM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.30.102)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = eam.iasecurity.com)
)
)
---------------------------------------------
Here is my tnsnames.ora file on the server.

EAM.IASECURITY.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ultra80)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = eam.iasecurity.com)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
-----------------------------------------------

These are the result on the client.
***********************************************
C:OracleOra81bin>tnsping eam

TNS Ping Utility for 32-bit Windows: Version 8.1.6.0.0 - Production on 20-DEC-20
02 17:28:23

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

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=172.16.30.102)(PORT=1521))
OK (200 msec)

C:OracleOra81bin>
***********************************************

The below thing is the file "C:OracleOra81precompdemoprocsample1sqlnet.log"
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:OracleOra81precompdemoprocsample1WinDebugsample1.exe)(HOST=WHYOON)(USER=Administrator))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production
Time: 20-DEC-2002 16:35:39
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:Protocol Adapter Error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol Adapter Error
nt secondary err code: 126
nt OS err code: 0
***********************************************************************

I have no idea how the protocol name was set to "BEQ"
which is different from the value of TNSNAMES.ORA.

Anyone have any ideas why I can't connect with the SAMPLE1 ?

How can I shoot this problem "[[ORA-12560 TNS:protocol adapter error]] ?

Thank you for listening me ....