connection from oracle client to oracle server

From: thi <thi2411_at_yahoo.com>
Date: 26 Nov 2001 14:55:18 -0800
Message-ID: <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 Mon Nov 26 2001 - 23:55:18 CET

Original text of this message