DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: pupbld.sql

  1. #1
    Join Date
    Mar 2001
    Posts
    78

    Question

    In 8.1.7 is pupbld.sql loacted at ORACLE_HOME/dbs/? I just created a DB manually and I'm trying to run that script as system but anytime I try it does not work.
    e.g.
    SQL> @$ORACLE_HOME/dbs/pupbld.sql
    SP2-0310: unable to open file "/u01/app/oracle/product/8.1.7/dbs/pupbld.sql"
    SQL>

    When I try to connect as an ordinary user, I get the message so I need to run that script:

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

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi,

    This file is available at two locations

    1) ORACLE_HOME/ora81/sqlplus/admin

    2) ORACLE_HOME/dev/DBS

    Regards
    Santosh

  3. #3
    Join Date
    Mar 2001
    Posts
    78
    I could not find it.

    $ cd $ORACLE_HOME/dev
    ksh: /oradata/ora/oracle/product/8.1.7/dev: not found.


    $ cd $ORACLE_HOME/ora81
    ksh: /u01/app/oracle/product/8.1.7/ora81: not found.

    I am using UNIX


  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    It should be in $ORACLE_HOME/sqlplus/admin on unix. If not, from an OS prompt:
    cd $ORACLE_HOME
    find . -name pupbld.sql -print

    to find out where it is
    Jeff Hunter

  5. #5
    Join Date
    Mar 2001
    Posts
    78
    I got it. Thanks

Posting Permissions

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


Click Here to Expand Forum to Full Width