Recently been tasked with planning an upgrade from 11.2.0.2 to 12.1.0.2.
After the upgrade I needed to install another database so the cluster had two databases.
Oracle Cluster = 12.1.0.2
Oracle Database = 11.2.0.2
So I ran dbca from the Oracle Database home and the installer got part of the way into adding the database and I saw:
PRCR-1006 : Failed to add resource ora<name>.db for null
PRCD-1183 : Failed to upgrade configuration of service type to version 11.2.0.2.0
PRCR-1071 : Failed to register or update resource type ora.service.type
CRS-0245 : User doesn't have enough privileges to perform the operation
Trying to implement the workaround in Doc ID
13460353.8 - Registration of 11.2 database fails against 12.1 CRS stack
(required fix for 11g DB with 12c GI).
We have 11.2.0.2 database
software and 12.1.0.2 clusterware currently install (we are preparing for to
upgrade). I am trying to create a new database and get CRS-0245. I have Bug 13460353 - Registration of 11.2 database fails against
12.1 CRS stack (required fix for 11g DB with 12c GI) ( Doc ID
13460353.8 ) and am planning on running the workaround:
[root bin]# ./crsctl modify type ora.lnxd.db -attr
"ATTRIBUTE=TYPE_VERSION,DEFAULT_VALUE=3.2"
CRS-4995: The command 'Modify
type' is invalid in crsctl. Use srvctl for this command.
Solution - Use the -unsupported flag.
[root@ bin]# ./crsctl modify type ora.database.type -attr "ATTRIBUTE=TYPE_VERSION,DEFAULT_VALUE=3.2" -unsupported
[root@ bin]# ./crsctl modify type ora.service.type -attr "ATTRIBUTE=TYPE_VERSION,DEFAULT_VALUE=2.2" -unsupported
Thank you for the post. Saved time by not creating the SR with Oracle.
ReplyDeleteJust worked like a charm. Sadly I created an SR and wasted 2 days, still without any luck.
ReplyDeleteThe main function of concurrency control is to ensure optimal levels of performance in the database even if various constraints are placed on the operations of the database.kpi dashboards
ReplyDeleteFirewall configuration will help in protecting the data and ensuring the security of the database. mysql dashboards
ReplyDeleteWorked like charm. Thx
ReplyDeleteشركة تنظيف سجاد بالرياض
ReplyDeleteشركة جلى بلاط بالرياض
شركة تنظيف موكيت بالرياض
شركة تنظيف مجالس بالرياض
ReplyDeleteشركة شحن اثاث من جدة الى الامارات
شركة شحن اثاث من مكة الى الامارات
شركة شحن عفش من الطائف الى الامارات
شركة تنظيف فرشات بالرياض
شركة قص اشجار بالرياض
شركة تنسيق حدائق بالرياض
شركة تركيب مظلات خشبية بالرياض
شركة ترميم بالرياض
شركة تنظيف كرفانات بالرياض