On Mar 6, 7:21 am, "peter" <hhh.datab..._at_gmail.com> wrote:
> 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
Normal behavior.
SQL*Net uses one port to get in touch with the listener, and one port
for the actual communications.
If you want to disable this: there are various ways to accomplish
this. They are all documented and have been published numerous times
here by me.
But obviously, again you didn't read the manual, and you didn't search
Google, because you love wasting others people's time, because you are
just too lazy for a sucessfule DBA career.
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Mar 06 2007 - 03:26:29 CST
