This discussion is archived
3 Replies Latest reply: Sep 27, 2012 10:46 PM by Sunny kichloo RSS

Error accessing PRODUCT_USER_PROFILE - need to run PUPBLD.SQL.

PrashantDixit Newbie
Currently Being Moderated
Hi,

Today after creating some of the user accounts in Database we started getting issues about users recieving error messages when trying to connect.
Purpose behind these test accounts to perform backup operations.

SQL> conn genietes1/XXXXX
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.

Issue still persists evern after we executed 'pupbld.sql' in /u01/app/oracle/product/10.2.0/db_1/sqlplus/admin directory.


Results after running pupbld.sql file
================================

SQL> @pupbld.sql
Synonym dropped.

DATE_VALUE FROM PRODUCT_USER_PROFILE
*
ERROR at line 3:
ORA-00980: synonym translation is no longer valid


DROP TABLE PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-00942: table or view does not exist


ALTER TABLE SQLPLUS_PRODUCT_PROFILE ADD (LONG_VALUE LONG)
*
ERROR at line 1:
ORA-01430: column being added already exists in table


CREATE TABLE SQLPLUS_PRODUCT_PROFILE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object


DROP TABLE PRODUCT_PROFILE
*
ERROR at line 1:
ORA-00942: table or view does not exist

View dropped.

View created.

Grant succeeded.

Synonym dropped.

Synonym created.

DROP SYNONYM PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist

Synonym created.

Synonym dropped.

Synonym created.

Assistance Required.


Thanks
Ant ...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points