ORA-12526: TNS:listener: all appropriate instances are in restricted mode
Database Version: 10.2.0.4
Platform: HP UX 11.23
Application: Temenos
My database was running smoothly till noon yesterday. Eventually I got complained from application users that they are not getting connection to the database. There was "NO" abnormal message received in the database alert log. But there was following error message received in the application log:
ORA-12526: TNS:listener: all appropriate instances are in restricted mode
When I checked "select open_mode from v$database;" the result came "READ WRITE". But when I checked "select logins from v$instance;" it resulted "RESTRICTED".
After I give command "alter system disable resticted session;" the issue got resolved.
My question is:
What could be the possible reasons/causes for the issue, when no one neither run command:
1. startup restrict
nor
2. alter system enable restricted session;
I request the Gurus here on the forum to Please give me some points on this so that I can put solid statement to the management.
Regards,