Re: product user profile warning

In article <37.2bbe4fe7_at_software-ag.de> joefw_at_eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek) writes:
>Message-ID: <C4vDz5.Lp0_at_skates.gsfc.nasa.gov>
>Sender: usenet_at_skates.gsfc.nasa.gov
>Organization: NASA/GSFC, Code 902.2
>Date: Fri, 2 Apr 1993 18:56:55 GMT
>Lines: 18
>
>I have 2 oracle instances (v6) running on an SGI. I thought I set them
>up identically but when I connect into one of them I get a warning:
>
> Warning: Product user profile information not loaded.
>
>I don't get the warning when connecting to the other instance. The SQLPlus and
>SGI Installation manuals mention the glogin.sql and login.sql files which I
>would suspect except I don't have either file anywhere on the system (so that
>doesn't explain why I would get the warning for one instance and not the other).
>My environment is the same, except for ORACLE_SID.
>
>Any suggestions would be appreciated.
>
>
>Joe Fulson-Woytek
>Code 902/Goddard DAAC
>NASA/Goddard Space Flight Center
>joefw_at_eosdev1.gsfc.nasa.gov

This should be in the FAQ if it isn't already. Run the PUPBUILD.SQL or PUPBLD.SQL scripts to build the product_user_profile table in the system account of the instance that generates the error message.

For more information, look up product_user_profile in the RDBMS or SQL*Plus manuals.

• Dan

Daniel Druker
Anderson Graduate School of Management at UCLA                    

| Dan Druker                                                               |
| agsm mail 	: ddruker                                                  |
| internet 	: ddruker_at_agsm.ucla.edu                                    |
| oracle*mail	: unix:ddruker_at_agsm.ucla.edu                               |
----------------------------------------------------------------------------

Disclaimer: None. I'm a student now and I don't care what you think. Received on Mon Apr 05 1993 - 10:03:10 CEST