Capture got log wrapped after activating config was done successfully. In the event_log, the following messages are recorded:
Error 2012-06-19 12:14:20.152764 24060 1087969600 Capture: Error reading block 0 from file +LOG_EMREP/emrep/onlinelog/group_3.260.782931491: ASMreadBlock: ASMFileReadBlock: ASMFileReadExtent: ASMDgroupReadDisk: ASMDgroupDiskRead: Open Error 13 on disk 1, path /dev/oracleasm/disks/LOGVOL2: Permission denied. (group 3 LOG_EMREP). (extent number 0, file +LOG_EMREP/emrep/onlinelog/group_3.260.782931491). (block number 0, file +LOG_EMREP/emrep/onlinelog/group_3.260.782931491). (capturing from EMREP) [module oct]
Capture debug showed shareplex was able to log in RDBMS and ASM, but it failed to open redo log which located in ASM.
using grid and oracle users for role separation, and oracle does not have all the roles that it needed to open and read asm files.
>>>> ps -ef | grep smon
oracle 13627 1 0 10:37 ? 00:00:01 ora_smon_EMREP
oracle 23597 8897 0 14:28 pts/4 00:00:00 grep smon
grid 31943 1 0 Jun15 ? 00:00:00 asm_smon_+ASM
id
uid=500(oracle) gid=503(oinstall) groups=502(dba),503(oinstall),506(asmdba)
# id grid
uid=1100(grid) gid=503(oinstall) groups=503(oinstall),502(dba),507(asmadmin),506(asmdba)
>>>>> cat /etc/group | grep oracle
dba:x:502:grid,oracle
asmdba:x:506:grid,oracle
asmadmin:x:507:grid
oinstall:x:503:grid oracle
>>>> cat $GRID_HOME/rdbms/lib/config.c
/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */
/* Refer to the Installation and User's Guide for further information. */
/* IMPORTANT: this file needs to be in sync with
rdbms/src/server/osds/config.c, specifically regarding the
number of elements in the ss_dba_grp array.
*/
#define SS_DBA_GRP "asmdba"
#define SS_OPER_GRP "asmoper"
#define SS_ASM_GRP "asmadmin"
>>>>> ls -ltr $GRID_HOME
total 276
drwx--x--x 6 grid oinstall 4096 Mar 20 12:16 css
drwxr-xr-x 2 root oinstall 8192 Mar 20 12:42 bin
drwxr-xr-x 3 root oinstall 8192 Mar 20 12:42 lib
ls -ltr /u01/app/oracle/product/11.2.0/dbhome_1/bin/oracle
r-xr-s--x 1 oracle asmadmin 173515991 Apr 4 10:34
>>>>> ls -ltr $SP_SYS_PRODDIR
total 32
drwxrwxr-x 2 oracle oinstall 4096 Jun 6 13:41 log
drwxrwxr-x 2 oracle oinstall 4096 Jun 6 13:41 doc
drwxrwxr-x 2 oracle oinstall 4096 Jun 6 13:41 util
drwxr-xr-x 2 oracle oinstall
Add asmadmin group to oracle, and explicitly add oinstall group into oracle user and grid user
usermod -g <primary group> -G oinstall,asmadmin,<and additional groups that grid and oracle need to have> <oracle|grid>
cat /etc/group to make sure grid and oracle users are included in the asmadmin and oinstall group.
asmadmin:x:507:grid,oracle
oinstall:x:503:grid oracle
System administartor is required to achieve the above task.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy