今天安裝的資料庫出現作業系統認證可以透過,口令檔案認證不能透過的情況.

[oracle@ud060 admin]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 28 09:33:57 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> conn sys/oracle@wldb as sysdba
ERROR:
ORA-01031: insufficient privileges


Warning: You are no longer connected to ORACLE.

結果發現是密碼檔案的檔名錯了,沒有.ora

[@more@]