| tnsping unable to resolve [message #256699] |
Mon, 06 August 2007 06:59  |
preet_kumar
Messages: 204
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)
)
)
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
