Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-12535 error ( Not using right port )
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:
ORCL11G.CORP.NCR.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 153.58.45.81)(PORT = 1522))
)
(CONNECT_DATA =
(SID = ORCL11G)
)
)
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))
)
)
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
![]() |
![]() |