Re: ORA-12545: TNS:name lookup failure

This could be MANY things.

First thing to check is that the is listener started, and listening on the instance that you require to connect to. Your listener configuration file (listener.ora) is commonly in $O_H/network/admin directory. If it is not, then you should set your environment variable $TNS_ADMIN to where ever it is.

To start a V2 or 3 listener, it is lsnrctl start listener_name (if its not LISTENER). Make sure your $ORACLE_SID is set to the SID name, and your $ORACLE_HOME is set to the directory where your database resides.

Confirm that your sqlnet.ora is set up and ok. This is the file that controls where you want to connect to.

Check these things first, and let me know if you need some example files of a listener.ora or sqlnet.ora.

Good luck.
Cheers.

Matthew Franklin wrote in message <34B38408.81C_at_boat.bt.com>...
>Dan Keefe wrote:
>>
>> Hi, All,
>>
>> After installing, when I try to run "svrmgrl " I get the following
>> error. I am confused as I believe that we use server based
>> configuration with no TNS.
>>
>> The platform is: SUN OS (4.1.3_U1)
>> Oracle: Oracle7.2.2.3
>>
>> oracle_at_sunbgs2[413_722]> ./svrmgrl
>>
>> Oracle Server Manager Release 2.1.4.0.0 - Production
>>
>> Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
>>
>> ORA-12545: TNS:name lookup failure
>> SVRMGR>
>Check the file TNSNAMES.ORA in your <ORACLE HOME>/NETWORK/ADMIN
>directory. This file contains the TNS alais name that connects you to
>the required database.
Received on Thu Jan 08 1998 - 00:00:00 CET