On Sun, Apr 14, 2002 at 03:18:17PM -0800, Reddy, Madhusudana wrote:
>
> Enter user-name: ccadmin
> Enter password:
> Error accessing PRODUCT_USER_PROFILE
> Warning: Product user profile information not loaded!
> You may need to run PUPBLD.SQL as SYSTEM
--
Note:1019310.102 ( edited to run in the alotted time )
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 03-NOV-1999
Last Revision Date: 22-JAN-2002
Problem Description:
====================
You are receiving the following warning message when starting a SQL*Plus
session:
"WARNING-PRODUCT USER PROFILE INFORMATION NOT LOADED"
If you have run the "PUPBLD.SQL" script and are still receiving this warning,
then do the following:
Connect as user system, drop the PRODUCT_PRIVS view and rerun the "PUPBLD.SQL"
script.
Explanation:
============
SQL*Plus reads product restrictions from the PRODUCT_USER_PROFILE table when a
user logs in to SQL*Plus, and maintains those restrictions for the duration of
the session. Changes to PRODUCT_USER_PROFILE will only take effect the next
time the affected users login to SQL*Plus. If the PRODUCT_USER_PROFILE table is
created incorrectly, all users other than SYSTEM will see a warning when
connecting to Oracle from SQL*Plus, that the PRODUCT_USER_PROFILE information
is not loaded. This message is a warning you that the PRODUCT_USER_PROFILE
table has not been built in the SYSTEM account.
Running the SQL script "PUPBLD.SQL" ( or "V7PUP.SQL" on some platforms) will
build the PRODUCT_USER_PROFILE table, thus avioding the warning message.
.
--------------------------------------------------------------------------------
Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.
===============================================================
Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ray Stell
INET: stellr_at_cns.vt.edu
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sun Apr 14 2002 - 20:18:20 CDT
