We are continuing with the same series of listener errors. Let’s have looked over the new error. Let’s go for the steps

Condition for error

When Database is on in restricted on no mount status and you will see service handler for this instance is on BLOCKED or RESTRICTED state.

Solution:

Add (UR=A) in tnsnames.ora file.

Today’s Thought……

We can easily forgive a child who is afraid of the dark; the real tragedy of life is when men are afraid of the light. —Plato

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.