Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Product_user_profile Error?

Re: Oracle Product_user_profile Error?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 17 Nov 2004 01:54:35 -0800
Message-ID: <92eeeff0.0411170154.6c81ef22@posting.google.com>


"Jim Cheng" <jinxcheng_at_hotmail.com> wrote in message news:<cnebun$maq$1_at_news.Stanford.EDU>...
> I just installed Oracle 8.1.7.2 on Solaris 8.
> When I login as an ordinary user, I got the following warning:
>
> Error accessing PRODUCT_USER_PROFILE
> Warning: Product user profile information not loaded!
> You may need to run PUPBLD.SQL as SYSTEM
>
> So I tried to execute the SQL script as SYSTEM:
>
> $sqlplus /nolog
> SQL> connect / as sysdba
> Connected.
> SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
>
> However, there are some erros during the execution:
>
> date_value from product_user_profile
> *
> ERROR at line 3:
> ORA-00942: table or view does not exist
>
> After it is done, I get the same warning when I login as an ordinary user.
>
> What is the problem here?
>
> BTW, there were a few erros when I ran the following scripts during the
> database creation:
> @$ORACLE_HOME/rdbms/admin/catalog.sql
> @$ORACLE_HOME/rdbms/admin/catproc.sql
>
> Thank you,
> Jim

Run pupbld.sql as SYSTEM and not as SYS as you did. It's pretty clear from this message "You may need to run PUPBLD.SQL as SYSTEM".

connect system/password and then run the script again.

Regards
/Rauf Received on Wed Nov 17 2004 - 03:54:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US