10.2.0.5 DBCA "Instance Management" is grayed out when adding an Second Instance

(Doc ID 1642695.1)

Last updated on APRIL 02, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

The following error will occur when adding an second instance on standby database via DBCA from 10.2.0.4 home.

The database options like,  'Configure Database Options',  'Delete a Database', 'Instance Management' are grayed out.

From DBCA Screen shot,

 

1) From OCR dump,

[DATABASE.DATABASES.stdby_db]
ORATEXT : STDBY_DB
SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_WRITE, OTHER_PERMISSION : PROCR_READ, USER_NAME : orafprod1, GROUP_NAME : dba}

[DATABASE.DATABASES.stdby_db.ORACLE_HOME]
ORATEXT : /u01/fprod/oracle/fproddb/racfprod/                     << You have a trailing "/"   in the value of ORACLE_HOME key

[DATABASE.DATABASES.stdby_db.DB_NAME]
ORATEXT :                                                                     <<  Database name is null

SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_WRITE, OTHER_PERMISSION : PROCR_READ, USER_NAME : orafprod1, GROUP_NAME : dba}

 

2) srvctl config database -d STDBY_DB -a

[orafprod1@msidrdb2 ~]$ srvctl config database -d STDBY_DB -a
msidrdb2 FPROD2 /u01/fprod/oracle/fproddb/racfprod/             << The problem is oracle home have an additional '/' registered in the OCR
DB_NAME: null
ORACLE_HOME: /u01/fprod/oracle/fproddb/racfprod/
SPFILE: null
DOMAIN: null
DB_ROLE: null
START_OPTIONS: null
POLICY:  AUTOMATIC
ENABLE FLAG: DB ENABLED

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms