Peoplesoft - Up and running on a laptop: Step 3

Download:

http://edelivery.oracle.com/linux

1. Oracle Linux (for Product Pack choose Oracle Database, for Platform, choose Linux x86 64 and select Go) select Oracle® Database 11g Release 2 (11.2.0.1.0) Media Pack for Linux x86-64 and download

Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64 (Part 1 of 2)

File: V17530-01_1of2.zip

Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64 (Part 2 of 2)

File: V17530-01_2of2.zip

Install Oracle 11gR2

Create oracle User Account

Login as root and create te user oracle which belongs to oinstall,dba,asmdba and asmadmin groups.

[root@peoplesoftlab ~]# groupadd dba

[root@peoplesoftlab ~]# groupadd oinstall

[root@peoplesoftlab ~]# useradd -g oinstall -G dba oracle

[root@peoplesoftlab ~]# passwd oracle

Changing password for user oracle.

New UNIX password: 

Retype new UNIX password: 

passwd: all authentication tokens updated successfully.

[root@peoplesoftlab ~]# mkdir /software 

[root@peoplesoftlab ~]# chown -R oracle:dba /software

[root@peoplesoftlab ~]# mkdir /opt/oracle

[root@peoplesoftlab ~]# chown -R oracle:dba /opt/oracle

[root@peoplesoftlab ~]# mkdir /opt/oraInventory

[root@peoplesoftlab ~]# chown -R oracle:dba /opt/oraInventory[root@peoplesoftlab ~]# exit

Unzip Oracle software

[oracle@peoplesoftlab ~]$ cd /software/
[oracle@peoplesoftlab software]$ cd oracle_11gR2/
[oracle@peoplesoftlab oracle_11gR2]$ unzip V17530-01_1of2.zip
Archive: V17530-01_1of2.zip
   creating: database/
   creating: database/doc/
   creating: database/doc/dcommon/

...

inflating: database/install/lsnodes
extracting: database/install/addLangs.sh
inflating: database/runInstaller
inflating: database/welcome.html
[oracle@peoplesoftlab oracle_11gR2]$ unzip V17530-01_2of2.zip
Archive: V17530-01_2of2.zip
   creating: database/stage/Components/oracle.ctx/
   creating: database/stage/Components/oracle.ctx/11.2.0.1.0/
   creating: database/stage/Components/oracle.ctx/11.2.0.1.0/1/
   creating: database/stage/Components/oracle.ctx/11.2.0.1.0/1/DataFiles/

...

oracle.sysman.console.db/11.2.0.1.0/1/DataFiles/filegroup8.jar
inflating: database/stage/Components/oracle.sysman.console.db/11.2.0.1.0/1/DataFiles/filegroup9.jar
[oracle@peoplesoftlab oracle_11gR2]$

/etc/sysctl.conf

kernel.shmmax = 536870912
kernel.shmmni = 4096
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

kernel.msgmni=512
kernel.msgmax=1048576
kernel.msgmnb=1048576

kernel.shmall=1073741824
kernel.sem=250 256000 100 1024

then execute "sysctl -p"

/etc/pam.d/login

session required pam_limits.so

/etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

log on as oracle

add to oracle profile

/home/oracle/.bash_profile

ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/112
ORACLE_SID=FDMO
LD_LIBRARY_PATH=$ORACLE_HOME/lib
ORACLE_UNQNAME=FDMO
PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH ORACLE_UNQNAME PATH

save and load oracle environment

cd /home/oracle

. .bash_profile

cd /media/Enterprise\ Linux\ dvd\ 20100405/Server
rpm -ivh elfutils-libelf-devel-static-0.137-3.el5.x86_64.rpm elfutils-libelf-devel-0.137-3.el5.x86_64.rpm
rpm -ivh libgomp-4.4.0-6.el5.x86_64.rpm
rpm -ivh kernel-headers-2.6.18-194.el5.x86_64.rpm
rpm -ivh glibc-headers-2.5-49.x86_64.rpm
rpm -ivh libstdc++-devel-4.1.2-48.el5.x86_64.rpm
rpm -ivh libaio-devel-0.3.106-5.x86_64.rpm
rpm -ivh gcc-4.1.2-48.el5.x86_64.rpm glibc-devel-2.5-49.i386.rpm
rpm -ivh gcc-c++-4.1.2-48.el5.x86_64.rpm
rpm -ivh libtermcap-devel-2.0.8-46.1.x86_64.rpm
rpm -ivh readline-devel-5.1-3.el5.x86_64.rpm
rpm -ivh unixODBC-2.2.11-7.1.x86_64.rpm
rpm -ivh unixODBC-devel-2.2.11-7.1.x86_64.rpm
rpm -ivh libaio-devel-0.3.106-5.i386.rpm
rpm -ivh unixODBC-2.2.11-7.1.i386.rpm
rpm -ivh unixODBC-devel-2.2.11-7.1.i386.rpm
rpm -ivh sysstat-7.0.2-3.el5.x86_64.rpm
rpm -ivh glibc-devel-2.5-49.x86_64.rpm

rpm -Uvh perl-Convert-ASN1-0.20-1.1.noarch.rpm
rpm -Uvh samba-3.0.33-3.28.el5.x86_64.rpm
rpm -Uvh system-config-samba-1.2.41-5.0.1.el5.noarch.rpm

rpm -ivh vsftpd-2.0.5-16.el5_4.1.x86_64.rpm

then run

[root@peoplesoftlab ~]# cd /software/
[root@peoplesoftlab software]# cd scripts/
[root@peoplesoftlab scripts]# ./oracle_prereq.sh
warning: elfutils-libelf-devel-static-0.137-3.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:elfutils-libelf-devel ########################################### [ 50%]
   2:elfutils-libelf-devel-s########################################### [100%]
warning: libgomp-4.4.0-6.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:libgomp ########################################### [100%]
warning: kernel-headers-2.6.18-194.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:kernel-headers ########################################### [100%]
warning: glibc-headers-2.5-49.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:glibc-headers ########################################### [100%]
warning: libstdc++-devel-4.1.2-48.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:libstdc++-devel ########################################### [100%]
warning: libaio-devel-0.3.106-5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:libaio-devel ########################################### [100%]
warning: gcc-4.1.2-48.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:glibc-devel ########################################### [ 50%]
   2:gcc ########################################### [100%]
warning: gcc-c++-4.1.2-48.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:gcc-c++ ########################################### [100%]
warning: libtermcap-devel-2.0.8-46.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:libtermcap-devel ########################################### [100%]
warning: readline-devel-5.1-3.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:readline-devel ########################################### [100%]
warning: unixODBC-2.2.11-7.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:unixODBC ########################################### [100%]
warning: unixODBC-devel-2.2.11-7.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:unixODBC-devel ########################################### [100%]
warning: libaio-devel-0.3.106-5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:libaio-devel ########################################### [100%]
warning: unixODBC-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:unixODBC ########################################### [100%]
warning: unixODBC-devel-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:unixODBC-devel ########################################### [100%]
warning: sysstat-7.0.2-3.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:sysstat ########################################### [100%]
warning: glibc-devel-2.5-49.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:glibc-devel ########################################### [100%]
warning: perl-Convert-ASN1-0.20-1.1.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:perl-Convert-ASN1 ########################################### [100%]
warning: samba-3.0.33-3.28.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:samba ########################################### [100%]
warning: system-config-samba-1.2.41-5.0.1.el5.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
   1:system-config-samba ########################################### [100%]
[root@peoplesoftlab scripts]#

Run Oracle install program

[oracle@peoplesoftlab ~]$ cd /software/
[oracle@peoplesoftlab software]$ cd oracle_11gR2/
[oracle@peoplesoftlab oracle_11gR2]$ cd database/
[oracle@peoplesoftlab database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 217506 MB Passed
Checking swap space: must be greater than 150 MB. Actual 5951 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-12-28_02-25-14PM. Please wait ...[oracle@peoplesoftlab database]$ You can find the log of this install session at:
/opt/oraInventory/logs/installActions2010-12-28_02-25-14PM.log

[oracle@peoplesoftlab ~]$ su root
Password:
[root@peoplesoftlab oracle]# cd /opt/oraInventory
[root@peoplesoftlab oraInventory]# ./orainstRoot.sh
Changing permissions of /opt/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /opt/oraInventory to oinstall.
The execution of the script is complete.
[root@peoplesoftlab oraInventory]# cd /opt/oracle/112/
[root@peoplesoftlab 112]# ./root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:
   ORACLE_OWNER= oracle
   ORACLE_HOME= /opt/oracle/112

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@peoplesoftlab 112]#

Configure Oracle for Auto Startup and Shutdown

Post-Installation Tasks

1. (Optional) Auto Startup and Shutdown of Database and ListenerLogin as root and modify /etc/oratab file and change last character to Y for apropriate database.

fdmo:/opt/oracle/112:Y

As root user create new file "oracle" (init script for startup and shutdown the database) in /etc/init.d/ directory with following content:

#!/bin/bash
#
# oracle Init file for starting and stopping
# Oracle Database. Script is valid for 10g and 11g versions.
#
# chkconfig: 35 80 30
# description: Oracle Database startup script

# Source function library.

. /etc/rc.d/init.d/functions

ORACLE_OWNER="oracle"
ORACLE_HOME="/opt/oracle/112"

case "$1" in
start)
echo -n $"Starting Oracle DB:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"

# start app server
su - $ORACLE_OWNER -c "/apps/psoft/appserv/psadmin -c boot -d FDMO"

# increase MAX_FILE_DESCRIPTORS
ulimit -n 4096

# start weblogic web server
# will run as root so we can use port 80
/apps/psoft/webserv/peoplesoft/bin/startPIA.sh

# start process scheduler
su - $ORACLE_OWNER -c "/apps/psoft/appserv/psadmin -p start -d FDMO"

echo "OK"
;;
stop)
echo -n $"Stopping Oracle DB:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME"

# stop process scheduler

su - $ORACLE_OWNER -c "/apps/psoft/appserv/psadmin -p stop -d FDMO"

# stop app server
su - $ORACLE_OWNER -c "/apps/psoft/appserv/psadmin -c shutdown -d FDMO"

# stop weblogic server
/apps/psoft/webserv/peoplesoft/bin/stopPIA.sh

echo "OK"
;;
*)
echo $"Usage: $0 {start|stop}"
esac

Execute (as root) following commands (First script change the permissions, second script is configuring execution for specific runlevels):

chmod 750 /etc/init.d/oracle
chkconfig --add oracle --level 0356

log out and reboot

Confirm Oracle is Up and Running

https://localhost:1158/em

save and load new environment

cd /home/oracle

. .bash_profile

tnsnames.ora

# tnsnames.ora Network Configuration File: /opt/oracle/112/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

FDMO =
  (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.142.135)(PORT = 1521))
   (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = fdmo)
   )
  )

listener.ora

# listener.ora Network Configuration File: /opt/oracle/112/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
   (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.142.135)(PORT = 1521))
   )
  )

SID_LIST_LISTENER =

   (SID_LIST =

   (SID_DESC =
   (ORACLE_HOME = /opt/oracle/112)
   (SID_NAME = fdmo)
   )
   )

/home/oracle/.bash_profile

# add to .bash_profile for peoplesoft apps

ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/112
ORACLE_SID=FDMO
LD_LIBRARY_PATH=$ORACLE_HOME/lib
ORACLE_UNQNAME=FDMO
PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH ORACLE_UNQNAME PATH

JAVA_HOME=/home/oracle/jmrc-4.0.0-1.6.0

PATH=$JAVA_HOME/bin:$PATH

export JAVA_HOME PATH

export TUXDIR=/home/oracle/Oracle/Middleware/tuxedo10gR3

export PATH=$PATH:$TUXDIR/bin

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$TUXDIR/lib

export PS_HOME=/apps/psoft

export PS_CFG_HOME=$PS_HOME

. $TUXDIR/tux.env

. $PS_HOME/psconfig.sh

cd $PS_HOME

Step 3 - Oracle