Sunday, October 17, 2010

Peopletools 8.51 : Weblogic 11gR1 (10.3.2 – JRockit 27.6.7)

Downloaded from http://edelivery.oracle.com
Choose "Peoplesoft Entreprise", plateform "Linux x86", then under "PeopleSoft Enterprise - PeopleTools 8.51 Media Pack", choose the disk : "Oracle WebLogic Server 11gR1 (10.3.2) Generic"
It also requires the JRockit 27.6.7 (patch 9843749 to be downloaded from
http://support.oracle.com).

1. OS user
Same weblogic user created for previous unstallation as described
here.

2. Install software as weblogic user.
The weblogic's installation folder might be inside the PS_HOME directory, but since we can share the Weblogic software by multiple Peopletools and Peoplesoft applications, better to externalize the Weblogic software and do not duplicate the installation.

First of all, unzip the JRockit in the middleware home.
[weblogic@orion3:/apps/mdlware2]$ unzip /nfs/software/PeopleSoftCD/BEA/JRockit/Oracle_JRockit27_6_7/p9843749_2767_Linux-x86-64.zip
Archive:  /nfs/software/PeopleSoftCD/BEA/JRockit/Oracle_JRockit27_6_7/p9843749_2767_Linux-x86-64.zip
   creating: jrockit-jdk1.6.0_20/
  inflating: jrockit-jdk1.6.0_20/THIRDPARTYLICENSEREADME.txt
   creating: jrockit-jdk1.6.0_20/bin/
...
[weblogic@orion3:/nfs/software/PeopleSoftCD/BEA/Weblogic/Oracle_Weblogic_11gR1]$

Then set the JAVA_HOME variable and run the installer :
[weblogic@orion3:/nfs/software/PeopleSoftCD/BEA/Weblogic/Oracle_Weblogic_11gR1]$ export JAVA_HOME=/apps/mdlware2/jrockit-jdk1.6.0_20
[weblogic@orion3:/nfs/software/PeopleSoftCD/BEA/Weblogic/Oracle_Weblogic_11gR1]$ $JAVA_HOME/bin/java -jar ./wls1032_generic.jar -mode=console -logs=./wls1032_install.log
Extracting 0%....................................................................................................100%

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Welcome:
--------

This installer will guide you through the installation of WebLogic 10.3.2.0.
Type "Next" or enter to proceed to the next prompt.  If you want to change data entered previously, type "Previous".  You may quit the installer at any time by typing "Exit".

Enter [Exit][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Choose Middleware Home Directory:
---------------------------------

->1|* Create a new Middleware Home
   2|/apps/mdlware

Enter index number to select OR [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Choose Middleware Home Directory:
---------------------------------

    "Middleware Home" = [Enter new value or use default
"/home/weblogic/Oracle/Middleware"]

Enter new Middleware Home OR [Exit][Previous][Next]> /apps/mdlware2

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Choose Middleware Home Directory:
---------------------------------

    "Middleware Home" = [/apps/mdlware2]

Use above value or select another option:
    1 - Enter new Middleware Home
    2 - Change to default [/home/weblogic/Oracle/Middleware]

Enter option number to select OR [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Choose Middleware Home Directory:
---------------------------------

    Warning

/apps/mdlware2 directory is not empty. Proceed with installation?

Enter [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Register for Security Updates:
------------------------------

Provide your email address to be informed of security issues, install the product, and initiate configuration manager. http://www.oracle.com/support/policies.html

   1|Email:[]
   2|My Oracle Support Password:[]
   3|Receive Security Update:[Yes]

Enter index number to select OR [Exit][Previous][Next]> 3

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Register for Security Updates:
------------------------------

Provide your email address to be informed of security issues, install the product, and initiate configuration manager. http://www.oracle.com/support/policies.html

    "Receive Security Update:" = [Enter new value or use default "Yes"]

Enter [Yes][No]? No

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Register for Security Updates:
------------------------------

Provide your email address to be informed of security issues, install the product, and initiate configuration manager. http://www.oracle.com/support/policies.html

    "Receive Security Update:" = [Enter new value or use default "Yes"]

    ** Do you wish to bypass initiation of the configuration manager and
    **  remain uninformed of critical security issues in your configuration?

Enter [Yes][No]? Yes

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Register for Security Updates:
------------------------------

Provide your email address to be informed of security issues, install the product, and initiate configuration manager. http://www.oracle.com/support/policies.html

   1|Email:[]
   2|My Oracle Support Password:[]
   3|Receive Security Update:[No]

Enter index number to select OR [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Register for Security Updates:
------------------------------

Provide your email address to be informed of security issues, install the product, and initiate configuration manager. http://www.oracle.com/support/policies.html

   1|Email:[]
   2|My Oracle Support Password:[]
   3|Receive Security Update:[No]

Enter index number to select OR [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Choose Install Type:
--------------------

Select the type of installation you wish to perform.

->1|Typical
    |  Install the following product(s) and component(s):
    | - WebLogic Server

   2|Custom
    |  Choose software products and components to install and perform optional
    |configuration.

Enter index number to select OR [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

JDK Selection (Any * indicates Oracle Supplied VM):
---------------------------------------------------

JDK(s) chosen for use with this product installation will be installed. Supported defaults if not deselected will be used in script string-substitution.

   1|Add Local Jdk
   2|/apps/mdlware/mdlware2/jrockit-jdk1.6.0_20[x]
note : due to space management, /apps/mdlware2 used earlier is a symbolic link to /apps/mdlware/mdlware2

   *Estimated size of installation:  672.3 MB

Enter 1 to add or >= 2 to toggle selection  OR [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Choose Product Installation Directories:
----------------------------------------

Middleware Home Directory: [/apps/mdlware/mdlware2]

Product Installation Directories:

    "WebLogic Server" = [Enter new value or use default
"/apps/mdlware/mdlware2/wlserver_10.3"]
note : due to space management, /apps/mdlware2 used earlier is a symbolic link to /apps/mdlware/mdlware2

Enter new WebLogic Server OR [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

The following Products and JDKs will be installed:
--------------------------------------------------

    WebLogic Platform 10.3.2.0
    |_____WebLogic Server
         |_____Core Application Server
         |_____Administration Console
         |_____Configuration Wizard and Upgrade Framework
         |_____Web 2.0 HTTP Pub-Sub Server
         |_____WebLogic SCA
         |_____WebLogic JDBC Drivers
         |_____Third Party JDBC Drivers
         |_____WebLogic Server Clients
         |_____WebLogic Web Server Plugins
         |_____UDDI and Xquery Support

    *Estimated size of installation: 672.4 MB

Enter [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Installing files..

0%          25%          50%          75%          100%
[------------|------------|------------|------------]
[***************************************************]

Performing String Substitutions...

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Configuring OCM...

0%          25%          50%          75%          100%
[------------|------------|------------|------------]
[***************************************************]

Creating Domains...

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Installation Complete

Congratulations! Installation is complete.

Press [Enter] to continue or type [Exit]>

<-------------------- Oracle Installer - WebLogic 10.3.2.0 ------------------->

Clean up process in progress ...
[weblogic@orion3:/nfs/software/PeopleSoftCD/BEA/Weblogic/Oracle_Weblogic_11gR1]$

Peopletools 8.51 – Tuxedo 10gR3 (10.3.0 - RP035)

Peopletools 8.51 has been released last month, it’s time to have a look. I will reuse my lab orion3, based on OEL5.4 64-bits. I already use the same machine for a Peopletools 8.50 install as I described last year in previous installation articles.

Tuxedo is downloadable from
http://edelivery.oracle.com.
Choose "Peoplesoft Entreprise", plateform "Linux x86", then under "PeopleSoft Enterprise - PeopleTools 8.51 Media Pack", choose the disk : "Tuxedo 10gR3 for Linux x86-64".
You should also grab the Rolling Patch 31 (or above) from the support website (
http://support.oracle.com). Here I’ll use RP035, the latest available for Linux.

1. OS user
I’ll use the same tuxedo OS user used for previous installation (see
here).

2. A new middleware home will be used to avoid confusion and problem with previous install
/apps/mdlware2
Be sure tuxedo user is the owner and also due to InstallAnywhere software, it should have a wrtie access to the parent directory.

3. Installation of Tuxedo
[tuxedo@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64]$ ./tuxedo10gR3_64_Linux_01_x86.bin -i console
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...

Preparing CONSOLE Mode Installation...

===============================================================================
Choose Locale...
----------------

  ->1- English

CHOOSE LOCALE BY NUMBER:
===============================================================================
Tuxedo 10gR3                      (created with InstallAnywhere by Macrovision)
-------------------------------------------------------------------------------

===============================================================================
Introduction
------------

InstallAnywhere will guide you through the Tuxedo 10gR3 installation.

It is strongly recommended that you quit all programs before continuing with
this installation.

Enter "next' to proceed to the next screen. Enter "back" to modify the previous
screen.

You may cancel this installation at any time by typing "quit".

WARNING: "Quitting" creates an incomplete  Tuxedo 10gR3 installation.You must
re-install  Tuxedo 10gR3. For more information, see "Preparing to Install the
Oracle Tuxedo System" in the  Tuxedo 10gR3 Installation Guide.

PRESS <ENTER> TO CONTINUE:

===============================================================================
Choose Install Set
------------------

Please choose the Install Set to be installed by this installer.

  ->1- Full Install
    2- Server Install
    3- Full Client Install
    4- Jolt Client Install
    5- ATMI Client Install
    6- CORBA Client Install

    7- Customize...

ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
   :

===============================================================================
Choose Oracle Home
------------------

    1- Create new Oracle Home
    2- Use existing Oracle Home

Enter a number: 1
Specify a new Oracle Home directory: /apps/mdlware2
note : /apps/mdlware2 will be my new Middleware Oracle home (Tuxedo and Weblogic for Peopletools 8.51 instance)

===============================================================================
Choose Product Directory
------------------------

    1- Modify Current Selection (/apps/mdlware2/tuxedo10gR3)
    2- Use Current Selection (/apps/mdlware2/tuxedo10gR3)

Enter a number: 2
Install Samples (Y/N): N

===============================================================================
Pre-Installation Summary
------------------------

Please Review the Following Before Continuing:

Product Name:
    Tuxedo 10gR3

Install Folder:
    /apps/mdlware2/tuxedo10gR3

Link Folder:
    /home/tuxedo

Disk Space Information (for Installation Target):
    Required:  195,536,693 bytes
    Available: 2,654,818,304 bytes

PRESS <ENTER> TO CONTINUE:

===============================================================================
Ready To Install
----------------

InstallAnywhere is now ready to install Tuxedo 10gR3 onto your system at the
following location:

   /apps/mdlware2/tuxedo10gR3

PRESS <ENTER> TO INSTALL:

===============================================================================
Installing...
-------------

[==================|==================|==================|==================]
[------------------|------------------|------------------|------------------]

===============================================================================
Configure tlisten Service
-------------------------

Password:
Verify Password:
Password Accepted! Press "Enter" to continue.

===============================================================================
SSL Installation Choice.
------------------------

Would you like to install SSL Support?

  ->1- Yes
    2- No

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:
   : 2

===============================================================================
Installation Complete
---------------------

Congratulations. Tuxedo 10gR3 has been successfully installed to:

   /apps/mdlware2/tuxedo10gR3

PRESS <ENTER> TO EXIT THE INSTALLER:
[tuxedo@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64]$

4. Installation of the Rolling Patch
[root@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035]# tar zxf RP035.tar.Z
[root@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035]# ls -lrt
total 9224
-r-xr-xr-- 1 3862  601   23979 Jul 16 06:20 uninstall
-rw-r--r-- 1 3862  601    1360 Jul 16 06:20 README.txt
-r-xr-xr-- 1 3862  601   38361 Jul 16 06:20 install
drwxr-xr-x 3 3862  601    4096 Jul 16 06:20 udataobj
drwx------ 6 3862  601    4096 Jul 16 06:20 locale
drwx------ 2 3862  601    4096 Jul 16 06:20 lib
drwx------ 2 3862  601    4096 Jul 16 06:20 bin
-rwxrwxrwx 1 root root    2180 Jul 16 15:25 releasenotes.txt
-rwxrwxrwx 1 root root    5489 Jul 16 15:25 patchlev
-rwxrwxrwx 1 root root 9314974 Jul 16 15:25 RP035.tar.Z
-rwxrwxrwx 1 root root   11185 Jul 16 15:28 README.html
[root@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035]# chmod -R 777 *
[root@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035]# su - tuxedo
[tuxedo@orion3:/home/tuxedo]$ cd /nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035

note : set the environment variables
[tuxedo@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035]$ export TUXDIR=/apps/mdlware2/tuxedo10gR3
[tuxedo@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035]$ . $TUXDIR/tux.env
[tuxedo@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035]$ ./install
DIR=/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035
rpreleasenote =  SUSE LINUX Enterprise Server 10 (x86_64) x86 for AMD64, 64bits Tuxedo
portreleasenotes= SUSE LINUX Enterprise Server 10 (x86_64) x86 for AMD64, 64bits Tuxedo
Installing server and client files...
Enter owner for patch files:
tuxedo
Enter group for patch files:
psoft
\nThe patch installation finished successfully.
[tuxedo@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035]$
note : verify the installation
[tuxedo@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035]$ more ${TUXDIR}/udataobj/patchlev
``#ident  "@(#) udataobj/patchlev       $Revision: 1.17.4.83 $" 10gR3 Rolling Patch:
------------------
001. CR384055 Port Tuxedo 10.1 on HP-UX 11iv2 Itanium 32-bit
001. CR384850 DBBL crash with IA-HP Tuxedo 10gR3 32-bit binary DDR feature
001. CR384690 On AMD 64 Solaris, buildclient of 64bit Tuxedo for COBOL does not work
001. CR369297 TUXEDO 9.1 - The ISH.pipe socket files are created with world writable permissions
001. CR317441 Tux 9.1: Blocked tpforward
001. CR345393 TUX 9.1 - (HPUX) GWTDOMAIN does not retry silently to local host
001. CR354079 Tux 9.1:MIB API does not work for T_DM_CONNECTION class
001. CR344520 Tuxedo 9.1 (HPUX) : Orphan GWTDOMAIN processes after tmshutdown
001. CR244786 Tux 9.1 - Enhancement request: improve gateway connection retry logic
001. CR348991 "connect over connect" event suppressed automatically by TMSYSEVT
001. CR384975 "INSTALL RP WITHOUT CHECK PLATFORM"
001. CR354939 "TUX 9.1 - PATCH INSTALLER OVERWRITE FAILS AFTER RP075"
001. CR101725 "TUX 7.1 - PROVIDE INCREMENTAL INSTALLATION OF ROLLING PATCHES FOR WIN"
001. CR105807 "TUX 7.1: INSTALLING MULTIPLE PATCHES IN SUCCESSION SHOULD FAIL"
002. BUG7688216 Port Tuxedo 10gR3 on Windows X86 32-bit with BCB2007
002. BUG8406995 TUX10gR3:PACKAGETEST FAILED IN TUX10GR3 RP BUILD
003. BUG8499394 improve sca server performance by eliminating special thread for scaadmin pstats
003. CR368875 Propagation CR368875 form tux8.1 to TUX10gR3
004. BUG8464203 TUXEDO 10GR3 - PORT BUG8112509 - TX8.1 BRTHREADS=Y CAUSES 'TMADMIN' TO HANG WHILEMASTER MIGRATION ON FAILO
004. BUG8178850 TUXEDO 10GR3 - COBOL compiler fail on OEL5 32-bit platform
004. BUG8286211 tuxedo will escaping the leading slash
004. BUG8508175  Propagation Bug8157545 from tux9.1 to TUX10gR3 - TPTERM() FAILS WHEN USING SETJMP/LONGJMP ON HP-UX
005. BUG8533462 SUPPORT IBM COBOL 3.1 IN TUXEDO 10GR3 32 AND 64BIT ON AIX 5.3/6.1
006. BUG8610515 ON STARTUP GWTDOMAIN DOESN'T RETRY IF PASSWORDS DON'T MATCH
007. BUG8467126 .net client cannot get data when call tprecv
008. BUG8607764 TUXEDO 10GR3: IIOP CONNECTION FAILS AFTER RE-STARTING ISL PROCESS
008. BUG8179439 [ENHANCEMENT] ON WINDOWS SHOULD CREATE PROCESSES USING USE
009. BUG8555831 TUX10gR3:CONNOT USE TPEXCEPTION.TPERRNO FROM LIBWSCDNET IN VISUAL BASIC
009. BUG8676257 [TUX 10.3] GWTDOMAIN CRASHES/CORES WITH SEGV_MAPERR
009. BUG8175990 isl crashing with large number of iiop messages
009. BUG8610515 ON STARTUP GWTDOMAIN DOESN'T RETRY IF PASSWORDS DON'T MATCH
010. BUG8738048 [TUX 10.3 RP8] GWTDOMAIN CONNECTIONS FAIL WHEN SECONDARY PASSWORDS DON'T MATCH
011. BUG8608942 CAN'T BUILD /WS COBOL CLIENT WITH BUILDCLIENT -W -C
011. BUG8772511 TPCALL(TPNOTRAN) RETURNS UNEXPECTED TPESVCERR
012. BUG8895722 all tuxedo vers> ipcs queue left after tmshutdown
012. BUG8175990 isl crashing with large number of iiop messages
012. BUG8761973 JREPSRV WITH -W OPTION CAN'T BE PROPERLY RESTART
013. BUG8969925 [/ws] [tmtrace] tpterm() sets tpinvalidcontext for tpmul
014. BUG9018818 request will missing and cannot failover when target slave node is partitioned.
015. BUG9078553 TUXEDO 9.1 >  TUXEDO SERVER IN BASH PROCESS GROUP
016. BUG8178757 [CR385092] TUX8.1: STALE REQUEST IMPACT PERFORMANCE
016. BUG8674840 BLOCKTIME HAS NO EFFECTIVE FOR SERVICE REQUEST FROM WTC
017. BUG9092584 tux10.3 ish memory leak when invoking costransactions/transactionfactory objects
018. BUG9168215 blr backport of bug 9046205 on top of version 10.1
019. BUG9202705 tux 10.3: isl/ish memory leak when multithreaded clients interact
020. BUG9154374 TUX10GR3 : PROPAGATE BUG 8160372(CR368499)
021. BUG9202270 TX10.3: ALLOW USAGE OF STLPORT SUN OPEN SOURCE DELIVERY FOR STANDARD C++ LIBRARI
022. BUG9058386 tux10gr3 : cobcc invokes invalid cobol compiler
023. BUG9342574 GWTDOMAIN CRASHES IF DOMAINID EXCEEDS 15 CHARACTERS
023. BUG9178349 TUX10.3: INCLUDE FILE E_ENGINE.H ISN'T DELIVERED WHILE FULL /WS INSTALLATION
023. BUG9231494 TUX10GR3: RP INSTALLER ADDS TWO UNINSTALLER ENTRIES IN CONTROL
023. BUG9220136 isl memory leak when multithreaded java client starts too many threads
024. BUG9307236 TUX10GR3 : PLEASE PROPAGATE 8044573(CR309171) FROM TUXEDO8.1
024. BUG9315533 TUX10GR3 : PLEASE PROPAGATE 8135521(CR299584) FROM TUXEDO8.1
024. BUG9315539 TUX10GR3 : PLEASE PROPAGATE 7969906(CR347646) FROM TUXEDO8.1
025. BUG9409972 TUX10GR3 support HP OpenVMS Itanium 64
026. BUG9349544 TUX10GR3: tpacall return = -1
026. BUG9385743 TUX10GR3 : PLEASE PROPAGATE 8001820(CR208877) AND 8056995(CR246925)
027. BUG9461880 TUX10GR3 support IBM OS400 powerpc
028. BUG9354444 TUX10GR3 tmboot fail when the length of tuxconfig environment is 255 in OVMS
029. BUG9502580 tux10gr3:propagate bug 8846114 for libtux : 533 and libtux: 516 errors
030. BUG9389675 TUX10GR3 : TMADMIN OUTPUTS GARBLED CHARACTER ON JAPANESE ENVIRONMENT
031. BUG9578869 TUX10GR3-32: PROPAGATION OF BUG 9470763 (TPCALL DOESN'T RETURN TPED_TERM)
031. BUG9610700 TUX10.3: PORTING TUX10GR364RP INSTALLER TO WIN64 VS2008 PLATFORM
031. BUG9656822 TUX10.3: CAN'T INSTALL PATCHES ON WINDOWS 2003 X86-64 VS2005
032. BUG9713741 TUX10GR3: PROPAGATE BUG:8593642 WARNING MESSAGE OUTPUT WITH BUILD COMMAND ON HP-UX  Itanium 11.31
032. BUG9655834 TUX10.3: TMSHUTDOWN FAILS WITH 'CMDTUX_CAT:766: ERROR: MUST RUN ON MASTER
033. BUG9795195 TUX 10.3 - RESTART OF GWTDOMAIN FAILS WHEN IT IS KILLED DURING LOAD PERIOD
034. BUG9855607 TUX 10.3 - patch request for bug 8506647 on aix 6.1 64bit
035. BUG9826466 tuxedo backup node in mp conf hang when primary node crashed
[tuxedo@orion3:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64/RP035]$

Sunday, October 03, 2010

Oracle 11.2.0.2 (out-of-place install)

From the first patchset of Oracle 11gR2 (11.2.0.2), we are able to install it from “scratch” without having the need to install the based version (in most of the case *.1, e.g. 11.2.0.1), called out-of-place install or upgrade.
This is rather nice for any new installation, let’s say you start a brand new project, you want to be on the latest patchset. No need anymore to do it in two steps (first 11.2.0.1 then 11.2.0.2), you can directly install the latest available patchset.
Moreover, the Installer offers also the possibilities to install the latest PSU (PatchSet Update, a set of one-off patches and CPU) within a special step.

So, why waiting more, let’s install it.
From the
patchset page download on MOS, we can see 7 zipped files (!), but each one is for different usage :
* Files 1_of_7 and 2_of_7 are for Database
* Files 3_of_7 are for Grid Infrastructure
* Files 4_of_7 are for the Client
* Files 5_of_7 are for Gateway
* Files 6_of_7 are for Examples
* Files 7_of_7 are for Deinstaller

Don’t download everything if you don’t need, in the case below, only the first two are in used. I would say name of files would have been choose more carefully…
The install below is on Linux x86_64 OEL5.3.

 
Oracle11gR2.2_001 Oracle11gR2.2_002 Oracle11gR2.2_003

Oracle11gR2.2_004
 Oracle11gR2.2_005  Oracle11gR2.2_006
Oracle11gR2.2_007
The screen above is new from 11.2.0.2, you are prompted for email/password of My Oracle Support in case you want to apply the latest PSU, rather nice ! (in our case there is not). 
Oracle11gR2.2_008    Oracle11gR2.2_009 Oracle11gR2.2_010
Oracle11gR2.2_011  
Oracle11gR2.2_012
Remember, I’m doing an out-of-place installation (not based on any previous installation), and I already have a 11.2.0.1 installation on the same server, that’s why my oracle home directory contains the patchset number. It could become a name convention as of now.
Oracle11gR2.2_013   Oracle11gR2.2_014 Oracle11gR2.2_015  Oracle11gR2.2_016   Oracle11gR2017  
Right now, I have two Oracle home for 11gR2 (11.2.0.1 and 11.2.0.2), so, I modified my .bash_profile to be able to switch from one to the other easily :

[root@orion3:/]# su - oracle
[oracle@orion3:/home/oracle(OH-11.2.0.1)]$ more .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/apps/oracle

settings()
{
export ORACLE_BIN=$ORACLE_HOME/bin
export PATH=$ORACLE_BIN:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
}

o1()
{
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0
PS1="[\u@\h:\$PWD(OH-11.2.0.1)]\\$ "
settings
}

o2()
{
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.2
PS1="[\u@\h:\$PWD(OH-11.2.0.2)]\\$ "
settings
}

o1
[oracle@orion3:/home/oracle(OH-11.2.0.1)]$ sqlplus -v

SQL*Plus: Release 11.2.0.1.0 Production

[oracle@orion3:/home/oracle(OH-11.2.0.1)]$ o2
[oracle@orion3:/home/oracle(OH-11.2.0.2)]$ sqlplus -v

SQL*Plus: Release 11.2.0.2.0 Production

[oracle@orion3:/home/oracle(OH-11.2.0.2)]$

There are a couple of new features coming within this patchset, find out more in the documentation. I like the point 2.1.1.4 (While truncating a table or partition, you can now specify whether or not to keep any segments), it has been discussed several times over here. It is also now the case for partitioned table, point 2.1.1.15.

Enjoy the new version !

Nicolas.

Saturday, October 02, 2010

Peoplesoft and Oracle Edition

What Edition of Oracle database is required for Peoplesoft application ? Easy question, obvious answer ? Not so obvious.

In most of cases, response will be Enterprise Edition. But Peoplesoft works also fine with a Standard Edition as well. See the MOS note
PeopleTools Certification FAQs - Database Platforms - Oracle [ID 756280.1].
If you are not using any of the Enterprise options and features, then you definitely should consider the Standard Edition, it could dramatically drop your license costs down.
Of course, before changing or going for Standard Edition, you should double check your architecture and see further if you really need the Enterprise Edition or not.
For instance, you may not need Partitioning, not DataGuard (maybe a third party tool), not need Total Recall, not need Fine-Grained Auditing, not need Database Vault, no Advanced and Label Security neither (to name only few major features and options)… Then Standard Edition is probably more accurate for you.
Few features are really missing, like Flashback table (only Enterprise Edition feature) which really might help and be useful, and the main limitation being the 4 sockets max.
Find out which Edition is for you
here according to your environment and requirements.
If you eventually decide to move from Enterprise to Standard Edition, the procedure is quite simple, export and import, well
documented.

Was it new for you ? So, what Oracle Edition are you using in your Peoplesoft environment ? Would you consider a change for a cost cutting ?

Nicolas.