Re: SP2-0575 error

From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Sun, 5 Oct 2008 15:04:22 -0700
Message-ID: <2ead3a60810051504w7ba8188od65886a098a97df6@mail.gmail.com>


Matt, can you check if all the binaries and libraries have the right permissions for "others"?

John

On 10/3/08, Adams, Matthew (GE Indust, ConsInd) <MATT.ADAMS_at_ge.com> wrote:
> platform is 9.2.0.4 on HP-UX
>
> Users not in the unix group DBA, get the following error when attempting
> to get in via sqlplus
>
> SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
>
> and a failure to connect to the database, even though sqlplus does start
> and they
> end up at the SQL> prompt.
>
>
> Users in the DBA group get no such error and are connected. It doesn't
> seem to matter
> if the oracle account has the 'dba' role or not, only the unix group
> seems to matter.
>
> according to metalink, the most common cause of this is
> problems with the DUAL table, so I've verified that there is exactly
> one dual table with a public synonym and exactly one row.
>
>
> All the environmental variables
> (PATH, SHLIB_PATH, LD_LIBRARY_PATH, ORACLE_HOME, ORACLE_SID) are
> correct.
>
> And the user can connect to other 9.2.0 databases on this server (that
> have seperate ORACLE_HOME's)
>
> I'm at a loss to explain this behavior. Anybody have any ideas?
>
>
>
>
>
>

-- 
Sent from Gmail for mobile | mobile.google.com

John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Oct 05 2008 - 17:04:22 CDT

Original text of this message