New members: get your first 7 days of Courselog Premium for free! Unlock your discount now!

Hi DBAs,

Recently we faced a strange issue which became a show stopper for us.

Database Configuration Assistant was not showing the database and  Configure Database Options and it was greyed out(disabled).

 We tried setting up ORACLE_SID and ORACLE_HOME and ran dbca but it was not showing the database and the above option was  greyed out.

We checked and verified the oratab file for correct entry for the database we were trying to access from dbca but still it was greyed out.

To resolve this issue I utilized all my experience and knowledge at last was able to resolve it. The issue was simple and silly but sometimes small things matter.

Below are steps used to resolve this issue:


Leave a Reply

Your email address will not be published. Required fields are marked *