Wednesday, July 31, 2013

Oracle PeopleSoft Enterprise Complete Installation Document for Linux (OEL5.x 64bit server)
Oracle – PeopleSoft Installation on RHELx or OEL 5.x
Pre-Requirements:
A.           Install Windows 2003/2008 Server/Windows 7x on Client machine.
B.           Install VM ware Server.
C.           Allocate 100GB for RHEL4 for installing PeopleSoft
D.            Install RHEL5 or OEL5 on the Server

  1. Install VM ware and allocate 100GB free space. Make sure physical memory 100GB is freespace.
  2. Install OEM5.3.iso image copy and follow the Linux installation steps. Select all Oracle related RPM’s
  3. Once complete OEM5.3 Installation is over install VMware tools to create a complete virtual server.
  4. Create a Group using root user
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba

                Oracle User Creation

                                     # /usr/sbin/useradd -g oinstall -G dba oracle

useradd -g oinstall -G dba,asmdba,oper emopr
useradd -g oinstall -G dba emopr
Set Password for Oracle User

# passwd oracle



  1. Set Kernel Parameters(If you installing OEL5.3 or any Oracle Linux you can ignore this step)
          Step1: Login as a root user and perform the below steps.
             Add the following lines to the /etc/sysctl.conf file:
                        kernel.msgmni = 100
  1. Run the following command to change the current kernel parameters(If you installing OEL5.3 or any Oracle Linux you can ignore this step):
                   /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

   Change psoft passowrd:

             passwd psoft

  1. 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 


  1. Install Oracle 11gR2 64 bit Binaries to /u01/Oracle location.
  2. Install Oracle 11gR2 32 bit Client to /u01/Oracle/Client.






PEOPLESOFT INSTALLATION ON OEL5x or OEL6x
1. Log in as root.
             # su – root
2. Create a directory “/u02/psoft”
#mkdir -p /u02/psoft
               
4. Create the Linux user who will be the owner of PeopleSoft Application, Web Logic, & 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/xxxx/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:$PS_HOME/bin/sqr/ORA/lib:$ORACLE_BASE/product/xxx/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 TUXEDOXx or
$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   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/j2sdkX.X.X_0X/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 the PS_HOME directory when asked for:    /u02/psoft/HRPROD
            When it prompts for the tuxedo directory, enter:  /u02/bea/tuxedoX



PEOPLETOOLS PATCH INSTALLATION
1.      Log in as psoft
               2.   Start the PeopleTools installation
                       $./setup.linux -is:javahome /usr/java/j2sdkX.X.X_0X/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/tuxedoXx

PEOPLESOFT APPLICATION INSTALLATION –HRMS/CS/ELM/FSCM/CRM
1. Log in as psoft.
                          su – psoft
2. Start the PeopleTools installation
                                # cd /mnt/cdrom/hcmXX/HCMXX
                            $ ./setup.linux -is:javahome /usr/java/j2sdkX.X.X_0X/bin -console
  
            This will launch the installer wizard. Click next when you see the welcome screen.
            3.  Follow the onscreen instructions
                      Enter your license code for PeopleSoft HRMS.X Application.
                  117fef-ffff8f-ffffebf-119783-2qimmg
         Choose Non-Unicode database for non multilingual installation
           4.  Select all the servers to be installed (Only Web Server will be listed).
           5.  Specify the PS_HOME directory when asked for:  “/u02/psoft/PROD”
           6.  When it prompts for the tuxedo directory, enter:   “/u02/bea/tuxedoXX”

In Windows 2003/2008 Server Install Oracle 11g Client Software.

  1.  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
2.      Open VMware Server Console

           Select settings on VM Menu

  1. 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 OEL Server.

               i.e 192.168.1.1

Note: Here Windows 200X server ip address is 192.168.1.2


4.      How to set ipaddress if the OELx 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 200X (client) and
                    VMWare Server (LINUX Server)\

In OELx Create a Blank Database
1.      Create a blank demo database using manually or DBCA GUI mode.
2.      Configure the listener and tnsname.ora manually or NETCA GUI mode.
Copy tnsnames.ora file from LINUX Server located at
                /u01/app/oracle/product/xxxx/xxxx/network/admin/
              From the above directory into
            C:\oracle\product\xxxx\client_1\NETWORK\ADMIN
                     Into windows 200X client.
Now configure the listener.ora
SID_LIST_LISTENER =
                 (SID_LIST =
                  (SID_DESC =
                (SID_NAME = HRPRD)
                                (ORACLE_HOME = /u01/app/oracle/product/XXXX/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/xxxx/xxx/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.
3.      To check the connectivity of oracle client to oracle server
C:\tnsping <SID>
C:\sqlplus /nolog
Sql>conn SYSTEM/SYSTEM@<SID>
Sql>select name from v$database;
Sql>exit;

4.      Modify and run the six 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.

5.      Configure the Configuration Manager

The rest of the steps you have to follow Oracle PeopleSoft Installation guide from Page no: 212 To 244.
How to create the Application server

  1. 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 – Create a soft link in Linux
$ ls –ltr libcl*.*

  1. login as root
# su – psoft
$ pwd
$ ls –ltr
$ ./psadmin

Ø  now select the options
Ø  select 1
Ø  select 2
Ø  select 1
Ø  select  Y
Ø  17 --userid PS
Ø  18 –passwd PS
Ø  Load configuration


In Case of error during PSADMIN invoking make sure tux.env set properly and $PS_HOME/bin is set over LD_LIBRARY_PATH. Open tux.env copy all and paste into “psoft” bash_profile. Invoke the using “. .bash_profile” to reflect the changes.


How to install web server

  1. Install web logic binaries
              # mkdir –p /u03/weblogic
            # chown –R psoft:psoft /u03
# chmod –R 777 /u03
# su – psoft
$ cd /media/cdrom
$ ls –ltr
$ cd WEBLOGICXx.x
$ ./install.sh –console
it will ask for the path--  “/u03/weblogic
                                            ./setup.linux –is:javahome /u03/weblogic/jdk14_08  -console

  1. Installing  PIA
Goto PS_HOME->setup->PsMpPIAInstall-> Install the PIA
Follow the navigation.

How to stop the web server and PIA (In Linux)

  1. Goto PS_HOME-> Invoke ./psconfig.sh(Make sure PS_CFG_HOME,TUXDIR,PS_HOME/bin set properly)
  2. Go to PS_HOME->webserv-><WEBSITENAME>-> BIN
./startPIA.sh (To start web server)
./stopPIA.sh(To stop web server)
#su – psoft
[psoft@hari HRPRD]$tail –f logs/PIA _stdout.log

By : Prasanth Bhaskaran (Oracle PeopleSoft Application DBA) 

No comments:

Post a Comment