Friday, May 8, 2009

7.3 Peoplesoft Database creation part III

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

No comments: