0
Hi User,
Add the Connection String to the remote database in the TNSNAMES.ora usually located in $ORACLE_HOME\ora81\network\ADMIN
And, Once added you can check the Service for the database can be reached using http://www.oracleutilities.com/OSUtil/ping.html
Something like this, From Command Prompt,
C:\Documents and Settings\s0891811>tnsping orcl
TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 13-OCT-20
12 10:59:11
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\oracle\ora81\network\admin\sqlnet.ora
C:\oracle\ora81\network\admin\tnsnames.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 17.12.1.9)(PORT = 1521))) (CONNECT_DATA = (SID = orcl)))
OK (70 msec)
C:\Documents and Settings\s0891811>
Here orcl is the database you are trying to connect.
Thanks,
Shankar
0