How to fix “Error accessing PRODUCT_USER_PROFILE”?

When logging in SQL*PLus if one receives the following message.

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

This can be fixed by executing as SYSTEM
SQL> @?/sqlplus/admin/PUPBLD.SQL
..

And after the script is run reconnect as the user.
SQL> connect scott/tiger
Connected.

Advertisements

One comment

  1. i did the same but i got the same error message again. There were internal errors when the script was run like “private synonym to be dropped does not exist. I guess it is possible because i did not execute as system..actually i dont know how to do that. could you please elaborate on how to execute as SYSTEM??

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.