Interesting Problem with Oracle

[Ganesh Anekar]

Hi,

I am working D class HP9000 machine.

I am able to mount the database,able to start listener.

But when i try to connect with Database user with the tnsnames. It says "tns could not resolve service name"

I checked tnsnames.ora file ...the entries are there for same tnsname.

can somebody guide me ? how should i proceed?

Thanks
Ganesh

[MANOJ SRIVASTAVA]

Hi Ganesh

I think you are working on the new OS , how is the system able to resolve its name . Do a nslookup and nslookup I think there is some issue with your resolv.conf or nssswitch file , all you can do is to rename the resolve.conf if you entries are good in /etc/hosts.



Manoj Srivstava

[Ganesh Anekar]

hi manoj,

I checked nslookup for host and ip ..its working fine.

I am able to connect for database user without tnsname , but not with tnsname.

how should i do this?

ganesh

[Helen French]

Hi Ganesh:

Some options:

1) Check the permission of tnsnames.ora file
2) Make sure that your SID is in the tnsnames.ora file
3) Make sure that the listener knows that the SID is in the tnsnames.ora file.
4) If you are using NNM, then there can be a problem while resolving the names. Then you need to edit the file -/home/dba/oracle/product/8.0.6/network/admin/sqlnet.ora - and comment out this line:

NAMES.DEFAULT_DOMAIN

HTH,
Shiju

[Ganesh Anekar]

Dear Manoj,

can you tell me how should i check that on which IP,database is running as I have to IPs for one NIC in the same machine.

Is this tns error is related to that?

I checked group and and permissions for the unix user from which i was connecting to db ..all are correct.

please guide me.

ganesh

[Wodisch]

Hi,

my guess would be just the opposite: you don't have a "sqlnet.ora" file and hence all your TNSnames are too complicated (having some kind of ".something" appended).
So check, wether you have a "sqlnet.ora" in "$ORACLE_HOME/network/admin" or "/etc" ("/etc" wins if both exist!).

HTH,
Wodisch

[Ganesh Anekar]

Hi,

I check sqlnet.ora file

It is in $ORACLE_HOME\network\admin
but not in \etc

so what next?

ganesh

[John Palmer · Accepted solution]

Also ensure that you only have one tnsnames.ora file.

I believe that Oracle searches for it as follows:

1. TNS_ADMIN environment variable.
2. $ORACLE_HOME/network/admin
3. /etc

Regards,
John

[Ganesh Anekar]

hi,

I ensured that in ENV variables

1.TNS_ADMIN is set to
$ORACLE_HOME/network/admin

2.what about etc? what shall i check for etc?

ganesh

[Ganesh Anekar]

hi,

I checked for tnsnames.ora file it is only in
$ORACLE_HOME/network/admin directory.

ganesh