ORA-12528: TNS:listener: all appropriate instances are blocking new connections This is a new Oracle 10g error code, which is normally visible during instance startup.
If this error message is still displayed a few minutes after trying to start the instance, check if there is no problem starting up the instance.
You might want to check for invalid database parameters, missing control files, database corruption, ...
Forum Messages
when i try to connect to the database, i received this error : ORA-12528: TNS:listener: all appropriate instances are blocking new connections. how can i clear it.. |
| : -> 11-FEB-2008 02:52:52 | startup | DbMotive | Reply |
Hello,
You have to startup your database. If this is unsuccessful, check for errors in the alert.log or oradim.log files |
| LISTNER BLOCK |
| : -> 30-MAY-2008 14:27:23 | More info needed | DbMotive | Reply |
| Can you please provide more info, is the instance running, do you see errors in the alert.log file or oradim.log file? |
Add your message for ORA-12528
|