Saturday, April 05, 2008

Want help with an Oracle listener problem?

Especially if you are on the Oracle forums, and you are asking for help getting your listener to run.

For us to troubleshoot the problem properly, please provide the following information:

1) Windows

Tell us the operating system (Windows XP Home, Windows XP Professional, Vista Ultimate, Vista Business) ... PLUS service pack information! You can get the appropriate information from the Control Panel > System

Tell us how many ORACLE_HOMEs you have. Several ways to find out, one being to go to the SERVICES (Control Panle > Administration Tools > Services) and simply looking for entries that start with 'Oracle' and end with 'TNSLIstener'

Copy/paste the listener.ora to the forum - You can ignore the samples, but be aware that you may have several. If you have more than one search for all the listener.ora files on your system.

We need basic Computer naming and IP/interface information. From the command line (Start > Run > cmd)
  • hostname
  • echo %COMPUTERNAME%
  • ipconfig /all
  • route print
It's very useful to see whether

And we need to understand what your listener thinks it is doing, so provide a copy paste of the output (also form the command line) for
  • lsnrctl status
If the listener is not running, you may want to start it using 'lsnrctl start'
  • IP interface config (Windows: ipconfig /all, route print; Linux: ifconfig; route)

2) Similar information from Linux would be

Linux distro (RedHat EL4 Update 5, Ubuntu 6.10 Server, SUSE 10.1, Fedora8, etc.), and especially useful is the output from
  • uname -a
Please copy/paste the /etc/oratab file and the listener.ora file(s) from the ORACLE_HOMEs found in that file. (The Homes are the second colon-delimited field at the bottom of the file.)

We need basic Computer naming and IP/interface information. From the command line
  • hostname
  • /sbin/ifconfig
  • /sbin/route
We need to see your Environment.
  • set | grep -i ora
and you may want to set the environment using
  • . oraenv (that is a dot space) and answer with aan ORACLE_SID from the above oratab
  • . oracle_env.sh (if you are using XE)
And we need to understand what your listener thinks it is doing, so provide a copy paste of the output (also form the command line) for
  • lsnrctl status
If the listener is not running, you may want to start it using 'lsnrctl start'



If you provide that information up front, we won't have to ask for it

9 comments:

Marco Gralike said...

I have written a checklist for developers because I got sick of explaining every time the same essentials. Maybe the following is useful for those with SQL*Net problems.

"Small introduction to SQL*Net debugging" (http://www.liberidu.com/blog/?p=115)

Forbrich said...

Nice one.

Ivan Kartik said...

Hans,

Congratulation to Oracle ACE Director :-)
I'm pretty sure that this status is in right hands...

Forbrich said...

Thanks Ivan. From you, that is high praise.

Frank said...

Hey - you made ACE Director, too? Congrats!

Anonymous said...

It is all great and nice! But, you guys concentrate on how great you are and not on what some of us asked. The original question was how to resolve TNS-01190 on vista even though everything is set correctly.......and yes I know the list by heart and I've checked everything.

Forbrich said...

Anonymous:

1) Which 'original problem'? I don't see an original problem listed in the blog.

2) 'which vista'?

and
3) where are the answers to the rest of the questions in the blog?

Heavy sigh.

vipin said...

Hi,

Please find the following details.

1. Windows vista home premium.
2. oracle 10g

I am facing lisner problem. when i am trying to start listener by windows servies. it says
"windows could not start the OracleoracleTNSlistener on local computer.

Error 3 :system cannot find the path specified."

Please help me.

thanks
Vipin

Forbrich said...

One of the challenges you face is that you are using a totally unsupported operating system. Although it is possible that you could get it working, I deliberately avoid Windows xyz Home because missing or unactivated capabilities make Oracle troubleshooting a hit-and-miss proposition.

If I remember correctly Error 3 (a Windows message, not an Oracle message) means you have not configured your networking correctly or the firewall is blocking it.