List of PeopleSoft Tables

PeopleSoft Object Definition Tables
PSACTIVITYDEFN	Activity definitions are stored
PSAESECTDEFN	Stores the application engine section definitions
PSAESTEPDEFN	Stores the application engine step definitions
PSAESTEPMSGDEFN	Stores the messages of the AE programs
PSPCMPROG	Peoplecode programs stored
PSSQLTEXTDEFN	Application engine sql
PSAEAPPLDEFN	Application engine program name
PSMENUDEFN	Menu names
PSPNLDEFN	Page names
PSPNLGROUP	Stores Component definitions
PSBCDEFN	Stores component interface names
PSBUSPROCDEFN	Stores Business process definitions
PS_APPR_RULE_HDR	Stores Approval rule set definitions
PSCHNLDEFN	Stores channel definitions
PSEVENTDEFN	Changing the column value of active to 0 leads to disabling activities
PSFLDFIELDDEFN	Filelayout stored
PSFILEREDEFN	File reference stored
PSINDEXDEFN	Index information stored
PSIODEFN	Stores business interlink information
PSKEYDEFN	Stores the index key information
PSMPDEFN	Contains info about mobilepages
PSMSGAGTDEFN	Refers to the activity object
PSMSGCATDEFN	Related to Messages –  Message catalogs
PSMSGDEFN	Stores Application Message definitions
PSDBFIELD	Contains field definitions
PSDDLDEFPARMS	This table holds the storage structure of the tables for db platforms
PSGATEWAY	This table hold the gateway url.
PSIDXDDLPARM	This table holds the storage structure of the indexes for db platforms
PSRECDEFN	This table holds the information of all the peoplesoft records.
PSPACKAGEDEFN	This table holds the application packages definitions
PSPNLGRPDEFN	Contains Panel group definitions
PSPRDMDEFN	Contains the portal information
PSPROJECTDEFN	Contains project definitions
PSPRSMDEFN	Detailed information of the portal objects
PSPRUFDEFN	Information about portal objects
PSPRUHDEFN	Information about portal objects
PSQRYDEFN	Holds the query definitions
PSROLEDEFN	Role definitions
PSSQLDEFN	SQL object definitions are stored
PSSQLTEXTDEFN	SQL object’s text are stored
PSSTEPDEFN	Contains stepnames with reference to the activity
PSSTYLEDEFN	Contains the styles definitions
PSSTYLSHEETDEFN	Contains the stylesheet definitions
PSSUBDEFN	Conatins Message subscription definitions
PSTOOLBARDEFN	Holds a single row provided by PS, which helps to view the toolbar
PSTREEDEFN	Contains the treename
PSCLASSDEFN	Gives info abt the peoplesoft permission lists
PSURLDEFN	To see which URL’s are used as fileservers for the file attachments
PS_AE_TEMPREC_VW	Tracks all temporary tablenames and their descriptions
PS_AE_TEMPLOCK_VW	Tracks how many locks are currently in effect for a particulartemporary table
PS_DATA_FIND_BASE	Used as search record for the panel.  SHould always be empty.
PS_MSG_CATLG_VW	Contains text for all error messages and warnings.

Integration Broker Setup Tables

PSMSGNODEDEFN	Tools table that holds definitions for Message Node objects
PSNODEURITEXT	Associated table is PSMSGNODEDEFN. This table is comprised of long text field NODE_URITEXT which is a long text field. The data in NODE_URITEXT is used by the Portal Registry.
PSAPMSGDSPSTAT
PSAPMSGDOMSTAT	IB Domain Status
PSCONN	Connector Definition
PSCONNPROP	Connector Properties
PSCONNPROPLANG	Registered Integration Server Connector Properties Protocols and attributes
PSGATEWAY	Integration Broker Connector Gateway
PSIBSVCSETUP	IB Service setup
PSNODECONPROP	Registered Integration Server Connector Properties Protocols and attributes
PSIBRTNGSUBDEFN	IB Routing Sub Definition
PSRTNGDFNPARM	IB Routing Parameter View
PSIBRTNGDEFN	IB Routing Definitions

Web Profile Setup Tables

PSWEBPROFBROW;	Web Profile Browsers
PSWEBPROFCOOK	Web Profile Cookies
PSWEBPROFDEF	Web Profile Defaults
PSWEBPROFILE	Web Profile
PSWEBPROFPROP	Web Profile Custom Properties
PSWEBPROFNVP	Web Profile Name/Value Pairs
PSWEBPROFHIST	Web Profile History

Process servers

PS_SERVERCLASS	Server Defn - Process Types
PS_SERVERDEFN	Server Defn
PS_SERVERDEFN_LNG	Server Defn
PS_SERVERNOTIFY	Server Notification
PS_SERVERMESSAGE	Server Defn

DES on Oracle WebLogic on UNIX

Dialog Servers-DES

1. Shut down any Oracle WebLogic web server that is running.
2. Go to PS_HOME/setup/PsMpWebAppDeployInstall and run the appropriate setup command with these
additional parameters.

[psoft@hostname PsMpWebAppDeployInstall]$ ./setup.sh
Setting temporary directory /tmp/IA.31320
Executing setup.linux LAX_VM /u01/app/psoft/pshomes/crdmo/jre/bin/java  -DCOMP_NAME=hostname -DPS_UMASK=0022
Preparing to install...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...

========================================================================
PeopleSoft Webapp Deploy Tool                    (created with InstallAnywhere)
-------------------------------------------------------------------------------

Preparing CONSOLE Mode Installation...

========================================================================

Welcome to the InstallShield Wizard for PeopleSoft Webapp Deploy Tool.

Using the InstallShield Wizard you will install PeopleSoft Webapp Deploy Tool
on your computer.

Version: 8.54.22

Note: If installing onto a Oracle WebLogic Server, make sure to shutdown any
running web servers to avoid web server corruption.

Press 1 for Next, 3 to Cancel or 5 to Redisplay [1] :

========================================================================

Choose the directory where you wish to deploy the Web Server domain:

   Please specify a directory name or press Enter
   [/u01/app/psoft/ps_config_homes/crdmo]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

=======================================================================
Choose the installation type that best suits your needs.

  ->1- Oracle WebLogic Server
    2- IBM WebSphere Server

To select an item enter its number, or 0 when you are finished [0] :

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================

 Select the web server root directory [/home/psoft/oracle/Middleware]: /u01/app/psoft/Weblogic12c

Detected web server version : WebLogic 12.1.3.0.0

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Choose the Deployment type:

  ->1- Deploy DES
    2- Deploy OPA

To select an item enter its number, or 0 when you are finished [0] :

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Enter domain name or click Next to select default [PSWebApp]: DES

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Please enter the administrator login and password for WebLogic domain.

 Login ID [system]:

 Password []:

 Re-type Password []:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Select the configuration.
Please select the configuration to install.

  ->1- Single Server Domain
    2- Multi Server Domain
    3- Distributed Managed Server

To select an item enter its number, or 0 when you are finished [0] :

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Choose the directory where you previously installed PeopleSoft Applications,
commonly known as "PS_APP_HOME".

Note: If you have installed PeopleSoft Applications outside PeopleTools PS_HOME
then choose the PeopleSoft Applications home "PS_APP_HOME", else leave the
default "PS_HOME".

   Please specify a directory name or press Enter
   [/u01/app/psoft/pshomes/crdmo]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Please select the application package to deploy:
  ->1- CRM OMK

To select an item enter its number, or 0 when you are finished [0] :

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Specify the CRM database information.

CRM OMK :

   Database Type [MSSQL]: ORACLE

   Database Server Name [ ]: database host

   Database Port Number [1433]: 1521

   Database Instance Name [ ]: crdmo

   Database User Name [Admin]: SYSADM

   Database User Password [*]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Enter port numbers.

HTTPPort [80]: Http port number

HTTPSPort [443]: Https port number

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Review and confirm your selections before deploying the DES server

Setup Type : weblogic

Web server root directory : /u01/app/psoft/Weblogic12c

Web server version : 12.1

Web server domain : DES

HTTP port : Http port number

HTTPS port : Https port number

Selected deploy package(s) : crm_omk_wl.ear

Package(s) webserver directory : /u01/app/psoft/ps_config_homes/crdmo/webserv

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Installing...
 [==================|==================|==================|================
Installation Complete
---------------------
Congratulations! PeopleSoft Webapp Deploy Tool has been successfully installed
to:/u01/app/psoft/ps_config_homes/crdmo/webserv:

Modifying the setEnv.sh:

Provide below information in the setEnv.sh file
#CLASSPATH=.:${PSCLASSPATH}:${PLATFORM_PATCH}:${JAVA_HOME}/lib/tools.jar:${WL_HOME}/server/lib/weblogic_sp.jar:${WL_HOME}/server/lib/weblogic.jar:
CLASSPATH=${JAVA_HOME}/lib/tools.jar:${WL_HOME}/server/lib/weblogic_sp.jar:${WL_HOME}/server/lib/weblogic.jar:
export CLASSPATH
PATH=${WL_HOME}/bin:${JAVA_HOME}/jre/bin:${JAVA_HOME}/bin:${PS_HOME}/bin:$PATH
export PATH

Starting the DES on an Oracle WebLogic Server

On UNIX, start the DES application on an Oracle WebLogic Server by entering the following in the
Command Window:
>cd PS_CFG_HOME/webserv/<domain name>/bin
>startPSWEBAPPS.sh
Special note:
1.ojdbc6.jar
2.crm_omk_wl.ear
Make sure this file are copied in the below path on linux server:
/u01/app/psoft/ps_config_homes/crdmo/webserv/DES/applications/crm

Dialog Flow Designer on Linux and UNIX for Oracle WebLogic:

1. Verify that files DialogDesigner_wl.ZIP for Oracle WebLogic exist and are located at: <PS_HOME>/setup/PsMpPIAInstall/archives/ or<PS_APP_HOME>/setup/PsMpPIAInstall/archives/

2. Run the PIA install.sh again at <PS_HOME>\\setup\PsMpPIAInstall. You will see the following:

Launching installer...
========================================================================
PeopleSoft Internet Architecture                 (created with InstallAnywhere)
-------------------------------------------------------------------------------
Preparing CONSOLE Mode Installation...
========================================================================
Welcome to the InstallShield Wizard for PeopleSoft Internet Architecture.

Using the InstallShield Wizard you will install PeopleSoft Internet
Architecture on your computer.

Version: 8.54.22

Note: If installing onto a Oracle WebLogic Server, make sure to shutdown any
running web servers to avoid web server corruption.

Press 1 for Next, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Choose the directory where you wish to deploy PeopleSoft Pure Internet
Architecture :

   Please specify a directory name or press Enter
   [/u01/app/psoft/ps_config_homes/crdmo]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Choose the installation type that best suits your needs.
 ->1- Oracle WebLogic Server
   2- IBM WebSphere Server

To select an item enter its number, or 0 when you are finished [0] :

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Select the web server root directory [/home/psoft/oracle/Middleware]: /u01/app/psoft/Weblogic12c

Detected web server version : WebLogic 12.1.3.0.0

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Select the webserver domain. Select the option 2 for existing weblogic domain.
  ->1- Create New WebLogic Domain
    2- Existing WebLogic Domain

To select an item enter its number, or 0 when you are finished [0] : 2
    1- Create New WebLogic Domain
  ->2- Existing WebLogic Domain

To select an item enter its number, or 0 when you are finished [0] :

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================Select application name from list:
  ->1- crdmo

To select an item enter its number, or 0 when you are finished [0] :

Select application name from list:

  ->1- Install additional PeopleSoft site
    2- Redeploy PeopleSoft Internet Architecture
    3- Re-create WebLogic domain and redeploy PeopleSoft Internet Architecture
    4- Deploy additional PeopleSoft application extensions

To select an item enter its number, or 0 when you are finished [0] : 4

Select application name from list:

    1- Install additional PeopleSoft site
    2- Redeploy PeopleSoft Internet Architecture
    3- Re-create WebLogic domain and redeploy PeopleSoft Internet Architecture
  ->4- Deploy additional PeopleSoft application extensions

To select an item enter its number, or 0 when you are finished [0] :

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Please enter the administrator login and password for Weblogic Domain.
   Login ID [system]:
   Password []:
Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Please enter the Integration Gateway User and Password.

   Integration Gateway User [administrator]:

   Password []:

   Re-type Password []:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Please enter the AppServer Domain Connection Password.
   Password []:

   Re-type Password []:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Choose the directory where you previously installed PeopleSoft Applications,
commonly known as "PS_APP_HOME".

Note: If you have installed PeopleSoft Applications outside PeopleTools PS_HOME
then choose the PeopleSoft Applications home "PS_APP_HOME", else leave the
default "PS_HOME".

   Please specify a directory name or press Enter
   [/u01/app/psoft/pshomes/crdmo]:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Please select the application package to deploy:

  ->1- Dialog Designer

To select an item enter its number, or 0 when you are finished [0] :

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Please specify a name for the PeopleSoft web site:

   Website name [ps]: crdmo

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Enter port numbers and summaries.

   AppServer name [hostname]: application server host
 
   JSL Port [9000]: JSL port number

   HTTP Port [80]: provide your DES http port number

   HTTPS Port [443]: provide your DES https port number

   Authentication Token Domain:(optional) []:   
Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Please enter the Name of the Web Profile used to configure the webserver. The
user id and password will be used to retrieve the web profile from the
database. (NOTE: Other available preset web profile names are TEST", "DEV",and
"KIOSK".)
   Web Profile Name [PROD]: DMO
   User ID : PTWEBSERVER
   Password []:
   Re-type Password []:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Select the Report Repository location:
   Please specify a directory name or press Enter [/home/psoft/PeopleSoft
   Internet Architecture/psreports]: /u01/app/psoft/psreports

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :
========================================================================
Setup Type : weblogic

Web server root directory : /u01/app/psoft/Weblogic12c

Web server version : 12.1

Web server domain : crdmo

Internet Architecture app name : PORTAL

Integration Gateway app name : PSIGW

PeopleSoft Business Interlink app name : PSINTERLINKS

Environment Management Hub : PSEMHUB

Portlet Container app name : pspc

Site name : crdmo

Authentication Token Domain :

Application server name : Application host

JSL port : JSL port number

Report repository directory : /u01/app/psoft/psreports

PIA webserver directory : /u01/app/psoft/ps_config_homes/crdmo/webserv

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] :

========================================================================
Installing...
-------------
 [==================|==================|==================|===============]
========================================================================
Installation Complete
---------------------
Congratulations! PeopleSoft Internet Architecture has been successfully
installed to:

/u01/app/psoft/ps_config_homes/crdmo/Webserv

Testing the DES Installation:

Before you test the DES installation, you should stop the application server, clear the cache and restart the server.
Then start the DES.
To test the DES installation, perform the following steps:
1. Test the communication to the server and verify that PeopleSoft OLM is installed.
Go to http://<webserver>:<port>/DCS/mcp?rut=1.
If the connection is working properly, the web page displays the message "i am here."
2. Verify database connectivity with the web server.
Go to http://<webserver>:<port>/DCS/mcp?rutdb=1.
If the connection and the database is working properly, the web page displays the message "db: i am here."
3. Verify JOLT connectivity with the web server.
Go to http://<webserver>:<port>/DCS/mcp?rutas=1.
If the connection and the application server is working properly, the web page displays the message as: "i am
here."
4. Verify FTP connectivity with the FTP server.
Go to http://<webserver>:<port>/DCS/mcp?rutftp=1.
If the connection and the application server are working properly, the web page displays the message "ftp: i
am here."
5. Check for errors in the DES log files:

TUXEDO PATCHING

Prerequisites

1.Completely shut down your Tuxedo application, including the tlisten process. 

2.Backup current Tuxedo Home.

3.Make sure the environment variable TUXDIR is set to point to the area where the fix is to be installed.

4.Make sure ORACLE_HOME is set.

Procedure

Create a directory under tuxedo home like RP067

1.     Untar the .gz file

2.     Set TUXDIR to /u01/app/psoft/tuxedo12.1.1.0 and ORACLE_HOME to /u01/app/psoft (location which contains registry.xml file).

3.     Go to RP067 folder and execute install

4.     And execute ./install

5.     After executing the install file. It will ask the below details.

a.     Enter owner for patch files: 
psoft 

b.    Enter group for patch files: 
oinstall

Example: 

[psoft@HOSTNAME Tux_patch_111130_Linux]$  ./install

Installing server and client files...

Enter owner for patch files:

psoft

Enter group for patch files:d

oinstall

DIR=/u01/app/SRC/Tux_patch_111130_Linux

rpreleasenote =  ORACLE Enterprise LINUX 5 (x86_64) x86 for Intel Xeon, 64bits Tuxedo

portreleasenotes= ORACLE Enterprise LINUX 5 (x86_64) x86 for Intel Xeon, 64bits Tuxedo

TUXDIR:/u01/app/psoft/tuxedo11gR1113P

ORACLE_HOME:/u01/app/psoft

Must specify the correct TUXDIR :(/u01/app/psoft/tuxedo11gR1,/u01/app/psoft/tuxedo11gR1113P)

[psoft@HOSTNAME Tux_patch_111130_Linux]$ ./install

Installing server and client files..

Enter owner for patch files:

psoft

Enter group for patch files:

oinstall

DIR=/u01/app/SRC/Tux_patch_111130_Linux

rpreleasenote =  ORACLE Enterprise LINUX 5 (x86_64) x86 for Intel Xeon, 64bits Tuxedo

portreleasenotes= ORACLE Enterprise LINUX 5 (x86_64) x86 for Intel Xeon, 64bits Tuxedo

TUXDIR:/u01/app/psoft/tuxedo11gR1113P

ORACLE_HOME:/u01/app/psoft

The patch installation finished successfully 

Before Installation:

------------------- 

Issue the command after setting the environmental variables(TUXDIR & PATH).

tmadmin –v

The above will provide the Tuxedo version with patch information

[psoft@HOSTNAME psoft]$ vi registry.xml.orig

<?xml version="1.0" encoding="UTF-8" standalone="no"?><bea-product-information><host name="HOSTNAME"><product format="1.0" name="Tuxedo"><release InstallDir="/u01/app/psoft/tuxedo11gR1" InstallMode="GA" InstallSet="Full" InstallTime="Aug 24, 2015 3:24:18 PM" InstallerType="Product" PatchLevel="028" Status="installed" level="11.1.1.3.0"><component name="tuxtsrv"/><component name="tuxtcli"/><component name="tuxccli"/><component name="joltrly"/><component name="joltcli"/></release><release InstallDir="/u01/app/psoft/tuxedo12.1.1.0" InstallMode="GA" InstallSet="Full" InstallTime="Dec 18, 2015 2:08:44 AM" InstallerType="Product" PatchLevel="067" Status="installed" level="12.1.1.0"><component name="tuxtsrv"/><component name="tuxtcli"/><component name="tuxccli"/><component name="joltrly"/><component name="joltcli"/></release></product></host></bea-product-information>

After Installation:

------------------

Issue the command after setting the environmental variables(TUXDIR & PATH).

tmadmin –v

The above will provide the Tuxedo version with patch information

vi registry.xml

<?xml version="1.0" encoding="UTF-8"?><bea-product-information><host name="HOSTNAME"><product format="1.0" name="Tuxedo"><release InstallDir="/u01/app/psoft/tuxedo11gR1113P" InstallMode="GA" InstallSet="Full" InstallTime="May 5, 2016 1:18:32 AM" InstallerType="Product" PatchLevel="067" Status="installed" level="11.1.1.3.0"><component name="tuxtsrv"/><component name="tuxtcli"/><component name="tuxccli"/><component name="joltrly"/><component name="joltcli"/></release><release InstallDir="/u01/app/psoft/tuxedo12.1.1.0" InstallMode="GA" InstallSet="Full" InstallTime="Dec 18, 2015 2:08:44 AM" InstallerType="Product" PatchLevel="067" Status="installed" level="12.1.1.0"><component name="tuxtsrv"/><component name="tuxtcli"/><component

name="tuxccli"/><component name="joltrly"/><component name="joltcli"/></release></product></host></bea-product-information>

You should see the correct patch number must be reflecting.

AE VERSION in PeopleSoft

Application Engine Version :

We may need to run AE VERSION when SYSAUDIT report shows that objects are out of sync and when you do a PeopleTool or/and Application Upgrade. It should only be run when there is reason to believe that the versions in the PSVERSION table are no longer coherent, or when the versions in one of the managed objects tables are out of sync with PSVERSION. Instead of running AE VERSION from PIA, it should be run from command line.

Below are the steps showing how to run AE VERSION in PeopleSoft.

Step 1. Shutdown all application servers, process schedulers, web servers.

Step 2. Make sure that there is no application designer or data mover is connected to the target database on which you plan to run AE VERSION. To be sure you can have the database restarted.

Note: It’s critical that you make sure that there is no connection to the database when you run the AE VERSION as it could lead to drastic change in performance of the application.

Step 3. Go to PS_HOME/bin and run the below command in command line

Command line syntax for AE VERSION:

psae -CD <database name > -CT <database type>-CO <application user id> -CP <application user password> -R <Valid Runcontrol id for the user>  -AI VERSION

 example:

E:\HCM92\bin\client\winx86\psae -CD HRDMO92 -CT ORACLE -CO PS -CP PSS -R RESETVERSIONS -AI VERSION

Step 4. It will take some time for AE Version to finish. After successful completion validate the entries in database by executing below command.

SELECT * FROM PSVERSION ORDER BY VERSION DESC;

Make sure that all the values for VERSION column is ‘1’.

Step 5. Clear cache and start Application Server, Web server and Process Scheduler

Screenshots:

PeopleSoft login process

The PeopleSoft login process through application designer is explained below,
In the Login Window, user has the option to select Type of login.
There if we select Database say Oracle then we are connecting directly to database.
1. User enters the credentials the App designer login window (PS/PS), App designer first connects to database using the connectID provided in the Configuration Manager. Usually, ConnectID will be people.

2. Once connection is successful, the user ‘people’ issues a couple of select statements on peopletools Security tables (PSDBOWNER/PSSTATUS/PSACCESSPRFL/PSOPRDEFN) to validate the credentials provided.
3. Gets the owner name from PSDBOWNER, usually SYSADM. Then checks the tools release.
4. Retrieves the SYMBOLICID (SYSADM1) for the given UserID from PSOPRDEFN.

5. Now gets the ACCESSID/PWD (SYSADM) from the PSACCESSPRFL which is linked to the SYMBOLICID.
6. Disconnects from Database, Connects using AccessID namely SYSADM/pwd. Now App Designer opens and is awaiting user action.

Tuxedo instalation in UNIX

1.  Download the required version of tuxedo from E-delivery.

 https://edlivery.oracle.com

Select the required version and download it.

2.      Move this zip file to UNIX server. Ex: /u01/app/SRC and extract it and give full permission.

1.Please follow the following process for Installation:

To install Oracle Tuxedo on UNIX or Linux:

1. Make the installer an executable with the following command

chmod +x tuxedo12110_64_linux_5_x86.bin

2. Start the installation in console mode with the following command:

./tuxedo12110_64_linux_5_x86.bin -i console

3. Select English as the installation language:

90 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Chapter 3 Installing Additional Components

Choose Locale...

-----------------------

->1- English

CHOOSE LOCALE BY NUMBER: 1

 4. Press ENTER after reading the introduction.

Introduction

------------

InstallAnywhere will guide you through the Tuxedo 12.1.1.0 installation.

It is strongly recommended that you quit all programs before continuing with⇒

this installation.

Enter "next’ to proceed to the next screen. Enter "back" to modify the previous⇒

screen.

You may cancel this installation at any time by typing "quit".

WARNING: "Quitting" creates an incomplete Tuxedo 12.1.1.0 installation. You⇒

must re-install Tuxedo 12.1.1.0. For more information, see "Preparing to⇒

Install the Oracle Tuxedo System" in the Tuxedo 12.1.1.0 Installation Guide.

PRESS <ENTER> TO CONTINUE

5. Select Full Install as the installation set:

Choose Install Set

------------------

Please choose the Install Set to be installed by this installer.

->1- Full Install

2- Server Install

3- Full Client Install

4- Jolt Client Install

5- ATMI Client Install

6- CORBA Client Install

7- Customize...

ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: 1

6. Enter a full path for the top-level installation directory.

The following example creates a new ORACLE_HOME directory. If you want to use an existing directory,

enter 2 and select one of the existing directories.

Copyright © 2013, Oracle and/or its affiliates. All rights reserved. 91

Installing Additional Components Chapter 3

Note. In previous Oracle Tuxedo and PeopleSoft PeopleTools releases, the installation directory was

referred to as BEA_HOME. You may see installation directories from previous releases displayed at this

prompt, and if so, you can select one.

Choose Oracle Home

------------------

->1- Create new Oracle Home

2- Use existing Oracle Home

Enter a number: 1

Specify a new Oracle Home directory: /home/user/oracle

7. Enter 2 to accept the default product directory, which is ORACLE_HOME/tuxedo12cR1, or enter 1 to specify another location. This directory is referred to as TUXDIR.

Choose Product Directory

------------------------

->1- Modify Current Selection (/home/user/oracle/tuxedo12cR1)

2- Use Current Selection (/home/user/oracle/tuxedo12cR1)

Enter a number: 2

8. Enter Y to continue:

Install Samples (Y/N): Y

9. Review the installation summary and press ENTER to continue.

Pre-Installation Summary

------------------------

Please Review the Following Before Continuing:

Product Name:

Tuxedo 12cR1

Install Folder:

/home/user/oracle/tuxedo12cR1

Link Folder:

/home/user

Disk Space Information (for Installation Target):

Required: 195,549,595 bytes

Available: 13,555,073,024 bytes

PRESS <ENTER> TO CONTINUE:

10. Press ENTER to begin the installation.

92 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Chapter 3 Installing Additional Components

Ready To Install

----------------

InstallAnywhere is now ready to install Tuxedo 12cR1 onto your system at the⇒

following location:

/home/user/Oracle/tuxedo12cR1

PRESS <ENTER> TO INSTALL:

11. Enter and confirm a password of your choice for tlisten.

Configure tlisten Service

-------------------------

Password:

Verify Password:

Password accepted! Press "Enter" to continue.

12. Select 2 for No when asked whether to install SSL support.

SSL Installation Choice

----------------

Would you like to install SSL Support?

->1- Yes

2- No

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:

2

13. Press ENTER to exit the installer.

Installation Complete

---------------------

Congratulations. Tuxedo 12cR1 has been successfully installed to:

/home/user/oracle/tuxedo12cR1

PRESS <ENTER> TO EXIT THE INSTALLER