Re: Missing listener.ora and tnsnames.ora file

aprinsloo_at_sagetelecom.net wrote:
> We recently installed Oracle 9i on Redhat and have discovered that
> there is no listener.ora and tnsnames.ora file in the usual location:
> /u01/app/oracle/product/9.2.0/network/admin
>
> The server has been running fine and we have performed imp's and exp's
> without any issues, clients have also been connecting without issue.
>
> We discovered the files were missing when attempting to run sqlplus on
> the server, it gave an:
> ORA-12514: TNS:listener could not resolve SERVICE_NAME........ ,
>
> and upon investigation discovered the missing files.
>
> Anyone seen this before?
> Thx

If TNS_ADMIN environment variable is set, its value takes precedence for Net configuration files location. Check if you have it set and if it points to a different location than the default. The listener actually doesn't need the listener.ora file to operate: if started without the config file, it will listen on default TCP port and local Oracle instances will register themselves with the listener dynamically. tnsnames.ora file is not necessary, too, it is only used for local naming. If you have a compatible LDAP server or Oracle Names server then you don't need to bother with tnsnames.ora. However, if you don't use a directory server and don't have the tnsnames.ora file, Net will be unable to resolve names (throwing exactly the error you're getting.)

More information is in Net Services Administrator's Guide for your Oracle release.

hth,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Sun Aug 06 2006 - 04:09:26 CDT