Showing posts with label ORA-29702: error occurred in Cluster Group Service operation. Show all posts
Showing posts with label ORA-29702: error occurred in Cluster Group Service operation. Show all posts

Friday, April 14, 2017

10g database with 11g Grid infrastructure

11gR2 Grid Infrastructure with lower version DB

I had a situation where I need to have 11gR2 infrastructure Grid with lower version Database 10gr2.
faced issues starting the database after 11gr2 grid install.

Steps I have done before starting the DB

x. Install Grid Infrastructure 11.2.0.3
x. Install 10.2.0.1
x. Apply patch set on 10.2.0.1 to 10.2.0.4


DB start up was giving the error

[oracle@xd3cfp001 dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 17 14:28:08 2011

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount
ORA-29702: error occurred in Cluster Group Service operation
SQL> exit

This is due to the fact that nodes were not pinned to grid infrastructure.

atsdb1.ea.com[ATS4A]$ /opt/oracle/grid/11.2.0/bin/olsnodes -t -n
atsdb1        1       Unpinned
atsdb2        2       Unpinned


To pin, I had to run the below commands


/opt/oracle/grid/11.2.0/bin/crsctl pin css -n atsdb1  atsdb2


atsdb2.ea.com[APF11G]$  /opt/oracle/grid/11.2.0/bin/olsnodes -t -n
atsdb1        1       Pinned
atsdb2        2       Pinned

create database AP10G
    USER SYS IDENTIFIED BY dvstmq4
    USER SYSTEM IDENTIFIED BY dvstmq4
    MAXLOGFILES 10
    MAXLOGMEMBERS 2
    MAXDATAFILES 200
    MAXINSTANCES 1
    MAXLOGHISTORY 1
logfile
        group 1 ('/oradata_dbupgrade/APF11G/redo/redo1a.log','/oradata_dbupgrade/APF11G/redo/redo1b.log') size 400M,
        group 2 ('/oradata_dbupgrade/APF11G/redo/redo2a.log','/oradata_dbupgrade/APF11G/redo/redo2b.log') size 400M,
        group 3 ('/oradata_dbupgrade/APF11G/redo/redo3a.log','/oradata_dbupgrade/APF11G/redo/redo3b.log') size 400M,
        group 4 ('/oradata_dbupgrade/APF11G/redo/redo4a.log','/oradata_dbupgrade/APF11G/redo/redo4b.log') size 400M
datafile  '/oradata_dbupgrade/APF11G/data/system01.dbf' size 1000M
extent management local
sysaux datafile '/oradata_dbupgrade/APF11G/data/sysaux01.dbf' size 1000M
undo tablespace UNDOTBS1
datafile '/oradata_dbupgrade/SOAPF11G/data/undotbs01.dbf' size 5000M
default temporary tablespace temp tempfile '/oradata_dbupgrade/APF11G/data/temp01.dbf' size 5000M
character set  AL32UTF8
national character set AL16UTF16;

$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapwAP10GA password=oracle entries=5

alter database add logfile thread 2
group 5 ('/oradata_dbupgrade/APF11G/redo/redo5a.log','/oradata_dbupgrade/APF11G/redo/redo5b.log') size 400M,
group 6 ('/oradata_dbupgrade/APF11G/redo/redo6a.log','/oradata_dbupgrade/APF11G/redo/redo6b.log') size 400M,
group 7 ('/oradata_dbupgrade/APF11G/redo/redo7a.log','/oradata_dbupgrade/APF11G/redo/redo7b.log') size 400M,
group 8 ('/oradata_dbupgrade/APF11G/redo/redo8a.log','/oradata_dbupgrade/APF11G/redo/redo8b.log') size 400M;

create undo tablespace UNDOTBS2 datafile '/oradata_dbupgrade/APF11G/data/undotbs02.dbf' size 1000M;

From 10g DB home

srvctl add database -d AP10G -o $ORACLE_HOME

srvctl add instance -d AP10G -i AP10GA -n atsdb1
srvctl add instance -d AP10G -i AP10GB -n atsdb2
srvctl enable database -d AP10G
srvctl enable instance -d AP10G  -i AP10GA
srvctl enable instance -d AP10G  -i AP10GB

atsdb1.ea.com[APF11G]$ /opt/oracle/product/1020/bin/srvctl start instance -d AP10G -i AP10GA
atsdb1.ea.com[APF11G]$ /opt/oracle/product/1020/bin/srvctl start instance -d AP10G -i AP10GB

Convert snapshot standby database to Physical standby database: Dataguard 11gR2

Step 1 SQL> shutdown immediate; Step 2 SQL> startup nomount Step 3 SQL> alter database mount; Step 4 SQL>  ALTER DATABASE CONV...