| ORA-12560: TNS:protocol adapter error....AGAIN! [message #397496] |
Sat, 11 April 2009 09:45  |
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 #397502 is a reply to message #397499] |
Sat, 11 April 2009 10:47  |
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 #397504 is a reply to message #397496] |
Sat, 11 April 2009 11:45 |
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 #397982 is a reply to message #397496] |
Tue, 14 April 2009 13:23 |
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 #399133 is a reply to message #397496] |
Mon, 20 April 2009 18:56 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
