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.

  • 2
    Use a local connection: sqlplus / as sysdba. What you tried will not work without static listener registration. – Balazs Papp Nov 18 at 10:21
  • as a work around you can try a local connection to the database if this is possible. connect to the server and connect using sqlplus and 'connect / as sysdba' – miracle173 Nov 18 at 10:30

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

  • sorry, but that is wrong, Besides that , how should one issue a "shutdown immediate" if one cannot connect to the database – miracle173 Nov 18 at 10:28
  • you dont need a listener for os authentification as sysdba. Connect as sysdba shoud be possible – MarcelS Nov 18 at 10:31
  • 1
    I know, but the OP is not able to connect to the database to to do a "startup mount", so why do you think he is able to connect to the database to do a "shutdow immediate"? – miracle173 Nov 18 at 10:47
  • db is already shutdown.. so listener restart could be help. – MarcelS Nov 18 at 11:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.