Oracle – PeopleSoft Installation on RHEL4
A. Install Windows 2003 Server on Client machine.
B. Install VM ware Server.
C. Allocate 100GB for RHEL4 for installing PeopleSoft
D. Install RHEL4 on the Server
I.
Group Creation
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
Oracle User Creation
# /usr/sbin/useradd -g oinstall -G dba oracle
Set Password for Oracle User
# passwd oracle
a. Set Kernel Parameters
Step1: Login as a root user and perform the below steps.
Add the following lines to the /etc/sysctl.conf file:
kernel.msgmni = 100
b. Run the following command to change the current kernel parameters:
/sbin/sysctl -p
Copy the following details in “/etc/security/limits.conf” file
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
Create the relevant Directories
# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle
Create the new groups and users:
groupadd oper
groupadd psoft
useradd -g oinstall -G dba psoft
or
useradd –g dba psoft
passwd psoft
Configure the .bash_ profile of the oracle user
#su – oracle
$vi .bash_profile
Note: Add the below lines at the end of the .bash_profile
----------------------------------------------------------------
PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH; export PATH
PATH=$PATH:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin;
PATH=$PATH:$ORACLE_HOME/Apache/Apache/bin; export PATH
ORACLE_SID=HRPRD; export ORACLE_SID; export PATH
EDITOR=vi; export EDITOR;
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
unset USERNAME
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
Execute the bash_profile by typing the following command
$. .bash_profile
PEOPLESOFT INSTALLATION ON RHEL4
1. Log in as root.
# su – root
3. Create a directory /u02/psoft
mkdir -p /u02/psoft
#
4. Create the linux user who will be the owner of peoplesoft Application, WebLogic, Tuxedo
# chown -R psoft:psoft /u02/psoft
5. Create directory to hold the BEA Tuxedo software
# mkdir /u02/bea
6. Change the ownership of the above created directories to psoft user
# chown -R psoft.psoft /u02
7. Log in as psoft.
# su - psoft
$ vi .bash_profile (mentioned below)
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH; export PATH
PATH=$PATH:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/opmn/bin;
PATH=$PATH:$ORACLE_HOME/Apache/Apache/bin; export PATH
PATH=/usr/java/j2sdk1.4.2_08/bin:$ORACLE_HOME/bin:$PATH; export PATH
ORACLE_OWNER=oracle; export ORACLE_OWNER
PS_HOME=/u02/psoft/HRPRD; export PS_HOME
ORACLE_SID=HRPRD; export ORACLE_SID; export PATH
LD_LIBRARY_PATH=$PS_HOME/bin:$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u02/psoft/HRPRD/bin/sqr/ORA/lib:$ORACLE_BASE/product/10.2.0/db_1/lib
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib; export CLASSPATH
LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
export NLSPATH=/u02/bea/tuxedo81/locale/C
export PATH LD_LIBRARY_PATH PS_HOME
export PATH
TUXDIR=/u02/bea/tuxedo81; export TUXDIR
unset USERNAME
Execute the bash_profile file.
$. .bash_profile
TUXEDO INSTALLATION :
1. Log in as psoft.
# su – psoft
3. Execute the shell script, install.sh to install tuxedo
# su – psoft
$cd /media/cdrecorder
$cd TUXEDO8.1
$ls -ltr
$ ./install.sh
The above one is working fine.
Or
$sh /media/cdorm/install
4. The tuxedo install program will prompt to choose the platform to install for.
Choose
linux/aes21 (option one by default not selected) -- enter
5. When asked to choose the where files are to be installed,
choose:-- /u02/bea
6. Provide the password for tlisten when asked for -- enter
7. Follow the subsequent onscreen instructions and complete the installation
PEOPLETOOLS 8.48 INSTALLATION
1. Log in as psoft.
2. Make a folder to Install PeopleSoft Software
mkdir -p /u02/psoft/HRPRD
switch to root user
#chmod 777 /u02/psoft/HRPRD
3. Start the PeopleTools installation
$ cd /media/cdrom/Disk1
$./setup.linux -is:javahome /usr/java/j2sdk1.4.2_08/bin –console
4. Follow the onscreen instructions.
Enter your license code for PeopleTools.
zm7ky3-w41m04-4u863q6-7oke1m-s7t1f2
Choose Non-Unicode database for non multilingual installation
Select all the servers to be installed
(Database Server, Application Server,Web Server,
Batch server).
Specify th PS_HOME directory when asked for:-- /u02/psoft/HRPROD
When it prompts for the tuxedo directory, enter:-- /u02/bea/tuxedo81
PEOPLETOOLS PATCH 8.48.08 INSTALLATION
1. Log in as psoft
2. Start the PeopleTools installation
$./setup.linux -is:javahome /usr/java/j2sdk1.4.2_08/bin -console
3 Follow the onscreen instructions.
Enter your license code for PeopleTools.
zm7ky3-w41m04-4u863q6-7oke1m-s7t1f2
Choose Non-Unicode database for non multilingual installation
Select all the servers to be installed
(Database Server,Application Server,Web Server,
Batch server).
Specify the PS_HOME directory when asked for.:-- /u02/psoft/HRPROD
When it prompts for the tuxedo directory, enter:-- /u02/bea/tuxedo81
PEOPLESOFT APPLICATION INSTALLATION --HRMS
1. Log in as psoft.
su – psoft
2. Start the PeopleTools installation
# cd /mnt/cdrom/hcm89/HCM89
$ ./setup.linux -is:javahome /usr/java/j2sdk1.4.2_08/bin -console
This will launch the installer wizard. Click Next when you see the welcome screen.
3. Follow the onscreen instructions
1. Enter your license code for PeopleSoft HRMS 8.9 Application.
117fef-ffff8f-ffffebf-119783-2qimmg
2. Choose Non-Unicode database for non multilingual installation
3. Select all the servers to be installed (Only Web Server will be listed).
4. Specify the PS_HOME directory when asked for:-- “/u02/psoft/PROD”
5. When it prompts for the tuxedo directory, enter:- “/u02/bea/tuxedo81”
In Windows 2003 Server Install Oracle 10g Client Software.
Install LAN Drivers.
Or
Start -? settings --? Controlpanel -? Add Hardware ?Next ?
Select radio button ( Yes, I have added the hardware yet)
Select Add a New Hardware device.
Select install the hardware that I manually selected from the list.
Select Network Adapters
Here select Microsoft Loop back adapter.
You will find LAN drivers connection.
Here the windows ip address is 192.168.1.2
And Subnet mask is 255.255.255.0
Open VMware Server Console
Select settings on VM Menu
Install Putty
Using Putty we can open RHEL kernel in Windows 2003 Server.
How to install and configure putty.
Double click on Putty.
Enter ipaddress of the RHEL 4 Server.
i.e 192.168.1.1
Note: Here Windows 2003 server ip address is 192.168.1.2
How to set ipaddress if the RHEL4 Server
Select Applications Menu --? System Settings ---?Network
Click on Edit.
Staticall set ipaddress
Manual ipaddress settings
Address: 192.168.1.1
SubnetMask: 255.255.255.0
Press OK then click on Activiate.
Then Network will establish between Windows 2003 (client) and
VMWare Server (LINUX Server)
Copy tnsnames.ora file from LINUX Server located at
/u01/app/oracle/product/10.2.0/db_1/network/admin/
From the above directory into
C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
Into windows 2003 client.
Now configure the listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = HRPRD)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP(HOST = 192.168.1.1)
(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
Note: Here you have to enter Server information
Just copy listener.ora file into
/u01/app/oracle/product/10.2.0/db_1/network/admin/
Tnsnames.ora
HRPRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST=192.168.1.1)
(PORT= 1521))
)
(CONNECT_DATA =(SERVICE_NAME = HRPRD)
)
)
Note: You need not copy listener.ora.
Tnsnames.ora file enough.
To check the connectivity of oracle client to oracle server
C:\tnsping PROD
C:\sqlplus /nolog
Sql>conn SYSTEM/SYSTEM@HRPRD
Sql>select name from v$database;
Sql>exit;
Modify and run the Scripts like
The Scripts are located at
/u02/psoft/HRPRD/scripts
a) Utlspace.sql
b) Dbowner.sql
c) Hcddl.sql
d) Psroles.sql
e) Psadmin.sql
f) Connect.sql
And run the scripts in LINUX Server.
Configure the Configuration Manager
The rest of the Steps u have to follow Installation guide from Page no: 212
To 244.
How to create the Application server:--
Before starting the application server create a link for libclntsh.so.10.1
# su – oracle
$ cd $ORACLE_HOME/lib
$ ln –s libclntsh.so.10.1 libclntsh.so.9.0
$ ls –ltr libcl*.*
1.login as root
# su – psoft
$ pwd
$ ls –ltr
$ ./psadmin
now select the options
1
2
1
y
17 --userid
PS
18 --passwd
PS
20 –add to path of $ORACLE_HOME/bin
/u01/app/oracle/product/10.2.0.1.0/bin
13 –load config as show
How to install webserver
# mkdir –p /u03/weblogic
# chown –R psoft:psoft /u03
# chmod –R 777 /u03
# su – psoft
$ cd /media/cdrom
$ ls –ltr
$ cd WEBLOGIC8.1SP5
$ ./install.sh –console
it will ask for the path-- “/u03/weblogic
Installing PIA
./setup.linux –is:javahome /u03/weblogic/jdk14_08 -console
PIA path
How to stop the webserver and PIA
To start Network service #service network restart
TROUBLESHOOTING ON DISPLAY
#echo $DISPLAY
:0.0
How to set DISPLAY
#DISPLAY=:0.0
SCREENSHOT:
Application Server configurations
Before starting the application server create a link for libclntsh.so.10.1
#su – oracle
$cd $ORACLE_HOME/lib
$ls –l libclntsh*.*
$cd libclntsh.so.10.1
$ls –l libclntsh.so.*.*
$ln –s libclntsh.so.10.1 libclntsh.so.9.0
$ls –ltr libcl *.*
#chown -R oracle:oinstall /u01
#chown -R psoft:psoft /u02
1. Login as root
2. #su - psoft
3. Pwd
4. Ls -ltr
5. $ ./psadmin
How to start application server
./psadmin
I gave permissions to
#chmod 777 /u02/psoft/HRPRD/appserv
#su – psoft
Then run
$./psadmin
Psdb.sh located at
Located at /u02/psoft/HRPRD/setup/psdb.sh
Here make sure that
TUXDIR is properly configured or not
Eg:
TUXDIR=/u02/bea/tuxedo81; export TUXDIR
Psconfig.sh located at
/u02/psoft/HRPRD/psconfig.sh
In this file PS_HOME must be
/u02/psoft/HRPRD
Eg:
PS_HOME=/u02/psoft/HRPRD; export PS_HOME
To know the status of WebSever and PIA
Use the following command
#su – psoft
[psoft@hari HRPRD]$tail –f logs/PIA _stdout.log
