Re: connection from oracle client to oracle server

First, the tnsnames.ora file should be located in /Oracle/Ora81/Network/admin/ directory unless you change the default location.

Second, you might need to add (SERVICE_NAME=ORCL) right after (SID_ORCL) line
Third, I don't think you need the entry about ORCL = ....

Finally, you should use ORACLE_DB as your connection string instead of ORCL. Good Luck.

thi2411_at_yahoo.com (thi) wrote in message news:<581a3baa.0111261455.588e7245_at_posting.google.com>...
> Hi,
> I don't know much about Oracle.
> Please help !!!
> After installing Oracle client to my computer, I try to establish a connection
> to Oracle server.
> First, I update :/Oracle/Ora81/Network/tnsnames.ora
>
> ORACLE_DB =
> (DESCRIPTION =
> (SOURCE_ROUTE = OFF)
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE_SERVER)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = ORCL)
> )
> )
>
> ORCL =
> (DESCRIPTION =
> (SOURCE_ROUTE = OFF)
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = MY_COMPUTER_NAME)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ORCL)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> However, I still get the ORA-12537: TNS - Connection closed ERROR whenever I try
> to access to the database from my computer.
> Is there anything else I need to update?
>
> Thanks,
> Thi
Received on Wed Nov 28 2001 - 22:25:29 CET