SP2-0575 error

From: Adams, Matthew (GE Indust, ConsInd) <MATT.ADAMS_at_GE.COM>
Date: Fri, 3 Oct 2008 10:41:13 -0400
Message-ID: <9B91048922998049A2BED0F0745FB4A906C93511@LOUMLVEM03.e2k.ad.ge.com>


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?          

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 03 2008 - 09:41:13 CDT

Original text of this message