oracle数据库user_error,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--