OraFAQ Forum: Forms » TNSListener

Home » Developer & Programmer » Forms » TNSListener

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNSListener [message #258261]

Fri, 10 August 2007 13:39

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

Report message to a moderator

Re: TNSListener [message #258305 is a reply to message #258261]

Fri, 10 August 2007 23:44

azamkhan
Messages: 557
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

Report message to a moderator

Re: TNSListener [message #258408 is a reply to message #258305]

Sat, 11 August 2007 11:39

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

Report message to a moderator

Re: TNSListener [message #258510 is a reply to message #258408]

Sun, 12 August 2007 20:21

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: TNSListener [message #258581 is a reply to message #258408]

Mon, 13 August 2007 02:04

azamkhan
Messages: 557
Registered: August 2005

Senior Member

ok... do this ... delete your listener and again recreate it

Report message to a moderator

Re: TNSListener [message #258967 is a reply to message #258581]

Mon, 13 August 2007 23:50

Samin
Messages: 6
Registered: August 2007

Junior Member

Hi
I have deleted my listener but I do not know how should I recreate it???

Report message to a moderator

Re: TNSListener [message #258972 is a reply to message #258510]

Mon, 13 August 2007 23:57

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??

Report message to a moderator

Re: TNSListener [message #259015 is a reply to message #258972]

Tue, 14 August 2007 02:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: TNSListener [message #259103 is a reply to message #259015]

Tue, 14 August 2007 07:19

Samin
Messages: 6
Registered: August 2007

Junior Member

I wanted to know what happen if the TNSLister couldn't find the tnsnames.ora Sad

Report message to a moderator

Re: TNSListener [message #259122 is a reply to message #258261]

Tue, 14 August 2007 08:27

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

Report message to a moderator

Re: TNSListener [message #259210 is a reply to message #258261]

Tue, 14 August 2007 11:54

alijeyan
Messages: 184
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

Report message to a moderator

Re: TNSListener [message #259302 is a reply to message #259122]

Tue, 14 August 2007 23:53

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.

Report message to a moderator

Re: TNSListener [message #259305 is a reply to message #258261]

Tue, 14 August 2007 23:58

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:20:00 CDT 2024