3 Replies Latest reply: Sep 28, 2012 12:46 AM by Sunny kichloo RSS

    Error accessing PRODUCT_USER_PROFILE - need to run PUPBLD.SQL.

    Prashant Dixit
      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 ...