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

Common Blockers to Technology Adoption

In this Blog I will share some issues and potential blockers to technology adoption I have seen,  and share steps which can be undertaken to address these and hopefully accelerate adoption.

Blockers are commonly categorised into 3 groups

People, Process & Technology

Screen Shot 2015-04-01 at 11.58.48

People

Personal and organizational barriers are a frequent causes for slow adoption; there can be many reasons for resistance, these can include:

  • Missing or weak executive Sponsorship
  • Lack of vision or poor communication.
  • Staff just don’t get it
    • What are the Business benefits?
  • Fear of Change
    • How does it impact me?
  • Silo’ed teams
    • Historic mistrust of other teams and or departments
  • Inadequate Training
    • Lack of confidence to use solution.

Department or individuals not on side can quickly become detractors and significantly impact your ability to move forward, once identified they need to be addressed.

Process

Internal company processes, procedures and standards can all be blockers or factors in delays for wider adoption.

  • Governance
    • Engineering standards
      • Does new solution comply with existing standards?
    • Financial chargeback models
      • Do existing models support this are they correct?
    • Solution ownership
      • Data center, development teams, business etc..
  • IT Service Management ITIL (Information Technology Infrastructure Library)
    • Change Management
      • How are changes approved and implemented
    • Configuration Management
      • How are configuration items managed
    • Request Fulfilment Process
      • How are new requests raised and approved
    • Incident Management Process
      • How are incidents categorised and managed

Technology adoption can sometimes be disruptive, old processes may need to be reworked or retired if no longer appropriate.

Technology

Enterprise level adoption requires that the technology not only works as expected but is compliant to internal policies.

  • Is the technology in-line with EA (Enterprise Architecture) Principles
  • Is the technology and business benefit understood
  • Is there a technology champion
  • Is there a clear vision of how the solution will be used
  • Does the solution satisfy a recognised business issue
  • Does the solution work the as expected

If any of the above are ‘No’ there is a risk that the technology will become ‘Shelfware’ and never expand out of it’s original deployment.


Key steps to Adoption

  • Establish a sense of urgency.
    • Senior leadership explains compelling need for business transformation
  • Form a powerful guiding coalition
    • Recruit key sponsors to drive change value proposition for technology and business transformation
  • Create a compelling vision
    • Establish business transformation strategy, driver and target technology vision.
  • Communicate vision
    • Develop detailed stakeholder management and communication plan
  • Empower others and remove obstacles
    • Establish strong governance organisation and build effective technical capabilities in critical areas
  • Create short term wins
    • Create incremental plans for technical delivery based on transition architectures.
  • Consolidate and build on change
    • Establish technology lifecycle and change management.
  • Institutionalise change
    • Establish technology as core for business and IT transformation, technical organisation, best practices & standards, recruitment & skills development etc…

Kotters 8 Steps for Change Management