Oracle Product_user_profile Error?

From: Jim Cheng <jinxcheng_at_hotmail.com>
Date: Tue, 16 Nov 2004 18:10:25 -0800
Message-ID: <cnebun$maq$1@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 Received on Tue Nov 16 2004 - 20:10:25 CST