[10.2.0.4] ORA-12526 : sys cannot access database in restricted session
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
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
0