Tuesday, April 10, 2018

Oracle & PS Installation steps in Linux

         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