linux下创建密码文件的格式为orapw,windows下为pwd.ora
刚刚因为弄混了两种格式,白白耗费了几十分钟时间。
事情大致如下,登陆server始终无法使用sqlplus登陆,报如下错误
orasw/app/oracle/product/10.2.0.4/bin>sqlplus / as sysdba
Message 395 not found; product=SQLPlus; facility=SP2
Message 396 not found; product=SQLPlus; facility=SP2
Message 397 not found; product=SQLPlus; facility=SP2
Message 398 not found; product=SQLPlus; facility=SP2
Message 399 not found; product=SQLPlus; facility=SP2
Message 400 not found; product=SQLPlus; facility=SP2
Message 403 not found; product=SQLPlus; facility=SP2
Message 743 not found; product=SQLPlus; facility=SP2
Message 402 not found; product=SQLPlus; facility=SP2
Message 401 not found; product=SQLPlus; facility=SP2
尝试一大堆方法均无效,于是改用远程登陆,创建密码文件的时候居然使用了pwd.ora格式,
$ORACLE_HOME/bin/sqlplus sys/oracle@aaa.world as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Wed May 2 03:58:35 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
起初还以为sqlnet.authetication_services设置出了问题,最后才发现原来是这个低级错误所致。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15480802/viewspace-722562/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15480802/viewspace-722562/