error while accessing the orale 9i(sql plus)

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