I'm trying to enable archivelog mode in Oracle database. For that I shutdown the services and used startup mount. Instead of database getting mounted, I'm getting error ORA- 12528 TNS – All instances are blocking new connections.
Any one can guide on this.
Best Answer
in which state your database was at the point you issue the shutdown command? Maybe the unregister in listener was incomplete. try:
stop database
shutdown immediate
restart listener
lsnrctl restart
start database
startup mount