General
cancel
Showing results for 
Search instead for 
Did you mean: 

I am not able to find tnsnames.ora file

arijit dey
Occasional Contributor

I am not able to find tnsnames.ora file

I just installed oracle 10g, as preinstallation step, i just exported ORACLE_BASE and ORACLE_SID env variables and used the ORACLE_HOME as the installer gave. After successful creation of database, I cannot find the tnsnames.ora file either in /etc or in $ORACLE_HOME/network/admin/

Please suggest me, why this is happening.

Was it neccessary that I should have had TNS_ADMIN env variable before creating the database instance.
6 REPLIES
Steven E. Protter
Exalted Contributor

Re: I am not able to find tnsnames.ora file

Shalom,

I don't see an TNS_ADMIN variable on my Oracle 10g systems.

Search the system for the file, it should be there, especially after a database is created with the gui.

find -name tnsnames.ora

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Patti Johnson
Respected Contributor

Re: I am not able to find tnsnames.ora file

TNS_ADMIN is only necessary if you want to use an non-default location for the tnsnames.ora.
Did you run the network configuration assistant after creating the database. You can run it now and create a tnsnames.ora file.

Patti
arijit dey
Occasional Contributor

Re: I am not able to find tnsnames.ora file

Noe I ran the net config assistant and created one. But i thought tnsnames.ora would be created during database creation only.

Am i wrong?
Patti Johnson
Respected Contributor

Re: I am not able to find tnsnames.ora file

Creating the db will not create the tnsnames.ora ( or listener.ora) these are both done as part of the network configuration. Normally the networks configuration assistant is started at the end of the installation process, but if it fails or you exit before completing it will not create the files.

These files are not necessary to connect to the database locally from the server, just for client access, so your db can be properly created and the files not exist.

Re: I am not able to find tnsnames.ora file

side note

find -name tnsnames.ora might want ...
find -name tnsnames.ora 2>/dev/null

Yogeeraj_1
Honored Contributor

Re: I am not able to find tnsnames.ora file

hi,

i suggest that you run the network configuration assistant.

$ORACLE_HOME/bin/netca

If there are any already defined aliases or an existing tnsnames.ora, you will be able to find it there (in view).

hope this helps

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)