存储架构

Configure Database option is greyed out in DBCA

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:









Step 1:


Make sure the ORACLE_HOME is some thing like below : /u01/app/oracle/12.1/dbhome in /etc/oratab file


(Note we should not have ‘/’ after dbhome)







Step 2:

Check the value of the configuration of  RAC Database:

srvctl config database -d testdb1

Where:
testdb1=> DB Name.

Now change the ORACLE_HOME value as below:

srvctl modify database -o /u01/app/oracle/12.1/dbhome

Where: 
/u01/app/oracle/12.1/dbhome=> ORACLE HOME location.

Make sure you don’t use ‘/’ after dbhome.


Step 3:

Now launch ‘dbca’ bye setting correct Environment.

Now you should see the option enabled for Configure Database Options after launching dbca.

Enjoy troubleshooting Database….

Happy DBA Learning…

Thanks,

Rafi

展开阅读全文

微信扫一扫,分享到朋友圈

Configure Database option is greyed out in DBCA
0

卡巴斯基推出全新品牌和视觉标识

上一篇

支付宝推出“关怀版” 再也不怕爸妈不会用了

下一篇

你也可能喜欢

评论已经被关闭。

插入图片
******* Rafi ORACLE DBA & APPS DBA Blog******* 投稿者
我还没有学会写个人说明!
最近文章
  • * 没有更多文章了
  • Configure Database option is greyed out in DBCA

    长按储存图像,分享给朋友