Home » Developer & Programmer » Forms » ORA-12560: TNS:protocol adapter error....AGAIN! (Oracle 10g Developer Suite, Windows XP (Media Center Edition '05))
ORA-12560: TNS:protocol adapter error....AGAIN! [message #397496] Sat, 11 April 2009 09:45 Go to next message
balla4eva33
Messages: 13
Registered: March 2009
Junior Member
Hello,

After much, much, much googling and searching through these forums for days upon days, I have concluded that my situation is unique and needs special help!

I'm getting that dreaded TNS adapter error, but it's only happening when I try to run my forms.


-I can connect to everything perfectly,

-I've only got one Oracle home listed in my registry (despite installing standard edition before the developer suite),

-All my tables and everything run smoothly and work perfect in sql plus and from cmd prompt,

-I can tnsping my ip successfully

-I have set tnsnames.ora=<orahome>/tnsnames.ora....


I'm running out of ideas!!

If someone could please help me solve this, I would be sooooo grateful!

Thank you in advance!

Sincerely,
Matt
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397499 is a reply to message #397496] Sat, 11 April 2009 09:49 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/search/12560

Search words: 12560 Total hits: 252
Search time: 0.000 seconds Run time: 0.011 seconds

Are claiming none on these 252 threads gives you any clue?

When was the last time things worked?
What changed?

[Updated on: Sat, 11 April 2009 09:59]

Report message to a moderator

Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397502 is a reply to message #397499] Sat, 11 April 2009 10:47 Go to previous messageGo to next message
balla4eva33
Messages: 13
Registered: March 2009
Junior Member
Haha, well I appreciate the sarcasm, as I probably came across as if I hadn't searched well, but I'm telling you....I've looked at hundreds of threads and forums and sites. I've tried multiple combinations with no luck.

The connection has always been successful, but I just started using the Forms, and they've given me the TNS error since the first time I attempted using them. Clearly, I set something up wrong, but I can't figure it out for the life of me!

Any other suggestions? Possibly, a little more specific to my problem..?

Thanks,
Matt
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397503 is a reply to message #397496] Sat, 11 April 2009 11:40 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Forms has a different HOME directory than the DB software
& therefore its own tnsnames.ora file.

rename tnsnames.ora within the Forms tree & copy the tnsnames.ora file from DB tree into Forms folder.
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397504 is a reply to message #397496] Sat, 11 April 2009 11:45 Go to previous messageGo to next message
balla4eva33
Messages: 13
Registered: March 2009
Junior Member
I read that somewhere also, but I was unsuccessful in finding such a home folder for forms. Is there already a tnsnames.ora file in there that i'd be replacing?....Or am I copying it in there as a brand new file?

This would be my forms home I presume?

C:\Oracle\Oracle10gDeveloperSuiteHome\forms90

So I simply copy the tnsnames.ora file right in there?

Thanks,
Matt
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397505 is a reply to message #397496] Sat, 11 April 2009 11:51 Go to previous messageGo to next message
balla4eva33
Messages: 13
Registered: March 2009
Junior Member
I've tried putting it in there and nothing changes...Still the same bloody TNS adapter error!

Am I in the wrong spot?

Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397506 is a reply to message #397496] Sat, 11 April 2009 12:00 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
http://forums.oracle.com/forums/search.jspa?objID=f64&q=ORA-12560
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397507 is a reply to message #397496] Sat, 11 April 2009 12:14 Go to previous messageGo to next message
balla4eva33
Messages: 13
Registered: March 2009
Junior Member
Been there, done that...Nothing solves my problem.

Does it matter that I'm running locally and logging in with system?
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397508 is a reply to message #397507] Sat, 11 April 2009 12:40 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:

-I can connect to everything perfectly,

-I've only got one Oracle home listed in my registry (despite installing standard edition before the developer suite),

-All my tables and everything run smoothly and work perfect in sql plus and from cmd prompt,

-I can tnsping my ip successfully

-I have set tnsnames.ora=<orahome>/tnsnames.ora....


Post all details and post your error details (copy and paste your session)

Babu
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397512 is a reply to message #397496] Sat, 11 April 2009 13:08 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
post the last dozen lines from listener.log to prove SQL*Net properly configured & accepting new connections.
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397659 is a reply to message #397496] Mon, 13 April 2009 03:19 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
i am also getting same error

whats your oracle & Developer version ?


i think its an listener problem ? might be


Thanks


Shahzaib ismail
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #397982 is a reply to message #397496] Tue, 14 April 2009 13:23 Go to previous messageGo to next message
balla4eva33
Messages: 13
Registered: March 2009
Junior Member
That's the unique thing about my situation. I have no errors in SQL Plus. It runs great and I don't get the TNS error in there. It's not until I attempt to compile and run my FORMS that I get the "ORA-12560: TNS:protocol adapter error" in Internet Explorer after Oracle Forms opens. It will not display any forms. There is nothing to copy and paste, because that's all there is. End of story....That's why I can't find a solution. I wouldn't doubt that it is indeed a listener error, but how can I go about fixing it? I'm not very experienced with Oracle and I know absolutely nothing about the listeners. I'm running locally, using the system login.

Thanks...
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #398011 is a reply to message #397496] Tue, 14 April 2009 17:08 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
post the last dozen lines from listener.log to prove SQL*Net properly configured & accepting new connections.
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #398012 is a reply to message #397496] Tue, 14 April 2009 18:35 Go to previous messageGo to next message
balla4eva33
Messages: 13
Registered: March 2009
Junior Member
I don't have a listener.log!

Or at least I can't find it anywhere...
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #398013 is a reply to message #397496] Tue, 14 April 2009 18:44 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.


Is the Developer s/w is loaded onto the same system upon which the database resides? Yes or NO?


If the Developer s/w is loaded onto the same system upon which the database resides, then it could be no listener is running.

Forms require a listener to be running; where as SQL*Plus does not.
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #398261 is a reply to message #397496] Wed, 15 April 2009 15:50 Go to previous messageGo to next message
balla4eva33
Messages: 13
Registered: March 2009
Junior Member
Everything is loaded on the same system. It is possible I have no listener present....What methods should I follow to check for one and possibly make one work. I tried setting one up a long time ago and had no luck.

THanks!
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #398264 is a reply to message #397496] Wed, 15 April 2009 16:57 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
From within a command window issue the following commands
lsnrctl status
lsnrctl start
lsnrctl status
lsnrctl service


Using CUT & PASTE, extract the commands & resultant output
& PASTE everything back here.


Which version of Oracle RDBMS to 4 decimal places?
Post results from
SQL> select * from v$version
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #398587 is a reply to message #398264] Thu, 16 April 2009 19:42 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please use the 'tns_admin' environment variable to point to your 'tnsnames.ora' file.

David
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #398588 is a reply to message #397496] Thu, 16 April 2009 19:48 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
From within a command window issue the following commands
SET


Using CUT & PASTE, extract the commands & resultant output & PASTE everything back here.
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #399099 is a reply to message #397496] Mon, 20 April 2009 10:21 Go to previous messageGo to next message
MALOKO
Messages: 1
Registered: April 2009
Junior Member

hi there

i think your IE browser should be reconfigured. go to tool => option=> advanced and check the following options
. allow active content from cds to run on my computer
. allow active content to run in files on my computer
. allow software to run or install even if the signature is invalid


then revert
Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #399132 is a reply to message #397496] Mon, 20 April 2009 18:43 Go to previous messageGo to next message
balla4eva33
Messages: 13
Registered: March 2009
Junior Member
Here's what I got...ERRORS Sad


C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 20-APR-2009 19:41
:59

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

TNS-01150: The address of the specified listener name is incorrect
 NL-00303: syntax error in NV string

C:\>lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 20-APR-2009 19:42
:06

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting tnslsnr: please wait...

Service OracleOracle10gStandardHomeTNSListener already running.
TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error
  32-bit Windows Error: 1056: Unknown error

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 20-APR-2009 19:42
:12

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

TNS-01150: The address of the specified listener name is incorrect
 NL-00303: syntax error in NV string

C:\>lsnrctl service

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 20-APR-2009 19:42
:16

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

TNS-01150: The address of the specified listener name is incorrect
 NL-00303: syntax error in NV string

C:\>

Re: ORA-12560: TNS:protocol adapter error....AGAIN! [message #399133 is a reply to message #397496] Mon, 20 April 2009 18:56 Go to previous message
balla4eva33
Messages: 13
Registered: March 2009
Junior Member
Ok, I had the DB shutdown...this is the information you really want.

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 20-APR-2009 19:55
:23

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date                17-APR-2009 03:16:47
Uptime                    3 days 16 hr. 38 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         C:\Oracle\Oracle10gStandardHome\network\log\listener.l
og
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Sheila)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Sheila)(PORT=8080))(Presentation=HTT
P)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Sheila)(PORT=2100))(Presentation=FTP
)(Session=RAW))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\>lsnrctl service

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 20-APR-2009 19:55
:26

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:54 refused:0 state:ready
         LOCAL SERVER
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1002 state:ready
         DISPATCHER <machine: SHEILA, pid: 2188>
         (ADDRESS=(PROTOCOL=tcp)(HOST=Sheila)(PORT=3388))
The command completed successfully

C:\>



VERSION
BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.1.0.2.0 - Production
PL/SQL Release 10.1.0.2.0 - Production
CORE    10.1.0.2.0      Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production
Previous Topic: How to display screen saver every 10 seconds ?
Next Topic: Comparing Two Combo Boxes
Goto Forum:
  


Current Time: Wed Dec 07 20:31:16 CST 2016

Total time taken to generate the page: 0.15461 seconds