Home » RDBMS Server » Server Administration » SQL*Plus hangs trying to logon
SQL*Plus hangs trying to logon [message #190225] Tue, 29 August 2006 15:52 Go to next message
yatingg
Messages: 16
Registered: August 2006
Junior Member
I can connect to the database from the server using SQLPlus. But I can't do the same on the client. It hangs after I submit the credentials.

I've read everywhere that it has to do w/ the listener and that it needs to be running. My listener seems to be running. I've posted the contents of my listener.ora & tnsnames.ora (server & client).

Please help. I don't know why I can't get connected from the client.

listener.ora on server
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = OracleSRV)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = OracleAC.sqalab.com)
      (ORACLE_HOME = C:\oracle\ora92)
      (SID_NAME = OracleAC)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = OEMREP.sqalab.com)
      (ORACLE_HOME = C:\oracle\ora92)
      (SID_NAME = OEMREP)
    )
  )



tnsnames.ora on server

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

OEMREP.SQALAB.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = OracleSRV)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = OEMREP.sqalab.com)
    )
  )

EXTPROC_CONNECTION_DATA.SQALAB.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

INST1_HTTP.SQALAB.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = OracleSRV)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

ORACLEAC.SQALAB.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = OracleSRV)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = OracleAC.sqalab.com)
    )
  )




tnsnames.ora on client

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLEAC_ORACLESRV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oraclesrv)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = OracleAC)
      (SERVER = DEDICATED)
      (SERVICE_NAME = OracleAC.sqalab.com)
    )
  )
Re: SQL*Plus hangs trying to logon [message #190226 is a reply to message #190225] Tue, 29 August 2006 15:59 Go to previous message
yatingg
Messages: 16
Registered: August 2006
Junior Member
Nevermind. Answering my own question, my host string was incorrect.
Previous Topic: deinstalling 9.2.0.6 patchset on HP-UX
Next Topic: clone db fr 815 to 92
Goto Forum:
  


Current Time: Tue Dec 06 12:29:00 CST 2016

Total time taken to generate the page: 0.10244 seconds