06-21-2014 11:28 AM
hi..
when we open db (Oracle 11.2.0.4 2node RAC in HP), we got the error...
Sun Jun 01 23:19:24 2014
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))' SCOPE=MEMORY SID='MNP001';
ALTER DATABASE MOUNT /* db agent *//* {1:15272:181} */
This instance was first to mount
Errors in file /oracle/MNP/saptrace/diag/rdbms/mnp/MNP001/trace/MNP001_ckpt_230.trc (incident=432209):
ORA-00600: internal error code, arguments: [ksfd_odmopn2], [ODM ERROR V-41-4-2-313-22 Invalid argument], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/MNP/saptrace/diag/rdbms/mnp/MNP001/incident/incdir_432209/MNP001_ckpt_230_i432209.trc
[PROD spncpd01:/#] mount -p
.......................
/dev/vg00/lvol10 /maxigent50 vxfs ioerror=mwdisable,largefiles,qio,delaylog,dev=4000000a 0 0
/dev/vg00/lvol11 /SIMPANA vxfs ioerror=mwdisable,largefiles,qio,delaylog,dev=4000000b 0 0
xx.xx.89.167:/snctrans /usr/sap/trans nfs rsize=32768,wsize=32768,NFSv3,dev=4000002 0 0
xx.xx.89.167:/sncmnp /sapmnt/MNP nfs rsize=32768,wsize=32768,NFSv3,dev=4000003 0 0
xx.xx.89.167:/sapimage /sapcd nfs rsize=32768,wsize=32768,NFSv3,dev=4000004 0 0
-hosts /net autofs ignore,indirect,nosuid,soft,nobrowse,dev=4000005 0 0
/dev/odm /dev/odm odm smartsync,dev=4000006 0 0
/dev/vx/dsk/ncpdg1/mnpomnp /oracle/MNP vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=20059d8 0 0
/dev/vx/dsk/ncpdg1/mnpstage /oracle/stage/112_64 vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=20059d9 0 0
/dev/vx/dsk/ncpdg1/mnpcli /oracle/client vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=20059da 0 0
/dev/vx/dsk/ncpdg3/mnpocr1 /oracle/OCR1 vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=2009858 0 0
/dev/vx/dsk/ncpdg3/mnpvote1 /oracle/VOTE1 vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=2009859 0 0
/dev/vx/dsk/ncpdg4/mnpocr2 /oracle/OCR2 vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=200c350 0 0
/dev/vx/dsk/ncpdg4/mnpvote2 /oracle/VOTE2 vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=200c351 0 0
/dev/vx/dsk/ncpdg5/mnpocr3 /oracle/OCR3 vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=200e678 0 0
/dev/vx/dsk/ncpdg5/mnpvote3 /oracle/VOTE3 vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=200e679 0 0
/dev/vx/dsk/ncpdg1/mnploga /oracle/MNP/origlogA vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=20059db 0 0
/dev/vx/dsk/ncpdg1/mnplogb /oracle/MNP/origlogB vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=20059dc 0 0
/dev/vx/dsk/ncpdg1/mnpmloga /oracle/MNP/mirrlogA vxfs ioerror=mdisable,largefiles,qio,cluster,crw,delaylog,dev=20059dd 0 0
<--- no using CIO
so, we can not use veritas odm library...
could you teach me, how we can use veritas odm library ??? ( Is there any issue in veritas / Oracle ?? )
Thanks~~~~
07-08-2014 08:15 PM
I am not sure why you are saying you can not use ODM.
Veritas ODM would help you to improve database performance by skipping the veritas level locking mechanism (GLM) because this function is already performed by RAC itself.
Do you have RAC installed with libraries linked to Veritas ? Refer below link
https://sort.symantec.com/public/documents/sfha/6.0/hp-ux/productguides/html/sfrac_install/ch17s01.htm
G
07-10-2014 01:28 PM
What is the version of SFRAC? Please review the compatibility matrix for the SF release and 11.2.0.4 RAC here:
07-13-2014 09:32 PM
hi.. Thanks for reply..
1
#####################################
I am not sure why you are saying you can not use ODM.
-->
1> linked to Veritas libraries
and then
2> sqlplus "/as sysdba"
SQL> startup
ORA-00600 [ksfd_odmopn2], [ODM ERROR V-41-4-2-313-22 Invalid argument]
SQL>
so, we unlinked to Veritas libraries
3> sqlplus "/as sysdba"
SQL> startup
<-- ok..
we can not use Veritas libraries
because "ORA-00600 [ksfd_odmopn2], [ODM ERROR V-41-4-2-313-22 Invalid argument]"..
2
#####################################
[PROD spncpd01:/stand/current/mod#] what odm
odm:
$Revision: odm: VERITAS 5.1.00.00%dev perf version for 11.31 built by ( fsbuild @ malhar1 )
odm:$RCSfile: koff.c,v $ $Revision: 1.23 $
odm:$RCSfile: odm_node.c,v $ $Revision: 1.39 $
odm:$RCSfile: odm_io.c,v $ $Revision: 1.115.4.1 $Date: 2013/04/09 10:05:24 $ PATCH_11.31 (PHKL_43538)
odm:$RCSfile: odm_kioctl.c,v $ $Revision: 1.119.8.3 $Date: 2013/04/17 15:15:58 $ PATCH_11.31 (PHKL_43538)
odm:$RCSfile: odm_ted.c,v $ $Revision: 1.7.4.1 $Date: 2013/04/09 10:05:24 $ PATCH_11.31 (PHKL_43538)
vxfs:$RCSfile: odm_ted_osdep.c,v $ $Revision: 1.2 $
odm:$RCSfile: odm_ops.c,v $ $Revision: 1.54 $
odm:$RCSfile: odm_rops.c,v $ $Revision: 1.25 $
odm:$RCSfile: odm_makename.c,v $ $Revision: 1.10 $
odm:$RCSfile: odm_page.c,v $ $Revision: 1.36 $
odm:$RCSfile: odm_clust.c,v $ $Revision: 1.73 $
odm:$RCSfile: odm_raw.c,v $ $Revision: 1.36 $
odm:$RCSfile: odm_vxfs.c,v $ $Revision: 1.43 $
odm:$RCSfile: odmmod.c,v $ $Revision: 1.2 $
odm:$RCSfile: odm.c,v $ $Revision: 1.5.8.2 $Date: 2013/04/09 10:24:24 $ PATCH_11.31 (PHKL_43538)
odm:$RCSfile: odm_osrelk.c,v $ $Revision: 1.7.10.1 $Date: 2013/04/09 10:05:26 $ PATCH_11.31 (PHKL_43538)
odm:$RCSfile: odm_types.h,v $ $Revision: 1.10 $
odm:$RCSfile$ $Revision$
odm:$RCSfile: odm_osrelk.h,v $ $Revision: 1.5.10.1 $
odm:$RCSfile: odm_os.h,v $ $Revision: 1.37 $
odm:$RCSfile: odm.h,v $ $Revision: 1.16 $
odm:$RCSfile: odm_ioctl.h,v $ $Revision: 1.26.24.1 $
odm:$RCSfile: odm_ops.h,v $ $Revision: 1.22 $
odm:$RCSfile: odm_kioctl.h,v $ $Revision: 1.48.24.1 $
odm:$RCSfile: odm_ted.h,v $ $Revision: 1.10.4.1 $
odm:$RCSfile: odm_vxvm.h,v $ $Revision: 1.3 $
vxfs:$RCSfile: vx_odm.h,v $ $Revision: 4.18 $
odm:$RCSfile: odm_clust.h,v $ $Revision: 1.33 $
odm:$RCSfile: odm_io.h,v $ $Revision: 1.36.4.1 $
odm:$RCSfile: odm_page.h,v $ $Revision: 1.14 $
odm:$RCSfile: koff.h,v $ $Revision: 1.28 $
odm:$RCSfile: odm.modmeta,v $ $Revision: 1.2.40.1 $Date: 2011/12/05 09:39:25 $ PATCH_11.31 (PHKL_43538)
07-13-2014 09:34 PM
hi.. Thanks for reply..
1
#####################################
I am not sure why you are saying you can not use ODM.
-->
1> linked to Veritas libraries
and then
2> sqlplus "/as sysdba"
SQL> startup
ORA-00600 [ksfd_odmopn2], [ODM ERROR V-41-4-2-313-22 Invalid argument]
SQL>
so, we unlinked to Veritas libraries
3> sqlplus "/as sysdba"
SQL> startup
<-- ok..
we can not use Veritas libraries
because "ORA-00600 [ksfd_odmopn2], [ODM ERROR V-41-4-2-313-22 Invalid argument]"..
2
#####################################
[PROD spncpd01:/stand/current/mod#] what odm
odm:
$Revision: odm: VERITAS 5.1.00.00%dev perf version for 11.31 built by ( fsbuild @ malhar1 )
odm:$RCSfile: koff.c,v $ $Revision: 1.23 $
odm:$RCSfile: odm_node.c,v $ $Revision: 1.39 $
odm:$RCSfile: odm_io.c,v $ $Revision: 1.115.4.1 $Date: 2013/04/09 10:05:24 $ PATCH_11.31 (PHKL_43538)
odm:$RCSfile: odm_kioctl.c,v $ $Revision: 1.119.8.3 $Date: 2013/04/17 15:15:58 $ PATCH_11.31 (PHKL_43538)
odm:$RCSfile: odm_ted.c,v $ $Revision: 1.7.4.1 $Date: 2013/04/09 10:05:24 $ PATCH_11.31 (PHKL_43538)
vxfs:$RCSfile: odm_ted_osdep.c,v $ $Revision: 1.2 $
odm:$RCSfile: odm_ops.c,v $ $Revision: 1.54 $
odm:$RCSfile: odm_rops.c,v $ $Revision: 1.25 $
odm:$RCSfile: odm_makename.c,v $ $Revision: 1.10 $
odm:$RCSfile: odm_page.c,v $ $Revision: 1.36 $
odm:$RCSfile: odm_clust.c,v $ $Revision: 1.73 $
odm:$RCSfile: odm_raw.c,v $ $Revision: 1.36 $
odm:$RCSfile: odm_vxfs.c,v $ $Revision: 1.43 $
odm:$RCSfile: odmmod.c,v $ $Revision: 1.2 $
odm:$RCSfile: odm.c,v $ $Revision: 1.5.8.2 $Date: 2013/04/09 10:24:24 $ PATCH_11.31 (PHKL_43538)
odm:$RCSfile: odm_osrelk.c,v $ $Revision: 1.7.10.1 $Date: 2013/04/09 10:05:26 $ PATCH_11.31 (PHKL_43538)
odm:$RCSfile: odm_types.h,v $ $Revision: 1.10 $
odm:$RCSfile$ $Revision$
odm:$RCSfile: odm_osrelk.h,v $ $Revision: 1.5.10.1 $
odm:$RCSfile: odm_os.h,v $ $Revision: 1.37 $
odm:$RCSfile: odm.h,v $ $Revision: 1.16 $
odm:$RCSfile: odm_ioctl.h,v $ $Revision: 1.26.24.1 $
odm:$RCSfile: odm_ops.h,v $ $Revision: 1.22 $
odm:$RCSfile: odm_kioctl.h,v $ $Revision: 1.48.24.1 $
odm:$RCSfile: odm_ted.h,v $ $Revision: 1.10.4.1 $
odm:$RCSfile: odm_vxvm.h,v $ $Revision: 1.3 $
vxfs:$RCSfile: vx_odm.h,v $ $Revision: 4.18 $
odm:$RCSfile: odm_clust.h,v $ $Revision: 1.33 $
odm:$RCSfile: odm_io.h,v $ $Revision: 1.36.4.1 $
odm:$RCSfile: odm_page.h,v $ $Revision: 1.14 $
odm:$RCSfile: koff.h,v $ $Revision: 1.28 $
odm:$RCSfile: odm.modmeta,v $ $Revision: 1.2.40.1 $Date: 2011/12/05 09:39:25 $ PATCH_11.31 (PHKL_43538)
07-14-2014 12:42 PM
from the o/p above the vrts odm version/SF version seems to be 5.1. If you review the SF supportability matix with RAC (link provided in my earlier post) .. you should be at SF 6.0.3 to have this working with 11.2.0.4.
For 5.1, see: http://www.symantec.com/business/support/index?page=content&id=TECH173597 (the issu mentioned in this link is wrt 11.2.0.3 though)