Enable archivelog

archive-logoracle

Screen Shot hereI'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:

  1. stop database

    shutdown immediate

  2. restart listener

    lsnrctl restart

  3. start database

    startup mount