Re: product user profile warning

In article <1993Apr2.213950.663_at_vaxsar.vassar.edu>, 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

-- 

Easy!  You didn't load your "product user profile" into the database or
SQL*Plus can't find it.  In UNIX, (including SGI), you can need to run the
$ORACLE_HOME/sqlplus/admin/pupbld.sql from SYSTEM.  This will creates a set of
tables and views which allow you to control different privleges from different
users, (such as preventing certain users from doing UPDATE and DELETE from
SQL*Plus, or using HOST commands to gain access to the operating system.  It is
also used by SQL*ReportWriter for setting page limits to reports.
Then again, it's JUST a warning, you can ignore it and it won't hurt SQL*Plus
scripts.

================================================================================
Scott Stephens				inet:	sstephen.us.oracle.com
Oracle Offhour Support                  Redwood City, California