We help IT Professionals succeed at work.

Listener down in Oracle 11g

missymadi
missymadi asked
on
Medium Priority
2,163 Views
Last Modified: 2013-11-11
Experts,

       I have an Oracle 11g database on Windows 2003 on a VM hypervisor. Yesterday morning we the listener was down. I started the listener and then started the database, no problem. Then sometime during the day, the listener went down. I tried bringing the listener back up but I'm getting a TNS error. What is causing this? There are many users on this system so I'm not sure if anything was changed. One theory I have is that the listener runs because it sees the only instance and uses the default settings. But when it needs the listener.ora file or tns file there is incorrect info. in these files?? How do I fix the problem so the listener stops going down?

Thanks, MissyMadi
Comment
Watch Question

Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
what's in your listener.log  for the times when it goes down?
CERTIFIED EXPERT
Top Expert 2008

Commented:
What about the firewalls and antiviruses.
Port blocker can colapse the listener.
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
"Port blocker can colapse the listener."

please post an example of how this could happen.
or maybe rephrase it.  Perhaps I'm misunderstanding.

Are you suggesting that a firewall can cause the listener process to end
or are you suggesting that a firewall can cause communication to the listener to end?

If the former,  that doesn't make sense, I would love to see more information on how that could possibly happen.

If the latter, yes, I totally agree.
 
CERTIFIED EXPERT
Top Expert 2008

Commented:
---> But when it needs the listener.ora file or tns file there is incorrect info
What this means. Give example.

have you changed the IP or domain name of the VM.

Author

Commented:
strange...I did a search on listener.log - no logs. I also did a search on sql.log - no logs.

What is also strange - When I go through services and try to start the Listener manually - I get an error
ERROR 5 - access denied.

From the commnand prompt:
lsnrctl> start
starting tnslsnr:please wait
tns-12560 TNS Protocol Adapter error
tns-00530 protocol adaptor error

How do I find out what port the listener is actually liistening on?
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
lsnrctl status will show the port

you should see a line like...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=your.machine.com)(PORT=1521)))

what does your listener.ora look like?  Is it writing a log file to a nonexistent path?

Author

Commented:
Also, could it be possible that the listener is looking at the default listener settings - which it is getting everything it needs to start(port hostname etc)
BUT when it does need to look at the listener.ora file or sql.ora file the info is incorrect?
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
if you are getting access denied errors, check your user permissions
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
the listener will start with many default values already set the listener.ora lets you change them,  so yes, the listener can start without your listener.ora but it should be reading it immediately on startup to see what values need to be changed from the default
CERTIFIED EXPERT
Top Expert 2008

Commented:
You have to start the Listener service as Administrator
Database Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks, I was able to obtain the correct admin and password that allowed me to administer the LISTENER.
Is it possible to create a windows script to automatically start the listener when the system starts?
CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.