Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-12535 error ( Not using right port )

ORA-12535 error ( Not using right port )

From: peter <hhh.database_at_gmail.com>
Date: 5 Mar 2007 22:21:46 -0800
Message-ID: <1173162106.890100.87180@q40g2000cwq.googlegroups.com>


C:\>SQLPLUS "SCOTT/TIGER_at_ORCL11G" SQL*Plus: Release 9.2.0.8.0 - Production on Tue Mar 6 11:37:58 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-12535: TNS:operation timed out

Enter user-name:



tnsnames.ora

ORCL11G.CORP.NCR.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 153.58.45.81)(PORT = 1522))
    )
    (CONNECT_DATA =
(SID = ORCL11G)

    )
  )



Listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = ORCL11G)
(ORACLE_HOME = D:\oracle\product\10.1.0\db_1)
(SID_NAME = ORCL11G)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 153.58.45.81)(PORT = 1522))
    )
  )



Listener.log

06-MAR-2007 11:31:43 * (CONNECT_DATA=(SERVER=DEDICATED) (SERVICE_NAME=ORCL11G)(CID=(PROGRAM=D:\oracle\product\10.1.0\db_1\bin \sqlplus.exe)(HOST=WINAK185100-TU8)(USER=AK185100))) * (ADDRESS=(PROTOCOL=tcp)(HOST=153.58.45.81)(PORT=4370)) * establish * ORCL11G * 0



SQLNet.ora

NAMES.DEFAULT_DOMAIN = corp.ncr.com Received on Tue Mar 06 2007 - 00:21:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US