Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Product_user_profile Error?
"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