Sunday, May 6, 2018

NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL

Error: adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress.

INST_TOP/admin/log/clone/run/ohsT2PApply/CLONE2016-02-02_13-10-02_599255196.error:
2015-12-02T3:10:04-06:00] [opmn] [ERROR:1] [] [internal]...
2015-12-02T13:10:04-06:00] [opmn] [ERROR:1] [] [internal] lxlinit - NLS boot file not found or invalid
opmnctl ping: error parsing /u01/tech_st/fs1/FMW_Home/webtier/instances/EBS_web_EBDEV_OHS1/config/OPMN/opmn/opmn.xml
[2015-12-02T3:10:04-06:00] [opmn] [ERROR:1] [105] [internal] XML parser init: character set initialization failed.
SEVERE : Dec 2, 2016 03:10:04 - ERROR - CLONE-20218   Cloning is not successful.
SEVERE : Dec 2, 2016 03:10:04 - CAUSE - CLONE-20218   An internal operation failed.
SEVERE : Dec 2, 2016 03:10:04 - ACTION - CLONE-20218   Provide the clone log and error file for investigation.

Cause: adcfgclone started in the same session where previous environment is set.

Solution:
The issue is because of existing environment variables. Before executing the adcfgclone verify any of the environment is set. If already set please try to unset and run adcfgclone.

Else, Unset the following environment:

ORA_NLS10
TNS_ADMIN
ORACLE_HOME


Start a fresh session always for refresh

Monday, February 8, 2016

How to check Oracle Application Home Versions in R12

 10.1.2 Oracle Home Version:

/u01/app/applmgr/apps/tech_st/10.1.2

-bash-4.1$ frmcmp_batch
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

Forms 10.1 (Form Compiler): Release  - Production

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

PL/SQL Version 10.1.0.5.0 (Production)
Oracle Procedure Builder V10.1.2.3.0 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE     10.1.0.5.0      Production

10.1.3 Oracle Home Version:

-bash-4.1$ pwd
/u01/app/applmgr/apps/tech_st/10.1.3/Apache/Apache/bin
-bash-4.1$ cd /u01/app/applmgr/apps/tech_st/10.1.2
-bash-4.1$ httpd -version
Server version: Oracle-Application-Server-10g/10.1.3.5.0 Oracle-HTTP-Server
Server built:   Jul 21 2009 11:12:22

CPU, PSU, SPU - Oracle Critical Patch Update Terminology Update


It all started in January 2005 with Critical Patch Updates (CPU).  Then Patch Set Updates (PSU) were added as cumulative patches that included priority fixes as well as security fixes.  As of the October 2012 Critical Patch Update, Oracle has changed the terminology to better differentiate between patch types.  This terminology will be used for the Oracle Database, Enterprise Manager, Fusion Middleware, and WebLogic.
Critical Patch Update (CPU) now refers to the overall release of security fixes each quarter rather than the cumulative database security patch for the quarter.  Think of the CPU as the overarching quarterly release and not as a single patch.
Patch Set Updates (PSU) are the same cumulative patches that include both the security fixes and priority fixes.  The key with PSUs is they are minor version upgrades (e.g., 11.2.0.1.1 to 11.2.0.1.2).  Once a PSU is applied, only PSUs can be applied in future quarters until the database is upgraded to a new base version.
Security Patch Update (SPU) terminology is introduced in the October 2012 Critical Patch Update as the term for the quarterly security patch.  SPU patches are the same as previous CPU patches, just a new name.  For the database, SPUs can not be applied once PSUs have been applied until the database is upgraded to a new base version.
Bundle Patches are the quarterly patches for Windows and Exadata which include both the quarterly security patches as well as recommended fixes.
References: New Patch Nomenclature for Oracle Products [ID 1430923.1]

Friday, January 1, 2016

Add/Increase swap space in Linux

[root@myhost ~]# dd if=/dev/zero of=/swapfile1 bs=1024 count=10485760
10485760+0 records in
10485760+0 records out
10737418240 bytes (11 GB) copied, 110.084 s, 97.5 MB/s
[root@myhost ~]# chown root:root /swapfile1
[root@myhost ~]# chmod 0600 /swapfile1
[root@myhost ~]# mkswap /swapfile1
Setting up swapspace version 1, size = 10485756 KiB
no label, UUID=a7a5c45b-d56a-424f-8c50-41149fdd0935
[root@myhost ~]# swapon /swapfile1
[root@myhost ~]# free -m
              total        used        free      shared  buff/cache   available
Mem:          15456        7999          87         161        7369        7132
Swap:         17919           0       17919
[root@myhost ~]# vi /etc/fstab
add the following line



/swapfile1 none swap sw 0 0

[root@myhost ~]# free -m
              total        used        free      shared  buff/cache   available
Mem:          15456        8573          89         161        6793        6553
Swap:         17919           0       17919

Wednesday, December 30, 2015

JRE Version in R12

To find the JRE/Java version used by Client Machine,

-bash-4.1$ cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version
sun_plugin_version=1.6.0_45

(or)

-bash-4.1$ grep plugin $CONTEXT_FILE

                        1.6.0_45</sun_plugin_ver>
                        jdk
-bash-4.1$
 


(or)

cd $COMMON_TOP/webapps/oacore/util/jinitiator

-bash-4.1$ ls -ltr
-rwxrwxr-x 1 applmgr applmgr 17090992 Aug 10  2013 j2se16045.exe

-bash-4.1$


j2se16045.exe means client machine uses jre1.6.0_45.

The name  j2se16045.exe as when we do jre upgrade, will move as follows

 mv jre-6u45-windows-i586.exe $COMMON_TOP/webapps/oacore/util/jinitiator/j2se16045.exe

Sunday, November 29, 2015

Install Oracle EBS rpms

  1. Download and copy the appropriate yum configuration file in place, by running the following commands as root:

    Oracle Linux 7

    # cd /etc/yum.repos.d
    # wget http://public-yum.oracle.com/public-yum-ol7.repo

    Oracle Linux 6

    # cd /etc/yum.repos.d
    # wget http://public-yum.oracle.com/public-yum-ol6.repo

    Oracle Linux 5

    # cd /etc/yum.repos.d
    # wget http://public-yum.oracle.com/public-yum-el5.repo

    Oracle Linux 4, Update 6 or Newer

    # cd /etc/yum.repos.d
    # mv Oracle-Base.repo Oracle-Base.repo.disabled
    # wget http://public-yum.oracle.com/public-yum-el4.repo

    Oracle OpenStack for Oracle Linux 2.0

    # cd /etc/yum.repos.d
    # wget http://public-yum.oracle.com/public-yum-ol7.repo
    # yum install yum-plugin-priorities
    Note: Make sure to enable ol7_optional_latest repository before installing yum-plugin-priorities on your system

    Oracle OpenStack for Oracle Linux 1.0

    # cd /etc/yum.repos.d
    # wget http://public-yum.oracle.com/public-yum-openstack-ol6.repo

    Oracle VM 2

    # cd /etc/yum.repos.d
    # wget http://public-yum.oracle.com/public-yum-ovm2.repo
  2. By default, the latest repository is enabled. If you want to change the default, you can enable an alternative repository by editing the yum configuration file.
    • Open the yum configuration file in a text editor
    • Locate the section in the file for the repository want to enable, e.g. [el4_u6_base]
    • Change enabled=0 to enabled=1

[root@r122prod ~]# cd /etc/yum.repos.d/
[root@r122prod yum.repos.d]# wget http://public-yum.oracle.com/public-yum-el5.repo
--2015-11-29 23:49:20--  http://public-yum.oracle.com/public-yum-el5.repo
Resolving public-yum.oracle.com... 123.176.32.146, 123.176.32.178
Connecting to public-yum.oracle.com|123.176.32.146|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5274 (5.2K) [text/plain]
Saving to: `public-yum-el5.repo'

100%[===========================================================================================================================>] 5,274       --.-K/s   in 0s


2015-11-29 23:49:20 (195 MB/s) - `public-yum-el5.repo' saved [5274/5274]

Edit the public-yum-ol6.repo file to enable the ol5_addons channel.
Find the ol6_addons section and change enabled=0 to enabled=1.
[ol6_addons]
name=Oracle Linux $releasever Add ons ($basearch)
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/addons/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol5
gpgcheck=1
enabled=1
Save the file.


[root@r122prod yum.repos.d]# yum install oracle-ebs-server-R12-preinstall -y
Loaded plugins: rhnplugin, security
This system is not registered with ULN.
ULN support will be disabled.
el5_addons                                                                                                                                    | 1.2 kB     00:00
el5_addons/primary                                                                                                                            | 108 kB     00:01
el5_addons                                                                                                                                                   418/418
el5_latest                                                                                                                                    | 1.4 kB     00:00
el5_oracle_addons                                                                                                                             |  951 B     00:00
el5_oracle_addons/primary                                                                                                                     | 1.7 kB     00:00
el5_oracle_addons                                                                                                                                                7/7
ol5_UEK_latest                                                                                                                                | 1.2 kB     00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package oracle-ebs-server-R12-preinstall.x86_64 0:1.0.0-6.el5 set to be updated
el5_addons/filelists                                                                                                                          | 686 kB     00:05
el5_latest/filelists                                                                                                                          |  41 MB     06:16

Monday, June 29, 2015

fnd_concurrent_queues table control_code column meaning

Concurrent Manger queues Status code meaning
SQL> select lookup_code,meaning from apps.fnd_lookups where lookup_type = 'CP_CONTROL_CODE' order by lookup_code;

LOOKUP_CODE                    MEANING
------------------------------ -------------------------------------------------
A                              Activating
B                              Activated
D                              Deactivating
E                              Deactivated
N                              Target node/queue unavailable
O                              Suspending concurrent manager
P                              Suspended
Q                              Resuming concurrent manager
R                              Restarting
T                              Terminating
U                              Updating environment information

LOOKUP_CODE                    MEANING
------------------------------ -------------------------------------------------
V                              Verifying
X                              Terminated

13 rows selected.

NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL

Error: adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress. INST_TOP/adm...