Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » ORA-12560 : TNS: protocol adapter error
ORA-12560 : TNS: protocol adapter error [message #77408] Sun, 15 December 2002 00:28 Go to next message
Thitipong
Messages: 1
Registered: December 2002
Junior Member
i have a problem about connection to the database. i can't access to my database in Form Builder.
Would you please tell me how to configure or any where i can found the answer

Thank you
Re: ORA-12560 : TNS: protocol adapter error [message #77422 is a reply to message #77408] Wed, 19 March 2003 07:21 Go to previous messageGo to next message
Mike Bronowicki
Messages: 4
Registered: March 2003
Junior Member
In %ORA_HOME%/network/admin
there is a file named TNSNAMES.ORA which needs to be filled in with the appropriate Database information.
Re: ORA-12560 : TNS: protocol adapter error [message #77454 is a reply to message #77422] Fri, 16 January 2004 09:24 Go to previous messageGo to next message
Jeff
Messages: 63
Registered: July 1999
Member
you need one of these on each machine that connects
and the server
Re: ORA-12560 : TNS: protocol adapter error [message #77457 is a reply to message #77422] Thu, 12 February 2004 05:39 Go to previous messageGo to next message
manik
Messages: 2
Registered: February 2004
Junior Member
I've installed 9i Database and sometimes it runs and sometimes it gives the error
ORA-12560 : TNS: protocol adapter error.
How to solved this error. If someone can help me out then that will be great.
Thanks
Re: ORA-12560 : TNS: protocol adapter error [message #77458 is a reply to message #77408] Fri, 20 February 2004 11:57 Go to previous messageGo to next message
Gabriel Medina
Messages: 1
Registered: February 2004
Junior Member
I know this post is not directly related to this thread, but I just wanted to give my two cents...

This one is about ODP.NET and Oracle, I was receiving ORA-12560 : TNS: protocol adapter error when trying to connect to oracle using the ODP.NET, the oracle site claims that the package you download to install ODP.NET contains the client, but this client is for users only and does not contain the MSDTC, which is needed to make connections in Web Forms in .NET, you have to download the complete Oracle client, and THEN install the ODP.NET package, before you can run web apps in .net which use ODP.NET, I hope someone finds this useful.
Thanks,
Gabriel Medina
EDS
Nee help ORA-12560 error [message #77460 is a reply to message #77422] Sat, 13 March 2004 07:31 Go to previous messageGo to next message
abdul
Messages: 18
Registered: May 2001
Junior Member
ORA-12560: TNS:protocol adapter error
i am having this problem in Oracle 9i when i use to connetc through
Sql>connect sys/oracle as sysdba

i am on Local machine(Stand Alone)
any one to help me now
Re: ORA-12560 : TNS: protocol adapter error [message #77463 is a reply to message #77457] Fri, 26 March 2004 18:46 Go to previous messageGo to next message
harsh
Messages: 1
Registered: March 2004
Junior Member
sir,
when i m trying to go on oracle sql . its giving an error tns protocol adapter error
Re: ORA-12560 : TNS: protocol adapter error [message #77464 is a reply to message #77463] Thu, 01 April 2004 12:26 Go to previous messageGo to next message
mohamad
Messages: 1
Registered: April 2004
Junior Member
when i m trying to go on oracle sql . its giving an error tns protocol adapter error

please help.
Re: ORA-12560 : TNS: protocol adapter error [message #77465 is a reply to message #77422] Sat, 03 April 2004 04:42 Go to previous messageGo to next message
Tarik
Messages: 3
Registered: April 2002
Junior Member
hi,
i install oracle 9i (minimal installation 650Mo) but when i open SQL and want to log with scott or system , SQL* give me the error ora - 12560...
i don't have this error with standard installation...
should i configure something....?
(and i don't create any Database and user yet )
thank you
Re: ORA-12560 : TNS: protocol adapter error [message #77469 is a reply to message #77465] Fri, 16 April 2004 08:15 Go to previous messageGo to next message
adnan köksal
Messages: 1
Registered: April 2004
Junior Member
if you know this problem what happend.
send message my e-mail
than you
Re: Nee help ORA-12560 error [message #77470 is a reply to message #77460] Mon, 19 April 2004 19:01 Go to previous messageGo to next message
Rashmi
Messages: 20
Registered: April 2001
Junior Member
U need to check for the Services which starts during the machine Boot up eg "OracleORAHome90Agent" and " OracleORAHome90TNSListner" which are set in "Automatic" Mode, u need to go to the control panel and click administrative tools and then click services which gives u the list of the services on the local system and their startup modes.
Check and change their mode to Automatic if not set .
Re: Nee help ORA-12560 error [message #77488 is a reply to message #77470] Mon, 28 June 2004 13:43 Go to previous messageGo to next message
Rick Warrington
Messages: 1
Registered: June 2004
Junior Member
I have an application that uses a ODBC connection to an Oracle 8i database. When the login screen for the application pops up, you type in the settings for login,password and data source and the save button.It will log you in but the next time you use the application it won't save the settings which it is supposed to do. You get a ORA-12560 error. Any insight in to what is causing this problem would be greatly appreciated. Thanks.
Re: ORA-12560 : TNS: protocol adapter error [message #77490 is a reply to message #77463] Mon, 05 July 2004 07:10 Go to previous messageGo to next message
sidh
Messages: 1
Registered: July 2004
Junior Member
sir,
when i m trying to login in oracle sql . its giving an error tns protocol adapter error ,reply plz fast
Re: ORA-12560 : TNS: protocol adapter error [message #77525 is a reply to message #77422] Wed, 09 February 2005 20:46 Go to previous messageGo to next message
Kishore Kumar Desu
Messages: 2
Registered: February 2005
Junior Member
Can't connect via oracle 9i Client to oracle db behind router when firewall is running

I am trying to connect oracle9i client to database server behind router when firewall is running.

I am facing problem with ORA 12560: TNS : Protocl Adapter Error.

Can u suggest me to connect oracle client to server when firewall is running.

Kishore Kumar Desu
Re: ORA-12560 : TNS: protocol adapter error [message #77528 is a reply to message #77454] Fri, 11 February 2005 09:07 Go to previous messageGo to next message
jyoti dahiya
Messages: 1
Registered: February 2005
Junior Member
b'cause of this not connnect my oracle database
Re: ORA-12560 : TNS: protocol adapter error [message #77530 is a reply to message #77464] Wed, 16 February 2005 04:48 Go to previous messageGo to next message
rebs
Messages: 1
Registered: February 2005
Junior Member
when i m trying to go on oracle sql . its giving an error tns protocol adapter error
Re: ORA-12560 : TNS: protocol adapter error [message #109526 is a reply to message #77530] Fri, 25 February 2005 06:35 Go to previous messageGo to next message
mdarshad
Messages: 1
Registered: February 2005
Location: INDIA
Junior Member
I've installed 9i Database and sometimes it runs and sometimes it gives the error
ORA-12560 : TNS: protocol adapter error.
How to solved this error. If someone can help me out then that will be great.
Thanks
Re: ORA-12560 : TNS: protocol adapter error [message #409446 is a reply to message #77408] Mon, 22 June 2009 14:20 Go to previous messageGo to next message
deepan_g
Messages: 12
Registered: May 2008
Junior Member
hi,
i executed the following create spfile command
"create spfile from pfile;"
i got an error 'could not open parameter file' or something like that
from then on whenever i try to connect i get "ORA-12560 : TNS: protocol adapter error"...


what should i do to resolve this problem please help...

( i have installed oracle 9i on a standalone computer win xp sp2)
Re: ORA-12560 : TNS: protocol adapter error [message #635810 is a reply to message #77408] Thu, 09 April 2015 04:34 Go to previous message
hcdba
Messages: 34
Registered: March 2015
Member
Hello i am new to oracle technology and dba field.
for practice i install oracle 11g on vmware workstation.
then i install developer suit 11g on same vmware.

my problem is when i open form builder and want to connect to the database it gives adapter error.

and same problem i m phasing when i connect to database through command line.

but when i open sqlplus direct from bin its working fine.

where i made mistake?

please anyone guide me


Thanx in advance

Previous Topic: Internal Server Error
Goto Forum:
  


Current Time: Thu Mar 28 10:47:48 CDT 2024