Re: Oracle Product_user_profile Error?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 17 Nov 2004 23:11:53 -0800
Message-ID: <1100761829.176200@yasure>

IANAL_VISTA wrote:

> "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?

It may be innocuous but it is irritating.

And would have gone away if Jim had done what he said he was going to do.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Nov 18 2004 - 01:11:53 CST