oracle中用户登录出现Error accessing PRODUCT_USER_PROFILE问题的解决方法

在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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22049049/viewspace-1031364/