Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/ora/8.1.7/bin/oracle)(ARGV0=oraclemvs)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=omc)(USER=root)))) VERSION INFORMATION: TNS for Linux: Version 8.1.7.0.0 - Development Oracle Bequeath NT Protocol Adapter for Linux: Version 8.1.7.0.0 - Development Time: 24-NOV-2004 17:36:05 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 530 TNS-00530: Protocol adapter error nt secondary err code: 9 nt OS err code: 0
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/ora/8.1.7/bin/oracle)(ARGV0=oraclemvs)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=omc)(USER=root)))) VERSION INFORMATION:
TNS for Linux: Version 8.1.7.0.0 - Development
Oracle Bequeath NT Protocol Adapter for Linux: Version 8.1.7.0.0 - Development
Time: 24-NOV-2004 17:36:05
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 9
nt OS err code: 0
#501 1522 1 0 09:58 ? 00:00:00 ora_pmon_mvs
#501 1524 1 0 09:58 ? 00:00:00 ora_dbw0_mvs
#501 1526 1 0 09:58 ? 00:00:00 ora_lgwr_mvs
#501 1528 1 0 09:58 ? 00:00:00 ora_ckpt_mvs
...
用root,sqlplus /nolog
SQL> connect
输入用户密码后包错:
Enter user-name: abc
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
为什么?
oracle 484 1 0 08:40:25 ? 0:01 oraclephp (LOCAL=NO)
oracle 312 1 0 08:17:32 ? 0:00 ora_pmon_php
oracle 348 1 0 08:17:53 ? 0:02 /home/oracle/product/9.2.0/bin/tnslsnr LISTENER -inherit
oracle 314 1 0 08:17:32 ? 0:00 ora_dbw0_php
oracle 316 1 0 08:17:32 ? 0:00 ora_lgwr_php
oracle 318 1 0 08:17:33 ? 0:00 ora_ckpt_php
oracle 320 1 0 08:17:33 ? 0:02 ora_smon_php
oracle 322 1 0 08:17:33 ? 0:00 ora_reco_php
oracle 324 1 0 08:17:33 ? 0:00 ora_cjq0_php
oracle 326 1 0 08:17:33 ? 0:33 ora_qmn0_php
oracle 328 1 0 08:17:33 ? 0:00 ora_s000_php
oracle 330 1 0 08:17:33 ? 0:00 ora_d000_php
oracle 1327 1311 0 15:26:31 pts/2 0:00 -bash
oracle 1326 1311 0 15:26:31 pts/2 0:00 ps -ef
oracle 1311 1309 0 15:26:13 pts/2 0:00 -bash
oracle 657 1 0 08:52:16 ? 0:00 oraclephp (LOCAL=NO)
我的服务器显示情况
我分析,应该是用户权限和启动文件的问题。
用:sqlplus name/passwd失败,而用sqlplus name/passwd@ocl就能成功,搞不懂,高手执教