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...
psae -CD DMOHRMS9 -CT ORACLE -CO PS -CP PS -R INSTALL -AI VERSION
ReplyDeletewhen 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.
A PeopleTools System database does NOT have PS application user.
ReplyDeleteTry 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).
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
ReplyDeleteGreat document. I've used this several times, because it is much better than the official Oracle document. Thank you for posting this.
ReplyDeleteHi Nic,
ReplyDeletewhen 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!
I install peopletools without application. After I create database, I run version application engine program:
ReplyDeleteC:\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.
What about PS instead of SYSADM to run AE ?
ReplyDeleteHave a look to your (?) thread on OTN forum :
http://forums.oracle.com/forums/thread.jspa?messageID=3485302#3485302
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.
ReplyDelete