topic Re: I am not able to find tnsnames.ora file in Operating System - HP-UX

I am not able to find tnsnames.ora file

arijit dey — Mon, 24 Jul 2006 07:09:36 GMT

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.

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

Steven E. Protter — Mon, 24 Jul 2006 07:25:07 GMT

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

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

Patti Johnson — Mon, 24 Jul 2006 07:27:57 GMT

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

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

arijit dey — Mon, 24 Jul 2006 07:32:49 GMT

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?

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

Patti Johnson — Mon, 24 Jul 2006 09:51:59 GMT

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

Stephen Ray Badgett — Mon, 24 Jul 2006 19:20:17 GMT

side note

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

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

Yogeeraj_1 — Tue, 25 Jul 2006 01:37:19 GMT

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