Warning: Product user profile information not loaded

[oracle@NVMBD1BZY150D00 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 22 11:21:06 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn test/test

Error accessing PRODUCT_USER_PROFILE

Warning:  Product user profile information not loaded!

You may need to run PUPBLD.SQL as SYSTEM

Connected.

Problem Description:

Error accessing PRODUCT_USER_PROFILE

Warning:  Product user profile information not loaded!

You may need to run PUPBLD.SQL as SYSTEM

Cause:  PRODUCT_USER_PROFILE table not available

Action: run pupbld.sql by system user.

Problem Explanation:

The PRODUCT_USER_PROFILE (PUP) table provides product-level security that supplements the user-level security provided by the SQL GRANT and REVOKE commands and user roles. To create the PUP table, log in to SQL*Plus as the SYSTEM user and run PUPBLD.SQL which is located in the ORACLE_HOME\SQLPLUS\ADMIN directory with:

SQL> @%ORACLE_HOME%\SQLPLUS\ADMIN\PUPBLD.SQL

Oracle will throw the “roduct user profile information not loaded" when you have not run the pupbld.sql script.  To remove this warning, you just need to run pupbld.sql as the SYSTEM user

Solution Description:

1. Connect to database using system user.

SQL> connect system/xxx

Connected.

2. Run pupbld.sql script.

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.

Synonym dropped.

Synonym created.

DROP SYNONYM PRODUCT_USER_PROFILE

             *

ERROR at line 1:

ORA-01434: private synonym to be dropped does not exist

Synonym created.

Synonym dropped.

Synonym created.

3.Conect to database.

[oracle@NVMBD1BZY150D00 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 22 11:21:06 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn test/test

Connected.

I hope this article helped you. Your suggestions/feedback are most welcome.

Keep learning... Have a great day!!!