Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Error accessing PRODUCT_USER_PROFILE

  1. #1

    Error accessing PRODUCT_USER_PROFILE


    I am getting error as below . this error warning comes when i am logged in as sysdba and try to connect as a rman user. please guide what should me action to resolve this error.

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

    Manish Kumar

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    New Delhi, India
    A) Make sure that the TWO_TASK or ORACLE_SID is set to the currect database.

    perform these steps

    1) cd $ORACLE_HOME/sqlplus/admin

    2) connect to the database as system user

    sql> sho user
    user "system"

    3) run the pupbld.sql script so that it will create the profiles and some synonyms under the system schemas then it will allow to use


+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training

Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics