sqlplus登录是报错,ORA-12570: TNS: 包阅读程序失败,提示重新输入用户名和密码后成功登录,很诡异.....,跪求高手指点迷津....
cmd 提示如下:
C:\Users\Administrator>sqlplus system/system@orcl as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期一 8月 13 09:48:37 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR:
ORA-12570: TNS: 包阅读程序失败
请输入用户名: system
输入口令:连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>
cmd 提示如下:
C:\Users\Administrator>sqlplus system/system@orcl as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期一 8月 13 09:48:37 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR:
ORA-12570: TNS: 包阅读程序失败
请输入用户名: system
输入口令:连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.oracle)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CID=(PROGRAM=F:\Database\app\Administrator\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=LENOVO-PC)(USER=Administrator)))) VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Time: 14-8月 -2012 10:14:26
Tracing not turned on.
Tns error struct:
ns main err code: 12570
TNS-12570: TNS: 包阅读程序失败
ns secondary err code: 12560
nt main err code: 530
TNS-00530: 协议适配器错误
nt secondary err code: 53
nt OS err code: 0
Tue Aug 14 10:14:38 2012
或者system/你的sys密码
输入:services.msc
打开服务,找到ORACLE的监听服务OracleOraDb10g_homeTNSListener,启动即可