Alex Lima

How to fix “Error accessing PRODUCT_USER_PROFILE”?

Published by

Alex Lima

on

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.

One response to “How to fix “Error accessing PRODUCT_USER_PROFILE”?”

  1. Ankith Prabhu Avatar
    Ankith Prabhu

    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??

    Like

    Reply

Leave a reply to Ankith Prabhu Cancel reply

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

Previous Post
Next Post

Alex Lima

About

Taking one day at a time.

Follow Us

Blog at WordPress.com.