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