Chinaunix

标题: 关于“ERROR: ORA-12571: TNS:packet writer failure”的问题 [打印本页]

作者: mys3721 时间: 2009-07-29 15:12
标题: 关于“ERROR: ORA-12571: TNS:packet writer failure”的问题
oracle 8i的数据库启动正常，但就是连不上，具体错误如下：

ntsb2> dbstart

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production

SVRMGR> Connected.
SVRMGR> ORACLE instance started.
Total System Global Area                      265679272 bytes
Fixed Size                                        94632 bytes
Variable Size                                  108118016 bytes
Database Buffers                               157286400 bytes
Redo Buffers                                     180224 bytes
Database mounted.
Database opened.
SVRMGR>
Server Manager complete.

Database "ora7" warm started.

LSNRCTL for DEC OSF/1 AXP: Version 2.3.2.1.0 - Production on 29-JUL-09 14:44:33

Copyright (c) Oracle Corporation 1994.  All rights reserved.

Starting /usr/ora732/app/oracle/product/7.3.2/bin/tnslsnr: please wait...

TNSLSNR for DEC OSF/1 AXP: Version 2.3.2.1.0 - Production
System parameter file is /etc/listener.ora
Log messages written to /usr/ora732/app/oracle/product/7.3.2/network/log/listeng
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=10)(HOST=192.0.0.202)(PORT=1521))

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.0.0.202)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for DEC OSF/1 AXP: Version 2.3.2.1.0 - Producn
Start Date             29-JUL-09 14:44:36
Uptime                   0 days 0 hr. 0 min. 0 sec
Trace Level             off
Security                OFF
SNMP                   OFF
Listener Parameter File /etc/listener.ora
Listener Log File       /usr/ora732/app/oracle/product/7.3.2/network/log/listg
Services Summary...
  ora7       has 1 service handler(s)
The command completed successfully
ntsb2>
ntsb2> sqlplus "/ as sysdba"

SQL*Plus: Release 3.3.2.0.0 - Production on Wed Jul 29 14:46:33 2009

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

ERROR: ORA-01017: invalid username/password; logon denied

ntsb2> sqlplus ntsb/ntsb

SQL*Plus: Release 3.3.2.0.0 - Production on Wed Jul 29 14:56:21 2009

Copyright (c) Oracle Corporation 1979, 1994.  All rights reserved.

ERROR: ORA-12571: TNS:packet writer failure

Enter user-name:

ERROR: ORA-12571: TNS:packet writer failure

通过客户端sqlplus连接则提示“ora-12541: TNS:没有监听器”

请教各位大侠，这是为什么？？？

作者: manunix 时间: 2009-07-29 19:47
看看sqlnet.ora文件中有没有"Sqlnet.authentcation_services=(NTS)"这一行,如果有,注释掉看看如何.

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)