Thursday 25 September 2014

Perl lib version (v5.8.8) doesn’t match executable version (v5.10.0)

Issue while running adcfgclone.pl on target database node, I can see below error messages in logfiles..

ERROR:
perl adcfgclone.pl dbTechStack
RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack
Perl lib version (v5.8.8) doesn’t match executable version (v5.10.0) at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/Config.pm line 46.
Compilation failed in require at /u01/oracle/product/11.2.0/appsutil/clone/ouicli.plline 35.
BEGIN failed–compilation aborted at /u01/oracle/product/11.2.0/appsutil/clone/ouicli.pl line 35.

AutoConfig is exiting with status 1

RC-50013: Fatal: Instantiate driver did not complete successfully.
/u01/oracle/product/11.2.0/appsutil/driver/regclone.drv




SOLUTION:
1. Make a backup copy of your existing Database Contextfile.
2. Modify the context file as shown.
BEFORE :

<PERL5LIB oa_var=”s_perl5lib” osd=”unix”>/<complete path>/db/tech_st/11.2.0/perl/lib/5.8.3: \\
/<complete path>/db/tech_st/11.2.0/perl/lib/site_perl/5.8.3:/<complete path>/db/tech_st/11.2.0/appsutil/perl</PERL5LIB>

AFTER :

<PERL5LIB oa_var=”s_perl5lib” osd=”unix”>/<complete path>/db/tech_st/11.2.0/perl/lib/5.10.0: \\
<complete path>/db/tech_st/11.2.0/perl/lib/site_perl/5.10.0:/<complete path>/db/tech_st/11.2.0/appsutil/perl</PERL5LIB>


3. Execute Autoconfig to get the modifications implemented. or again run adcfgclone.pl to complete the Clone on Target DB Tier.

/usr/lib/libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4′

Link to Motif library for Oracle Application Server 10.1.2 (on OEL 5 and RHEL 5 only)
Perform the following command (as root on your system) to update a required link to a Motif library prior to relinking or patching the 10.1.2 Application Server Oracle Home:
# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6
Without this updated link, you may see the following errors during a relink of the 10.1.2 Oracle Home:
/usr/lib/libXtst.so.6: undefined reference to  `__stack_chk_fail@GLIBC_2.4'
/usr/lib/libXtst.so.6: undefined reference to  `__fprintf_chk@GLIBC_2.3.4'
/usr/lib/libXtst.so.6: undefined reference to  `__sprintf_chk@GLIBC_2.3.4'

Tuesday 23 September 2014

How to find ICM log file on Oracle EBS R12

All Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location.The following bellow options are available to get the latest log files.

Option1:
Login to Apps User and source environment file
cd $APPLCSF/$APPLLOG
ls -lrt *$TWO_TASK*
  • Internal Concurrent Manager Log:  SID_MMDD.mgr   (Example: UAT_0923.mgr )
Here you can see other list of log files which are related to concurrent mangers.The name conversation for the concurrent manger log files are
  • Standard manager log:                   wxxxx.mgr      (Example : w20863.mgr)
  • Transaction manager log:                txxxx.mgr       (Example : t20847.mgr )
  • Conflict Resolution manager log:     cxxxx.mgr       (Example : c20852.mgr )
Where xxxx is the concurrent process id of the manager

Option2:
Log-in to the Apps User
Run Source environment file
Connect to sqlplus and run this query

SELECT 'ICM_LOG_NAME=' || fcp.logfile_name
FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq
WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id
AND fcp.queue_application_id = fcq.application_id
AND fcq.manager_type = '0'
AND fcp.process_status_code = 'A';
 
Sample Output:
'ICM_LOG_NAME='||FCP.LOGFILE_NAME
-------------------------------------------------------------
ICM_LOG_NAME=/applprod/comndev/admin/log/DEV_moon1/DEV_0426.mgr
 
Option3:
Log in to Sysadmin Responsibility

Go to ->Concurrent -> Manager -> Administer -Processes -> Click button Internal Manager Log.

Monday 22 September 2014

JRE Plugin Upgrade to 1.7.0_21 in R12.1.3

Step 1 : Download Java RunTime  Update 21 (Java JRE 1.7.0_21) for Java Client upgrade from webpage mentioned below : (Java SE Runtime Environment 7u21)

 Windows x64
31.59 MB  
jre-7u21-windows-x64.exe
 Windows x86 Offline
30.2 MB  

Check current Jre version:

cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version

sun_plugin_version=1.6.0_07

or.. check as below:

[appluat@erptest ~]$ grep -i plugin $CONTEXT_FILE
         <!-- JDK plugins -->
         <sun_plugin_ver oa_var="s_sun_plugin_ver">1.6.0_07</sun_plugin_ver>
         <sun_plugin_type oa_var="s_sun_plugin_type">jdk</sun_plugin_type>

·         Step 2 : Take the backup of the bellow files

Login to OS user appltest from PUTTY-

$ cd/u01/appltest/VIS/apps/apps_st/appl
$ . APPSVIS_erpdemo.env

$ cd /u01/appltest/VIS/inst/apps/VIS_erpdemo/appl/admin/
$ cp –rp VIS_erpdemo.xml VIS_erpdemo.xml-org_14_aug_2014

$ cd $COMMON_TOP
$ cp –rpwebapps webapps-org_14_aug_2014

$ cd $TNS_ADMIN
$ cp –rptnsnames.ora tnsnames.ora-org_14_aug_2014
$ cp –rplistener.ora listener.ora-org_14_aug_2014
  • Step 3 :Migrate the file to the TEST Application server location  $COMMON_TOP/webapps/oacore/util/jinitiator
Login to the putty using appltest user
$ cd /u01/appltest/VIS/apps/apps_st/appl
$ . APPSVIS_erpdemo.env
$ cd $COMMON_TOP/webapps/oacore/util/jinitiator
$ pwd
/u01/appltest/VIS/apps/apps/apps_st/comn/webapps/oacore/util/jinitiator

After that connect to the FTP session with appltest
and move the downloaded file to  ($COMMON_TOP/webapps/oacore/util/jinitiator)

/u01/appltest/VIS/apps/apps/apps_st/comn/webapps/oacore/util/jinitiator
location.

After that rename the jre file name on the same putty location

jre-7u21-windows-x64.exe  would be renamed j2se17021.exe

$ cd $COMMON_TOP/webapps/oacore/util/jinitiator
$ mv jre-7u21-windows-x64.exe  j2se17021.exe


  • Step 4 :Shut down the application services and Enable Maintenance Mode from adadmin utility.
Login to the application OS user (appltest) from PUTTY-
$ cd /u01/appltest/VIS/apps/apps_st/appl
$ . APPSVIS_erpdemo.env
$ cd $ADMIN_SCRIPTS_HOME
$ adstpall.sh apps/<apps_password>     ( i.e – adstpall.sh apps/apps )
$ ps –ef | grep FND | wc –l
When the output comes 1 then go with the next command
$ adadmin
Is this the correct APPL_TOP [Yes] ?[ TYPEENTER ]
Filename [adadmin.log] :[ TYPE ENTER ]
Do you wish to activate this feature [No] ?[ TYPE ENTER ]
Please enter the batchsize [1000] :[ TYPE ENTER ]
Is this the correct database [Yes] ?[ TYPE ENTER ]
Enter the password for your 'SYSTEM' ORACLE schema:[ TYPE THE DB system password ]
Enter the ORACLE password of Application Object Library [APPS] :[TYPE APPS PASSWORD]
1.    Generate Applications Files menu
   2.    Maintain Applications Files menu
   3.    Compile/Reload Applications Database Entities menu
   4.    Maintain Applications Database Entities menu
  5.    Change Maintenance Mode
   6.    Exit AD Administration
Enter your choice [6] :[ select 5 option ]
Please select an option:
  1.    Enable Maintenance Mode
 2.    Disable Maintenance Mode
   3.    Return to Main Menu
Enter your choice [3] :[ select 1 option ]
Enter your choice [3] :[ select 3 option ]
Enter your choice [6] :[ select 6 option ]

Step:5 Check Oracle_Home 10.1.2 version:

cd $ORACLE_HOME/config     ( this is 10.1.2 Oracle_Home)
[appltst@erptest ~]$ cd /u10/appltst/TEST/apps/tech_st/10.1.2/config
[appltst@erptest config]$ cat ias.properties |grep Version
Version=10.1.2.3.0

If you are on  Version=10.1.2.2.0 then you need upgrade it to 10.1.2.3.0
Follow below doc.
Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)

Check forms server version:
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)
Note: Several Forms 10.1.2.3.0 fixes have been consolidated in bundle patch 14825718. Customers are strongly recommended to uptake the bundle patch documented in Step 2.1.2. If customers are already on 10.1.2.3.0, follow instructions in Step 3.2 to apply the bundle patch.
If You are on Version=10.1.2.3.0 follow instructions in Step 3.2 to apply the bundle patch

You must upgrade OUI to the latest version before upgrading opatch version. Follow the README to install the OUI 10.1 upgrade patch 6640838.
While applying patch u may get pre requisite error for Operating system.
Sol:  go to Patch_top//cd/Disk1/install
Edit the oraparam.ini file with current Operating system details. Here I added redHat-5
add as below:
[Certified Versions]
Solaris=5.6,5.7,5.8,5.9
Linux=redhat-2.1AS,redhat-3,redhat-4,redhat-5
HPUX=B.11.11
Decunix=V5.1A,V5.1
AIX=5.1.0.0
You can download the latest version of opatch via patch 6880880. Make sure to choose release 10.1.0.0.0 from the release dropdown list before downloading
Patch 6995251 is applicable only to Linux x86-64 customers. This patch must be applied before applying the latest forms bundle patch 14825718.

apply the latest forms bundle patch 14825718.

Before applying overlay patch 17303472, you must apply the latest forms bundle patch 14825718
(Patch 14825718 is the latest forms bundle patch that includes the JRE 7 fix from Patch14614795.)

Rebuild Forms and Reports Executables (Conditional)

Note: This step is not applicable for Windows Platform.

Source the environment (under $INST_TOP/ora/10.1.2) to point to the 10.1.2 Oracle Home before relinking forms and reports executables.
Rebuild Forms and Reports executables:
cd $ORACLE_HOME/forms/lib32 
Note: if this directory does not exist: cd $ORACLE_HOME/forms/lib
 
$ make -f ins_forms.mk install

cd $ORACLE_HOME/reports/lib32
 
Note: if this directory does not exist: cd $ORACLE_HOME/reports/lib
 
$ make -f ins_reports.mk install

Regenerate JAR files

Run the AD Administration Utility to regenerate the JAR files:
  1. Run the AD Administration Utility (adadmin)
  2. Select Generate Applications Files
  3. Generate Product JAR Files
Note: Do not opt to force the regeneration of all JAR files.

  • Step 6 :Download JRE Upgrade Interoperability Patch Number 14837539 for 12.1 customers
  •  and Apply the same using adpatch options. Also check patch 4377566 applied or not, if not apply this patch also.
First check this patch is applied or not

$ cd /u01/appltest/VIS/apps/apps_st/appl
$ . APPSVIS_erpdemo.env
$ sqlplus apps/appspass                     ( if apps password is different please put that one )
On sql prompt please run the following command –
SQL>select bug_number from ad_bugs where bug_number=’14837539;
If you find any output (like 14837539 ) then please forget this patch and go with the step 6 otherwise go with the following process
Download above patch 14837539 for Linux x86-64 platform
Exit from SQL prompt type
SQL>exit
$ cd 14837539
$ adpatch
Is this the correct APPL_TOP [Yes] ?[ TYPE ENTER ]
Filename [adadmin.log] :   u14837539.log
Do you wish to activate this feature [No] ?[ TYPE ENTER ]
Please enter the batchsize [1000] :[ TYPE ENTER ]
Is this the correct database [Yes] ?[ TYPE ENTER ]
Enter the password for your 'SYSTEM' ORACLE schema:[ TYPE THE DB system password ]
Enter the ORACLE password of Application Object Library [APPS] :[TYPE APPS PASSWORD]
The default directory is [/home/appltest/14837539] :[TYPE APPS PASSWORD]
Please enter the name of your AutoPatch driver file :  u14837539.drv
Enter the number of parallel workers (30) :  20
After applying the patch please go with next step, if not please concern with any DBA.
  • Step 7:  Login to Application backend and Run the $FND_TOP/bin/txkSetPlugin.sh script against the web node of the application tier.
In the same $ prompt please run the following script (shtxkSetPlugin.sh will run autoconfig, if u want to skip autoconfig, edit the configuration file appsweb.cfg and CONTEXT_FILE abd FORMS_WEB_CONFIG_FILE manually) better run shtxkSetPlugin.sh
$ cd$FND_TOP/bin/
$ shtxkSetPlugin.sh 17021
The script will prompt you for the following values, if it does not find them automatically:
o    Location of APPSVIS_erpdemo.envfile, if not present in the default location $APPL_TOP
o    Location of the Auto-Config Context File.
o    Password for the APPS user in the database (If the correct value is returned by the script you may press the return key at the prompt).
Confirm jre upgraded in all configuration files :
[appltst@erptest ~]$ grep -i plugin $CONTEXT_FILE
         <!-- JDK plugins -->
         <sun_plugin_ver oa_var="s_sun_plugin_ver">1.7.0_21</sun_plugin_ver>
         <sun_plugin_type oa_var="s_sun_plugin_type">jdk</sun_plugin_type>

[appltst@erptest ~]$ cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version
sun_plugin_version=1.7.0_21
  • Step 7 : Disable Maintenance Mode from adadmin and Start the Application services
$ adadmin
Is this the correct APPL_TOP [Yes] ?[ TYPE ENTER ]
Filename [adadmin.log] :[ TYPE ENTER ]
Do you wish to activate this feature [No] ?[ TYPE ENTER ]
Please enter the batchsize [1000] :[ TYPE ENTER ]
Is this the correct database [Yes] ?[ TYPE ENTER ]
Enter the password for your 'SYSTEM' ORACLE schema:[ TYPE THE DB system password ]
Enter the ORACLE password of Application Object Library [APPS] :[TYPE APPS PASSWORD]
1.    Generate Applications Files menu
   2.    Maintain Applications Files menu
   3.    Compile/Reload Applications Database Entities menu
   4.    Maintain Applications Database Entities menu
  5.    Change Maintenance Mode
   6.    Exit AD Administration
Enter your choice [6] :[ select 5 option ]
Please select an option:
  1.    Enable Maintenance Mode
 2.    Disable Maintenance Mode
   3.    Return to Main Menu
Enter your choice [3] :[ select 2 option ]
Enter your choice [3] :[ select 3 option ]
Enter your choice [6] :[ select 6 option ]

After disabling the maintenance mode then start the services.
$ adstrtal.sh apps/<apps_password>
$adopmnctl.sh status
You are running adopmnctl.sh version 120.6.12010000.5
Checking status of OPMN managed processes...
Processes in Instance: TRAIN_trn.trn.evosys.co.in
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |   15238 | Alive
OC4JGroup:default_group          | OC4J:forms         |   15169 | Alive
OC4JGroup:default_group          | OC4J:oacore        |   15007 | Alive
HTTP_Server                              | HTTP_Server        |   14949 | Alive
adopmnctl.sh: exiting with status 0
If all the services are showing alive then go with next step.
  • Step 8 :Login to the application and open up any Oracle Form (It will automatically ask you for installing the new Java Plug-in 1.7.0_21).

  • Step 9 : Install the upgraded Java Plug-in for client machine and re-test the issue.

--------------------------------------------------------------------------------------------------------------------------

References


Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 [ID 393931.1]
                                                      https://blogs.oracle.com/stevenChan/entry/java_jre_1_7_04

Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported

While Running adcfgclone.pl dbTier on database Tier, you may get the following Error. 

Beginning dbconfig Apply – Fri May 17 01:37:14 2013
 /clone/oracle/product/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/clone/oracle/product/11.2.0/oui -classpath /clone/oracle/product/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/ojdbc5.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/java:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/share.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/clone/oracle/product/11.2.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /clone/oracle/product/11.2.0/appsutil/CLONE_ebso.xml -stage /clone/oracle/product/11.2.0/appsutil/clone   -showProgress   -noRmanRecovery yes -checkDBConnection
APPS Password : Log file located at /clone/oracle/product/11.2.0/appsutil/log/CLONE_ebso/ApplyDatabase_05170137.log
  |      0% completed       RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.
Please make sure you have UnZip 5.X in your path and try again…
 ERROR while running Apply…
 ERROR: Failed to execute /clone/oracle/product/11.2.0/appsutil/clone/bin/adclone.pl
  Please check logfile.
[orastg@ebso bin]$



Solution:
Which unzip should point to $ORACLE_HOME/bin/unzip
Take the backup of existing unzip from $ORACLE_HOME/bin
cd $ORACLE_HOME/bin
mv unzip unzip_bkp
Copy /usr/bin/unzip to $ORACLE_HOME/BIN
 cp -rp  /usr/bin/unzip $ORACLE_HOME/bin
Make sure the unzip utility under /usr/bin should be of version 5.X and not 6

Retest the issue by running adcfgclone.pl dbTier



adcfgclone.pl dbTier error: adcrdb.sh INSTE8 RC-50014: Fatal: Execution of AutoConfig was failed in R12

adcfgclone.pl error:RC-50014: Fatal: Execution of AutoConfig was failed in R12.

When we check the log file we can see the error like below
AutoConfig could not successfully instantiate the following files:

Directory: /u01/oradb/db/tech_st/11.1.0/appsutil/install/TEST1_<hostname>

adcrdb.sh INSTE8

AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed

Raised by oracle.apps.ad.clone.ApplyDatabase



Solution: we have to copy the adcrdb.sh file ($ORACLE_HOME/appsutil/template) from
Source to target ($ORACLE_HOME/appsutil/template) then
we run the adcfgclone.pl dbTier again.
Note: Normally adcrdb.sh file is missed if we provide the wrong apps password on target