Home » Developer & Programmer » Forms » TNSListener
TNSListener [message #258261] Fri, 10 August 2007 13:39 Go to next message
Samin
Messages: 6
Registered: August 2007
Junior Member
Hello Everybody

I have problem with TNSListener, I installed oracle 10g and I had not have any problem, but when since I installed Oracle developer suite 10g the TNSLister service stopped working by no reason.

The error message which I have got is :
"The OracleOraDb10g_home1TNSListener service on Local Computer started and the stopped. Some services stopped automatically if they have no work to do, for example the Performance log Alerts service."

and when I try sqlplus "/ as sysdba" on command prompt I have got this error : "ORA-12560: TNS:protocol adapter error"

Would you please help me???
I don't want to reinstall Oracle please help me
thank you in advance
Samin
Re: TNSListener [message #258305 is a reply to message #258261] Fri, 10 August 2007 23:44 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
You are right that there some services that stop and starts when they are required to perform there work. But the Listener service must be started with the database otherwise you will not be able to connect to Oracle.

This is so because Listener is the one who is responsible to take or to listen your request to Oracle Database.

Regard,
Azam Khan
Re: TNSListener [message #258408 is a reply to message #258305] Sat, 11 August 2007 11:39 Go to previous messageGo to next message
Samin
Messages: 6
Registered: August 2007
Junior Member
Hi
Actually I know about TNSListener, but I don't know why it dosen't work right now Sad
Re: TNSListener [message #258510 is a reply to message #258408] Sun, 12 August 2007 20:21 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I think this is the classic tnsnames.ora, listener.ora, sqlnet.ora problem. Please search this forum for these three files for posts relating to the problems that other people have had with these three files.

Basically, you need to see how many copies of these files that you have on your PC and make sure that, internally, they are in agreement with each other.

I believe that you may be trying to run two listeners for the same port or one listener for two ports.

Review your files and tell us how many you found, where they are, and any data inconsistencies in them.

David
Re: TNSListener [message #258581 is a reply to message #258408] Mon, 13 August 2007 02:04 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
ok... do this ... delete your listener and again recreate it
Re: TNSListener [message #258967 is a reply to message #258581] Mon, 13 August 2007 23:50 Go to previous messageGo to next message
Samin
Messages: 6
Registered: August 2007
Junior Member
Hi
I have deleted my listener but I do not know how should I recreate it???
Re: TNSListener [message #258972 is a reply to message #258510] Mon, 13 August 2007 23:57 Go to previous messageGo to next message
Samin
Messages: 6
Registered: August 2007
Junior Member
Hi djmartin

I have 2 TNSnames.ora one for Oracle10g and the other for Developer 10g
Should I delete one of them??? If yes which one ?

But you know once I renamed the Developer folder, but TNSListener wasn't start; so do you think if I delete one of the tnsnames.ora 's, it will start??
Re: TNSListener [message #259015 is a reply to message #258972] Tue, 14 August 2007 02:32 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
WHY DID YOU RENAME A DIRECTORY??? If you want to use a different name, uninstall that Oracle product and then reinstall it.

David
Re: TNSListener [message #259103 is a reply to message #259015] Tue, 14 August 2007 07:19 Go to previous messageGo to next message
Samin
Messages: 6
Registered: August 2007
Junior Member
I wanted to know what happen if the TNSLister couldn't find the tnsnames.ora Sad
Re: TNSListener [message #259122 is a reply to message #258261] Tue, 14 August 2007 08:27 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
LMFA0 ..

I renamed the directory to see what would happen ...

TNS Listener doesn't work .. What could of happened ??

Too Friggin funny
Re: TNSListener [message #259210 is a reply to message #258261] Tue, 14 August 2007 11:54 Go to previous messageGo to next message
alijeyan
Messages: 180
Registered: January 2007
Location: IRAN
Senior Member
hi
you must install developer at first (in \orant ) and then install oracle database in \oracle\ora10 .
when you install oracle database you must set home and path :
home: orahome10
path \oracle\ora10

i use above with oracle database 9 ande developer 6i
and work good.

Ali Jeyan

Re: TNSListener [message #259302 is a reply to message #259122] Tue, 14 August 2007 23:53 Go to previous messageGo to next message
Samin
Messages: 6
Registered: August 2007
Junior Member
TNSListener hadn't work before I renamed the directory.

Maybe it seems funny for you but if I were you instead of making fun of others, I would teach them what to do.
Re: TNSListener [message #259305 is a reply to message #258261] Tue, 14 August 2007 23:58 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Laughing Laughing Laughing
Previous Topic: how to disable system alerts?
Next Topic: Add Bookmark using Webutil
Goto Forum:
  


Current Time: Sun Dec 04 08:24:07 CST 2016

Total time taken to generate the page: 0.12330 seconds