Saturday, September 26, 2009

HRMS9.1 available

September 2009... the list of new product versions delivered by Oracle this month becomes very inpressive.
In the already long list, a new comer, on the Peoplesoft side, one week after the Peopletools 8.50, Peoplesoft HRMS9.1 is now available !

Read the announcement :
http://blogs.oracle.com/peopletools/2009/09/peoplesoft_hrms_91_is_now_gene.html

Enjoy !

Nicolas.

Sunday, September 20, 2009

Peopletools 8.50 : a first look

Last Friday, September 2009, the 18th, Peopletools 8.50 has been released. The announcement is here.

As usual, it is available on http://edelivery.oracle.com

The Peopletools are now in 3 CDs (instead of 7 for PT8.49 !) :
V17557-01 => 1.2Gb
V17558-01 => 1.9Gb
V17559-01 => 308Mb
I'm still wondering why not doing on DVD format, or why doing a third CD so small ?

Tuxedo is coming with version 10gR3, reference and size are depending of your plateform, but here for Linux (only 64bits is available) :
V15055-01 => 71Mb

Finally, Weblogic , coming in version 11gR1 (it is rather confusing, actually the version is 10.3.1), reference and size are depending of your plateform, but here for Linux :
V16997-01 => 587Mb

The documentation is also available on usual website, http://www.oracle.com/technology/documentation/psftent.html and especially the installation guide, depending of the database type you are installing Peopletools onto :
http://download.oracle.com/docs/cd/E15742_01/psft/html/docset.html
Note, the licence code are provided in a pdf document format.
I'm still wondering why the need of this licence code, why not just ask for the database type ?
I suggested it on http://mix.oracle.com, feel free to add your voice :
https://mix.oracle.com/ideas/104482-peopletools-install-remove-the-licence-code

Time to have a first look into it.
I'll write tutorial in a few weeks time, maybe once Peoplesoft 9.1 will come out (there will come based on Peopletools 8.50).
Ok, now the installation. I'm doing this installation on my lab, OEL5.3 64-bits and Oracle database 11gR2 64-bits (I know it is not yet certified, but on the way).

1. Tuxedo :
By running the installer, we are feeling the Oracle touch, you are prompted to create an Oracle home directory to install Tuxedo :
===============================================================================
Choose Oracle Home
------------------


1- Create new Oracle Home

Enter a number: 1
Specify a new Oracle Home directory: /apps/bea/tuxedo/10gR3
Well, nothing much to say, standard install, and finally checking :
[tuxedo@orion2:/nfs/software/PeopleSoftCD/BEA/Tuxedo/Oracle_Tuxedo_10gR3_Linux_64]$ cd /apps/bea/tuxedo/10gR3
[tuxedo@orion2:/apps/bea/tuxedo/10gR3]$ export TUXDIR=/apps/bea/tuxedo/10gR3
[tuxedo@orion2:/apps/bea/tuxedo/10gR3]$ . $TUXDIR/tux.env
[tuxedo@orion2:/apps/bea/tuxedo/10gR3]$ $TUXDIR/bin/tmadmin -v
INFO: Oracle Tuxedo, Version 10.3.0.0, 64-bit, Patch Level (none)
[tuxedo@orion2:/apps/bea/tuxedo/10gR3]$
2. Weblogic :
Again, the installer has been greatly modified to make it "more Oracle" like.
<-- Oracle Installer - WebLogic 10.3.1.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]>

Here you're also promted to keep update with the lastest version of Oracle :
<----- Oracle Installer - WebLogic 10.3.1.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.1.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.1.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
I find it rather confusing, "No" I don't want to receive security update and "Yes", I want to keep "uninformed"...

The documentation about Weblogic installation strongly recommand to get the latest patch of the JDK/JRockit.
Why not having it by default ?

3. Peopletools on Linux (64bits) - console :
Only three CDs have to be unzipped (disk1, disk2 and disk3 folders in one directory).
Here changes are doing life simpler, firstly the command line is simply "setup.sh" and the licence code is only one field to fill up.
But again, you're prompt to keep (un)informed of security update... maybe it is me, but here we're talking about a server installation, not a workstation...
And, a good one, we are not prompt for the next CD anymore like it was in the previous release.

4. Peopletools on Windows (client) - GUI :
The main difference with a console mode, the licence code are still divided in 6 fields...
This is a Java, and you could have to allow the program to be executed onto Windows :


5. Database :
I did not create database from scratch, need more time and disk space, but I reused a FSCM9 database (working on Peopletools 8.49).
So, I just managed an upgrade to the latest Peopletools release, the steps very similar of previous release, with some slight differences, including an activation of TIMESTAMP (script upgdboptions_enabletimestamps.sql), and some additional Application Engine (UPGPTSERVOPR, UPGPT850PTFP).
Again, patience and time are required, the project are very big and the project load and build take quite a while.

6. Application server :
Here two warning with big differences compared with Peopletools 8.4x, some environment variables are not set by default into psconfig.sh.
TUXDIR must be set to the Tuxedo home directory, otherwise you cannot configure and start a domain.
PS_CFG_HOME must also be set to the directory you want your domain configuration files, otherwise those files are going into /home//psft/appserv...
You can set those variables in the .profile (or .bash_profile, depending of your plateform), i.e. :
[ptools@orion2:/home/ptools]$ more .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
unset USERNAME
export ORACLE_HOME=/apps/oracle/product/11.2.0

export TUXDIR=/apps/bea/tuxedo/10gR3
export LD_LIBRARY_PATH=$TUXDIR/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$TUXDIR/bin:$PATH:$ORACLE_HOME/bin

export PS_HOME=/apps/psoft/ptools850
export PS_CFG_HOME=$PS_HOME
. $PS_HOME/psconfig.sh

[ptools@orion2:/home/ptools]$
I'm not sure to understand why it has be remove from standard configuration settings, but I'm sure that'll cause some headache if they are not set to find the config files.

7. PIA :
Again, the installer command line has been greatly simplify, just run setup.sh. Oracle Applicatoin Server has been removed from the choice, we've now only Weblogic and WebSphere, quite understandable.
A slight difference is about the password of the system user, you should take care about if you're upgrading an existing database (and used by report node) :
Please enter the administrator login and password for WebLogic domain.

Login ID [system]:

Password [Passw0rd]:

Re-type Password [Passw0rd]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
8. Connection :
Few very first impression, the "Processing" on the top right has been replace by a kind of wheel, and some dialog box are coming up in front, looks nice and more "modern" style.





9. (update 21-SEPT-2009) Following the advice from Bauke Gehem (see comment below), I changed the settings to get a very nice look :
Thanks so much Bauke !

Enoy this version.

Nicolas.

Friday, September 18, 2009

Peopletools 8.50

Again, we can say September' 2009 is rich in events for Oracle.
After Oracle database 11gR2, OEL5.4, one more proof, Peopletools 8.50, waited for a while is released !

Go through http://edelivery.oracle.com/ to do download
Go through http://download.oracle.com/docs/cd/E15742_01/psft/html/docset.html for the installation doc !

Enjoy !

Nicolas.

Update 19-SEPT-2009 :
The patch 1 is now available on the usual ftp website with the password protection getting from My Oracle Support.
PT8.50 has also been announced on the Peoplesoft Technology blog.

Nicolas.

Wednesday, September 16, 2009

OEL5.4 available

September' 2009 is beeing a very rich month regarding new Oracle software version.

After the Oracle database 11gR2, this is now for Oracle Entreprise Linux 5.4 to be available only few weeks after the linux based version RHEL5.4.
We'll see later if there is added value by Oracle in this release compared to RHEL.

Now, I'm awaiting the CentOS 5.4 which is the OS of my lab.
But since CentOS is a free OS developped on free time, it is always coming much later, one or two months...

Enjoy,

Nicolas.

Tuesday, September 08, 2009

Get rid off segment of empty table (11gR2)

I'm trying to get rid off segment of empty table, according to the documentation it should be possible to alter the table with the clause "SEGMENT CREATION DEFERRED", but it does not look like so obvious :
SQL> create table mytable1(id number);

Table created.

SQL> create table mytable2(id number);

Table created.

SQL> select segment_name,bytes from user_segments where segment_name like 'MYTABLE_';

no rows selected

SQL> insert into mytable1 values(1);

1 row created.

SQL> commit;

Commit complete.

SQL> select segment_name,bytes from user_segments where segment_name like 'MYTABLE_';

SEGMENT_NAME BYTES
---------- ------
MYTABLE1 65536

SQL> truncate table mytable1;

Table truncated.

SQL> select segment_name,bytes from user_segments where segment_name like 'MYTABLE_';

SEGMENT_NAME BYTES
---------- ------
MYTABLE1 65536

SQL> alter table mytable1 move;

Table altered.

SQL> select segment_name,bytes from user_segments where segment_name like 'MYTABLE_';

SEGMENT_NAME BYTES
---------- ------
MYTABLE1 65536

SQL> alter table mytable1 move segment creation deferred;
alter table mytable1 move segment creation deferred
*
ERROR at line 1:
ORA-14133: ALTER TABLE MOVE cannot be combined with other operations


SQL> alter table mytable1 segment creation deferred;
alter table mytable1 segment creation deferred
*
ERROR at line 1:
ORA-01735: invalid ALTER TABLE option


Ok, then let's try to export and import tables to see if it is easy :
[oracle@orion2:/oradata/DMOFSCM9/dpdump]$ expdp sysadm/sysadm dumpfile=mytable.dmp logfile=mytable.log directory=data_pump_dir tables=mytable1,mytable2

Export: Release 11.2.0.1.0 - Production on Tue Sep 8 21:57:36 2009

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSADM"."SYS_EXPORT_TABLE_01": sysadm/******** dumpfile=mytable.dmp logfile=mytable.log directory=data_pump_dir tables=mytable1,mytable2
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SYSADM"."MYTABLE1" 0 KB 0 rows
. . exported "SYSADM"."MYTABLE2" 0 KB 0 rows
Master table "SYSADM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSADM.SYS_EXPORT_TABLE_01 is:
/oradata/DMOFSCM9/dpdump/mytable.dmp
Job "SYSADM"."SYS_EXPORT_TABLE_01" successfully completed at 21:57:46


Then standard import (without particular options) :
[oracle@orion2:/oradata/DMOFSCM9/dpdump]$ impdp sysadm/sysadm dumpfile=mytable.dmp logfile=mytable_imp.log directory=data_pump_dir sqlfile=mytable.sql

Import: Release 11.2.0.1.0 - Production on Tue Sep 8 21:58:04 2009

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSADM"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SYSADM"."SYS_SQL_FILE_FULL_01": sysadm/******** dumpfile=mytable.dmp logfile=mytable_imp.log directory=data_pump_dir sqlfile=mytable.sql
Processing object type TABLE_EXPORT/TABLE/TABLE
Job "SYSADM"."SYS_SQL_FILE_FULL_01" successfully completed at 21:58:06

[oracle@orion2:/oradata/DMOFSCM9/dpdump]$ more mytable.sql
-- CONNECT SYSADM
ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';
-- new object type path: TABLE_EXPORT/TABLE/TABLE
CREATE TABLE "SYSADM"."MYTABLE1"
( "ID" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PSDEFAULT" ;

CREATE TABLE "SYSADM"."MYTABLE2"
( "ID" NUMBER
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "PSDEFAULT" ;


The SEGMENT CREATION IMMEDIATE is there for my table mytable1 (eventhough it is empty).
Let's try to remove storage of table during import :
[oracle@orion2:/oradata/DMOFSCM9/dpdump]$ impdp sysadm/sysadm dumpfile=mytable.dmp logfile=mytable_imp.log directory=data_pump_dir transform=storage:n sqlfile=mytable.sql

Import: Release 11.2.0.1.0 - Production on Tue Sep 8 21:58:17 2009

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSADM"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SYSADM"."SYS_SQL_FILE_FULL_01": sysadm/******** dumpfile=mytable.dmp logfile=mytable_imp.log directory=data_pump_dir transform=storage:n sqlfile=mytable.sql
Processing object type TABLE_EXPORT/TABLE/TABLE
Job "SYSADM"."SYS_SQL_FILE_FULL_01" successfully completed at 21:58:19

[oracle@orion2:/oradata/DMOFSCM9/dpdump]$ more mytable.sql
-- CONNECT SYSADM
ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';
-- new object type path: TABLE_EXPORT/TABLE/TABLE
CREATE TABLE "SYSADM"."MYTABLE1"
( "ID" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "PSDEFAULT" ;

CREATE TABLE "SYSADM"."MYTABLE2"
( "ID" NUMBER
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "PSDEFAULT" ;

No more luck.

Finally, let's remove the segment attribute :
[oracle@orion2:/oradata/DMOFSCM9/dpdump]$ impdp sysadm/sysadm dumpfile=mytable.dmp logfile=mytable_imp.log directory=data_pump_dir transform=segment_attributes:n sqlfile=mytable.sql

Import: Release 11.2.0.1.0 - Production on Tue Sep 8 21:58:34 2009

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSADM"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SYSADM"."SYS_SQL_FILE_FULL_01": sysadm/******** dumpfile=mytable.dmp logfile=mytable_imp.log directory=data_pump_dir transform=segment_attributes:n sqlfile=mytable.sql
Processing object type TABLE_EXPORT/TABLE/TABLE
Job "SYSADM"."SYS_SQL_FILE_FULL_01" successfully completed at 21:58:36

[oracle@orion2:/oradata/DMOFSCM9/dpdump]$ more mytable.sql
-- CONNECT SYSADM
ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';
-- new object type path: TABLE_EXPORT/TABLE/TABLE
CREATE TABLE "SYSADM"."MYTABLE1"
( "ID" NUMBER
) ;

CREATE TABLE "SYSADM"."MYTABLE2"
( "ID" NUMBER
) ;

[oracle@orion2:/oradata/DMOFSCM9/dpdump]$

Unfortunately, no more tablespace... that means every single imported table will be (re)created into the user's default tablespace, which is not good enough.

Looks like as soon as we have a segment for a table, it is rather difficult to "remove" it.

To be continued,

Nicolas.

Monday, September 07, 2009

Peoplesoft on 11gR2 64-bits

I should start to say, Peoplesoft (any version) is not supported yet on 11gR2 (64/32 bits).
But I would like to test it how it is working.

1. Install the 11gR2 64-bits, as I explained here

2. Upgrade your database, here below a FSCM9 database (or create from scratch - I did not tested it yet)
The upgrade is quite standard, start the db with old version and run the 11.2 check utility :
@/apps/oracle/product/11.2.0/rdbms/admin/utlu112i.sql

Then start your db in upgrade mode, and run the upgrade script (with 11.2 binaries) :
@$ORACLE_HOME/rdbms/admin/catupgrd.sql

After restarting the db in normal mode, check it afterwards :
@$ORACLE_HOME/rdbms/admin/utlu112s.sql

There is an additional script to run :
@$ORACLE_HOME/rdbms/admin/catuppst.sql

And finally, recompile the objects :
@$ORACLE_HOME/rdbms/admin/utlrp.sql


3. Because 11gR2 64-bits is not coming with 32-bits libraries, as I wrote here, you'll need to install a 32-client into a new Oracle home for the application and batch server clients.
That is fine, nothing much to say about the client install, check the runtime option :


4. Create the required symbolic link $ORACLE_HOME/lib/libclntsh.so.9.0 pointing to $ORACLE_HOME/lib/libclntsh.so.11.1 (assuming ORACLE_HOME is
your Oracle client home path directory). Do not forget to configure the tnsnames.ora as well.

5. Change the ORACLE_HOME env variable to the Oracle client home pathdirectory of the Peoplesoft Unix account, and reconfigure the
application and batch domains.

Finally every should run fine.

One very interesting feature of 11gR2 for Peoplesoft is the possibility to deferred the segment creation, it will be very nice to
avoid segment creation for thousands of unused and empty tables., I should also have a try to rebuild the tables without segments...

Enjoy,

Nicolas.

Sunday, September 06, 2009

11gR2 64-bits : where is lib32 ?

From the Peopletools 8.49.14, Peoplesoft is fully certified on a 64-bits OS and 11gR1 64-bits (application server and batch server), I already post an article few months ago.
Peoplesoft was still a 32-bits application, but in 11gR1 64-bits, Oracle provided a lib32 directory containing all the required 32-bits libraries, and it worked fine by doing a symbolic link from $ORACLE_HOME/lib/libclntsh.so.9.0 to $ORACLE_HOME/lib32/libclntsh.so.11.1.

Here we go, 11gR2 does not provide anymore the 32-bits libraries, no more $ORACLE_HOME/lib32 directory.
Consequently, Peopletools 8.49 (application server and batch server) cannot be used within 11gR2 64-bits.

What’s up if you are already on a 64-bits OS ? The thing is, you cannot install 11gR2 32-bits client server on 64-bits Linux (blocked by the Installer).
So, what ?
Well, Peoplesoft does not say anything yet about 11gR2, but most likely, Peoplesoft 8.49.x won't be certified soon on 11gR2 64-bits... you must stay on 11gR1 64-bits, or move your application/batch server to 11gR2 32-bits client (sigh)…

I don't hink that'll easy for Peoplesoft to get this certification (11gR2 64-bits client) for existing Peopletools (8.49). Hopefully, that won’t be an issue for the coming Peopletools 8.50 (note, it won't be certified anymore on Linux 32-bits).
This is an issue not only for Peoplesoft application, but for all the 32-bits application running out an Oracle 64-bits client so far.

Update 1 (07-Sept-09): well it seems to be possible by installing the 11gR2 32-bit client onto a new Oracle home on Linux 64-bits, thanks to Fredrik Adolfsson for pointing me out the right documentation :
http://download.oracle.com/docs/cd/E11882_01/install.112/e10841/install_overview.htm#BABFICCG

Saturday, September 05, 2009

Oracle 11.2.0.1 install on OEL5.3 64 bits

It is a quite interesting release, a lot of changes in the installation screenshots, especially for those who followed the Oracle install for a long time.
Here, we go.

Firstly, be sure the following RPMs are installed on your OS :
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
sysstat-7.0.2
unixODBC-2.2.11
unixODBC-2.2.11 (32 bit)
unixODBC-devel-2.2.11
unixODBC-devel-2.2.11 (32 bit)

Note the 32 bits packages requirements, it was a surprise for me.
Some of them was not installed on my server, so, need to be installed :
[root@orion2:/nfs/software/LinuxCD/OracleEntrepriseLinux/OEL5x86/OEL5.2x86/RPMs/cd2]# ls unix*
unixODBC-2.2.11-7.1.i386.rpm
[root@orion2:/nfs/software/LinuxCD/OracleEntrepriseLinux/OEL5x86/OEL5.2x86/RPMs/cd2]# rpm -Uvh unixODBC-2.2.11-7.1.i386.rpm
warning: unixODBC-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:unixODBC ########################################### [100%]
[root@orion2:/nfs/software/LinuxCD/OracleEntrepriseLinux/OEL5x86/OEL5.2x86/RPMs/cd2]# cd ../cd3
[root@orion2:/nfs/software/LinuxCD/OracleEntrepriseLinux/OEL5x86/OEL5.2x86/RPMs/cd3]# ls unix*
unixODBC-devel-2.2.11-7.1.i386.rpm unixODBC-kde-2.2.11-7.1.i386.rpm
[root@orion2:/nfs/software/LinuxCD/OracleEntrepriseLinux/OEL5x86/OEL5.2x86/RPMs/cd3]# rpm -Uvh unixODBC-devel-2.2.11-7.1.i386.rpm
warning: unixODBC-devel-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:unixODBC-devel ########################################### [100%]
[root@orion2:/nfs/software/LinuxCD/OracleEntrepriseLinux/OEL5x86/OEL5.2x86/RPMs/cd3]# ls libaio*
libaio-devel-0.3.106-3.2.i386.rpm
[root@orion2:/nfs/software/LinuxCD/OracleEntrepriseLinux/OEL5x86/OEL5.2x86/RPMs/cd3]# rpm -Uvh libaio-devel-0.3.106-3.2.i386.rpm
warning: libaio-devel-0.3.106-3.2.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:libaio-devel ########################################### [100%]
[root@orion2:/nfs/software/LinuxCD/OracleEntrepriseLinux/OEL5x86/OEL5.2x86/RPMs/cd3]#


Moreover, modifications are required into /etc/sysctl.conf :
#fs.file-max = 6553600
#change for 11gR2
fs.file-max = 6815744
...
#net.core.wmem_max = 262144
#change for 11gR2
net.core.wmem_max = 1048586
...
#net.ipv4.ip_local_port_range = 1024 65000
#change for 11gR2
net.ipv4.ip_local_port_range = 9000 65500


The run
/sbin/sysctl -p
or reboot your system.

Finally, within your prefered XWindow client :

















Enjoy the new version,

Nicolas.

Tuesday, September 01, 2009

11gR2

Well, it is not a scoop anymore, but the release 2 of Oracle 11g has been out today (only for Linux 32/64 bits).
The size is amazing (or is it already the inflation?) : the 10gR2 was about 800Mb, right now, 11gR2 is splitted on two files of 1Gb each...

Anyway, it needs to be tested. Especially the LISTAGG function as Laurent mentioned here.

Download : http://www.oracle.com/technology/software/products/database/index.html
Doc : http://www.oracle.com/pls/db112/homepage

Nicolas.

Peoplesoft plugin for OEM - part 3

Following the OEM 10.2.0.5 upgrade, I'm going to install the Peoplesoft plugin for OMS.
This is downloadable from hhtp://edelivery.oracle.com

Here we go.

1. Stop the OMS ($ORACLE_HOME/opmn/opmnctl stopall)
2. Go into $ORACLE_HOME/oui/bin (from OMS path directory) and run the installer.
3. Change the source location to Disk1/stage from the download file, as below :

4. Select Peoplesoft product for OMS
5. It will prompt for the SYS's password, and click on Install.
Unfortunately, in my case, I got an error :
[oracle@opcenter bin]$ more /appl/oracle/oms10g/cfgtoollogs/psemca-2009-8-30_17-321.out
Getting temporary tablespace from database...
Found temporary tablespace: TEMP
Environment :
ORACLE HOME = /appl/oracle/oms10g
REPOSITORY HOME = /appl/oracle/oms10g
SQLPLUS = /appl/oracle/oms10g/bin/sqlplus
SQL SCRIPT ROOT = /appl/oracle/oms10g/sysman/admin/emdrep/sql
EXPORT = /appl/oracle/oms10g/bin/exp
IMPORT = /appl/oracle/oms10g/bin/imp
LOADJAVA = /appl/oracle/oms10g/bin/loadjava
JAR FILE ROOT = /appl/oracle/oms10g/sysman/admin/emdrep/lib
JOB TYPES ROOT = /appl/oracle/oms10g/sysman/admin/emdrep/bin
Arguments :
...

Failed to register/update the following template(s):
Get New Alerts XML Outbound
Get Updated Alerts XML Outbound
Get Response Inbound
Exception has been caught. Please check log file for more information.
Restore the tweaked target type driver scripts ..
Total time taken for parsing and reconstructing target types SQL files: 25 ms.
Optimization done.
Done.
Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADED);END;

Repository Upgrade has errors. Please check file /appl/oracle/oms10g/sysman/log/emrepmgr.log.18350 for detailed errors.



....
SQL> SET ECHO OFF
MGMT_JOB_ENGINE.validate_job_type(l_job_type_name, l_commands, l_nested_jobtypes );
*
ERROR at line 42:
ORA-06550: line 42, column 21:
PLS-00302: component 'VALIDATE_JOB_TYPE' must be declared
ORA-06550: line 42, column 5:
PL/SQL: Statement ignored
ORA-06550: line 66, column 17:
PLS-00302: component 'INSERT_CLUSTER_TARGET_TYPES' must be declared
ORA-06550: line 66, column 1:
PL/SQL: Statement ignored
ORA-06550: line 130, column 64:
PL/SQL: ORA-00904: "ACTION": invalid identifier
ORA-06550: line 130, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 205, column 64:
PL/SQL: ORA-00904: "ACTION": invalid identifier
ORA-06550: line 205, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 262, column 64:
PL/SQL: ORA-00904: "ACTION": invalid identifier
ORA-06550: line 262, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 337, column 64:
PL/SQL: ORA-00904: "ACTION": invalid identifier
ORA-06550: line 337, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 394, column 64:
PL/SQL: ORA-00904: "ACTION": invalid identifier
ORA-06550: line 394, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 45

....


My OMS is 10.2.0.5, and it is clearly specify the OMS should be 10.2.0.2 minimum, so ?
So, when installing OMS with all the defaults, it is installing a 10.1.0.4 repository database, it needs to be upgraded before going further.

6. Finally, after upgrading my repository database to 10.2.0.4 (today, the latest 10gR2 release), it ran smoothly.

7. It is restarting OMS automatically, and once you're connected onto OEM, you got one more tab named Peoplesoft :
(sorry for the French screenshot, my explorer is installed in French, but I think it is understandable, at least for what I wan to show).

Next step is the Peoplesoft plugin for Agent.

Enjoy,

Nicolas.