oracle中使用者登入出現Error accessing PRODUCT_USER_PROFILE問題的解決方法

cnhtm發表於2010-02-23
OracleError

在oracle資料庫例項中，剛剛建立的使用者scott，登入時報告如下錯誤：

sys@CNHTM> conn scott/tiger
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.

這裡提示要以system使用者執行pubbld.sql指令碼。

[@more@]

用system使用者登入

sys@CNHTM> conn system/oracle
Connected.

執行pupbld.sql

pupbld.sql指令碼在$ORACLE_HOME/sqlplus/admin目錄下，檔名為小寫（在unix/Linux)中要注意檔名大小寫

system@CNHTM> @?/sqlplus/admin/pupbld.sql
DROP SYNONYM PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist


DATE_VALUE FROM PRODUCT_USER_PROFILE
*
ERROR at line 3:
ORA-00942: table or view does not exist


DROP TABLE PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-00942: table or view does not exist


ALTER TABLE SQLPLUS_PRODUCT_PROFILE ADD (LONG_VALUE LONG)
*
ERROR at line 1:
ORA-00942: table or view does not exist



Table created.

DROP TABLE PRODUCT_PROFILE
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW PRODUCT_PRIVS
*
ERROR at line 1:
ORA-00942: table or view does not exist



View created.


Grant succeeded.

DROP PUBLIC SYNONYM PRODUCT_PROFILE
*
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist



Synonym created.

DROP SYNONYM PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist



Synonym created.

DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist



Synonym created.

system@CNHTM>

再次用scott使用者登入，已經正常

system@CNHTM> conn scott/tiger
Connected.
scott@CNHTM>

--end--

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22049049/viewspace-1031364/，如需轉載，請註明出處，否則將追究法律責任。

相關文章