On The Peoplesoft Road : Oracle 10.2.0.3 install

Last step before going on the Peoplesoft installation itself, the Oracle installation.
The last Oracle database version certified for Peoplesoft is the 10gR2 patchset 2 (10.2.0.3). Don't forget the required patches for Peoplesoft.

As root, create the groups and the Oracle user :
[root@orion ~]# groupadd dba
[root@orion ~]# groupadd oinstall
[root@orion:/root] ()$ useradd -g oinstall -G dba ora102
[root@orion:/root] ()$ passwd ora102
Changing password for user ora102.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

Update the .bash_profile for the new user :
[ora102@orion:/home/ora102] ()$ more .bash_profile
ORACLE_BASE=/apps/oracle
ORACLE_HOME=$ORACLE_BASE/10.2.0
ORACLE_SID=DEMO102
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
LD_ASSUME_KERNEL=2.4.1
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH LD_ASSUME_KERNEL PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

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

As root update the file /etc/sysctl.conf
[root@orion:/root] ()$ more /etc/sysctl.conf
# Kernel sysctl configuration file for Enterprise Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1

kernel.sem = 250 32000 100 128
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.msgmnb = 65536
kernel.msgmni = 2878
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

[root@orion:/root] ()$

If you don't want to reboot your server, run sysctl -p command.

Update the followings files as well :
[root@orion:/root] ()$ more /etc/pam.d/login
#%PAM-1.0
auth required pam_securetty.so
auth required pam_stack.so service=system-auth
auth required pam_nologin.so
account required pam_stack.so service=system-auth
password required pam_stack.so service=system-auth
# pam_selinux.so close should be the first session rule
session required pam_selinux.so close
session required pam_stack.so service=system-auth
session required pam_loginuid.so
session optional pam_console.so
# pam_selinux.so open should be the last session rule
session required pam_selinux.so open

session required /lib/security/pam_limits.so
[root@orion:/root] ()$
[root@orion:/root] ()$ more /etc/security/limits.conf
# /etc/security/limits.conf
#
#Each line describes a limit for a user in the form:
#
#
#
#Where:
# can be:
# - an user name
# - a group name, with @group syntax
# - the wildcard *, for default entry
# - the wildcard %, can be also used with %group syntax,
# for maxlogin limit
#
# can have the two values:
# - "soft" for enforcing the soft limits
# - "hard" for enforcing hard limits
#
# can be one of the following:
# - core - limits the core file size (KB)
# - data - max data size (KB)
# - fsize - maximum filesize (KB)
# - memlock - max locked-in-memory address space (KB)
# - nofile - max number of open files
# - rss - max resident set size (KB)
# - stack - max stack size (KB)
# - cpu - max CPU time (MIN)
# - nproc - max number of processes
# - as - address space limit
# - maxlogins - max number of logins for this user
# - maxsyslogins - max number of logins on the system
# - priority - the priority to run user process with
# - locks - max number of file locks the user can hold
# - sigpending - max number of pending signals
# - msgqueue - max memory used by POSIX message queues (bytes)
#
#
#

#* soft core 0
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#@student - maxlogins 4
* - nproc 16384
* - nofile 16384
oracle soft nproc 2047
ora102 soft nproc 2047
oracle hard nproc 16384
ora102 hard nproc 16384
oracle soft nofile 1024
ora102 soft nofile 1024
oracle hard nofile 65536
ora102 hard nofile 65536
# End of file
[root@orion:/root] ()$

Insert the CD3 of the OEL4.6 disks install, and install additional packages :
[root@orion /]# cd /media/cdrom/
[root@orion cdrom]# ls
Enterprise EULA GPL RPM-GPG-KEY TRANS.TBL
[root@orion cdrom]# cd Enterprise/RPMS/
[root@orion RPMS]# rpm -Uvh compat-gcc-32-3.2.3-47.3.i386.rpm
warning: compat-gcc-32-3.2.3-47.3.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-gcc-32 ########################################### [100%]
[root@orion RPMS]# rpm -Uvh compat-gcc-32-c++-3.2.3-47.3.i386.rpm
warning: compat-gcc-32-c++-3.2.3-47.3.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-gcc-32-c++ ########################################### [100%]
[root@orion RPMS]# rpm -Uvh compat-libcom_err-1.0-5.i386.rpm
warning: compat-libcom_err-1.0-5.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-libcom_err ########################################### [100%]
[root@orion RPMS]# rpm -Uvh compat-libgcc-296-2.96-132.7.2.i386.rpm
warning: compat-libgcc-296-2.96-132.7.2.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-libgcc-296 ########################################### [100%]
[root@orion RPMS]# rpm -Uvh compat-libstdc++-296-2.96-132.7.2.i386.rpm
warning: compat-libstdc++-296-2.96-132.7.2.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-libstdc++-296 ########################################### [100%]
[root@orion RPMS]# rpm -Uvh compat-libgcc-296-2.96-132.7.2.i386.rpm
warning: compat-libgcc-296-2.96-132.7.2.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
package compat-libgcc-296-2.96-132.7.2 is already installed
[root@orion RPMS]# rpm -Uvh compat-glibc-headers-2.3.2-95.30.i386.rpm
warning: compat-glibc-headers-2.3.2-95.30.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:compat-glibc-headers ########################################### [100%]
[root@orion:/media/cdrom/Enterprise/RPMS] ()$ rpm -Uvh libaio-0.3.105-2.i386.rpm
warning: libaio-0.3.105-2.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:libaio ########################################### [100%]
[root@orion:/media/cdrom/Enterprise/RPMS] ()$

[root@orion:/root] ()$

Then in a XClient, as Oracle user, my ora102, run the Installer.
[ora102@orion:/home/ora102] (DEMO102)$ cd /nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_1_0/
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_1_0] (DEMO102)$ cd database/
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_1_0/database] (DEMO102)$ ./runInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-12-28_09-48-06PM. Please wait ...
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_1_0/database] (DEMO102)$
Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.



During the installation, run the root.sh as root user.

Then upgrade to the 10.2.0.3 patchset level :
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2] (DEMO102)$ ls
Oracle_10_2_0_1_0 Oracle_10_2_0_3_0_upgrade Required_patches_PS
c[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2] (DEMO102)$ cd Oracle_10_2_0_3_0_upgrade/
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_3_0_upgrade] (DEMO102)$ ls
Disk1 p5337014_10203_LINUX.zip README.html
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_3_0_upgrade] (DEMO102)$ cd Disk1/
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_3_0_upgrade/Disk1] (DEMO102)$ ls
10203_buglist.htm install patch_note.htm response runInstaller stage
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Oracle_10_2_0_3_0_upgrade/Disk1] (DEMO102)$ ./RunInstaller
Starting Oracle Universal Installer...

Checking installer requirements...

Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed


All installer requirements met.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-12-28_10-10-43PM. Please wait ...



During the patchset installation, run the root.sh as root user.

Install the OPatch utility (4898608).
Go in the $ORACLE_HOME and unzip the downloaded patch
[ora102@orion:/apps/oracle/10.2.0] (DEMO102)$ unzip /nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/p4898608_10201_GENERIC_Opatch.zip
Archive: /nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/p4898608_10201_GENERIC_Opatch.zip
replace OPatch/docs/FAQ? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
inflating: OPatch/docs/FAQ
inflating: OPatch/docs/Users_Guide.txt
inflating: OPatch/docs/Prereq_Users_Guide.txt
inflating: OPatch/jlib/opatch.jar
inflating: OPatch/jlib/opatchutil.jar
inflating: OPatch/jlib/opatchprereq.jar
inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml
inflating: OPatch/opatchprereqs/opatch/rulemap.xml
inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml
inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml
inflating: OPatch/opatchprereqs/prerequisite.properties
inflating: OPatch/opatch
inflating: OPatch/opatch.bat
inflating: OPatch/opatch.pl
inflating: OPatch/opatch.ini
inflating: OPatch/emdpatch.pl
inflating: OPatch/README.txt
[ora102@orion:/apps/oracle/10.2.0] (DEMO102)$

Then you have to install the three required patches recommanded by Peoplesoft.
p5128368_10203_LINUX.zip
p5574966_10203_LINUX.zip
p5683652_10203_LINUX.zip

[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5574966] (DEMO102)$ $ORACLE_HOME/OPatch/opatch apply
Invoking OPatch 10.2.0.1.5

Oracle interim Patch Installer version 10.2.0.1.5
Copyright (c) 2007, Oracle Corporation. All rights reserved..


Oracle Home : /apps/oracle/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.1.5
OUI version : 10.2.0.3.0
OUI location : /apps/oracle/10.2.0/oui
Log file location : /apps/oracle/10.2.0/cfgtoollogs/opatch/opatch2007-12-28_22-36-03PM.log

ApplySession applying interim patch '5574966' to OH '/apps/oracle/10.2.0'
Invoking fuser to check for active processes.
Invoking fuser on "/apps/oracle/10.2.0/bin/oracle"

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/apps/oracle/10.2.0')

Is the local system ready for patching?

Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '5574966' for restore. This might take a while...
Backing up files affected by the patch '5574966' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.3.0...
Updating archive file "/apps/oracle/10.2.0/lib/libserver10.a" with "lib/libserver10.a/kkqjpd.o"
Updating archive file "/apps/oracle/10.2.0/lib/libserver10.a" with "lib/libserver10.a/vop.o"
Running make for target ioracle
ApplySession adding interim patch '5574966' to inventory

Verifying the update...
Inventory check OK: Patch ID 5574966 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5574966 are present in Oracle Home.

The local system has been patched and can be restarted.


OPatch succeeded.
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5574966] (DEMO102)$ cd ../5128368
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5128368] (DEMO102)$ $ORACLE_HOME/OPatch/opatch apply
Invoking OPatch 10.2.0.1.5

Oracle interim Patch Installer version 10.2.0.1.5
Copyright (c) 2007, Oracle Corporation. All rights reserved..


Oracle Home : /apps/oracle/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.1.5
OUI version : 10.2.0.3.0
OUI location : /apps/oracle/10.2.0/oui
Log file location : /apps/oracle/10.2.0/cfgtoollogs/opatch/opatch2007-12-28_22-37-14PM.log

ApplySession applying interim patch '5128368' to OH '/apps/oracle/10.2.0'
Invoking fuser to check for active processes.
Invoking fuser on "/apps/oracle/10.2.0/bin/oracle"

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/apps/oracle/10.2.0')

Is the local system ready for patching?

Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '5128368' for restore. This might take a while...
Backing up files affected by the patch '5128368' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.3.0...
Updating archive file "/apps/oracle/10.2.0/lib/libserver10.a" with "lib/libserver10.a/kko.o"
Running make for target ioracle
ApplySession adding interim patch '5128368' to inventory

Verifying the update...
Inventory check OK: Patch ID 5128368 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5128368 are present in Oracle Home.

The local system has been patched and can be restarted.


OPatch succeeded.
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5128368] (DEMO102)$ cd ../5683652
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5683652] (DEMO102)$ $ORACLE_HOME/OPatch/opatch apply
Invoking OPatch 10.2.0.1.5

Oracle interim Patch Installer version 10.2.0.1.5
Copyright (c) 2007, Oracle Corporation. All rights reserved..


Oracle Home : /apps/oracle/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.1.5
OUI version : 10.2.0.3.0
OUI location : /apps/oracle/10.2.0/oui
Log file location : /apps/oracle/10.2.0/cfgtoollogs/opatch/opatch2007-12-28_22-38-14PM.log

ApplySession applying interim patch '5683652' to OH '/apps/oracle/10.2.0'
Invoking fuser to check for active processes.
Invoking fuser on "/apps/oracle/10.2.0/bin/oracle"

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/apps/oracle/10.2.0')

Is the local system ready for patching?

Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '5683652' for restore. This might take a while...
Backing up files affected by the patch '5683652' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.3.0...
Updating archive file "/apps/oracle/10.2.0/lib/libclient10.a" with "lib/libclient10.a/kpugem.o"

Patching component oracle.rdbms.rsf, 10.2.0.3.0...
Updating archive file "/apps/oracle/10.2.0/lib/libclient10.a" with "lib/libclient10.a/kpugem.o"
Running make for target client_sharedlib
Running make for target ioracle
ApplySession adding interim patch '5683652' to inventory

Verifying the update...
Inventory check OK: Patch ID 5683652 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5683652 are present in Oracle Home.

The local system has been patched and can be restarted.


OPatch succeeded.
[ora102@orion:/nfs/software/oracle/Oracle_for_Linux_x86/Oracle10gR2/Required_patches_PS/5683652] (DEMO102)$ cd $ORACLE_HOME
[ora102@orion:/apps/oracle/10.2.0] (DEMO102)$ $ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.1.5

Oracle interim Patch Installer version 10.2.0.1.5
Copyright (c) 2007, Oracle Corporation. All rights reserved..


Oracle Home : /apps/oracle/10.2.0
Central Inventory : /apps/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.1.5
OUI version : 10.2.0.3.0
OUI location : /apps/oracle/10.2.0/oui
Log file location : /apps/oracle/10.2.0/cfgtoollogs/opatch/opatch2007-12-28_22-39-11PM.log

Lsinventory Output file location : /apps/oracle/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2007-12-28_22-39-11PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 2 products installed in this Oracle Home.


Interim patches (5) :

Patch 5683652 : applied on Fri Dec 28 22:38:58 CET 2007
Created on 5 Jul 2007, 01:27:01 hrs PST8PDT
Bugs fixed:
5683652

Patch 5128368 : applied on Fri Dec 28 22:38:04 CET 2007
Created on 23 Mar 2007, 00:53:55 hrs PST8PDT
Bugs fixed:
5128368

Patch 5574966 : applied on Fri Dec 28 22:36:53 CET 2007
Created on 4 Apr 2007, 05:58:26 hrs PST8PDT
Bugs fixed:
5574966

Patch 5556081 : applied on Fri Dec 28 22:23:43 CET 2007
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081

Patch 5557962 : applied on Fri Dec 28 22:23:31 CET 2007
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974


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

OPatch succeeded.
[ora102@orion:/apps/oracle/10.2.0] (DEMO102)$

Then, if you want to create a "seed" database to play as well, the simplest way is still DBCA, in XClient session :

Change the datafiles location as you want :

[...]

Don't forget to update your tnsnames.ora file (on the server as on the client), and starting the listener.
Because I experienced the error tns-12546 permission denied, I did the workaround :
[root@orion:/var/tmp] ()$ ls -alrt
total 24
drwxr-xr-x 23 root root 4096 Dec 16 22:14 ..
drwxrwxrwt 3 root root 4096 Dec 27 21:28 .
drwxrwxrwt 2 root oinstall 4096 Dec 27 21:29 .oracle
[root@orion:/var/tmp] ()$ chown ora102:dba .oracle
Then the listener has been started as well.

Have fun,

Extend swap space

You had change the amount of memory of the guest OS, or added some more RAM, the swap swap space should be updated.
I followed the below procedure.
Check the current swap space and mount points :
[root@orion:/root] ()$ swapon -s
Filename Type Size Used Priority
/dev/mapper/VolGroup00-LogVol01 partition 2031608 0 -1
[root@orion:/root] ()$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
141G 8.4G 126G 7% /
/dev/sda1 99M 13M 82M 14% /boot
none 1.3G 0 1.3G 0% /dev/shm
192.168.1.11:/nfs/peoplesoftcd
97G 60G 37G 62% /nfs/software/peoplesoft
192.168.1.11:/nfs/oraclecd
97G 60G 37G 62% /nfs/software/oracle

Create a new file to receive extra swap space (1Gb more) :
[root@orion:/root] ()$ dd if=/dev/zero of=/extraswap bs=1M count=1024
1024+0 records in
1024+0 records out

Make the file as swap :
[root@orion:/root] ()$ mkswap /extraswap
Setting up swapspace version 1, size = 1073737 kB

Turn on the file as swap :
[root@orion:/root] ()$ swapon /extraswap

Check the new swap space and mount points (new file has been added) :
[root@orion:/root] ()$ swapon -s
Filename Type Size Used Priority
/dev/mapper/VolGroup00-LogVol01 partition 2031608 0 -1
/extraswap file 1048568 0 -2
[root@orion:/root] ()$

To take in account the change on the next reboot, add the line /extraswap...
[root@orion:/root] ()$ more /etc/fstab
# This file is edited by fstab-sync - see 'man fstab-sync' for details
/dev/VolGroup00/LogVol00 / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
none /dev/pts devpts gid=5,mode=620 0 0
none /dev/shm tmpfs defaults 0 0
none /proc proc defaults 0 0
none /sys sysfs defaults 0 0
/dev/VolGroup00/LogVol01 swap swap defaults 0 0
/extraswap none swap sw 0 0
# Beginning of the block added by the VMware software
.host:/ /mnt/hgfs vmhgfs defaults,ttl=5 0 0
# End of the block added by the VMware software
192.168.1.11:/nfs/peoplesoftcd /nfs/software/peoplesoft nfs rw,vers=2 0 0
192.168.1.11:/nfs/oraclecd /nfs/software/oracle nfs rw,vers=2 0 0
/dev/hdc /media/cdrom auto pamconsole,fscontext=system_u:object_r:removable_t,exec,noauto,managed 0 0
/dev/fd0 /media/floppy auto pamconsole,fscontext=system_u:object_r:removable_t,exec,noauto,managed 0 0
[root@orion:/root] ()$

Enjoy,

On The Peoplesoft Road : Cygwin (XClient and NFS)

After installing VMWare, which allowed to build an other OS on-line, after installing OEL4.6, it's almost time to start the Oracle database installation.
Before to go in that direction, and since I've already downloaded all the required software on my Windows host OS, I need to share some folders with my new OS to avoid FTP transfer or other weird thing.
So, I would like my Windows host like a NFS server. And I would like a XWindow client for interactive installation of Oracle.

Cygwin is one of the solution, there are other, at least for XWndow client, as it explained very well by Ivan Kartik on his blog few days ago : Choosing X client for graphical installation

Cygwin offer the possibilities of the two (three) requirements : first a XClient, second a NFS server (and it's free).

Let's start.

Open your favorite browser, and enter the following url to run the installation : http://cygwin.com/setup.exe

Choose the installation from internet, you have to choose a server, take care, all the server are not up and running. The following link worked fine for me : http://cygwin.cybermirror.org

You'll see a list of package, expand the list to check some of them.
For XClient usage, you'll have to check the followings ones :
xorg-x11-base (2 KiB; required, automatically selects a base set of packages for the typical installation)
xorg-x11-bin (1.2 MiB; optional, executables for xterm, twm, etc.)
xorg-x11-bin-dlls (2 MiB; optional, libraries (DLLs) for executables.)
xorg-x11-bin-lndir (5 KiB; optional, lndir program, useful for developing)
xorg-x11-devel (964 KiB; optional, additional files needed to compile programs for Cygwin/X)
xorg-x11-etc (335 KiB; required, configuration files for the X Server and programs in xorg-x11-bin)
xorg-x11-f100 (12 MiB; optional, 100 dpi fonts (75 dpi fonts are used by default))
xorg-x11-fcyr (368 KiB; optional, Cyrillic fonts)
xorg-x11-fenc (489 KiB; required, font encodings)
xorg-x11-fnts (16.4 MiB; required, 75 dpi fonts)
xorg-x11-fscl (2.2 MiB; optional, Speedo and Type1 scalable fonts)
xorg-x11-fsrv (201 KiB; optional, X Font Server)
xorg-x11-libs-data (154 KiB; required, X11R6/lib/ files)
xorg-x11-man-pages (551 KiB; optional, man pages)
xorg-x11-man-pages-html (596 KiB; optional, man pages in html format)
xorg-x11-nest (1.1 MiB; optional, Xnest nested X Server)
X-start-menu-icons (4 KiB; optional, adds icons for X Clients to the Start menu)
X-startup-scripts (22 KiB; required, example X Server and client startup scripts)
xorg-x11-vfb (1.2 MiB; optional, X Virtual Frame Buffer (Xvfb) server)
xorg-x11-xwin (1.3 MiB; required, the Cygwin/X X Server)
xorg-x11-xwin-gl (761 KiB; optional, the Cygwin/X X Server with ***EXPERIMENTAL*** GLX acceleration)

For NFS usage, add check the following ones : vim, nfs-server, sunrpc, cygrunsrv

You may also want to ensure that the inetutils and openssh packages are selected if you wish to use telnet and ssh to connect to remote machines.

Continue the installation until the end, "click next"...

A new icon has been added on your desktop, open it.

For a XClient, run the command in the new opened DOS window :

A new terminal window is opened, you can connect to your server by the command :
ssh -Y ServerIPAddress
Then you can test by XClock command :



You can connect now as the expected user for your software installation.

For NFS server, there are additional steps.

1. On your host OS (my Windows XP OS) :
1a. Enable the ports and services on the firewall
NFS/2049/TCP
nfsd/2049/UDP
sunrpc/111/UDP
sunrpc TCP/111/TCP
C:\cygwin\usr\sbin\rpc.mountd.exe

Examples (well, the screenshots are in French, but I don't think it's a problem here) :


1b. Run the Cu\ygwin program, it open a DOS window command prompt, run the NFS installation :
/usr/bin/nfs-server-config
Default answer should be ok in most of cases.
Allowed the remote server to access on your NFS server by inserting (use vi editor) a line in /etc/hosts.allow file :
nfsd: 192.168.1.21
The /etc/hosts.deny file can be empty.

1c. I want to share two directories F:\PeopleSoftCD and F:\OracleCD, then run the following commands (always in the Cygwin DOS window) :
mkdir -p /nfs/peoplesoftcd
mount F:/PeopleSoftCD /nfs/peoplesoftcd
mkdir -p /nfs/oraclecd
mount F:/OracleCD /nfs/oraclecd

1d. Insert the two new mount points in the /etc/exports file (NB : IP address of your remote server, rw for read/write access, no_root_squash to allowed the root connection) :
/nfs/peoplesoftcd 192.168.1.21(rw, no_root_squash)
/nfs/oraclecd 192.168.1.21(rw, no_root_squash)

1e. Lastly, on the Windows host, there are three services associated with NFS, you have to start and stop them to take in account all the previous modifications :
Cygwin mountd
Cygwin nfsd
Cygwin portmap

2. On your remote server, currently my OEL4.6 OS server,
2a. By a telnet/ssh connection (the IP address the one from the host Windows which share the directories) :
mkdir -p /nfs/software/peoplesoft
mount -t nfs 192.168.1.11:/nfs/peoplesoftcd /nfs/software/peoplesoft
mkdir -p /nfs/software/oracle
mount -t nfs 192.168.1.11:/nfs/oraclecd /nfs/software/oracle
Now it should work.
2b. To make the NFS mount points as permanent, even after a server reboot, you have to update the /etc/fstab file, by adding the two following lines :
192.168.1.11:/nfs/peoplesoftcd /nfs/software/peoplesoft nfs rw,vers=2 0 0
192.168.1.11:/nfs/oraclecd /nfs/software/oracle nfs rw,vers=2 0 0

Now, I'm happy, from my guest/remote OS, I'm able to read my host/local directories' software installation.

Enjoy,

On The Peoplesoft Road : OEL 4.6

To be able to install Peoplesoft, I need an OS certified for Peoplesoft. OEL 5 is not yet certified, so I'll try OEL4.6.

After installing previously VMWare, created a Guest virtual machine, now it's the moment for OS.
OEL 4 update 6 has been downloaded the four CD from http://edelivery.oracle.com
Extract each doanloaded file, then burn them as ISO image on CD.

On the VMWare server, choose the virtual machine which will receive the new OS installation. Insert the first CD and start the virtual machine.
Then, go onto the Console tab :
Nice one, now, follow the instruction as well :





For the network configuration, take care, better to use fixed IP address (click on Edit button) :
You can already allowed the SSH connection :

Choose your root password (at least 6 characters)
To be able to install the VMWare tools easily, you have to add some additional packages :

Add editors if you want :Add Administration Tools and System Tools :

Insert the following CD when it ask you.
Lastly,

The definition screen, important step regarding the VMWare, because I don't need the FullScreen mode, I choose the one which allow me to see all the screen inside the VMWare window.
You have to choose the "default" user and password, the you have the login screen and the OEL desk :
On the VMWare window corresponding to the current virtual machine, then Add VMWare tool. A virtual CD is added on the OEL desk, open it, and install the VMWare tool on the new OS.
The VMWare tool allowed you to shut the OS down properly.
Lastly, open a XTerm windows and connect as root :
[ngasparotto@orion ~]$ su - root
Password:
[root@orion ~]# vmware-config-tools.pl

Stopping VMware Tools services in the virtual machine:
Guest operating system daemon: [ OK ]
Trying to find a suitable vmmemctl module for your running kernel.

The module bld-2.6.9-5.EL-i686smp-RHEL4 loads perfectly in the running kernel.

Trying to find a suitable vmhgfs module for your running kernel.

The module bld-2.6.9-5.EL-i686smp-RHEL4 loads perfectly in the running kernel.

pcnet32 31049 0
Unloading pcnet32 module

Trying to find a suitable vmxnet module for your running kernel.

The module bld-2.6.9-5.EL-i686smp-RHEL4 loads perfectly in the running kernel.

Trying to find a suitable vmblock module for your running kernel.

The module bld-2.6.9-5.EL-i686smp-RHEL4 loads perfectly in the running kernel.

Trying to find a suitable vmsync module for your running kernel.

The module bld-2.6.9-5.EL-i686smp-RHEL4 loads perfectly in the running kernel.

[EXPERIMENTAL] The Virtual Machine Communication Interface (VMCI) service
provides a new communications capability, primarily for development at the
moment. Would you like to enable this feature? [no]



Detected X.org version 6.8.


Please choose one of the following display sizes that X will start with (1 -
15):

[1] "640x480"
[2] "800x600"
[3] "1024x768"
[4] "1152x864"
[5] "1280x800"
[6] "1152x900"
[7] "1280x1024"
[8] "1376x1032"
[9] "1400x900"
[10] "1400x1050"
[11] "1440x900"
[12] "1680x1050"
[13] "1600x1200"
[14] "1920x1200"
[15] "2364x1773"
Please enter a number between 1 and 15:

[3]


X Window System Version 6.8.2
Release Date: 9 February 2005
X Protocol Version 11, Revision 0, Release 6.8.2
Build Operating System: Linux 2.6.18-1.2798.fc6 i686 [ELF]
Current Operating System: Linux orion.phoenix-nga 2.6.9-67.0.0.0.1.ELsmp #1 SMP Sun Nov 18 00:23:42 EST 2007 i686
Build Date: 19 November 2007
Build Host:

Before reporting problems, check http://wiki.X.Org
to make sure that you have the latest version.
Module Loader present
OS Kernel: Linux version 2.6.9-67.0.0.0.1.ELsmp (mockbuild@ca-build15.us.oracle.com) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-3)) #1 SMP Sun Nov 18 00:23:42 EST 2007
Markers: (--) probed, (**) from config file, (==) default setting,
(++) from command line, (!!) notice, (II) informational,
(WW) warning, (EE) error, (NI) not implemented, (??) unknown.
(++) Log file: "/tmp/vmware-config0/XF86ConfigLog.6116", Time: Sun Dec 16 22:41:01 2007
(++) Using config file: "/tmp/vmware-config0/XF86Config.6116"

X is running fine with the new config file.

Starting VMware Tools services in the virtual machine:
Switching to guest configuration: [ OK ]
Guest filesystem driver: [ OK ]
Mounting HGFS shares: [FAILED]
Guest memory manager: [ OK ]
Guest vmxnet fast network device: [ OK ]
Blocking file system: [ OK ]
File system sync driver: [ OK ]
DMA setup: [ OK ]
Guest operating system daemon: [ OK ]

The configuration of VMware Tools e.x.p build-63231 for Linux for this running
kernel completed successfully.

You must restart your X session before any mouse or graphics changes take
effect.

You can now run VMware Tools by invoking the following command:
"/usr/bin/vmware-toolbox" during an X server session.

To use the vmxnet driver, restart networking using the following commands:
/etc/init.d/network stop
rmmod pcnet32
rmmod vmxnet
depmod -a
modprobe vmxnet
/etc/init.d/network start

Enjoy,

--the VMware team

[root@orion ~]# /etc/init.d/network stop
Shutting down loopback interface: [ OK ]
[root@orion ~]# rmmod pcnet32
ERROR: Module pcnet32 does not exist in /proc/modules
[root@orion ~]# rmmod vmxnet
[root@orion ~]# depmod -a
[root@orion ~]# modprobe vmxnet
[root@orion ~]# /etc/init.d/network start
Setting network parameters: [ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface eth0: [ OK ]
[root@orion ~]# vmware-toolbox &
[1] 6973
[root@orion ~]#
[1]+ Done vmware-toolbox
[root@orion ~]#
[root@orion ~]#
[root@orion ~]#

It's finish, at least for the OEL installation.

Have fun.

On the Peoplesoft Road : VMWare

I already explained my new lab configuration, my Windows XP Pro SP2 will be my client machine.
In order for a Peoplesoft installation, I need a supported OS for Peoplesoft, so, I'll go for Oracle Entreprise Linux 4 update 6 (since Peoplesoft is not yet certified on OEL5). This will be my server.
So, instead of having two PC, a virtual machine seems the best way.
I'll install VMWare server, and since there is a version 2.0, I'll try that one, even if it's in beta version. The GUI is a web application. Installation is very easy, download, run the installer, and click next...
A new icon is added on the Quick Launch bar, click on it, you'll see the following ones :

At this step, you have to enter the username/password used for install the VMWare software. Note for the Vista user, the user must be flag as Administrator.
Then, add a virtual machine, which will be a Guest OS, and will host OEL4.6 :


One of the key point is the network configuration, by choosing Bridge, the Guest OS will be independant of your Host OS. It will be able to see all the network, and to be seeing from all the network.
A quick re-call, Guest and Host are used only regarding the VMWare software, the Host OS is the OS whicj the VMWare has been installed on, the Guests are installed through the VMWare virtual machine.
The screenshots above are just for example, but you can choose to create a special folder (or drive) to host the Guest filesystems.
As I did for my OEL virtual machine installation.
Lastly, you have a page which resume all your VM :
Now, you'll be able to go into the new VM (Virtual Machine) :
To install your Guest OS, insert the install CD, a run the VM (green triangle), you can see what happens in the Console tab :
Well, this is a beta version, but seems working fine.
However, there are some odds things :
1. The main thing is the amount of the required memory, not less than 250Mb just for the Tomcat server which manage the virtual server. If you add around 100Mb for 5 others VMWare processes, you'll need 350Mb RAM just to run VMWare. It's a bad new, moreover, you have to take in account the Host OS RAM requirement, the Guest OS RAM requirement, plus the further database, plus the further Peoplesoft application (Application server, Process SCheduler and Web server), you need a lot of RAM. And my 4Gb won't be too low.
2. Some problem on the Guest's screen definition which not allowed you to get your Guest OS in FullScreen mode, not funny if you want to work as a desktop...

Anyway, it's still easy to use.

Next step, OEL4.6 install,

Have fun.

New lab

My new lab :
Dell Inspiron 1720
Windows XP Pro SP2
4Gb RAM
500Gb hard disk (2x250Gb)
Intel Core 2 Duo T7500

Of course, such config is not just for fun, but to test... Oracle databases and Peoplesoft application.

1. Windows XP Pro SP2 : my client machine (however, Oracle 9i, 10g and 11g database server installed)
2. VMWare 2.0 (beta version - very easy to install and use) :
2.1 OpenSuse 10.3, my local DNS server
2.2 OEL (4.x or 5.1, to be defined), coming soon, but my database server, and Peopelsoft application/tools/web server.

Coming soon example of Peoplesoft installation, maybe under the Peoplesoft forum.

Now, I have to find time to work hardly and install all what required on my new lab.

Enjoy,

Comeback on blogosphere

Well, around one year after my last post here, I'm coming back, and try to update to date more often this blog.
What's new since last year ?
A lot of things :
. Oracle 11g is out (on most of plateforms).
. Most of the Peoplesoft applications are now in version 9.0
. A new look on the OTN forum side
. New forums entries : PeopleSoft General Discussion, Ospace Community Feedback and Suggestions and Peoplesoft on Grid (and a lot of others...)
. Oracle Wiki : http://wiki.oracle.com
...

I'll try to participate on the new Peoplesoft forums sides.

Have fun,