After building your Oracle 11g database you receive the following error upon login to SQLPLUS as a user other than SYS or SYSTEM:

Error:

Error accessing PRODUCT_USER_PROFILE

Warning:  Product user profile information not loaded!

You may need to run PUPBLD.SQL as SYSTEM

 

The following procedure install the correct components to resolve this error:

1.  Login to SQLPLUS as the DBSNMP user and note the error received.

SQL> connect dbsnmp/ucop_pass@ucop1

Error accessing PRODUCT_USER_PROFILE

Warning:  Product user profile information not loaded!

You may need to run PUPBLD.SQL as SYSTEM

Connected.

SQL>

2. Reconnect as the SYSTEM user.

SQL> connect system/ucop_pass@ucop1

Connected.

SQL>

 

3. Execute the command.

 

Windows:

SQL> @?/sqlplus/admin/pupbld.sql

 

Linux / Unix

SQL> @?\sqlplus\admin\pupbld.sql

4. Re-connect as DBSNMP user.

SQL> connect dbsnmp/ucop_pass@ucop1

Connected.

SQL>

Note:  the error message does not appear.

 

 

Larry Catt