Re: Oracle Product_user_profile Error?

"Jim Cheng" <jinxcheng_at_hotmail.com> wrote in 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
>
>

I would have thought that anyone attending Stanford would know how to use GOOGLE. http://asktom.oracle.com/pls/ask/f?p=4950:8:15400562374212173458::NO::F4950 _P8_DISPLAYID,F4950_P8_CRITERIA:584223242750, It is an innocuous message.

P.S.
Did you even bother to open up $ORACLE_HOME/sqlplus/admin/pupbld.sql to see what what said in both the comments & the code? Received on Tue Nov 16 2004 - 20:37:27 CST