SP2-0575 error
- From: "Adams, Matthew (GE Indust, ConsInd)" <MATT.ADAMS@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Oct 2008 10:41:13 -0400
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?
Other related posts:
