Error accessing PRODUCT_USER_PROFILE

最新推荐文章于 2025-07-11 16:43:31 发布

转载最新推荐文章于 2025-07-11 16:43:31 发布 · 84 阅读

文章标签：

本文详细记录了在使用Oracle数据库时遇到的产品用户配置加载失败的问题，并提供了从加载失败到成功配置产品的完整步骤。包括了从错误信息分析、执行特定SQL脚本到最终成功创建公共同义词的全过程。

USER is "SYS"
SQL> conn gggggggg/gggggggg1127
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> show user;
USER is "gggggggg"
SQL> conn gggggggg/gggggggg1127
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> @$ORACLE_HOME/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-00980: synonym translation is no longer valid

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-01031: insufficient privileges

CREATE PUBLIC SYNONYM PRODUCT_PROFILE FOR SYSTEM.PRODUCT_PRIVS
*
ERROR at line 1:
ORA-01031: insufficient privileges

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-01031: insufficient privileges

CREATE PUBLIC SYNONYM PRODUCT_USER_PROFILE FOR SYSTEM.PRODUCT_PRIVS
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> SQL> conn gggggggg/gggggggg1127
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
You have mail in /var/mail/oracle
qwdb1:/oracle> pwd
/oracle
qwdb1:/oracle> id
uid=300(oracle) gid=300(dba)
qwdb1:/oracle> sqlplus gggggggg/gggggggg1127

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 29 16:34:00 2012

Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string      qwdb
db_unique_name                       string      qwdb
global_names                         boolean     FALSE
instance_name                        string      qwdb1
lock_name_space                      string
log_file_name_convert                string
service_names                        string      qwdb
SQL> show user;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-750272/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-750272/