Database Administration (MOSC)

MOSC Banner

[10.2.0.4] ORA-12526 : sys cannot access database in restricted session

edited Jan 26, 2010 7:21AM in Database Administration (MOSC) 4 commentsAnswered
 Hi The 10g administrator's guide says :
To place an instance in restricted mode, where only users with administrative privileges can access it, use the SQL statement ALTER SYSTEM with the ENABLE RESTRICTED SESSION clause.

I ran that command :
Once in restricted session, application users can't access database, but administrators too.

When I try to logon using : sqlplus sys/pwd@SID as sysdba, I've got the following error :
ORA-12526: TNS:listener: all appropriate instances are in restricted mode

Do you have an explanation?

Rgds

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center