Home » RDBMS Server » Networking and Gateways » Trouble connecting with tnsnames
Trouble connecting with tnsnames [message #228373] Mon, 02 April 2007 14:52 Go to next message
xadamz23
Messages: 7
Registered: June 2006
Junior Member
Hello,

I am having trouble connecting to a local database using tnsnames. I can connect from a remote PC just fine. Here are my specs:

-- Oracle 10g R2 w/patchset 10.2.0.3
-- listener.ora:
MOWBLSNR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle2.rhsnet.org)(PORT = 1529))
)

SID_LIST_MOWBLSNR =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mowb.rhsnet.org)
(ORACLE_HOME = /oraclebase/product/10.2.0)
(SID_NAME = mowb)
)
)

-- tnsnames.ora:
MOWB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle2.rhsnet.org)(PORT = 1529))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mowb.rhsnet.org)
)
)

-- sqlnet.ora:
NAMES.DEFAULT_DOMAIN= rhsnet.org

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Here is the output of tnsping:
oracle@oracle2:~> tnsping mowb

TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 02-APR-2007 14:49:52

Copyright (c) 1997, 2006, Oracle. All rights reserved.

Used parameter files:
/oraclebase/product/10.2.0/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

I know there is stuff on the net regarding this, but I cant find the answer to my problem.

Can anyone tell me why this isnt working?

Thanks
Re: Trouble connecting with tnsnames [message #228374 is a reply to message #228373] Mon, 02 April 2007 14:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>NAMES.DEFAULT_DOMAIN= rhsnet.org
try
#NAMES.DEFAULT_DOMAIN= rhsnet.org
instead

Post results from:
lsnrctl listener_MOWBLSNR status

[Updated on: Mon, 02 April 2007 14:59] by Moderator

Report message to a moderator

Re: Trouble connecting with tnsnames [message #228385 is a reply to message #228373] Mon, 02 April 2007 16:01 Go to previous messageGo to next message
xadamz23
Messages: 7
Registered: June 2006
Junior Member
I commented that out and it still does not work.

Here is the output of lsnrctl status MOWBLSNR:

oracle@oracle2:~> lsnrctl status MOWBLSNR

LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 02-APR-2007 16:01:10

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle2.rhsnet.org)(PORT=1529)))
STATUS of the LISTENER
------------------------
Alias MOWBLSNR
Version TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date 02-APR-2007 15:06:41
Uptime 0 days 0 hr. 54 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oraclebase/product/10.2.0/network/admin/listener.ora
Listener Log File /oraclebase/product/10.2.0/network/log/mowblsnr.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle2.rhsnet.org)(PORT=1529)))
Services Summary...
Service "mowb.rhsnet.org" has 1 instance(s).
Instance "mowb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Re: Trouble connecting with tnsnames [message #228392 is a reply to message #228373] Mon, 02 April 2007 20:41 Go to previous message
xadamz23
Messages: 7
Registered: June 2006
Junior Member
I figured out the problem. The file /etc/tnsnames.ora existed, but was empty. Apparently Oracle looks there before it looks in $ORACLE_HOME/network/admin/tnsnames.ora. I deleted the file /etc/tnsnames.ora and tnsping works.
Previous Topic: ORA-12154 only when logging in with my own login.
Next Topic: ORA-12571: TNS:packet writer failure
Goto Forum:
  


Current Time: Thu Mar 28 13:55:41 CDT 2024