Thanks a ton to all of you guys.

Problem is solved.

Somebody had changed the server name.

Rgds,
Suhail

-----Original Message-----
From: Nkansah Derek
[mailto:oracledba-ezmlmshield-x15115735.[Email address protected]
Sent: Monday, December 27, 2004 4:21 PM
To: LazyDBA Discussion
Subject: RE: URGENT : No Listener


Suhail,

Make sure you haven't got any trace set to on. Oracle sets this to on
automatically and what you want to do if this is not needed, is to turn it
off. Also, check this directory out and make sure you have not got too many
*.dat files; %ORACLE_HOME\otrace\admin.

Hope this helps.

Derek

-----Original Message-----
From: Suhail Ahmed
[mailto:oracledba-ezmlmshield-x75383384.[Email address protected]
Sent: Monday, December 27, 2004 9:57 AM
To: LazyDBA Discussion
Subject: URGENT : No Listener


Hi,

My database is Oracle 8.1.7 on Windows 2000 Sever

Today when I tried to connect my application , it gave error "No Listener"

I checked on database server for tnslistener service. It was not started.

I started it...but after 2-3 seconds it again stopped.

I checked windows alert logs..it gives error " unexpectedly terminating the
service"

what could be the reasons ?


Rgds,
Suhail


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
This e-mail (and any attachments) contains information, which is
confidential and intended solely for the attention and use of the named
addressee(s). If you are not the intended recipient you must not copy,
distribute or use it for any purpose or disclose the contents to any person.
If you have received this e-mail in error, please notify us immediately at
[Email address protected] The information contained in this e-mail (and any attachments)
is supplied in good faith, but the sender shall not be under any liability
in damages or otherwise for any reliance that may be placed upon it by the
recipient. Any comments or opinions expressed are those of the originator
not of NTT Europe Ltd unless otherwise expressly stated.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page