Re: need help TNS:no listener

In article <7vmaoq$7qf$1_at_jaydee.iway.fr>,   "Thomas" <thoeltzel_at_vestra.fr> wrote:
> I have this error: ora-12224: TNS: no listener
> How to start a listener on a remote machine?
>
> (I'm not DBA)
> Thanks, Thomas
>
>

Hi Thomas:
Since U are not DBA here are some possible scenes I can make out: First and foremost -- The listener on the remote server may be Up and running correctly but Ur client apps on Ur desktops may be configured to a different port i.e Your tnsnames.ora is configured incorrectly.

The solution is relatively very easy -- provided your listener.ora on the remote server is configured correctly. Just checkout the listener.ora on the serverside and match the client's port# to that of the server. If thats ok then start the listener .

If its a Un*x box then login as oracle s/w owner account [ usually its oracle ] and issue the command
UNIXPROMPT>lsnrctl start
U can also try out some more diagonostic commands like lsnrctl status etc.
========== IMPORTANT =========
Make sure that the port # listed in the listener.ora file is the same to which your tnsnames alias points in the client machine. U can find the listener.ora and tnsnames.ora files in the default location $ORACLE_HOME/network/admin/ directory. Where ORACLE_HOME is an environment variables. Also make a note that the listener.ora file is the one that is on the server side.

• Pardon me if I am detailing more like to a newbie. In fact that's what I made out. N.B: I forgot to mention, in NT it is implemented as a Service, which U can find in the services section of the control panel. In NT boxes usually ORACLE_HOME is X:\Orant where X is Ur oracle s/w install point. Exact location U can find in the registry of NT under the software/Oracle tree.

Vinayak
--
Luck is the dividend of sweat,
the more U sweat the more luckier U get. --Ray Kroc.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 02 1999 - 06:04:31 CST