SQLPLUS connect error for user
Date: Thu, 24 Mar 94 23:35:50 EST
Message-ID: <gate.wuBqJc1w164w_at_supa.supacom.brisnet.org.au>
>I'm a newby DBA (by default, since no one else would do it).
> We just purchased
>ORA 7 for SunOS server, and client PCs and MACs. Everything
> has gone fine, except
>for one teeny little thing...
>
>I created a new database, called "engs" with rollback segments,
> tables etc. Seems
>to be fine. Now, I've created a new user, DEB. If I'm in sqldba,
> and I connect
>as deb/password, everything is fine. However, if I try to use
> sqlplus and login
>as deb/password I get the following warning message:
>
>-----------------------------------------------------------
>Warning: Product user profile information not loaded!
>Error in disabling roles in product user profile.
>
>Connected to:
>ORACLE7 Server Release 7.0.15.4.0 - Production
>
>SQL>
[B-------------------------------------------------------------
>
>Now, the *really* wierd aspect, is that if I connect as system/passwd,
> no problem; if
>I connect as sys/passwd, I GET THE SAME KIND OF WARNING MESSAGE.
>
>
[B am baffled. Has anyone else ever seen this??? What do I need
> to do? It *seems*
>t[Bwork... but...
> [B
Hi Deborah, I think I remember this problem once way back in Oracle5.
The problem was that the users product profile was not set up. So try
checking out product profiles in the DBA guide.
By the way, SQLPlus will work correctly for the users, the profile is to
Regards, TIGER Received on Fri Mar 25 1994 - 05:35:50 CET