Connection Problem

[jsulman]

Greetings,
I am having a strange problem with connecting to ORACLE. I have just installed the client 9.2.0.1.0.

When I use a service name like CEAS_MCC I get a 12154 error TNS Could not resolve service name. However, if I add the IP address to the service name like M_152.225.91.090 I can connect with the same TNS Names data.

This problem did not exist in my previous version of ORACLE.

One more piece of info. I can connect through the Oracle Enterprise Manger Console using the normal service name (CEAS_MCC) but cannot us it to connect through such third part software such as TOAD or Crystal Reports.


Here are the two TNSNAMES.ORA entries:

/* This one works */
M_152.225.91.090 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ms00162f.mcc.irs.gov)(PORT = 1623))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CEAS.MCC.PPP.COM)
)
)

/* This one does not work */
CEAS_MCC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ms00162f.mcc.irs.gov)(PORT = 1623))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CEAS.MCC.PPP.COM)
)
)


My SQLNet.ora file looks like this
NAMES.DEFAULT_DOMAIN = dstest.irsnet.gov

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)

Does anybody have any ideas?

Thank You In Advance

 

[dbtoo2001]

here's my idea:

http://download.oracle.com/docs/cd/B10501_01/network.920/a96580/config_c.htm#484186

SQLNET.ORA is appending dstest.irsnet.gov to CEAS_MCC. It won't append it to your M_152.225.91.090 because it is a 'qualified' name (because it has the . in it.)


Use fully qualifed 'names' in your tnsnames.ora file.

CEAS_MCC.dstest.irsnet.gov


sqlnet.ora
Located on client and database server computer, this file may contain:

Client domain to append to unqualified service names or net service names

 

[engineer2100]

Or Remove the

NAMES.DEFAULT_DOMAIN = dstest.irsnet.gov

entry from SQLNET.ORA and set the service name to CEAS_MCC

OR

set the service name to

CEAS_MCC.dstest.irsnet.gov

 

[jsulman]

Found the problem. The default domain name given in the SQLNET.ora file was being appended to my service name. It was trying to connect to CEAS_MCC.whateverthedefdomnameis.com.

When the service name has an IP address in it like M.122.22.33.123 it does not append the default domain. So commenting the domain name fixed the problem.

Thanks for your help.

Jeff