Sunday, January 27, 2008

On The Peoplesoft Road : 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 :


Name your remote server IP address, the Application Server name, and the WSL port :
6. Lastly, open the Application Designer
Choose the connection type "Application Server" instead of Oracle.
Verify you're connect onto the databasee through the Application Server.

8 comments:

Anonymous said...

hi,

as per your method,idid all the installation procedure.. But coultn't connect application desiner ...i'm getting follwing error

"Could not connect to application server DELL (//172.168.10.200:7000). Possible causes are: the server name/IP address and port for the application server alias are incorrect, the application server is not booted, or the network is unreachable. Contact your system administrator or check the Tuxedo log for more information. "

Thsnks
Rajkumar

Jim Marion said...

Nicolas, on step 2, I couldn't get signed into SQLPlus. I was getting the error "ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA." I copied $ORACLE_HOME/network/admin/tnsnames.ora to ~/hrms9/.tnsnames.ora and was able to connect. Of course, I could have set TNS_ADMIN to point to $ORACLE_HOME/network/admin.

Nicolas Gasparotto said...

Jim, looks interesting.
Maybe you didn't set $ORACLE_HOME and not added the $ORACLE_HOME/bin into the $PATH variable in your .profile or .bash_profile (step 1+ disconnect+reconnect), did you ?
I never had to play with TNS_ADMIN and with a very local tnsnames.ora file of the PS user neither.
Furthermore, if many databases are managed on same server, it is maybe better to maintain only one tnsnames.ora (the one from $ORACLE_HOME/network/admin) instead of one by PS user, isn't it.

Unknown said...

I am getting the same problem as Rajkumar.

"Could not connect to application server PT850//157.201.227.51:7000).
Possible causes are: the server name/IP address and port for the application server alias are incorrect, the application server is not booted, or the network is unreachable. Contact your system administrator or check the Tuxedo log for more information. "

The WSL service is running and I can see it when I do a netstat. I can do an nmap for the localhost and see the port, but when I do an nmap to the machine: 157.201.227.51 port 7000 is not shown as open. I have checked the IPTABLES and it shows that port 7000 is open on the firewall. I have even tried shutting down the firewall but it mad no difference.

I can ping the machine and connect directly to the database from the Windows client.

I have tried everything I can think of. Can anyone help?

Anonymous said...

Hi,

Please check if your port number is correct. In this example, 7000 port was allocated to WSL.

The web config file should have an entry psserver=HOSTNAME:PORT_NUMBER.
where, HOSTNAME is the computer where you configured the application server. And, the PORT_NUMBER is the JSL port number (not WSL port number).

Anonymous said...

The file name is configuration.properties ( in case of web logic).

The pay may look like, $PS_HOME/weblogic/..../PORTAL/WEB-INF/psftdocs/FINPRO/configuration.properties

Anonymous said...

Hello i have the same problem. i can't connect to the application server with the application designer . I'm using the port 7000.
How can i check if the application server is correclty started?

Gilles

Anonymous said...

Hello Rajkumar,

I had the same problem and ran nmap. Port 7000 (the default workstation listener port) was open when it was run on the server, but was not open when run on the client and pointed at the server. The firewall was disabled so that was not the issue. I am running Peoplesoft on VMware using a NAT connection. This problem was solved by modifying psappsrv.cfg

[Workstation Listener]
;======================
;Settings for Workstation Listener
;===============================

;Address=%PS_MACH% comment out this line and replace with this

Address=//000.000.000.000

; where 000.000.000.000 is the IP address of your virtual machine


After doing this and reconfiguring the domain through psadmin I was able to connect with Application Designer and nVision in 3 tier mode.


Todd