Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help needed on warning message
On Fri, 25 Jun 1999 14:44:20 -0400, "cz" <zhangc_at_netcom.ca>
wrote:
>Warning: Product user profile information not loaded!
>Error in disabling roles in product user profile.
>
>I can still connect and do whatever I want.
This message is not nearly as bad as it sounds. You can
totally ignore it if you want, but then you'll get lots of
questions from your users. To fix it, you need to run a
script named PUPBLD.SQL. This is somewhere underneath your
Oracle home directory. Try looking in
$oracle_home/plus/admin. You may have to search for it,
because NT and Unix seem to put it in different directories.
Once you find where thtat script is, log in to your database as the SYSTEM user (not SYS, but SYSTEM), and execute the script. The script will create a table, a couple views, some synonyms, and the warning messages will go away.
regards,
Jonathan