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

On one of our database when customer tries to login into SQLPlus as protect (or any other account other than SYS or SYSTEM), the following set of messages appears:

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

This is warning message and customer of course can login into database, but for disappear this messages solution is pretty simple.

This warning message means PRODUCT_USER_PROFILE table has not been built in the SYSTEM account.

To create this table, a Database Administrator (DBA) must run the pupbld.sql script located in the $ORACLE_HOME/sqlplus/admin, this script must be run as SYSTEM user.

If the PRODUCT_USER_PROFILE table is created incorrectly, all users other than SYSTEM will see a warning when connecting to Oracle from SQL*Plus that the PRODUCT_USER_PROFILE information is not loaded.

Solution

$ cd $ORACLE_HOME/sqlplus/admin
$ ls
glogin.sql  help  libsqlplus.def  plustrce.sql  pupbld.sql

sqlplus 

Enter user-name: system
Enter password: ******

SQL> @ pupbld.sql