Re: Error accessing PRODUCT_USER_PROFILE...

"PasirRis" <jackling_at_singnet.com.sg> wrote in message news:98fr7v$d21$1_at_coco.singnet.com.sg...
> I first log in as internal.
>
> After the db is created and up, I run the catalog.sql and catproc.sql
 comes
> w/ Oracle to create the dynamics views etc.
>
> After that, I create a user a/c, e.g., myaccount, identified by password.
> Granting myaccount w/ create session, create table privileges, & dba role.
>
> Successful to log in as myaccount. However, as shown in the sample below,
 it
> mentions:
> "Error accessing PRODUCT_USER_PROFILE..."
>
> What does it mean? What implications and what are the steps I should do?
>
> thanks,
> jackling.
>
>
> Below is a sample:
>
> $sqlplus myaccount/password
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Sun Mar 11 00:31:47 2001
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> Error accessing PRODUCT_USER_PROFILE
> Warning: Product user profile information not loaded!
> You may need to run PUPBLD.SQL as SYSTEM
>
> Connected to:
> Oracle8i Release 8.1.7.0.0 - Production
> JServer Release 8.1.7.0.0 - Production
>
>

As the message says
You may need to run PUPBLD.SQL as SYSTEM

so please run the file pupbld.sql. It's location is platform dependent, and you don't mention your platform.

Hth,

Sybrand Bakker, Oracle DBA Received on Sun Mar 11 2001 - 07:08:25 CST