各位好,我在windowsXP下安装了ORACLE10g,并升级到了10.2.0.2.0 ,安装过程正常,database启动正常,listener启动也正常。
主要环境变量如下:
ORACLE_HOME=D:\oracle\product\10.2.0\db_1
ORACLE_SID=orcl
db_name,instance_name,global_name显示如下:
SQL> show parameters db_name
NAME TYPE VALUE
------------------------------------ ----------- --------
db_name string orcl
SQL> show parameters instance_name
NAME TYPE VALUE
------------------------------------ ----------- --------
instance_name string orcl
SQL> show parameters global_name
NAME TYPE VALUE
------------------------------------ ----------- --------
global_names boolean FALSE
sqlnet.ora文件配置如下:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
tnsnames.ora文件配置如下:
ls_orcl=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.18.117)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener.ora配置如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCLRMAN)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jiqiming)(PORT = 1522))
)
TRACE_LEVEL_LISTENER = SUPPORT
启动listener 显示信息如下:
LSNRCTL> start
启动tnslsnr: 请稍候...
TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Production
系统参数文件为D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入D:\oracle\product\10.2.0\db_1\network\log\listener.log的日志信息
写入D:\oracle\product\10.2.0\db_1\network\trace\listener.trc的跟踪信息
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.3.18.117)(PORT=1522)))
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.3.18.117)(PORT=1522)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Produ
ction
启动日期 31-3月 -2010 17:07:04
正常运行时间 0 天 0 小时 0 分 1 秒
跟踪级别 support
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
监听程序日志文件 D:\oracle\product\10.2.0\db_1\network\log\listener.log
监听程序跟踪文件 D:\oracle\product\10.2.0\db_1\network\trace\listener.t
rc
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.3.18.117)(PORT=1522)))
服务摘要..
服务 "ORCL" 包含 1 个例程。
例程 "ORCL", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 "ORCLRMAN" 包含 1 个例程。
例程 "ORCLRMAN", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功
执行tnsping 命令(成功):
D:\>tnsping ls_orcl
TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 31-3月 -
2010 17:10:29
Copyright (c) 1997, 2005, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.18.
117)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (60 毫秒)
进入sqlplus,以服务端后台直接连(成功):
D:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on 星期三 3月 31 17:12:49 2010
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> conn system/oracle;
已连接。
进入sqlplus,以客户端本地命名方式连接(失败,且一直hang在那里):
SQL> conn system/oracle@ls_orcl ;
此时,检查sqlnet日志,产生如下信息:
Fatal NI connect error 12560, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.2.0 - Production
Time: 31-3月 -2010 17:15:26
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS: 协议适配器错误
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
检查listener.log,日志如下:
TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Production on 31-3月 -2010 17:07:04
Copyright (c) 1991, 2005, Oracle. All rights reserved.
系统参数文件为D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入D:\oracle\product\10.2.0\db_1\network\log\listener.log的日志信息
写入D:\oracle\product\10.2.0\db_1\network\trace\listener.trc的跟踪信息
跟踪级别当前为16
以 pid=2024 开始
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.3.18.117)(PORT=1522)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
31-3月 -2010 17:25:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=jack))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869824)) * status * 0
31-3月 -2010 17:26:04 * ping * 0
31-3月 -2010 17:26:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=JACKLI)(USER=jack))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.3.18.117)(PORT=1552)) * establish * orcl * 0
检查listener跟踪文件listener.trc,最后部分信息为:
[31-3月 -2010 17:26:20:824] nsmfr: normal exit
[31-3月 -2010 17:26:20:824] nsclose: normal exit
[31-3月 -2010 17:26:20:824] nsbeqaddr: connect handshake is complete
[31-3月 -2010 17:26:20:824] nsbeqaddr: normal exit
[31-3月 -2010 17:26:20:824] nsbequeath: normal exit
[31-3月 -2010 17:26:20:824] nsglhe: exit
[31-3月 -2010 17:26:20:824] nsevwait: entry
[31-3月 -2010 17:26:20:824] nsevwait: 2 registered connection(s)
[31-3月 -2010 17:26:20:824] nsevwait: 0 pre-posted event(s)
[31-3月 -2010 17:26:20:824] nsevwait: waiting for transport event (1 thru 3)...
我用PL/SQL DEVELOPER连也hang在那里,在其他机器上用sqlplus连我这台数据库服务器也hang在那里。
我能想到的信息都帖到这里了,希望能有人帮我分析下到底是什么问题,在线等待......
[ 本帖最后由 handsomeSJG 于 2010-3-31 21:56 编辑 ]
主要环境变量如下:
ORACLE_HOME=D:\oracle\product\10.2.0\db_1
ORACLE_SID=orcl
db_name,instance_name,global_name显示如下:
SQL> show parameters db_name
NAME TYPE VALUE
------------------------------------ ----------- --------
db_name string orcl
SQL> show parameters instance_name
NAME TYPE VALUE
------------------------------------ ----------- --------
instance_name string orcl
SQL> show parameters global_name
NAME TYPE VALUE
------------------------------------ ----------- --------
global_names boolean FALSE
sqlnet.ora文件配置如下:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
tnsnames.ora文件配置如下:
ls_orcl=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.18.117)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener.ora配置如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCLRMAN)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jiqiming)(PORT = 1522))
)
TRACE_LEVEL_LISTENER = SUPPORT
启动listener 显示信息如下:
LSNRCTL> start
启动tnslsnr: 请稍候...
TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Production
系统参数文件为D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入D:\oracle\product\10.2.0\db_1\network\log\listener.log的日志信息
写入D:\oracle\product\10.2.0\db_1\network\trace\listener.trc的跟踪信息
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.3.18.117)(PORT=1522)))
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.3.18.117)(PORT=1522)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Produ
ction
启动日期 31-3月 -2010 17:07:04
正常运行时间 0 天 0 小时 0 分 1 秒
跟踪级别 support
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
监听程序日志文件 D:\oracle\product\10.2.0\db_1\network\log\listener.log
监听程序跟踪文件 D:\oracle\product\10.2.0\db_1\network\trace\listener.t
rc
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.3.18.117)(PORT=1522)))
服务摘要..
服务 "ORCL" 包含 1 个例程。
例程 "ORCL", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 "ORCLRMAN" 包含 1 个例程。
例程 "ORCLRMAN", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
命令执行成功
执行tnsping 命令(成功):
D:\>tnsping ls_orcl
TNS Ping Utility for 32-bit Windows: Version 10.2.0.2.0 - Production on 31-3月 -
2010 17:10:29
Copyright (c) 1997, 2005, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.18.
117)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (60 毫秒)
进入sqlplus,以服务端后台直接连(成功):
D:\>sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on 星期三 3月 31 17:12:49 2010
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> conn system/oracle;
已连接。
进入sqlplus,以客户端本地命名方式连接(失败,且一直hang在那里):
SQL> conn system/oracle@ls_orcl ;
此时,检查sqlnet日志,产生如下信息:
Fatal NI connect error 12560, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.2.0 - Production
Time: 31-3月 -2010 17:15:26
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNS: 协议适配器错误
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
检查listener.log,日志如下:
TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Production on 31-3月 -2010 17:07:04
Copyright (c) 1991, 2005, Oracle. All rights reserved.
系统参数文件为D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入D:\oracle\product\10.2.0\db_1\network\log\listener.log的日志信息
写入D:\oracle\product\10.2.0\db_1\network\trace\listener.trc的跟踪信息
跟踪级别当前为16
以 pid=2024 开始
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.3.18.117)(PORT=1522)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
31-3月 -2010 17:25:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=jack))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869824)) * status * 0
31-3月 -2010 17:26:04 * ping * 0
31-3月 -2010 17:26:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=JACKLI)(USER=jack))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.3.18.117)(PORT=1552)) * establish * orcl * 0
检查listener跟踪文件listener.trc,最后部分信息为:
[31-3月 -2010 17:26:20:824] nsmfr: normal exit
[31-3月 -2010 17:26:20:824] nsclose: normal exit
[31-3月 -2010 17:26:20:824] nsbeqaddr: connect handshake is complete
[31-3月 -2010 17:26:20:824] nsbeqaddr: normal exit
[31-3月 -2010 17:26:20:824] nsbequeath: normal exit
[31-3月 -2010 17:26:20:824] nsglhe: exit
[31-3月 -2010 17:26:20:824] nsevwait: entry
[31-3月 -2010 17:26:20:824] nsevwait: 2 registered connection(s)
[31-3月 -2010 17:26:20:824] nsevwait: 0 pre-posted event(s)
[31-3月 -2010 17:26:20:824] nsevwait: waiting for transport event (1 thru 3)...
我用PL/SQL DEVELOPER连也hang在那里,在其他机器上用sqlplus连我这台数据库服务器也hang在那里。
我能想到的信息都帖到这里了,希望能有人帮我分析下到底是什么问题,在线等待......
[ 本帖最后由 handsomeSJG 于 2010-3-31 21:56 编辑 ]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/297293/viewspace-631827/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/297293/viewspace-631827/