Solved

Listener down in Oracle 11g

Posted on 2009-07-08
13
1,830 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
0
Comment
Question by:missymadi
  • 6
  • 4
  • 3
13 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 24803126
what's in your listener.log  for the times when it goes down?
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24803327
What about the firewalls and antiviruses.
Port blocker can colapse the listener.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 24803447
"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.
 
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 48

Expert Comment

by:schwertner
ID: 24803615
---> 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.
0
 

Author Comment

by:missymadi
ID: 24803623
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?
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 24803660
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?
0
 

Author Comment

by:missymadi
ID: 24803665
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?
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 24803685
if you are getting access denied errors, check your user permissions
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 24803702
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
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24803711
You have to start the Listener service as Administrator
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 250 total points
ID: 24803717
you can force the listener to reread the listener.ora and update its configuration with

lsnrctl reload
0
 

Author Comment

by:missymadi
ID: 24804558
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?
0
 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 250 total points
ID: 24804665
In Windows - set the service to start automatical.
In unix - put line in dbora script to start.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle sql query 7 72
PL/SQL More than one element associated with another element 7 44
Oracle collections 15 26
join a table with user_tab_columns in oracle 3 46
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question