Home » RDBMS Server » Networking and Gateways » tnsping unable to resolve
tnsping unable to resolve [message #256699] Mon, 06 August 2007 06:59 Go to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
Below given is the configuration for tnsnames,sqlnet and listner on the primary database.The setup consist of primary and standby database.
It gives error while doing tnsping ORA10G.domain.de or ORA10G
Whats wrong in the configuration file,please help


TNSNAMES.ORA
--------------
ORA10G_primary.domain.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.111.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORA10G)
(SERVICE_NAME = ORA10G.domain.de)
)
)

ORA10G_secondary.domain.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.111.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORA10G)
(SERVICE_NAME = ORA10G.domain.com)
)
)


EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL =IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

SQLNET.ORA
--------------

NAMES.DIRECTORY_PATH = (TNSNAMES, LDAP, HOSTNAME)
BEQUEATH_DETACH=yes
AUTOMATIC_IPC=ON
NAMES.DEFAULT_DOMAIN = domain.com
SQLNET.EXPIRE_TIME=2

LISTNER.ORA
------------

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.111.1.1)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /export/home/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
(ENVS="EXTPROC_DLLS=ANY")
)
(SID_DESC =
(GLOBAL_DBNAME = ORA10G.domain.com)
(SID_NAME = ORA10G)
(ORACLE_HOME = /export/home/app/oracle/product/10.2.0/db_1)
)
)
Re: tnsping unable to resolve [message #256709 is a reply to message #256699] Mon, 06 August 2007 07:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Error? Which error? I don't see any error message in what you posted.

And I don't see any ORA10G.* entry in tnsnames.ora

Regards
Michel
Re: tnsping unable to resolve [message #256715 is a reply to message #256699] Mon, 06 August 2007 07:29 Go to previous messageGo to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
When i try to ping the servive name ora10g.domain.com it gives the below given error
TNS-03505: Failed to resolve name
Re: tnsping unable to resolve [message #256725 is a reply to message #256715] Mon, 06 August 2007 08:04 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course it can't resolve the name, it is not in tnsnames.ora.

Regards
Michel
Previous Topic: Error while using Oracle Transparent Gateways
Next Topic: ORA-12514 (error after reboot Win2003 R2)
Goto Forum:
  


Current Time: Sat Dec 03 14:15:22 CST 2016

Total time taken to generate the page: 0.04329 seconds