Search This Blog

Loading...

Thursday, January 15, 2015

How to check OCR details.

How to check OCR details.

Need to use the below tools for checking the OCR details

oracle@testserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3860
         Available space (kbytes) :     258260
         ID                       :  710588188
         Device/File Name         : +OCRVOTEDG
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check bypassed due to non-privileged user

oracle@testserver1i /u01/app/11.2.0.4/grid/bin +ASM1 >

Go inside the asm location to check the phisical file

oracle@testserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > asmcmd
ASMCMD> cd OCRVOTEDG
ASMCMD> ls
testingdbiscan/
ASMCMD> cd testingdbiscan/
ASMCMD> ls
ASMPARAMETERFILE/
OCRFILE/
ASMCMD> cd ASMPARAMETERFILE/
ASMCMD> ls
REGISTRY.253.807918545
ASMCMD>


To fine the OLR or the local registry for the Cluster node go to the root user and run the below command.

[root@testserver1i app]# . oraenv
ORACLE_SID = [root] ? +ASM1
The Oracle base has been set to /u01/app/oracle
[root@testserver1i app]# echo $ORACLE_HOME
/u01/app/11.2.0.4/grid
[root@testserver1i app]# ocrcheck -local
Status of Oracle Local Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2696
         Available space (kbytes) :     259424
         ID                       : 1047978051
         Device/File Name         : /u01/app/11.2.0.4/grid/cdata/testserver1i.olr
                                    Device/File integrity check succeeded

         Local registry integrity check succeeded

         Logical corruption check succeeded

[root@testserver1i app]#

How to check CRS (Cluster ready services ) status in Oracle

How to check CRS (Cluster ready services ) status in Oracle 

Go to the Grid home and bin direcotry.

oracle@testingserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

oracle@testingserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > srvctl status nodeapps
VIP testingserver1i-vip is enabled
VIP testingserver1i-vip is running on node: testingserver1i
VIP testingserver2i-vip is enabled
VIP testingserver2i-vip is running on node: testingserver2i
Network is enabled
Network is running on node: testingserver1i
Network is running on node: testingserver2i
GSD is disabled
GSD is not running on node: testingserver1i
GSD is not running on node: testingserver2i
ONS is enabled
ONS daemon is running on node: testingserver1i
ONS daemon is running on node: testingserver2i


oracle@testingserver1i /u01/app/11.2.0.4/grid/bin +ASM1 > crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.testDB.dg
               ONLINE  ONLINE       testingserver1i
               ONLINE  ONLINE       testingserver2i
ora.DBA_BANK.dg
               ONLINE  ONLINE       testingserver1i
               ONLINE  ONLINE       testingserver2i
ora.LISTENER.lsnr
               ONLINE  ONLINE       testingserver1i
               ONLINE  ONLINE       testingserver2i
ora.OCRVOTEDG.dg
               ONLINE  ONLINE       testingserver1i
               ONLINE  ONLINE       testingserver2i
ora.asm
               ONLINE  ONLINE       testingserver1i            Started
               ONLINE  ONLINE       testingserver2i            Started
ora.gsd
               OFFLINE OFFLINE      testingserver1i
               OFFLINE OFFLINE      testingserver2i
ora.net1.network
               ONLINE  ONLINE       testingserver1i
               ONLINE  ONLINE       testingserver2i
ora.ons
               ONLINE  ONLINE       testingserver1i
               ONLINE  ONLINE       testingserver2i
ora.registry.acfs
               ONLINE  ONLINE       testingserver1i
               ONLINE  ONLINE       testingserver2i
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       testingserver1i
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       testingserver2i
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       testingserver2i

ora.testingserver1i.vip
      1        ONLINE  ONLINE       testingserver1i
ora.testingserver2i.vip
      1        ONLINE  ONLINE       testingserver2i
ora.cvu
      1        ONLINE  ONLINE       testingserver2i
ora.oc4j
      1        ONLINE  ONLINE       testingserver2i
ora.scan1.vip
      1        ONLINE  ONLINE       testingserver1i
ora.scan2.vip
      1        ONLINE  ONLINE       testingserver2i
ora.scan3.vip
      1        ONLINE  ONLINE       testingserver2i
oracle@testingserver1i /u01/app/11.2.0.4/grid/bin +ASM1 >

Wednesday, October 8, 2014

NLS PT R12 Patch application error oracle.apps.xdo.XDOException: Template ARXAGFMX not found

NLS PT R12 Patch application error oracle.apps.xdo.XDOException: Template ARXAGFMX not found

Error:

Parameters passed to XLIFFLoader...
[FILE_NAME] [ apps/apps_st/appl/ar/12.0.0/patch/115/publisher/templates/PT/ARXAGF.xlf]
[APPS_SHORT_NAME] [AR]
[UPLOAD] [UPLOAD]
[DB_USERNAME] [APPS]
[JDBC_CONNECTION] [(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname.domain.com)(PORT=1551))(CONNECT_DATA=(SID=VISR12)))]
[DB_PASSWORD] [******]
[TEMPLATE_CODE] [ARXAGFMX]

Target file: ARXAGF.xlf
Start uploading...
oracle.apps.xdo.XDOException: Template ARXAGFMX not found
        at oracle.apps.xdo.oa.util.TemplateTranslator.getBaseTemplateInfo(TemplateTranslator.java:338)
        at oracle.apps.xdo.oa.util.TemplateTranslator.createMLSTemplates(TemplateTranslator.java:210)
        at oracle.apps.xdo.oa.util.XLIFFLoader.processUpload(XLIFFLoader.java:709)
        at oracle.apps.xdo.oa.util.XLIFFLoader.process(XLIFFLoader.java:565)
        at oracle.apps.xdo.oa.util.XLIFFLoader.main(XLIFFLoader.java:1073)



Solution:

1. Run this.
java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD \
-JDBC_CONNECTION \
-LOB_TYPE TEMPLATE_SOURCE \
-APPS_SHORT_NAME AR \
-LOB_CODE ARXAGFMX \
-LANGUAGE en \
-TERRITORY US \
-XDO_FILE_TYPE RTF \
-FILE_NAME $AR_TOP/patch/115/publisher/templates/US/ARXAGF.rtf \
-CUSTOM_MODE FORCE


2. Once 1 is successful run this.

UPDATE xdo_templates_b
SET mls_language = 'en', mls_teritorry = 'US'
WHERE application_short_name = 'AR'
and template_code = 'ARXAGFMX';

3. Then restart the failed worker which was working ARXAGF.xlf.

For more info rollow the below document

Patch 12702898:R12.AR.A Fails With oracle.apps.xdo.XDOException: Template ARXAGFMX not found (Doc ID 1495265.1)

Tuesday, October 7, 2014

RPM Packages and Kernel Parameter Required for EBS upgrade to R12.2 :

RPM Packages Required for EBS upgrade to R12.2 :

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386
binutils-2.17.50.0.6-9.0.1.x86_64
sysstat-7.0.0-3.el5.x86_64
unixODBC-2.2.11-7.1.i386
unixODBC-devel-2.2.11-7.1.i386
unixODBC-2.2.11-7.1.x86_64
unixODBC-devel-2.2.11-7.1.x86_64
libaio-devel-0.3.106-3.2.x86_64


Kernel Parameter

Parameter Value
kernel.semmsl 2561
kernel.semmns 320001
kernel.semopm 1001
kernel.semmni 1421
kernel.shmall 20971524
kernel.shmmax Half the size of the physical memory (in bytes), and at least 21474836482
kernel.shmmni 4096
kernel.msgmax 8192
kernel.msgmnb 65535
kernel.msgmni 2878
fs.file-max 131072
net.ipv4.ip_local_port_range 10000 650003
net.core.rmem_default 262144
net.core.rmem_max 4194304
net.core.wmem_default 262144
net.core.wmem_max 262144


set using the following entry in the /etc/sysctl.conf file: kernel.sem = 256 32000 100 142