|
|
Warning: Product user profile information not loaded
Oracle Database Tips by Donald BurlesonJanuary 9, 2015
|
Question:
I am trying to connect to SQL*Plus and I get the
message "Warning:
Product user profile information not loaded".
How do I load this
product user profile?
"Error accessing
PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM"
SQL*Plus
Enter user-name: xxx
Enter password:
Warning: Product user profile information not loaded!
Error in disabling roles in product user profile.
Answer: The Oracle docs note:
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 "Product
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:
SQL>
connect system/xxx
SQL>
$ORACLE_HOME/sqlplus/admin/pupbld.sql
You can sometimes see this error as well:
SP2-0623 - Error accessing PRODUCT_USER_PROFILE.
Warning: Product user profile information not loaded! You may need to run
PUPBLD.SQL as SYSTEM
Cause - The PRODUCT_USER_PROFILE table has not been built in the
SYSTEM account.
Action - The exact format of the file extension and location of the
file are system dependent. See the SQL*Plus installation guide provided for
your operating system. The script must be run as user SYSTEM.
Also, note that the product_user_profile must be owned by SYSTEM, and
you will get tan error if you run pupbld as SYS.
|
If you like Oracle tuning, you
might enjoy my book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get instant
access to the code depot of Oracle tuning scripts. |
|