dealing with oracle 11.2.0.4 database in grid infrastructure 12.1.0.2
Date: Sun, 27 Mar 2016 21:31:58 +0200
Message-ID: <56F8352E.20304_at_interia.pl>
Hi,
after upgrading GI standalone 11.2.0.4 -> 12.1.0.2 my 11.2.0.4 db instance stoped working as a part of cluster resource :( . Current state as below
[oracle_at_ol6a:~]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [12.1.0.2.0]
[oracle_at_ol6a:~]$ crsctl stat res -t
Name Target State Server State details --------------------------------------------------------------------------------Local Resources
ora.ADM_LSNR.lsnr
ONLINE ONLINE ol6a STABLE
ora.DATA.dg
ONLINE ONLINE ol6a STABLE
ora.LISTENER.lsnr
ONLINE ONLINE ol6a STABLE
ora.asm
ONLINE ONLINE ol6a Started,STABLE
ora.ons
OFFLINE OFFLINE ol6a STABLE
--------------------------------------------------------------------------------
Cluster Resources
ora.cssd
1 ONLINE ONLINE ol6a STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE ol6a STABLE
ora.orcl.db
1 ONLINE OFFLINE Instance Shutdown,ST
ABLE
Steps I've done:
used srvctl upgrade (with 12.1.0.2 binaries) but with wrong OH (the
12.1.0.2 one) to upgrade db resource info
removed database resource from GI using 12.1 srvctl binaries
added database to GI using 11.2.0.4 srvctl :
but when did that oracle binary owner group changed from valid oinstall
into asmdba
[oracle_at_ol6a:~]$ id -a
uid=54321(oracle) gid=54321(oinstall)
groups=54321(oinstall),502(vboxsf),54322(dba),54323(asmadmin),54324(asmdba)
like this:
[oracle_at_ol6a:/u01/app/oracle/product/11.2.0/db_11204/bin]$ ls -l oracle
-rwsr-s--x 1 oracle oinstall 239811839 Sep 17 2015 oracle
[oracle_at_ol6a:/u01/app/oracle/product/11.2.0/db_11204/bin]$ srvctl status
database -d orcl
Database is not running.
[oracle_at_ol6a:/u01/app/oracle/product/11.2.0/db_11204/bin]$ srvctl start
database -d orcl
PRCR-1079 : Failed to start resource ora.orcl.db
CRS-5017: The resource action "ora.orcl.db start" encountered the
following error:
ORA-27140: attach to post/wait facility failed ORA-27300: OS system dependent operation:invalid_egid failed with status: 1 ORA-27301: OS failure message: Operation not permitted ORA-27302: failure occurred at: skgpwinit6 ORA-27303: additional information: startup egid = 54321 (oinstall),current egid = 54324 (asmdba)
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/ol6a/crs/trace/ohasd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.orcl.db' on 'ol6a' failed
[oracle_at_ol6a:/u01/app/oracle/product/11.2.0/db_11204/bin]$ ls -l oracle
-rwsr-s--x 1 oracle asmdba 239811839 Sep 17 2015 oracle
The asmdba group was created before clusterware upgrade and used in response file:
#------------------------------------------------------------------------------- # The OPER_GROUP is the OS group which is to be granted OSOPER privileges.# The value to be specified for OSOPER group is optional. # Value should not be provided if configuring Client Cluster - i.e. storageOption=CLIENT_ASM_STORAGE.
#-------------------------------------------------------------------------------oracle.install.asm.OSOPER=dba
#-------------------------------------------------------------------------------# The OSASM_GROUP is the OS group which is to be granted OSASM privileges. This
# must be different than the previous two.
#-------------------------------------------------------------------------------oracle.install.asm.OSASM=asmdba
What is the proper way to manage 11.2.0.4 database from 12.1.0.2 GI standalone (oracle as an grid and oracle owner, meaning no role separation) ?
Regards
GG
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 27 2016 - 21:31:58 CEST