Sunday, January 27, 2008

On The Peoplesoft Road : Peoplesoft Database creation - Part III

The easiest part, and the shortest, the post-requisites :
1. Run application engine from your client, go to $PS_HOME/bin/client/winx86:
psae -CD DMOHRMS9 -CT ORACLE -CO PS -CP PS -R INSTALL -AI VERSION
***note CD => dbname, CT => dbtype, CO => user, CP => pwd, R => run control, AI => AppEngine name***

2. Run the $PS_HOME\sqr\SETSPACE.SQR from your client $PS_HOME\bin\sqr\ORA\BINW\sqrw.exe
Use the SYSADM user, and parameter -ZIFE:\apps\psoft\hrms9\sqr\pssqr.ini (replace E:\apps\psoft\hrms9 by your PS_HOME string)

3. Take a backup of your database.

Check the number of objects against your SYSADM's schema :
SQL> conn sysadm/sysadm
Connected.
SQL> select count(*), object_type from user_objects group by object_type;

COUNT(*) OBJECT_TYPE
---------- -------------------
2592 LOB
14 TRIGGER
25921 TABLE
30245 INDEX
18120 VIEW


Now, going on AppServer...

8 comments:

Anonymous said...

psae -CD DMOHRMS9 -CT ORACLE -CO PS -CP PS -R INSTALL -AI VERSION

when I run the above code ... I got an error:
Message Set Number: 0
Message Number: 0
Message Reason: Invalid User ID and password for signon. (0,0)
Error in signon

Please what could possibly cause this?? And what is the solution?

PeopleTools System database was installed and Data Mover scripts run successfully.

Gasparotto Nicolas said...

A PeopleTools System database does NOT have PS application user.
Try to use PTDMO instead.
What are you trying to achieve ? If you are installing an application, then you are wrong, PeopleTools System database is Peopletools objects/data only ! For an Peoplesoft application you should choose DEMO (wit hsample data) or SYS (empty of data sample).

baby said...

Excellent Document. and Very Easy to understand.since i had very little knowledge about Administration. I had Successfully Installed. This is far easy then any other documents.thanks lot

Anonymous said...

Great document. I've used this several times, because it is much better than the official Oracle document. Thank you for posting this.

Anonymous said...

Hi Nic,

when I run this query below I got this:

SQL> select count(*), object_type from user_objects group by object_type;

COUNT(*) OBJECT_TYPE
-------- -----------
2432 LOB
10 TRIGGER
24836 TABLE
28732 INDEX
18120 VIEW


Which I see is not the same as yours ... does that mean some objects were missing?


Texas!

Anonymous said...

I install peopletools without application. After I create database, I run version application engine program:
C:\Documents and Settings\Administrator>C:\pt\bin\client\winx86\psae.exe -CD PSDB -CT ORACLE -CO SYSADM -CP SYSADM -R INSTALL -AI VERSION
Message Set Number: 0
Message Number: 0
Message Reason: Invalid User ID and password for signon. (0,0)
Error in sign on

PSDB: database name
SYSADM: peoplesoft owner id

I can login in data mover by SYSADM user or people user and the database and listener is running. I change the user to try, it’s the same.

Gasparotto Nicolas said...

What about PS instead of SYSADM to run AE ?
Have a look to your (?) thread on OTN forum :
http://forums.oracle.com/forums/thread.jspa?messageID=3485302#3485302

Anonymous said...

Hi I installed peopletools 8.49, database FSCM application 9.0 and weblogic and tuxedo, everything is working fine, when i try to run the setspace.sqr i get the error "(SQR 4713) Cannot open the #INCLUDE file: 'setenv.sqc'". Kindly assist.