Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help needed on warning message

Re: Help needed on warning message

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sun, 27 Jun 1999 16:08:52 GMT
Message-ID: <37804bf0.9495083@netnews.worldnet.att.net>


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



jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Sun Jun 27 1999 - 11:08:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US