OraMag interview

Just a quick note, my interview in OraMag for Jan-Feb 2007 is out ;-)

PeopleTools 8.48 prerequisites

Our OS is AIX5.2.
Installation of PeopleTools 8.48 patch 04 without problem.
Unfortunately, configuring the AppServer abort :

/exec/applis/r5a8/G1R0/ETU_FS/hrms89/app/appserv> psadmin
PSADMIN -- Tools Release: 8.48.04
Copyright (c) 1988-2005 PeopleSoft, Inc. 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 :TESTPT48

Configuration templates:

1) developer
2) large
3) medium
4) small
Select config template number: 4

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: TESTPT48

Features Settings
========== ==========
1) Pub/Sub Servers : No 15) DBNAME :[TESTPT48]
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): 13

Performing load prechecks ...
exec(): 0509-036 Cannot load program ubbgen because of the following errors:
rtld: 0712-001 Symbol _Getctype__FPCc was referenced
from module /exec/applis/r5a8/G1R0/ETU_FS/hrms89/app/bin/libpsmt.a(), but a
runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol __ct__Q2_3std8_LocinfoFPCci was referenced
from module /exec/applis/r5a8/G1R0/ETU_FS/hrms89/app/bin/libpsmt.a(), but a
runtime definition
of the symbol was not found.
rtld: 0712-002 fatal error: exiting.

==============ERROR!================
UBBGEN encountered an error while configuring!
==============ERROR!================
After some research, undocumented prerequites about C-libraries.
Our is :
/exec/applis/r5a8/G1R0/ETU_FS/hrms89/app/appserv> lslpp -l | grep rte | grep xlC
xlC.aix50.rte 6.0.0.13 COMMITTED C Set ++ Runtime for AIX 5.0
xlC.msg.en_US.rte 6.0.0.0 COMMITTED C Set ++ Runtime
xlC.rte 6.0.0.0 COMMITTED C Set ++ Runtime
/exec/applis/r5a8/G1R0/ETU_FS/hrms89/app/appserv>

And it should be
xlC.aix50.rte.8.0.0.1 or later
xlC.rte.8.0.0.0 or later

Well, waiting for an install.

Linux distro choice

You want to install a linux distro. But what distro is for you ?
The Linux Distribution Chooser is a website which can help you in the distro choice. Without to be exhaustive, it can help for the linux beginners.

Bundles installation

Before the Change Assistant, the bundles installation was nightmare, because of there was only manual steps. And as a bundle is a set of corrections, there is several steps.

Now, with Change Assistant, there is less manual step, but the time of installation is now incredible long. One day per bundle, imagine, when we have to instal several bundles... In fact, the change assistant lose too many time in file transfer : open/close a ftp connection for each file to have to transfer. It's very consume time.

One solution is to stop the process during the automatic ftp, run it manual, set to complete these steps, and restart the Change Assistant.

Anyway, even the project installation, the datamover running and the sql seems to be slower than manual.

One advantage of auto step, you can read the newspapers (professional newspapers, of course), and learn by OTN forum participation. ;-)

PeopleSoft Installation : what required

In order to install a PeopleSoft application, we need to choose a database.
Oracle seems a good choice, even if the development was (still is ?) in most of case on SQL Server...
Then Tuxedo, and a webserver like Weblogic.
The choice of PeopleTools version, actually the last version is 8.48 (new from July), can be deciding what you can, and how many time your application can live without a big upgrade.

You can download all softwares (main version, not upgrade) on http://edelivery.oracle.com/ (unfortunately a http server, so download can be long) and patches on the ftp server ftp.peoplesoft.com (anonymous user).

I advise the reading of the white paper PeopleSoft Enterprise Architecture for more understanding.

Copybase and PSCA

The copy of a database is one of the tasks of a PS admin : to reinit a database from a reference database, to test bundle for example.
But some tasks mustn't be forget.

PSCA - PeopleSoft Change Assistant - is the new assistant to manage upgrade since 8.4x PeopleTools.
Before it was PSUA - PeopleSoft Upgrade Assistant - which was more a informational guide rather than a real assistant.
Since 8.4x PeopleTools, this new tool is very nice to help in bundles/patches/fix installation, there is only few manual tasks.
PSCA work by PS_HOME and by database. He needs a unique identifier into database, this is GUID column from PSOPTIONS table.
This field, not nullable, is initialize on start of the application server only if he's blank value.
So, after a copy of database, DON'T forget to update this field, without what, PSCA will not see your database in your environment, and you will lose some of time to search why...
SQL> select guid from psoptions;

GUID
--------------------------------------------------------------------------------
d96d2afa-1dd1-11b2-9e1f-dbeeda0b41ec

SQL> update psoptions set guid= ' ';

1 row updated.

SQL> commit;

Commit complete.

Here I restart the appserver, then :
SQL> select guid from psoptions;
GUID
--------------------------------------------------------------------------------
ae7099f4-1dd1-11b2-8d5a-fe9855e7faff

SQL>

We will see later that there are some of update after a copy of database, this one today, is only one of these tasks.

PeopleSoft and LONG datatype

Somebody knows when PeopleSoft will stop to use LONG datatype, even into the very last version, there is too much these ones :

SQL> select count(distinct table_name)
    from user_tab_columns
    where data_type = 'LONG'
SQL> /

COUNT(DISTINCTTABLE_NAME)
-------------------------
2085

SQL>

First message - presentation

Well, I launch my own blog today. It was a long reflexion, because I had some doubts about time to update blog, what I will write etc.
Finally, I'm decide to write and will see...

About me :
I'm working since 1995, first on an old system GCOS8, cobol and IDS2 database...
In 1998, I switch into Oracle world with a migration project on Oracle Application as a developper.
Later, in 2000, I start with analyze/conception then as admin Oracle.
And from 2002, I'm working as Oracle DBA in a PeopleSoft environment. As an Oracle consultant, I realize some time short missions for clients (backup/restore solution, performance problem, migration, etc.), but my main job is for a PeopleSoft client.
Now, I'm a technical support for development and production teams.

About this blog :
Mainly around the Oracle database, but as my job is in a PeopleSoft environment, I will try to write about PeopleSoft.
About PeopleSoft, it will be only from a technical point of view, I never will say about fonctional - which I don't know - but about : new release, installation of tier party (tuxedo, weblogic, crystal reports), peopletools, application module, what are the tasks of a PS administrator (copybase, security etc.).

Note :
This blog is under my own responsibility, what I write here never engaged Oracle or my company.
As you could see above, the english is not my mother tongue, so I'm sorry in advance if some word or grammar are not as well.
All remarks are welcome.

Good reading,