This content has been marked as final. Show 1 reply
Hello,1 person found this helpful
you did not specify any version of the database or client, but this error normaly means that you database has a restricted state on the database listener.
For example if your dba issue the following command on the database site
alter system enable restricted session;
then no new connection can made with the error you described until the dba ends this
alter system disable restricted session;
Of course there can also be other things which produce this error so give us more information like last errors from the alert log, lsnrctl status output or a select from your v$insance which can look something like this...
SQL> select logins from v$instance;