Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

pupbld.sql errors

user633509Sep 30 2010 — edited Sep 30 2010

**BE NICE NEW TO ORACLE**

I just created a database in Oracle 11g (on OEL). I created serveral users. I tested the login of one of the users and came up with a warning: Product user profile information not loaded
You may need to run PUPBLD.SQL.

Okay so connected to the db using system and used the correct location of the script when running it. However, when running the script I recieve errors:
1)DROP SYNONYM PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist

I only posted one due to everything in the script errors out after that. And I know why because then it asked to create the table TABLE SQLPLUS_PRODUCT_PROFILE and can't so then the rest will error out too.
Anyways I was wondering if anyone ran into errors like this and could give me advice.

Thanks
Klcopela

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2010

Added on Sep 30 2010

#linux, #oracle-linux

1 comment

352 views