I am not able to find tnsnames.ora file

[arijit dey]

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.

[Steven E. Protter]

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

[Patti Johnson]

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]

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]

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.

[Stephen Ray Badgett]

side note

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

[Yogeeraj_1]

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