Oracle EBS WebLogic 10.3 – SBU patching “GC overhead limit exceeded” error

When using the BSU (Smart Update) utility to patch your Oracle EBS WebLogic 10.3 you may experience “java.lang.OutOfMemoryError: GC overhead limit exceeded” errors.

[applvis@z-oracle1 bsu]$ ./bsu.sh -install -patch_download_dir=/u06/oracle/VIS/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=EQDE -prod_dir=/u06/oracle/VIS/fs1/FMW_Home/wlserver_10.3

Exception in thread “main” java.lang.OutOfMemoryError: GC overhead limit exceeded

at java.util.HashMap.inflateTable(HashMap.java:316)

at java.util.HashMap.put(HashMap.java:488)

at com.bea.cie.common.dao.xbean.XBeanDataHandler.loadPropertyMap(XBeanDataHandler.java:778)

at com.bea.cie.common.dao.xbean.XBeanDataHandler.(XBeanDataHandler.java:99)

at com.bea.cie.common.dao.xbean.XBeanDataHandler.createDataHandler(XBeanDataHandler.java:559)

at com.bea.cie.common.dao.xbean.XBeanDataHandler.getComplexValue(XBeanDataHandler.java:455)

at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:442)

at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:464)

at com.bea.plateng.patch.dao.cat.PatchCatalog.getPatchDependencies(PatchCatalog.java:56)

at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getInvalidatedPatchMap(PatchCatalogHelper.java:1621)

at com.bea.plateng.patch.PatchSystem.updatePatchCatalog(PatchSystem.java:436)

at com.bea.plateng.patch.PatchSystem.refresh(PatchSystem.java:130)

at com.bea.plateng.patch.PatchSystem.setCacheDir(PatchSystem.java:201)

at com.bea.plateng.patch.Patch.main(Patch.java:281)

Issue

The issue is due to the fact that the bsu.sh script does not allocate adequate memory to the JAVA process.

Resolution

To fix this backup the current bsu.sh script and amend the initial JAVA memory allocation (Xms) and maximum heap size (Xms) values to address the memory issues e.g.

MEM_ARGS=”-Xms512m -Xmx1024m -XX:+UseParallelGC”

to

MEM_ARGS=”-Xms2048m -Xmx2048m -XX:+UseParallelGC”

Results

[applvis@z-oracle1 bsu]$ ./bsu.sh -install -patch_download_dir=/u06/oracle/VIS/fs1/FMW_Home/utils/bsu/cache_dir -patchlist=EQDE -prod_dir=/u06/oracle/VIS/fs1/FMW_Home/wlserver_10.3
Checking for conflicts…….
No conflict(s) detected

Installing Patch ID: EQDE.
Result: Success

Advertisements

Oracle EBS R12.2.6 on Virtual Box Pt2

If you followed my previous post Oracle E-Business Suite R12.2.6 on Virtual Box you will have already downloaded the 19 required zip files, and be ready to go.

Ok, change directory to the location of the downloaded files, unzip and concatenate them into a single OVA file using the following:

$ unzip ‘V*.zip’

$ cat Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova.* > Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova

Getting started – Virtual Box

Start Virtual Box and navigate to File -> Import Appliance

Click on ‘Expert Mode’ and edit the ‘Virtual Disk Image’ path to a location with adequate space (~500GB), in this example I am using my Samsung Portable SSD T1 1TB dive mounted at ‘/Volumes/Samsung_T1’

OVA_import

Click ‘Import’, go to lunch or grab a coffee and watch the progress bar if you prefer, the remaining time will re-calulate periodically.

Importing

Once complete, start up your new Oracle EBS R12.2.6 VM from within Oracle VirtualBox

Oracle E-Business Suite R12.2.6

inital_boot

The initial boot will prompt you to change the ‘root’, ‘oracle’ and ‘applmgr’ passwords, the process will continue to start and configure an Oracle 12.1.0.2 database called ‘EBSDB’.

VISION

Use ifconfig -a’ to determine your VM’s IP address from you VirtualBox console before using SSH from your host to connect using your preferred client.

Add the IP address to your local ‘/etc/host’ file so your browser can resolve your Oracle EBS VISION sandbox environment. e.g.

#
192.168.0.23 apps.example.com apps
#

Change directory to ‘/u01/install/APPS/scripts’ to access the database and application stop / start scripts and run ‘startdb.sh’ and ‘startapps.sh’

  • startdb.sh
  • stopdb.sh
  • startapps.sh
  • stopapps.sh

Shell

[oracle@apps scripts]$ ./startdb.sh
Logfile: /u01/install/APPS/12.1.0/appsutil/log/EBSDB_apps/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process EBSDB …

LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 15-AUG-2017 07:42:19

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Starting /u01/install/APPS/12.1.0/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 12.1.0.2.0 – Production
System parameter file is /u01/install/APPS/12.1.0/network/admin/EBSDB_apps/listener.ora
Log messages written to /u01/install/APPS/12.1.0/admin/EBSDB_apps/diag/tnslsnr/apps/ebsdb/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.example.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps.example.com)(PORT=1521)))
STATUS of the LISTENER
————————
Alias EBSDB
Version TNSLSNR for Linux: Version 12.1.0.2.0 – Production
Start Date 15-AUG-2017 07:42:19
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/install/APPS/12.1.0/network/admin/EBSDB_apps/listener.ora
Listener Log File /u01/install/APPS/12.1.0/admin/EBSDB_apps/diag/tnslsnr/apps/ebsdb/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps.example.com)(PORT=1521)))
Services Summary…
Service “EBSDB” has 1 instance(s).
Instance “EBSDB”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/APPS/12.1.0/appsutil/log/EBSDB_apps/addlnctl.txt for more information …

You are running addbctl.sh version 120.1

Starting the database EBSDB …

SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 15 07:42:19 2017

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

Connected to an idle instance.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1308625016 bytes
Database Buffers 822083584 bytes
Redo Buffers 13848576 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

addbctl.sh: exiting with status 0

[oracle@apps scripts]$ ./startapps.sh 
Starting the Oracle E-Business Suite Application Tier Services
You are running adstrtal.sh version 120.24.12020000.11

All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /u01/install/APPS/fs1/inst/apps/EBSDB_apps/logs/appl/admin/log/adstrtal.log for more information …

Before you can logon you will need to enable SYSADMIN and the Demo accounts, Oracle have provided scripts to do this  e.g.

[oracle@apps scripts]$ ./enableSYSADMIN.sh

This script will let you set a new password for the SYSADMIN EBS Applications User, the default password most likely was “sysadmin”, so pick a different one now.

Enter new password for SYSADMIN:
Re-enter password for SYSADMIN:
Changing password for SYSADMIN
Log filename : L7583909.log
Report filename : O7583909.out
[oracle@apps scripts]$

[oracle@apps scripts]$ ./enableDEMOusers.sh

Enter a new password for the EBS Applications Users, the default password
most likely was “welcome”, so pick a different one now…

Enter new password for DEMO users:
Re-enter password for DEMO users:
Setting password for DEMO users…
Log filename : L7583911.log

[oracle@apps scripts]$

Oracle EBS R12 Dashboard

You should now be able to logon as ‘SYSADMIN’ or explore your Oracle EBS R12.2.6 VISION sandbox environment using the Demo users (see below) and the password defined above at: http://apps.example.com:8000/

“AFENG”, “AMARLIN”, “AMILLER”, “APOTTER”, “BPALMER”, “BWEBB”
“CBROWN”, “CONMGR”, “CONTMGR”, “CSADM”, “DBAKER”, “EBUSINESS”
“FBRAMER”, “HRMS”, “ILANG”, “ISUPPORTADMIN”, “JFROST”
“KJONES”, “LJONES”, “MFG”, “MGRMKT”, “MNT”, “OPERATIONS”
“PHENRY”, “PIMMGR”, “PLMMGR”, “PROCESS_OPS”, “PROJMFG”
“PSTOCK”, “RBATES”, “SCRIPTUSER”, “SERVICES”, “SFM”
“SPAIN”, “SVYADMIN”, “TRADEMGR”

Sales_Dashboard
Sales Dashboard – LJONES

Oracle EBS 12.2.6 on VirtualBox

Back in May, Oracle announced the general availability of Oracle VM Virtual Appliance for E-Business Suite 12.2.6 for download from the Oracle Software Delivery Cloud.

In this series of Blog posts I will detail how you can build an Oracle EBS 12.2.6 environment with VirtualBox for use on a laptop / PC.

Getting Started

Logon to the Oracle Software Delivery Cloud using you SSO credentials and search for ‘Oracle Virtual Appliance‘ , select the Product as below and click ‘Continue’ to download the Oracle VM Virtual Appliance for Oracle E-Business Suite.

Filter

Compatible with VirtualBox

As you can see from above, the Oracle VM Virtual Appliance for Oracle E-Business Suite supports both Oracle VM and Oracle VirtualBox. Once download the Virtual Appliance can be imported into VirtualBox for running on a laptop / PC.

The Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.6.0.0 for x86 64bit is packaged in 19 files requiring 69.4 GB, so may take some considerable time to download depending upon your network / internet connection.

DownloadQueue

The Download

You can download the 19 Oracle VM Virtual Appliances files individually by clicking on the file name or them all use wget, if you have never used wget you can read the following post on how to use wget for downloading.

Virtual_Appliance_SWThe distribution includes the entire Oracle EBS Technology and Apps stack including the example Vision database.

COMPONENT VERSION
RDBMS Oracle Home 12.1.0.2
Application Code Level Oracle E-Business Suite 12.2.6 Release Update Pack (My Oracle Support Knowledge Document 2114016.1) + AD and TXK Delta 8 (My Oracle Support Knowledge Document 2159750.1)
Oracle Forms and Reports 10.1.2.3
WebLogic Server 10.3.6
Web Tier 11.1.1.9
JDK JDK 1.7 build 1.7.0_121-b15
Java Plugin J2SE 1.7
Critical Patch Update (CPU) October 2016

In my next post I will detail how build an Oracle E-BS 12.2.6 environment within VirtualBox.

Downloading Oracle E-Business Suite R12.2.6 using wget

When it’s time for you to next download the Oracle E-Business Suite media you better plan ahead as it’s getting big, really big, R12.2.6 is now over 83GB and could take a considerable amount of time if your downloading it interactively.

Fortunately Oracle’s e-delivery website can help out.

Select your Options

Firstly, uncheck all the ‘Oracle E-Business Suite Languages (12.2.0.0.0)’ and ‘Oracle E-Business Suite Languages (12.2.6.0.0)’ not required.

Now, if you are only performing a ‘VISION’ installation you can uncheck the all files labeled ‘Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD – Disk X’.

Alternatively, if you don’t want the ‘VISION’ database uncheck all the files labeled ‘Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION – Disk X’.

WGET Options

Now we have selected our files, look for ‘WGET Options’ in the bottom left corner and click the link.

edelivery

This opens up a new window allowing you to download a wget script, hit ‘Download.sh’ to download the script to your desktop.

wget_options

Great, you now have a script you can run on your Linux/Unix server to ‘pull’ back all the files, you now need to copy the wget script to your server using scp for example.

Once copied over, open the script in your editor of choice, and find the references to ‘SSO_USERNAME’ and ‘SSO_PASSWORD’.

Update these to your Oracle SSO (Single Sign-On) credentials, save the file and then change the permissions to 755 to make it executable and your now good to go.

# SSO username and password
#read -p ‘SSO User Name:’ SSO_USERNAME
#read -sp ‘SSO Password:’ SSO_PASSWORD
SSO_USERNAME=john.smith@oracle.com
SSO_PASSWORD=maryjane

Note: The WGET download script does not provide any feedback about whether or not the script was successful. Therefore you need to view the log file to verify the download was a successful or to troubleshoot any issues. The log file by default will be called wgetlog-.log, however you can change the name and location in the wget script file by setting the following:

# Log directory and file
LOGDIR=.
LOGFILE=$LOGDIR/wgetlog-`date +%m-%d-%y-%H:%M`.log

Oracle E-Business Suite R12.2.5 Fresh Install – Part III

Oracle EBS R12.2.5 Upgrade

In Part I of my Oracle R12.2.5 Fresh Install walkthrough I described the prepatory steps for the install.

In Part II we shared details on how to install Oracle EBS using the latest R12.2.5 media including Oracle 12cR1.

In this Blog post I walk provide details of how to upgrade your EBS environment from R12.2.0 to R12.2.5.

Current Configuration

SQL> select banner from v$version;
BANNER
——————————————————————————–
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
PL/SQL Release 12.1.0.2.0 – Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 – Production
NLSRTL Version 12.1.0.2.0 – Production

SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
————————————————–
12.2.0

R12.2.5 Upgrade Process

If you have access to http://support.oracle.com refer to Oracle E-Business Suite Releases 12.2.5 Readme (Doc ID 1983050.1)

Apply Consolidated Seed Table Patch

Stop all Application services other than the WebLogic AdminServer on the run file system.

$ cd $ADMIN_SCRIPTS_HOME
$ ./adstpall.sh apps/apps

$ ./adadminsrvctl.sh start

Apply the patch using the new adop tool, adpatch no longer required.

$ cd ../VIS/fs_ne/EBSapps/patch
$ unzip p17204589.zip
$ unzip p21900871
$ adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes

Start all AppsTier services

$ cd $ADMIN_SCRIPTS_HOME
$ ./adstral.sh apps/apps

Enter Weblogic password when prompted.

Apply R12.2.5 Release Update Pack

Source the run edition environment variables

$. <INSTALL_BASE>EBSapps.env. run

Stop the Weblogic AdminServer and Node Manager services

$ cd $ADMIN_SCRIPTS_HOME
$ ./adadminsrvctl.sh stop
$ ./adnodemgrctl.sh stop

Set the 12c database parameter optimizer_adaptive_features to false

optimizer_adaptive_features=false

Apply previously downloaded patch 19676458

$ cd ../VIS/fs_ne/EBSapps/patch
$ unzip p19676458.zip
$ adop phase=apply apply_mode=downtime patches=19676458

Reset the 12c database parameter optimizer_adaptive_features back to true

optimizer_adaptive_features=true

Re-Start all AppsTier services

$ cd $ADMIN_SCRIPTS_HOME
$ ./adstral.sh apps/apps

Perform adop clean-up
$ adop phase=cleanup

Synchronise the file systems using atop as below, this will copy the new run edition code and configuration to the other file system.
$ adop phase=fs_clone

Updated Configuration

As you can see from below we have now a running Oracle EBS R12.2.5 environment on a 12c database.

R12.2.5 OAM

EBS_Release_Name

Oracle E-Business Suite R12.2.5 Fresh Install – Part II

Oracle EBS R12.2.5 Installation

Navigate to ../startCD/Disk1/rapidwiz an launch rapidwiz

As you can see from below the installation is going to include Oracle 12cR1 RDBMS.

Welcome

Review and click ‘Next’

Wizard1

Select ‘Install Oracle E-Business Suite Release R12.2.0’, click ‘Next’

config_choice

Select ‘Create a new configuration’, click ‘Next’

global_settings

Update Port Pool if required, click ‘Next’

database_node

Update Database Node Configuration, click ‘Next’

primary_app_node

Update Application Node Configuration, click ‘Next’

App_user_info

Update Application User Information, click ‘Next’

node_info

Review node information, click ‘Next’

validation

Review ‘Validate System Configuration’, click ‘Next’

review

Review summary, click ‘Next’

Installing

Click ‘Next’ to start install

Missing Java library

rw-50004

The above failure is due to a missing java library file, this can be fixed with the below.

$ORACLE_HOME/javavm/jdk/jdk7/lib/libjavavm12.a lib to $ORACLE_HOME/lib/

If your quick you can copy it whilst rapidwiz is installing the Oracle Home, otherwise you will have to clean-up the oraInventory and star rapidwiz again.

RMAN failure

The installer will try to restore the data files using RMAN, previous releases just unzipped the files, the installer will continue for a while until.

RMAN-04014: startup failed: ORA-01127: database name ‘OLDDBNAME’ exceeds size limit of 8 characters

This can be fixed by updating the RMANinit.ora file and restarting rapidwiz e.g.

/u01/oracle/VIS/12.1.0/dbs/RMANinit.ora
db_name=OLDDBNAME
to
db_name=VIS

Perl Segmentation fault

Another, problem you may encounter with your Oracle EBS R12.2.5 install is a perl ‘Segmentation fault’

$ pwd
/u01/oracle/VIS/12.1.0/perl/bin
$ ./perl -v
Segmentation fault

$ cd $ORACLE_HOME
$ mv perl/ perl.old/
$ mkdir perl

Change directory back to your downloaded version and re-compile.

$ cd
$ cd perl/perl-5.14.1
$./Configure -des -Dprefix=$ORACLE_HOME/perl -Doptimize=-O3 -Dusethreads -Duseithreads -Duserelocatableinc ; make clean ; make ; make install

$ cd $ORACLE_HOME/perl
$ rm -rf lib/ man/
$ cp -r ../perl.old/lib/ .
$ cp -r ../perl.old/man/ .
$ cp ../perl.old/bin/dbilogstrip bin/
$ cp ../perl.old/bin/dbiprof bin/
$ cp ../perl.old/bin/dbiproxy bin/
$ cp ../perl.old/bin/ora_explain bin/

Rapidwiz Completion

Once the installed is complete you can now confirm your EBS and database versions using the following:

SQL> select release_name from apps.fnd_product_groups;
SQL> select * from v$version;

In part III of this BLOG series I will share the steps to upgrade from R12.2.0 to R12.2.5

Oracle E-Business Suite R12.2.5 Fresh install – Part I

Oracle EBS R12.2.5 Installation

Oracle E-Business Suite R12.2.5 has been out a while now, so I thought it was about time that I took it for a test drive.

Steven Chan’s R12.2.5 Blog is a great place to start your planning, if your not a regular visitor to his Blog, probably a good time to start.

If you want to try our 12c, R12.2.5 is the first release to be shipped with Oracle 12.1.0.2.

Preparation

Before you begin you R12.2.5 make sure plan to spend some time downloading the R12.2.5 distribution from https://edelivery.oracle.com and the following patches from http://support.oracle.com

Also, make sure you have set your XDISPLAY set and it’s accessible, you can easily check this with xclock.

StartCD 12.2.0.51

p22066363_R12_GENERIC.zip

Consolidated Seed Table Upgrade Patch

p17204589_12.2.0_R12_GENERIC.zip

Oracle EBS R12.2.5 Release Update Patch

p19676458_R12_LINUX_1of9.zip
p19676458_R12_LINUX_2of9.zip
p19676458_R12_LINUX_3of9.zip
p19676458_R12_LINUX_4of9.zip
p19676458_R12_LINUX_5of9.zip
p19676458_R12_LINUX_6of9.zip
p19676458_R12_LINUX_7of9.zip
p19676458_R12_LINUX_8of9.zip
p19676458_R12_LINUX_9of9.zip>

p17537119_R12_GENERIC.zip
p20745242_R12.AD.C_R12_LINUX.zip
p20784380_R12.TXK.C_R12_GENERIC.zip
p21900871_12.2.0_R12_GENERIC.zip
p22123818_R12.AD.C_R12_LINUX.zip
p22363475_R12.TXK.C_R12_GENERIC.zip
p22495069_R12.TXK.C_R12_GENERIC.zip
p6880880_121010_Linux-x86-64.zip

Stage R12.2.5 distribution

$ unzip p22066363_R12_GENERIC.zip
$ cd startCD/Disk1/rapidwiz/bin
$ ./buildStage.sh

Build Stage Menu

——————————————————

1. Create new stage area

2. Copy patches to existing stage area

3. List files in TechPatches directory

4. Exit menu

Enter your choice [4]: 1

At the next prompt select your OS, in this walkthrough I have selected 2 (Linux x86 64-bit)

Rapid Install Platform Menu

——————————————————

1. Oracle Solaris SPARC (64-bit)

2. Linux x86 (64-bit)

3. IBM AIX on Power Systems (64-bit)

4. HP-UX Itanium

5. Exit Menu

Enter your choice [5]: 2

Enter location of R12.2.5 zipped installation media

Running command:

/mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin Linux_x64 Linux_x64

Specify the directory containing the zipped installation media:
/mnt/hgfs/Oracle/R12.2.5_x86-64
File list:
/mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat
The set of zip files is complete.
Unzip command is: /mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o
Unzipping V35802-01.zip
Unzipping V35803-01_1of3.zip
Unzipping V35803-01_2of3.zip
Unzipping V35803-01_3of3.zip
Unzipping V35804-01_1of2.zip
Unzipping V35804-01_2of2.zip
Unzipping V46095-01_1of2.zip
Unzipping V46095-01_2of2.zip
Unzipping V100059-01_1of2.zip
Unzipping V100059-01_2of2.zip
Unzipping V100060-01_1of3.zip
Unzipping V100060-01_2of3.zip
Unzipping V100060-01_3of3.zip
Unzipping V100053-01_1of2.zip
Unzipping V100053-01_2of2.zip
Unzipping V100054-01.zip
Unzipping V100055-01.zip
Unzipping V100056-01.zip
Unzipping V100057-01.zip
Unzipping V100058-01.zip
Unzipping V100061-01.zip
Unzipping V100102-01.zip
Unzipping V75792-01.zip
Unzipping V29856-01.zip
Unzip command is: /mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o
All files have been unzipped successfully.
Stage area is confirmed to be complete.
Command = cp /mnt/hgfs/Oracle/R12.2.5_x86-64/V100061-01.zip /mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip

Finished unzipping shiphome.

Directory /mnt/Stage/12.2.0.51/TechPatches

Unzipping Oracle Software Delivery Cloud one-off patches…
Command: /mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../unzip/Linux_x64/unzip -o /mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip -d /mnt/Stage/12.2.0.51/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/..
Press Enter to continue…

The staged media will now be unzipped

Build Stage Menu

——————————————————

1. Create new stage area

2. Copy patches to existing stage area

3. List files in TechPatches directory

4. Exit menu

Enter your choice [4]: 2

Rapid Install Platform Menu

——————————————————

1. Oracle Solaris SPARC (64-bit)

2. Linux x86 (64-bit)

3. IBM AIX on Power Systems (64-bit)

4. HP-UX Itanium

5. Exit Menu

Enter your choice [5]: 2

Once complete ‘Exit’

Virtual Machine Perl Issue

Finally before we start, some Oracle Virtual Box and VMware Fusion Linux user have reported issues with the perl version shipped in the 12.1.0.2 $ORACLE_HOME.

$ perl -v
Segmentation fault

To fix this I downloaded and un-tarred the zipped perl package.

$ cd
$ mkdir perl
$ cd perl/

$ curl -O http://www.cpan.org/src/5.0/perl-5.14.1.tar.gz
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 15.5M 100 15.5M 0 0 3233k 0 0:00:04 0:00:04 –:–:– 3400k

$ tar -zxvf perl-5.14.1.tar.gz

How to Check Oracle EBS Clone Configuration

How to check Oracle EBS Configuration

An interesting question was raised during a recent discussion on Delphix 5.0 and it’s new Oracle EBS Multi-Node capability.

How can I check what my Oracle EBS Clone topology is?

The simplest way to check your R12 Clone configuration is to use Oracle Applications Manager (OAM).

OAM (Oracle Applications Manager)

Logon to your Oracle R12 clone environment with an account that has the ‘System Administrator Responsibility’

Navigate to ‘Oracle Application Manager’

Select ‘Dashboard’ from here you can easily see a list of Database and Application Servers as well as the status of the services on each server.

 

OAM Configuration

Use SQL

Alternatively logon as ‘APPS’ to SQLPlus and perform the following checks

select INSTANCE_NAME, HOST_NAME from V$INSTANCE;

After a successful running adcfgclone.pl dbTier or adcfgclone.pl database (if database already exists)

You should see your cloned database DB_NAME updated to it’s new value

select DB_NAME from FND_DATABASES;

Once you have completed the AppsTier cloning you can check the Database and Application servers using the following:

select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES
where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID

e.g.

dbCheck

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Oracle E-Business Suite Clone Log Parser utility

Oracle EBS Log Parser

As anyone who has ever performed an Oracle E-Business suite clone knows it can be a complex time consuming task,  any error during the cloning process may result in a considerable amount of time been spent reviewing multiple clone log files in various directories on the Apps & Database tiers. To assist with this challenge the Oracle Proactive Support Team developed the ‘Log Parser’, this utility is able to consolidates error information from the 12 seperate clone log files into a easy to read HTML report. The ‘Log Parser’ also perform some basic configuration checks and reports this along with useful recommendations and the Oracle support pages links.

The Log parser analyses the following logs:

  • StageDBTier.log
  • StageAppsTier_.log
  • ApplyDBTier.log
  • ApplyDatabase.log
  • ApplyDBTechStack.log
  • ApplyAppsTechStack.log
  • ApplyAppsTier.log
  • CloneContext.log
  • make_.log, make.log
  • adconfig.log
  • ohclone.log
  • adcrdb_.txt
  • NetServiceHandler.log
  • setup_stubs.log
  • Central/Global oraInventory/logs directory and all sub-directories, for any files with a .err, .log or .txt extension

Installation

The installation couldn’t be much simpler – download, extract, run

You can download the ‘Log Parser’ directly from ‘My Oracle Support’  – E-Business Suite Clone Log Parser Utility (Rapid Clone 11i,12.0, 12.1) (Doc ID 1447553.1)

1447553

Database Tier

Download the ‘Log Parser’ zip file into /tmp and unzip the file into $ORACLE_HOME/appsutil/clone

Screen Shot 2015-01-07 at 10.49.10

Once you have unzipped the Log Parser your a ready to navigate to the LogParser directory and run the LogParser perl script.

Screen Shot 2015-01-07 at 11.27.34

On completion you will have a new HTML report available for your review

Screen Shot 2015-01-07 at 11.30.59

Transfer this back to your desktop an open in your preferred browser, click on the ‘Show Details’ links in the various sections to expand the report.

Screen Shot 2015-01-07 at 11.35.28

Applications Tier

Download the ‘Log Parser’ zip file into /tmp and unzip the file into <COMMON_TOP>/clone

Screen Shot 2015-01-07 at 18.55.48

Once you have unzipped the Log Parser your a ready to navigate to the LogParser directory and run the LogParser perl script.

Screen Shot 2015-01-07 at 19.01.48

On completion you will have a new HTML report available for your review, as before click on the ‘Show Details’ to expand the report.

Screen Shot 2015-01-07 at 18.56.22

Transfer this back to your desktop an open in your preferred browser.

Screen Shot 2015-01-07 at 19.06.07

In a future post I will walk through the Log Parser report and review the output.

Oracle EBS and Delphix

The Delphix EBS solution provides AppsDBA’s, functional consultants, test teams and business users the ability to perform Self Service on-demand EBS environment (Database, Database Tier & AppsTier) clones. This dramatically reduced the end-to-end provision time coming down from multiple weeks to a mater of minutes.

In a couple of previous posts I have provided a walkthrough of how to Virtualise your EBS environment and also how to create a new Virtual EBS environment.