--今天在處理修改密碼的時候出現了,如下的問題,經過搜索相關問題,已解決
--原因通常是由於手動建庫導致沒有執行過@$ORACLE_HOME/sqlplus/admin/pupbld.sql這個腳本導致。
--解決方法報錯中也給出了,You may need to run PUPBLD.SQL as SYSTEM
--使用system用戶登陸,執行腳本即可
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
--首先登陸數據庫,修改用戶的密碼,然後進行測試connect,報錯
[oracle@ilogdbtest ~]$ sqlplus / as sysdba
SQL> alter user qcarilog identified by xxxxxx;
User altered.
SQL> connect qcarilog/xxxxxxx
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> exit
--用system用戶登陸,執行腳本
SQL> conn system/system
Connected.
SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
--再次嘗試用該用戶登陸,無報錯,問題解決
[oracle@ilogdbtest ~]$ sqlplus / as sysdba
SQL> connect qcarilog/xxxxxx
Connected.