oracle10.2.01装上patch(10.2.02)后不能连接

leisuc

01安装未出现任何问题。

patch后，出现如下问题：

listener.log:

26-12月-2006 18:03:52 * ping * 0
26-12月-2006 18:06:26 * (CONNECT_DATA=(SID=orcl)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=CONNECTOR)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.101.3.152)(PORT=2043)) * establish * orcl * 12505
TNS-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID


sqlnet.log:
Time: 26-12月-2006 17:01:46
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
    TNS-12535: TNS: 操作超时
    ns secondary err code: 12606
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.101.7.201)(PORT=1057))


sqlnet.ora:


SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

listener.ora:

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

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = wkst-qatester)(PORT = 1521))
    )
  )


tnsnames.ora

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = wkst-qatester)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )