Registration 11.2 DB on 18c Grid Infrastructure fails with CRS-0245

Hi,

When you try to create an 11.2 database instance on 18c Grid Infrastructure using DBCA or  “srvctl add database” command , instance registration fails with CRS-0245 as below.

PRCR-1006 : Failed to add resource ora.orc01.db for orc01
PRCD-1184 : Failed to upgrade configuration of database type to version 11.2.0.3.0
PRCR-1071 : Failed to register or update resource type ora.database.type
CRS-0245:  User doesn’t have enough privilege to perform the operation

This is due to Bug 13460353. For solution you can apply patch number 13460353 to 11.2.0.3 database home. This fix is needed in the 11.2 DB home in order to work with 12c GI.

You can also try the following commands may be used to work around the problems. (as root user)

/u01/app/18.0.0/grid/bin/crsctl modify type ora.database.type -attr “ATTRIBUTE=TYPE_VERSION,DEFAULT_VALUE=3.2” “-unsupported”
/u01/app/18.0.0/grid/bin/crsctl modify type ora.service.type -attr “ATTRIBUTE=TYPE_VERSION,DEFAULT_VALUE=2.2” “-unsupported”

After running below commands, you can run DBCA or srvctl successfully.

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s