connection from oracle client to oracle server
Date: 26 Nov 2001 14:55:18 -0800
Message-ID: <581a3baa.0111261455.588e7245_at_posting.google.com>
Hi,
ORACLE_DB =
ORCL =
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
(DESCRIPTION =
(SOURCE_ROUTE = OFF)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE_SERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SID = 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 Mon Nov 26 2001 - 23:55:18 CET