CMDTUX CAT:1685: ERROR: Application initialization failure

CMDTUX CAT:1685: ERROR: Application initialization failure
CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler
 
Solutions for this Error:
1) Check if your application server can reach the tuxedo installed directory. Proper permissions must be there on the Middleware directory where the tuxedo installation is done.

2) Since this issue arrives at application server level check the database server is up and running and is accessible to application server or not. TNSPING and LSNRCTL status can be checked to verify the connectivity between application server and database server.

3) Environment variable can be checked for Tuxedo TUXDIR path.

4) Disk space can be checked at the application server machine. Due to low disk space also this kind of initialization failure can come.

5) Check the Application Server and Tuxedo logs for the exact error where it happens.

Peoplesoft Application Designer Basic Tutorial

This video explain the Basic of Application Designer. What it is? What is the use of it?

 

Video showing Application Designer Basic Tutorial

Peoplesoft Installation 8.53 Video Tutorials

"This videos can be helpfull for Learning Peoplesoft Installation 8.53 with Human Capital Management System HCM9.2"

Platform : Windows 7
Database : SQL Server 2008 SP3
Peoplesoft Peopletools 8.53
Application HCM9.2

In this Videos Peoplesoft Installation 8.53 ,Creating Peoplesoft Database, Configuring Domains, Integration Broker and Peoplesoft Test Framework configuration is shown: Learn and Share with peoplesoft professionals.

 

       A short Introduction to Peoplesoft - Video #1

    How to obtain softwares for peoplesoft Installation - Video #2

 
Installation of SQL Server 2008, JDK update, Tuxedo and Weblogic Server - Video #3
 

Installation of Peoplesoft Peopletools 8.53 - Video #4

Installation of Peoplesoft Application HCM9.2 - Video #5

 

Creating Peoplesoft Database with SQL Server 2008 - Video #6

 

Creating Application Server Domain in Peoplesoft - Video #7

 

  
Creating Weblogic Server Domain in Peoplesoft - Video #8

 

Creating Process Scheduler Domain in Peoplesoft - Video #9

 

Configure Integration Broker Setup in Peoplesoft - Video #10

 

Install Peoplesoft Test Framework - Video #11

Configure Peoplesoft Test Framework - Video #12
 
Please share it accross to help peoplesoft professionals to get the max knowledge and Information out of it.

WebServer in Peoplesoft is Running Slow

This is very common issue found in peoplesoft. Weblogic Server is running slow. The user is complaining the pages are taking a long time to open.

Solution:

1) In this case we can check if the application server is running properly or not. Is any bottleneck is happening between the application and database server.
2) We can check the server status through PSADMIN utility for the application server process PSAPPSRV. If all server process PSAPPSRV is busy then also it can be a reason for longer processing of the request which cause the web server to run slow.
3) We can increase the number of Server process PSAPPSRV, PSQCKSRV, PSQRYSRV which can help to run the long queries if any in lesser time.
4) Thread count can be increased if required to increase the number of service request to be processed more on the web server.

This are few solution that can be check on the peoplesoft server instance. Also possibly take backup of configuration files before any changes to be on safer side. 

Peoplesoft Installation 8.53 Major Steps

Peoplesoft Installation 8.53 Steps:
First we need to check the certification details for the peoplesoft peopletools, application, jdk, tuxedo and weblogic version with the hardware and operating system version. This details can be obtained from support.oracle.com
We are going to Install with the certification for peoplesoft 8.53 on Windows 7 and database as Oracle 11g Release 2.

1. Install the softwares one by one in the order mentioned for peoplesoft 8.53:
2. Install the Oracle Database 11g R2 (64-bit)
3. Install JDK for Windows 7 64-bit
4. Install Tuxedo 11g V2010 Windows 64-bit
5. Install WebLogic Server 10.3.6.0 in 64-bit mode
6. Install PeopleTools 8.53 (Disk1, Disk2 and Disk3)
7. Install PeopleSoft HCM 9.2 (Disk1)

Creating PeopleSoft Oracle Database:

1. Create the Oracle Database using Database Configuration Assistant (DBCA). Once created the Oracle database it is blank we need to run six SQL Scripts to create peoplesoft objects like records, temporary records, users, etc
2. Run UTLSPACE.SQL – This will create Catalog Views and Utility tablespaces like PSDEFAULT and PSTEMP
3. Run HCDDL.SQL – This will create Application related tablespaces. Make sure you have disk space on the oradata or where the data files will be created.
4. Run DBOWNER.SQL – This will create PS.PSDBOWNER table where it holds two columns Database Name, OwnerId. This table exists in Oracle only not when you create a database in SQL Server.
5. Run PSROLES.SQL – This will create PeopleSoft related database roles.
6. Run PSADMIN.SQL – This will create PeopleSoft database Owner ID (By default we give SYSADM)
7. Run CONNECT.SQL – This will create Connect ID (people) which is used in the initial connection to connect to the peoplesoft database.
8. Configure the PeopleSoft Configuration Manager. Set the Database Name, Type, Connect ID, Password, etc.
9. Now we can run the Database Setup using Data Mover to run the Import database Script which uses the (.db files) to create the peoplesoft database which can be a Demo, System or Peopletools database based on the selection.
10. Now, the Import Script will take some time to create peopesoft records, temporary records, views, etc.

Once the peoplesoft database is created with the import script, we need to check the PSSTATUS table for the version specified in the toolsversion column. If the version is the same as 8.53 it means we had the updated peopletools objects and system data. So, we can proceed to run the final scripts and complete the process.

Run VERSION AE program - It udates the PSVERSION table for the version.
Run DDDAUDIT.SQR - This will show the inconsistencies if any in the newly created database.
Run SYSAUDIT.SQR - This will show the orpahed objects if any there in the database.
Run SETSPACE.SQR – This SQR will synchronize the tablespace details with the system catalog.
Run ALTERAUDIT – This will synchronize the peopletools tables with the underlying SQL data tables.

Peoplesoft Create Domains

• We had few videos on how to create Application Server and Web Server Domains at this blog. Please refer to that.
• Boot the Domains Web Server, Application Server, Process Scheduler (After configure Report Nodes).
• Login to PIA (URL - http://servername:http_port/sitename/signon.html
  

Done.

Retrieve Dropped table in Oracle

A small post explaining how to retrieve dropped table from Oracle database:

1) When a table is drop with the DROP Table command the table is still there in Recycle bin until it's purged explicitly. 

The recycle bin is actually a data dictionary table containing information about dropped objects. You can turn it ON or OFF as required. To check the status of recycle bin below is the SQL Statement

SQL> SHOW PARAMETER RECYCLEBIN;

NAME        TYPE      VALUE

————————————
recyclebin    string           on

To turn Off the recyclebin

SQL>ALTER SYSTEM set RECYCLEBIN=OFF; (In Oracle 10g)

2) Retrieve dropped table from recyclebin

SQL> select OBJECT_NAME, ORIGINAL_NAME, TYPE from recyclebin

ORIGINAL_NAME is the original table that is dropped.

SQL> FLASHBACK table table_name to before drop;

Also, Index name needs to be restored to their original names;

Application Server Configuration Files

This post explains in short about the configuration files that get's created when we create an application server domain.

PSAPPSRV.CFG - This is one of the important configuration files for peoplesoft application server to get started. It contains the entire information of the configured application server domain.

PSAPPSRV.UBB - This is a file which stores the domain values that is required for tuxedo configuration loader executable (tmloadcf.exe) to run. With tmloadcf.exe this file is compiled to retrieve the domain values.

PSAPPSRV.UBX - This is a template or in simple terms a copy of PSAPPSRV.UBB file. After the domain is edited using the PSADMIN utility for some reasons this is the file where the changes for the environment settings are stored.

PSAPPSRV.ENV - This holds the information of the Installed PS_HOME, it's environment information, etc

PSAPPSRV.VAL - This is a file which contain the format details for the configuration parameters, that as set with some valid values as specified in this file. This file get's called with the message for any invalid values if tried to set in the system while domain configuration.

PSTUXCFG - This is tuxedo configuration files which holds the information regarding the location of tuxedo executables, files, and commands needed to run the server process of application server.