Friday, May 8, 2009

8 Configure Application Server

Before continuing on the installation, please, be sure about your /etc/hosts file :
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost loopback localhost.localdomain
192.168.1.21 orion.phoenix-nga orion
Before continuing on the installation, please, create the links as oracle user :
[ora102@orion:/apps/oracle/10.2.0/lib]DMOHRMS9$ ln -s libclntsh.so libclntsh.so.9.0
[ora102@orion:/apps/oracle/10.2.0/lib]DMOHRMS9$ ls -lrt libclntsh.so*
-rwxr-xr-x 1 ora102 oinstall 18762500 Dec 28 22:38 libclntsh.so.10.1
lrwxrwxrwx 1 ora102 oinstall 17 Dec 28 22:38 libclntsh.so -> libclntsh.so.10.1
lrwxrwxrwx 1 ora102 oinstall 12 Jan 8 21:02 libclntsh.so.9.0 -> libclntsh.so
[ora102@orion:/apps/oracle/10.2.0/lib]DMOHRMS9$
1. Update your .bash_profile (application OS user hrms9)
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
export ORACLE_HOME=/apps/oracle/10.2.0
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PS_HOME=/apps/psoft/hrms9
. $PS_HOME/psconfig.sh
2. Check the access database within the application user hrms9
[hrms9@orion:/home/hrms9]$ sqlplus sysadm/sysadm@DMOHRMS9
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jan 8 20:16:38 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
3. Create, configure and launch the AppServer
[hrms9@orion:/home/hrms9]$ cd $PS_HOME/appserv
[hrms9@orion:/apps/psoft/hrms9/appserv]$ ./psadmin
PSADMIN -- Tools Release: 8.49.08
Copyright (c) 1988, 2003, Oracle. All rights reserved.
--------------------------------
PeopleSoft Server Administration
--------------------------------
1) Application Server
2) Process Scheduler
3) Search Server
q) Quit
Command to execute (1-3, q): 1
--------------------------------------------
PeopleSoft Application Server Administration
--------------------------------------------
1) Administer a domain
2) Create a domain
3) Delete a domain
4) Import domain configuration
q) Quit
Command to execute (1-4, q) : 2
Please enter name of domain to create :DMOHRMS9
Configuration templates:
1) small
2) medium
3) large
4) developer
Select config template number: 1
Creating domain...
Copying application server configuration files...
Stripping Annotations...
Copying Jolt repository file...
Copying Java Query client files...
Domain created.
Would you like to configure this domain now? (y/n) [y] :y
----------------------------------------------
Quick-configure menu -- domain: DMOHRMS9
----------------------------------------------
Features Settings
========== ==========
1) Pub/Sub Servers : No 15) DBNAME :[DMOHRMS9]
2) Quick Server : No 16) DBTYPE :[ORACLE]
3) Query Servers : No 17) UserId :[QEDMO]
4) Jolt : Yes 18) UserPswd :[QEDMO]
5) Jolt Relay : No 19) DomainID :[TESTSERV]
6) WSL : No 20) AddToPATH :[.]
7) PC Debugger : No 21) ConnectID :[people]
8) Event Notification: Yes 22) ConnectPswd:[peop1e]
9) MCF Servers : No 23) ServerName :[]
10) Perf Collator : No 24) WSL Port :[7000]
11) Analytic Servers : Yes 25) JSL Port :[9000]
12) Domains Gateway : No 26) JRAD Port :[9100]
Actions
=========
13) Load config as shown
14) Custom configuration
h) Help for this menu
q) Return to previous menu
HINT: Enter 15 to edit DBNAME, then 13 to load
Enter selection (1-26, h, or q): 8
----------------------------------------------
Quick-configure menu -- domain: DMOHRMS9
----------------------------------------------
Features Settings
========== ==========
1) Pub/Sub Servers : No 15) DBNAME :[DMOHRMS9]
2) Quick Server : No 16) DBTYPE :[ORACLE]
3) Query Servers : No 17) UserId :[QEDMO]
4) Jolt : Yes 18) UserPswd :[QEDMO]
5) Jolt Relay : No 19) DomainID :[TESTSERV]
6) WSL : No 20) AddToPATH :[.]
7) PC Debugger : No 21) ConnectID :[people]
8) Event Notification: No 22) ConnectPswd:[peop1e]
9) MCF Servers : No 23) ServerName :[]
10) Perf Collator : No 24) WSL Port :[7000]
11) Analytic Servers : Yes 25) JSL Port :[9000]
12) Domains Gateway : No 26) JRAD Port :[9100]
Actions
=========
13) Load config as shown
14) Custom configuration
h) Help for this menu
q) Return to previous menu
Enter selection (1-26, h, or q): ***comment***enter the number of the option you want to (de)activate or to change a paramter value***
----------------------------------------------
Quick-configure menu -- domain: DMOHRMS9
----------------------------------------------
Features Settings
========== ==========
1) Pub/Sub Servers : No 15) DBNAME :[DMOHRMS9]
2) Quick Server : No 16) DBTYPE :[ORACLE]
3) Query Servers : No 17) UserId :[PS]
4) Jolt : Yes 18) UserPswd :[PS]
5) Jolt Relay : No 19) DomainID :[DMOHRMS9]
6) WSL : Yes 20) AddToPATH :[/appl/oracle/10.2.0/bin]
7) PC Debugger : No 21) ConnectID :[people]
8) Event Notification: No 22) ConnectPswd:[peop1e]
9) MCF Servers : No 23) ServerName :[]
10) Perf Collator : No 24) WSL Port :[7000]
11) Analytic Servers : No 25) JSL Port :[9000]
12) Domains Gateway : No 26) JRAD Port :[9100]
Actions
=========
13) Load config as shown
14) Custom configuration
h) Help for this menu
q) Return to previous menu
Enter selection (1-26, h, or q): 13 ***to load your config in a binary file***
Performing load prechecks ...
Loading validation table...
setting DBName=DMOHRMS9
setting DBType=ORACLE
setting UserId=PS
setting UserPswd=PS
setting ConnectId=people
setting ConnectPswd=peop1e
setting ServerName=
setting Port=7000
setting Port=9000
setting Listener Port=9100
setting Domain ID=DMOHRMS9
setting Add to PATH=/appl/oracle/10.2.0/bin
New CFG file written with modified Startup parameters
Log Directory entry not found in configuration file.
Setting Log Directory to the default... [PS_SERVDIR/LOGS]
Spawning disabled for server PSAPPSRV.
Configuration file successfully created.
CFG setting changes completed, loading configuration...
Domain configuration complete.
4. Start the AppServer
[hrms9@orion:/apps/psoft/hrms9/appserv]$ ./psadmin
PSADMIN -- Tools Release: 8.49.08
Copyright (c) 1988, 2003, Oracle. All rights reserved.
--------------------------------
PeopleSoft Server Administration
--------------------------------
1) Application Server
2) Process Scheduler
3) Search Server
q) Quit
Command to execute (1-3, q): 1
--------------------------------------------
PeopleSoft Application Server Administration
--------------------------------------------
1) Administer a domain
2) Create a domain
3) Delete a domain
4) Import domain configuration
q) Quit
Command to execute (1-4, q) : 1
Tuxedo domain list:
1) DMOHRMS9
Select domain number to administer: 1
--------------------------------
PeopleSoft Domain Administration
--------------------------------
Domain Name: DMOHRMS9
1) Boot this domain
2) Domain shutdown menu
3) Domain status menu
4) Configure this domain
5) TUXEDO command line (tmadmin)
6) Edit configuration/log files menu
7) Messaging Server Administration menu
8) Purge Cache
9) Preload File Cache
10) Clean IPC resources of this domain
q) Quit
Command to execute (1-10, q) : 1
-------------------------------
PeopleSoft Domain Boot Menu
-------------------------------
Domain Name: DMOHRMS9
1) Boot (Serial Boot)
2) Parallel Boot
q) Quit
Command to execute (1-2, q) [q]: 1
psappsrv.cfg has changed archiving old one...
Copying DMOHRMS9/Archive/psappsrv.cfg to DMOHRMS9/Archive/psappsrv_010808_2021_18.cfg
Attempting to boot bulletin board...
tmadmin - Copyright (c) 1996-1999 BEA Systems, Inc.
Portions * Copyright 1986-1997 RSA Data Security, Inc.
All Rights Reserved.
Distributed under license by BEA Systems, Inc.
Tuxedo is a registered trademark.
No bulletin board exists. Entering boot mode.
INFO: BEA Tuxedo, Version 9.1, 32-bit, Patch Level 036
INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000
INFO: Licensed to: Oracle-Peoplesoft-ISV
Booting admin processes ...
exec BBL -A :
process id=9412 ... Started.
1 process started.
Attempting to boot ...
INFO: BEA Tuxedo, Version 9.1, 32-bit, Patch Level 036
INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000
INFO: Licensed to: Oracle-Peoplesoft-ISV
Booting server processes ...
exec PSWATCHSRV -A -- -ID 248284 -C psappsrv.cfg -D DMOHRMS9 -S PSWATCHSRV :
process id=9414 ... Started.
exec PSAPPSRV -s@../psappsrv.lst -s@../psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOHRMS9 -S PSAPPSRV :
process id=9415 ... Started.
exec PSAPPSRV -s@../psappsrv.lst -s@../psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOHRMS9 -S PSAPPSRV :
process id=9436 ... Started.
exec PSAPPSRV -s@../psappsrv.lst -s@../psqcksrv.lst -sICQuery -sSqlQuery:SqlRequest -- -C psappsrv.cfg -D DMOHRMS9 -S PSAPPSRV :
process id=9444 ... Started.
exec PSSAMSRV -A -- -C psappsrv.cfg -D DMOHRMS9 -S PSSAMSRV :
process id=9452 ... Started.
exec PSMONITORSRV -A -- -ID 248284 -C psappsrv.cfg -D DMOHRMS9 -S PSMONITORSRV :
process id=9459 ... Started.
exec WSL -A -- -n //orion.phoenix-nga:7000 -z 0 -Z 0 -d unused -I 5 -T 60 -m 1 -M 3 -x 40 -c 5000 -p 7001 -P 7003 :
process id=9466 ... Started.
exec JSL -A -- -d unused -n //orion.phoenix-nga:9000 -m 5 -M 7 -I 5 -j ANY -x 40 -S 10 -c 1000000 -w JSH :
process id=9468 ... Started.
exec JREPSVR -A -- -W -P /apps/psoft/hrms9/appserv/DMOHRMS9/jrepository :
process id=9474 ... Started.
9 processes started.
5. Then, from your client machine, configure the Application ass well, within the Configuration Manager first :
clip_image001

clip_image002clip_image003

Name your remote server IP address, the Application Server name, and the WSL port :

clip_image004

6. Lastly, open the Application Designer

clip_image005

Choose the connection type "Application Server" instead of Oracle.

clip_image006

Verify you're connect onto the databasee through the Application Server.

clip_image007

clip_image008

No comments: