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 : 11) Analytic Servers : Yes 25) JSL Port : 12) Domains Gateway : No 26) JRAD Port : 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 184.108.40.206 COMMITTED C Set ++ Runtime for AIX 5.0 xlC.msg.en_US.rte 220.127.116.11 COMMITTED C Set ++ Runtime xlC.rte 18.104.22.168 COMMITTED C Set ++ Runtime /exec/applis/r5a8/G1R0/ETU_FS/hrms89/app/appserv>
And it should be xlC.aix50.rte.22.214.171.124 or later xlC.rte.126.96.36.199 or later Well, waiting for an install.
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.
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. ;-)
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).
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;
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.