Home » Developer & Programmer » Precompilers, OCI & OCCI » Question : [ORA-12560 TNS:protocol adapter error]
Question : [ORA-12560 TNS:protocol adapter error] [message #93755] Fri, 20 December 2002 01:46 Go to next message
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 ....
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #93815 is a reply to message #93755] Tue, 04 February 2003 04:38 Go to previous messageGo to next message
neeraj pant
Messages: 1
Registered: February 2003
Junior Member
connectivity of oracle with VB giving an error::::
ODBC driver for oracle ora12154 :TNS could not resolve service name
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #93818 is a reply to message #93815] Wed, 05 February 2003 02:10 Go to previous messageGo to next message
Thotakura
Messages: 9
Registered: January 2003
Junior Member
Check the service name in
ODBC Driver Connect dialog box

give database name as service name or configure a new service name using net8 config assistant
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #93847 is a reply to message #93755] Mon, 17 February 2003 23:06 Go to previous messageGo to next message
Jignesh
Messages: 6
Registered: April 2002
Junior Member
whenevre i poen sqlplus for 9i it ask username and password asfter giving scott@tiger
it give this error
what should i do?pls inform me
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #93958 is a reply to message #93847] Tue, 27 May 2003 04:45 Go to previous messageGo to next message
khaleel bin aqeel mohd bi
Messages: 1
Registered: May 2003
Junior Member
WHEN I INSTALL ORACLE 8I ENTERPRISES ON MILLENIUM EDITION.THEY INSTALL,BUT AFTER THE INSTALL OF ORACLE 8I ENTERPRISES.IF I ENTER SCOTT/TIGER .
THEY WILL BE GIVE ERRROR
JUST LIKE
ORA-12560 :TNS :PROTOCAL ADAPTER ERROR .
I WAITING FOR UR HELP
PLZ HELP ME
FOR GOD SAY
I AM UR STUDENTS OF ORACLE
I WRITE A EXAM OF OCP
THAT WHY I NEED A HELP FROM U .FROM ORACLE COOPERATION.
PLZ HELP ME
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #93972 is a reply to message #93755] Mon, 16 June 2003 09:01 Go to previous messageGo to next message
martin hamsch
Messages: 1
Registered: June 2003
Junior Member
Hi,
it's late but not to late?

I'm thinking the TNS-12560: TNS:Protocol Adapter Error isn't your main problem. Because the Bequeath (PROTOCOL=BEQ) will never exists in W2k! see "http://lists.isb.sdnpk.org/pipermail/comp-list/2003-February/001937.html"

I'v got the same problem. But there was a
" ns main err code: 12560
TNS-12560: TNS: Protokolladapterfehler
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protokolladapter-Fehler
nt secondary err code: 126
nt OS err code: 0
" too. And something like that may be your real problem. In my case i had to deinstall pgp. Why? I currrently don't know. W'll see.

good luck.

Martin
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94084 is a reply to message #93755] Sun, 18 January 2004 22:38 Go to previous messageGo to next message
Leela
Messages: 2
Registered: January 2004
Junior Member
i have set the username and password correctly while installing the oracle 8 but i get these error repeatdly please say me the solutions what to do.

but no net connection
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94090 is a reply to message #93755] Sat, 31 January 2004 10:04 Go to previous messageGo to next message
jim
Messages: 74
Registered: July 2000
Member
How can I shoot this problem "[[ORA-12560 TNS:protocol adapter error]] ?

I have trouble when I try to connect.
My system is windows XP and I am using Oracle8i

Thank you for listening me ....
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94143 is a reply to message #94084] Tue, 30 March 2004 05:12 Go to previous messageGo to next message
William Barrera
Messages: 1
Registered: March 2004
Junior Member
You have to verify if the ORACLE_SID is setting. You can setting this enviroment variable using:

set ORACLE_SID = MISID

Good look
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94149 is a reply to message #94143] Thu, 01 April 2004 20:35 Go to previous messageGo to next message
puneet
Messages: 76
Registered: August 2002
Member
hi
i m puneet
I m trying to install oracle on my pc
after the installation it ask me to enter the protocol name such as tcp/ip and then service name
i dont know whick is to be entered in protocol name and in service name
but i enter tcp/ip and then ORCL
but when i test the connection i got the error message
[[ORA-12560 TNS:protocol adapter error]]
i dont to know what to do
plz help me
thanks
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94157 is a reply to message #94149] Wed, 07 April 2004 07:57 Go to previous messageGo to next message
Daniel
Messages: 47
Registered: February 2000
Member
Hi puneet,

after the installation the Oracle Installer ask you to create a Database? Have you create a Database? You Need 2 Services to running the Database.

- ORACLEOraHome1TNSLISTENERListener
- ORACLEOraHome1ServiceSID

Check the Services if they running.

Then check the TNSNAMES.ORA File if it exists and if the entrys are right.
You find this file at Oracle 9i in the following folder:

[[DRIVE]]:ORACLEORA92NETWORKADMIN

If this file does not exist, start the "Net Manager Tool" netmgr.exe with this tool you can create the file.

Daniel
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94178 is a reply to message #94090] Sun, 18 April 2004 05:33 Go to previous messageGo to next message
nandkishor j. shinde
Messages: 1
Registered: April 2004
Junior Member
i have install oracle 9i in my personal computer
my operating system is windows 2003 server
when i log with oracle
it ask for username : (answer)scott
password : answer(tiger)
it is not login
it show the error
ora-12560 tns:protocol adapter error
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94179 is a reply to message #94084] Tue, 20 April 2004 23:23 Go to previous messageGo to next message
parlin
Messages: 2
Registered: April 2004
Junior Member
ORA-12560: TNS protocol adapter error
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94194 is a reply to message #94143] Tue, 04 May 2004 00:07 Go to previous messageGo to next message
parlin
Messages: 2
Registered: April 2004
Junior Member
help me
ora-12560 tns protocol adapter error
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94195 is a reply to message #94090] Tue, 04 May 2004 07:08 Go to previous messageGo to next message
ShriDevi
Messages: 2
Registered: April 2004
Junior Member
How can I shoot this problem "[[ORA-12560 TNS:protocol adapter error]] ?
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94216 is a reply to message #93755] Tue, 18 May 2004 06:28 Go to previous messageGo to next message
Praveen
Messages: 57
Registered: November 2001
Member
hello
I am praveen from hyd

i am getting Ora-12560 Tns Protocol Addaptor Error

so plese any body help me to resolve this problem

mail me to pvnkv@yahoo.com
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94217 is a reply to message #94216] Tue, 18 May 2004 23:00 Go to previous messageGo to next message
sajid
Messages: 18
Registered: April 2000
Junior Member
This problems come generally if your network is not working properly
1. Network problem
2. Oracle overloaded
3. try pinging if there is packet loss recrimp if not try another network card
4. If u r working on local system and u r getting this problem then it could be incorrect installtion of oracle or virus in the system.
5. check if all the services have started
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94232 is a reply to message #93755] Sun, 30 May 2004 03:39 Go to previous messageGo to next message
Bijoy Kharibam
Messages: 2
Registered: May 2004
Junior Member
The resolve this error, please execute below command first from C:OracleOra81bin> folder

ordim -startup -sid <<oracle sid name>>

*sid for me is oracle1 which I created when oracle application is installed for the first time in my system of Windows 2000 professional sp 4free.

You can also start the oracle service from the service management console. In my case it is OracleServiceORACLE1.

I hope this works for you guys.
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94233 is a reply to message #94232] Sun, 30 May 2004 03:42 Go to previous messageGo to next message
Bijoy Kharibam
Messages: 2
Registered: May 2004
Junior Member
Correction to command in my previous email.

oradim -startup -sid "provid here the oracle sid name"
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94257 is a reply to message #94084] Mon, 14 June 2004 21:58 Go to previous messageGo to next message
P.Dhatchanamoorthy
Messages: 1
Registered: June 2004
Junior Member
i have set the username and password correctly while installing the oracle 8 but i get these error repeatdly please say me the solutions what to do.

but no net connection
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94262 is a reply to message #94143] Wed, 23 June 2004 01:19 Go to previous messageGo to next message
Aarti Malik
Messages: 1
Registered: June 2004
Junior Member
set ORACLE_SID = SID_NAME

The above solution works.
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94290 is a reply to message #93755] Thu, 01 July 2004 01:40 Go to previous messageGo to next message
Hassan
Messages: 19
Registered: November 2001
Junior Member
w
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94319 is a reply to message #93847] Mon, 26 July 2004 19:02 Go to previous messageGo to next message
Peter Capton
Messages: 1
Registered: July 2004
Junior Member
ORA-12560 TNS:protocol adapter error
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94339 is a reply to message #93755] Tue, 10 August 2004 08:16 Go to previous messageGo to next message
Ted
Messages: 9
Registered: June 2002
Junior Member
Please be patient with my question, as I am totally an ammature at this.

I am running oracle on Windows Xp O/S. I am trying to create a connetion between Visual Basics and the Oracle database I created within a stand alone off-network machine. At some point, I was asked to "Enter server name". How do I get this information? I assumed it was my machine name, so I right-clicked on my machine--->clicked on properties--->clicked on the computer name tab---> and copied the computer full name and pasted it. I then put in my Oracle DB user name & password, and clicked on test connection.

The result was: ORA-12560 TNS:protocol adapter error

Please help.

Ted
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94362 is a reply to message #93755] Sat, 04 September 2004 00:11 Go to previous messageGo to next message
Manish
Messages: 79
Registered: December 2000
Member
i installed oracle 8 client on my home pc with windows 2000.my problem is that i am not able to even login
as scott/tiger. what should i do? i started oracle service. but as in win98 when i login as an administrator startup database doesn't appear
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94363 is a reply to message #93755] Mon, 06 September 2004 22:59 Go to previous messageGo to next message
tekasole
Messages: 1
Registered: September 2004
Junior Member
go to hell
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94370 is a reply to message #94149] Thu, 09 September 2004 22:38 Go to previous messageGo to next message
ashish
Messages: 107
Registered: December 2000
Senior Member
hi
i m puneet
I m trying to install oracle on my pc
my current operating system is windows98.
i trying to install oracle-8i
after the installation it ask me to enter the protocol name such as tcp/ip and then service name
i dont know whick is to be entered in protocol name and in service name
but i enter tcp/ip and then ORCL
but when i test the connection i got the error message
[[ORA-12560 TNS:protocol adapter error]]
i dont to know what to do

is oracle-8i not support windows98
i m aslo trying to install oracle-personal bu ti found same problem
plz help me
thanks
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94401 is a reply to message #94232] Thu, 07 October 2004 20:20 Go to previous messageGo to next message
AT
Messages: 14
Registered: July 1999
Junior Member
You helped me so much. Thanks!
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94416 is a reply to message #94363] Tue, 19 October 2004 00:00 Go to previous messageGo to next message
Mel
Messages: 7
Registered: May 2002
Junior Member
I have problem about

SQL>
SQL> connect / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
Question : [ORA-12560 TNS:protocol adapter error] [message #94428 is a reply to message #93972] Mon, 25 October 2004 21:28 Go to previous messageGo to next message
Vrinda V
Messages: 17
Registered: October 2004
Junior Member
This is the details found in sqlnet file

Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleordata)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ordata)(CID=(PROGRAM=D:OracleOra81binoradim.exe)(HOST=LAB25)(USER=SYSTEM))))

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: 21-AUG-2004 11:15:19
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: 2
nt OS err code: 0

What shall I do? Reinstall Oracle?
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94429 is a reply to message #93958] Tue, 26 October 2004 07:12 Go to previous messageGo to next message
Venkat
Messages: 110
Registered: February 2001
Senior Member
WHEN I INSTALL ORACLE 9I personal edition ON windows xp EDITION.THEY INSTALL,BUT AFTER THE INSTALL OF ORACLE 9I personal.IF I ENTER SCOTT/TIGER .
THEY WILL BE GIVE ERRROR
JUST LIKE
ORA-12560 :TNS :PROTOCAL ADAPTER ERROR .
I WAITING FOR UR HELP
PLZ HELP ME
FOR GOD SAY
I AM UR STUDENTS OF ORACLE
I WRITE A EXAM OF OCP
THAT WHY I NEED A HELP FROM U .FROM ORACLE COOPERATION.
PLZ HELP ME
Re: Question : [ORA-01034 Oracle not available, ORA-27101 Shared Memory realm do [message #94430 is a reply to message #93755] Tue, 26 October 2004 07:45 Go to previous messageGo to next message
venkatramarao
Messages: 1
Registered: October 2004
Junior Member
Hello,
I'm NVR from India and a novice of all DBMS.
I am trying to enter the user id and password for Oracle 9i on my Windows XP professional plotform. It will showing the given error.
ORA-27101: TNS:protocol adapter error.
ORA-01034: Oracle not available
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94438 is a reply to message #94232] Fri, 29 October 2004 03:03 Go to previous messageGo to next message
Michael Jackson
Messages: 1
Registered: October 2004
Junior Member
I am . da!
Re: Question : [ORA-01034 Oracle not available, ORA-27101 Shared Memory realm do [message #94440 is a reply to message #94430] Mon, 01 November 2004 19:05 Go to previous messageGo to next message
Deepak Sharma
Messages: 2
Registered: January 2004
Junior Member
1.oracle not installed properly.
2.oracle instance(default which you have configured default when installation) is not running.
3.connect as sys/password=? to pfile
4.when connected, run startup
5.oracle database should be started.
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94465 is a reply to message #93815] Thu, 02 December 2004 07:00 Go to previous messageGo to next message
Manikandan
Messages: 7
Registered: October 2000
Junior Member
kindly help me i can't able to install the oracle,the error is
ora-12560 TNS :protocol adapter error
ora 12154 TNS : couldn't resolve service name
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94513 is a reply to message #94363] Wed, 29 December 2004 11:31 Go to previous messageGo to next message
Suresh
Messages: 189
Registered: December 1998
Senior Member
Hi, This is suresh from GE.
I 'have installed Oracle 8I on Win 2000, but when i enter scott/tiget or system /manager,
I get an error: TNS:protocol adapter error.

May i have the solution.
Thanks
suresh
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94533 is a reply to message #94216] Mon, 10 January 2005 23:54 Go to previous messageGo to next message
Praveen
Messages: 57
Registered: November 2001
Member
Hai praveen,

This is ramesh from bangalore,i am also trying to solve ORA-12560 TNS:protocol adapter error
did you got any answer? if yes can you send to me?

My e mail id is bdl_ramesh@yahoo.com
thanks
ORA-12560: TNS:protocol adapter error ORA-12560 [message #94537 is a reply to message #94430] Fri, 14 January 2005 03:53 Go to previous messageGo to next message
Anzar Baig
Messages: 3
Registered: January 2005
Junior Member
oracle 9i is install in my pc (its instal by my brother )
but i enter user name system password manager
then its reply some error ORA-12560
how can i solve this problem bcoz i want to export some data
plz reply me quickly
thanks
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94540 is a reply to message #94179] Sat, 15 January 2005 23:16 Go to previous messageGo to next message
RICHARD HIPOLITE NGALLO
Messages: 1
Registered: January 2005
Junior Member
when i,m trying to connect to ORACLE SQL*PLUS by logging in with USER-NAME:scott
PASSWORD: tiger
I endedup with the above mentioned kind of ERROR.
How can i solve this problem?
Re: Question : [ORA-12560 TNS:protocol adapter error] [message #94545 is a reply to message #94363] Sun, 23 January 2005 09:25 Go to previous messageGo to previous message
sajeev kumar
Messages: 1
Registered: January 2005
Junior Member
sir,
how can i rectify ORA-12560 TNS:protocol adapter error while giving username & password on ORACLE ?
PLS GIVE ME THE ANSWER.

SAJEEV
Previous Topic: Memory leaks in OCIEnvCreate() ?
Next Topic: Problems with OCI without an environment (ORACLE_HOME not set)
Goto Forum:
  


Current Time: Fri Mar 29 07:57:20 CDT 2024