How To Administer PeopleSoft 9.2 Application on Virtual Box

by Prashant May 16, 2013
When you deploy any PeopleSoft 9.2 Image on Virtual Box, it installs all the required components like Database, App server, Web server and Process Scheduler. Depending on your choice at the time of installation, SES can be configured too. When you boot this virtual machine, it will start all the above mentioned components automatically and […]
Read the full article →

SQL Profiles in Oracle

by Apurva T. May 16, 2013
Oracle Databases have an interesting concept called SQL profiles. A SQL profile is a set of information for the optimizer, which is specific to a SQL statement. Conceptually, a SQL profile is to a SQL statement what statistics are to a table or an index. The database can use this information to improve execution plans. […]
Read the full article →

PeopleSoft Performance Benchmarks

by Apurva T. May 15, 2013
Performance is one aspect, which can never satisfy a person on. It is just not enough to keep improving the performance. Oracle understands this and regularly releases Benchmark papers on the same. Advantage of using these benchmarks is that the benchmarks show a level of acceptable performance and you can tune your application to meet […]
Read the full article →

How to Find Oracle Hidden Parameters

by Apurva T. May 11, 2013
Oracle has hundreds of initialization parameters, which are hidden and undocumented. Many savvy Oracle professionals are known to commonly adjust the hidden parameters to improve the overall performance of their systems. However, because these are “undocumented” parameters, most Oracle professionals rely on publications such as “Oracle Internals” to get insights into the proper setting for the […]
Read the full article →

PT8.53: How To Install Application Designer from PeopleSoft Virtual Appliance

by Prashant May 10, 2013
After finishing installation of PT8.53 application using Oracle Virtual Box, next thing you would definitely want to do is to configure Application Designer. PeopleSoft Image that you installed also comes with setup files to help you install App Designer very easily. Before you start with installation and configuration of PeopleSoft Application Designer, make sure that […]
Read the full article →

PeopleTools 8.53 : How To Install Oracle Client from PeopleSoft Image

by Prashant May 9, 2013
PeopleSoft Images are a great way to get started with PeopleSoft within couple of hours. PeopleSoft application installed in Oracle Virtual Box VM, may be accessed from the Windows Client machine where developers/DBA might want to use Oracle Client, App Designer, Data Mover for variety of purposes. For PeopleTools Clients like App Designer, Datamover to […]
Read the full article →

Enabling Automated SQL Tuning in Oracle 11g

by Apurva T. May 9, 2013
You need to identify if Automatic SQL Tuning job is enabled and regularly running. Use the following query to determine if any Automatic SQL Tuning jobs are enabled: SELECT client_name, status, consumer_group, window_group FROM dba_autotask_client ORDER BY client_name; If the Automatic SQL Tuning job is enabled, you will see something like this:       […]
Read the full article →

How to Identify User and SQLs in an Oracle database?

by Apurva T. May 8, 2013
This is a very common scenario for a DBA to be in a situation where a DBA needs to find out one of the following: Which user is running which SQL? A particular SQL is being run by which user? A particular user is running which SQL? As it is evident from these questions – […]
Read the full article →

Automated SQL Tuning in Oracle 11g

by Apurva T. May 7, 2013
Oracle Database 11g made it easier for the less experienced to have a shot at SQL tuning, which was earlier considered to be a bastion for veteran SQL tuners. A typical Oracle SQL tuning process had the following steps: Identification of high-resource SQL statements and bottlenecks Generating and interpreting execution plans Extracting data from the […]
Read the full article →

PeopleTools 8.53 – PeopleSoft Homes

by Apurva T. May 6, 2013
PeopleSoft Home refers to a file system location in which artifacts associated with a PeopleTools runtime environment are located. The various PeopleSoft Homes are intended to serve specific purposes. Until PeopleTools 8.50, all file system content related to a PeopleSoft environment was consolidated within the same directory tree, which was referred to as PeopleSoft Home […]
Read the full article →

What is Oracle VirtualBox?

by Apurva T. May 2, 2013
Oracle has been on such a buying and renaming spree that it is difficult to identify the products, especially for those who had worked on one of the products before Oracle bought it. We’ll try to provide you with brief history of Oracle products, so that it help you sink in all the information. Also, […]
Read the full article →

PeopleTools 8.53 – Secure Enterprise Search, SES and Search Framework

by Apurva T. May 1, 2013
Prior to PeopleTools 8.53, search functionality worked by building search engine indexes using custom PeopleCode and Application Engine programs. Each PeopleSoft application used a unique method for creating and maintaining search artifacts like collections and indexes–all of which required search engine-specific calls, commands, syntax, and so on. The PeopleSoft Search Framework consists of PeopleSoft components (pages […]
Read the full article →

PeopleSoft Development Tools

by Apurva T. April 27, 2013
As a PeopleSoft developer, you will havce a variety of tools available to develop and customize a PeopleSoft application. The tools you end up using will depend on the application installed at the place you’re working. Let’s have a look at the PeopleSoft development tools to gain some familiarity. PeopleSoft Development Tools Application Designer Application Designer is the […]
Read the full article →

Performance Tuning by Identifying Poor SQLs using v$

by Apurva T. April 26, 2013
To a user, an application is never fast enough to satisfy his/her needs. Similarly, to a database administrator, an application is never fast enough to satisfy the needs of the user community. Perception and unreasonable expectations are definitely a cause. However, , insufficient hardware, poorly tuned application code, a poorly tuned database, or an architecture that doesn’t […]
Read the full article →

ORA-28002 The password will expire within 7 days. Cannot logon to the database

by Apurva T. April 25, 2013
The error “ORA-28002 The password will expire within 7 days.  Cannot logon to the database” can be encountered when you run any process/job on the process scheduler. Many a times, the error is not limited to while running a job/process on the scheduler – it may show even for a portion of the application that needs […]
Read the full article →

Error: Micro Focus License Manager service is not running

by Prashant April 24, 2013
Trying to run COBOL process from PeopleSoft Process Scheduler and getting ‘Micro Focus License Manager service is not running’ ? In most of the cases it happens when you change or upgrade your windows server on which process scheduler is hosted. Micro Focus License Manager Service is required on run-time systems where compiled COBOLs are […]
Read the full article →

PeopleTools 8.53 : Deploying PeopleSoft ELM 9.2 Image on Virtual Box

by Prashant April 23, 2013
PeopleSoft 9.2 applications comes with demo images for PeopleSoft applications which means now you longer have to install a separate demo environment. Just download the latest version of PeopleSoft Image for your application (HCM,FSCM,ELM,CRM) from ‘PeopleSoft Update Manager Home Page’ on Oracle Support and deploy it using Oracle Virtual Box Manager. I am going to […]
Read the full article →

PeopleTools 8.53 : Install Oracle WebLogic on Windows 7

by Prashant April 23, 2013
Oracle WebLogic is required to install PeopleSoft Pure Internet Architecture (PIA). Download the software from Oracle’s Edelivery site and then install it in 64-bit mode. Note: By default if you run the setup, it will install the WebLogic Software in 32-bit. To Install it in 64-bit mode, you would need to install JDK 64-bit and […]
Read the full article →