tag:blogger.com,1999:blog-31216575.post3794413324584492550..comments2024-01-27T07:32:53.464+01:00Comments on On The Peoplesoft Road: On The Peoplesoft Road : Peoplesoft Database creation - Part INicolas Gasparottohttp://www.blogger.com/profile/06634519580752248909noreply@blogger.comBlogger29125tag:blogger.com,1999:blog-31216575.post-33421071449833357342023-12-21T05:58:56.949+01:002023-12-21T05:58:56.949+01:00Nice information. Visit SafePaaS, We offer you a n...Nice information. Visit SafePaaS, We offer you a new application-<a href="https://www.safepaas.com/control-risk-in-peoplesoft/" rel="nofollow"><b>risk management for PeopleSoft</b></a>, which unlocks new opportunities to show the impact of freight costs on your profit margins.SafePaaShttps://www.blogger.com/profile/03305799996908541715noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-19187705922737726992015-12-28T10:25:43.956+01:002015-12-28T10:25:43.956+01:00cannot create spfile already being used by the ins...cannot create spfile already being used by the instance?? Mean what?? <br /><br />Iam ask questions of create spfile <br />from pfile =c:\app.\...\...\pfile\initcsdev90.oraRAFIUDDEENhttps://www.blogger.com/profile/00979326359571133071noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-29728917773929937612012-09-04T10:34:35.545+02:002012-09-04T10:34:35.545+02:00Hi Nicolas, I am installing PeopleSoft HRMS 9.0 wi...Hi Nicolas, I am installing PeopleSoft HRMS 9.0 with PT 8.50 on personal laptop. I am at Step 15, where we need to run the DMS scripts. Since I am installing on laptop, I do not have a client m\c. So how should I go about running the DMS? The PS guide tells something about telnet seeion, but I am not able to actually understand it.Nehanoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-76939914399944974312012-07-22T04:11:24.275+02:002012-07-22T04:11:24.275+02:00Hi
I instaling PT849 and got below error during m...Hi <br />I instaling PT849 and got below error during manual database creation.<br />Logged into Datamover bootstrap mode with SYSADM and selected 'Database Setup' --> Demo. auto generated script cameup. When I executed the script got below error. Please help how to proceed from here.<br /><br />5<br /> Updating statistics for GP_FORMULA<br />Records remaining: 10832<br />Importing GP_FORMULA_CLUE <br /> Creating Table GP_FORMULA_CLUE <br />File: e:\pt849-905-R1-retail\peopletools\SRC\pssys\gendttm.cppSQL error. Stmt #: 192 Error Position: 62 Return: 942 - ORA-00942: table or view does not exist <br />Failed SQL stmt:SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD-HH24.MI.SS."000000"') FROM PSCLOCKHarinoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-16343585794681565732011-12-29T10:32:36.692+01:002011-12-29T10:32:36.692+01:00Hi,
This krish.I am searching for job as psadmin....Hi,<br /> This krish.I am searching for job as psadmin.can u tell me which type of quations asked in interviw.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-67987277714423454542010-08-05T17:49:39.569+02:002010-08-05T17:49:39.569+02:00Hi Nicolas,
I a new to PS, I am installi...Hi Nicolas,<br /> I a new to PS, I am installing PT8.49, HRMS9.0 v1 in Oracle10g, Win2003.<br /><br /> I got struck in creating datbase, I am using peoplesoft database configuration wizard to setup the database. It got struck with error.<br /><br />Importing AV_MBR_ORG_TBL <br /> Creating Table AV_MBR_ORG_TBL <br />SQL Error. Error Position: 34 Return: 8007 - Insufficient memory available<br />INSERT INTO PS_AV_MBR_ORG_TBL ....<br />Error: Unable to insert row 2<br />Error: SQL execute error for AV_MBR_ORG_TBL <br /> SQL Spaces: 0 Tables: 335 Triggers: 0 Indexes: 404 Views: 0<br />Ended: Thu Aug 05 20:31:43 2010<br />Unsuccessful completion<br /><br />I tried it several times, however i got struck at this point. <br /><br />I need your help to figure out the issue.<br /><br />Thanks<br /><br />RajeshAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-14259387854194573992010-02-17T18:39:34.369+01:002010-02-17T18:39:34.369+01:00PADDL.SQL is creating the tablespaces for Entrpris...PADDL.SQL is creating the tablespaces for Entrprise Portal, it should take place at step 9 instead of HCDDL.SQL (my case was on HRMS).<br />So, you should run it before load the Peoplesoft objects.<br />You don't need to PTDDL.SQL which is used for a Peopletools System Database (Peopletools objects only without Application).<br /><br />Nicolas.Nicolas Gasparottohttps://www.blogger.com/profile/06634519580752248909noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-32068190027623204392010-02-17T18:18:39.583+01:002010-02-17T18:18:39.583+01:00Hello.
Thanks so much for posting this info.
I a...Hello.<br /><br />Thanks so much for posting this info.<br /><br />I am installing on Windows XP/Oracle 11G. I am building the PeopleSoft database (Tools & Application have been installed) and executing the sql scripts to build the database.<br /><br />I have executed the following scripts.<br /><br />utlspace.sql <br />dbowner.sql <br /><br />I am ready to execute the PADDL.sql script but wanted to know at which part of the process I should execute the PTDDL.sql script? I created the database instance through DBCA.<br /><br />Thanks!!Alex Lozanohttps://www.blogger.com/profile/15040429876380855582noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-28042227991319548202009-12-04T01:57:06.824+01:002009-12-04T01:57:06.824+01:00Hi Nicolas,
I have successfully installed oracle 1...Hi Nicolas,<br />I have successfully installed oracle 11g R2, PT8.50 on OEL 5.3 on VMWare Server. I am running Database setup import script in datamover from my host windows machine , its been running since 3 days and the script didnt finished, I have added all the required recommended parameter to init.ora file but there is no improvement. Please give me any more suggestions on how can I improve this import script performance. Please let me know if you need any more information. Thanks in advanceshivanoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-64190171281993035162009-11-13T07:20:30.298+01:002009-11-13T07:20:30.298+01:00Hi, guys..you blog has really helped me run the PS...Hi, guys..you blog has really helped me run the PSOFT installation fromscratch. Thanks for your work. But I am stack at this point;<br />1) When I log in Data Mover as either PS/PS or sysadm/sysadm i get an <br />"File: E:\pt850-903-R1-retail\peopletools\SRC\pssys\stmget.cppSQL error. Stmt #: 2722 Error Position: 39 Return: 904 - ORA-00904: "DBNAME": invalid identifier <br />Failed SQL stmt:SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1" error but I used the Configuration manager to set them.<br />2) when i run psadmin.sql it run well but later gives me;<br />ERROR at line 1:<br />ORA-00942: table or view does not exist.<br />3) i do not know your step 3. Ensure your NLS_LANG env variable is set correctly. how to set the NLS_LANG .my is english. <br />and oracle is english and also how to set the password file.<br />I am using oracle 10g and FSCM 9.0 and PT 8.50<br />Also my domain is not booting. It always gives me the error that my appserv cannot connect to my database. But is the same user/password to log into the database.<br /><br />Can you send me an email(hubert_boateng@yahoo.co.uk) to let me know how I will be able to go about it. Thank you very much.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-52956541677000164892009-10-15T06:57:34.205+02:002009-10-15T06:57:34.205+02:00Hello Nicolas..
when I run createdb10.sql I got O...Hello Nicolas..<br /><br />when I run createdb10.sql I got Oracle Not available. I echo ORACLE_SID, it's same with variable I set up on createdb10.sql. <br /><br />Any idea.?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-51900552484973876762009-10-06T16:43:44.582+02:002009-10-06T16:43:44.582+02:00How long it takes to complete the database configu...How long it takes to complete the database configuration wizard, It is more than 1 hrs screen displays executing createdb10.sql and no log file is created yet....<br /><br />How to check whether it is running fine or having any issues...<br /><br />Thx<br />Kiran KumarAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-68989534161444876752009-09-15T11:06:09.088+02:002009-09-15T11:06:09.088+02:00Hi Bruce
3 scripts utlspace, dbowner and xxddl nee...Hi Bruce<br />3 scripts utlspace, dbowner and xxddl needs to be run as sysdba. On the other hand , psadmin and connect.sql should be run as system user. It is recommended by Peoplesoft. If you have ran these scripts than you can run them again using proper user ids. <br />If you are not able to login using PS designer, please share error or any logs if any.Prashanthttps://www.blogger.com/profile/09030497894076288830noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-16718959739270257972009-09-14T17:27:17.107+02:002009-09-14T17:27:17.107+02:00Hi
Oracle's documentation on the manual data...Hi <br /><br />Oracle's documentation on the manual database creation tells us to log into SQL Plus as "the System user" - your blog says to connect as sysdba. We did not do that, connected as system/manager. Do we need to revert and re-run from here? We ran grant.sql but cannot connect using PS as a PeopleSoft operator.<br /><br />thanks,<br />BruceBrucenoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-43557208087559637332009-03-09T20:08:00.000+01:002009-03-09T20:08:00.000+01:00Hi,I have installed application and have created t...Hi,<BR/>I have installed application and have created the database with the scripts you mentioned. Now I am on step 19 and when i choose demo database option, i could not see any database listing and as a result of this the "next" button is not active anymore. When i try the system database, it show me one database option and the next button is also active. <BR/>I have perform every step you mentioned in the peopletools installation and also applied the latest patch (8.49.19) on server and client machine.<BR/>Can you please help me resolving this issue??<BR/>ThanksFarooq Malikhttps://www.blogger.com/profile/15401540944911898633noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-44208871315576114022009-02-19T00:03:00.000+01:002009-02-19T00:03:00.000+01:00Have anybody faced problem like this before..I am ...Have anybody faced problem like this before..<BR/><BR/>I am trying to Copy The Project using Application Designer<BR/>(Tools > Copy Project)<BR/><BR/>As soon as I click on the Copy Project, my app designer closes..<BR/><BR/>Same happens in Data Mover, when I tried to open a file.<BR/><BR/>Any help would be appreciated..<BR/><BR/>PS: I am in the step 4 of Peoplesoft Database creation - Part IIAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-16482005645871505832009-01-20T12:51:00.000+01:002009-01-20T12:51:00.000+01:00Hi Nic, I'm back again. Now everything seems to wo...Hi Nic, I'm back again. Now everything seems to work fine ... I finally installed HRMS9.0 Apps and the database pops up in the Database setup ... but what I'm concerned about now is that it's been running for more than 8 hours now and not yet finished it's around <B>Importing GPCH_TX_RATES</B>.<BR/><BR/>Can you please tell me how long it takes to run and what the size of the DB will be?<BR/><BR/>Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-61378477363226048002009-01-19T11:42:00.000+01:002009-01-19T11:42:00.000+01:00Thanks for your wisdom.I'll do that ... and expect...Thanks for your wisdom.<BR/><BR/>I'll do that ... and expect to hear from me again ...<BR/><BR/><BR/>Regards.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-9417584560368415502009-01-19T11:24:00.000+01:002009-01-19T11:24:00.000+01:00Both directories should be same.If you used D:\PT8...Both directories should be same.<BR/>If you used D:\PT8.49 to installed Peopletools, then you should use D:\PT8.49 for the application installation (do not use different path directory or subfolder).Nicolas Gasparottohttps://www.blogger.com/profile/06634519580752248909noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-42375119768603140122009-01-19T11:20:00.000+01:002009-01-19T11:20:00.000+01:00If you installed Peopletools under D:\PT8.49, then...<B>If you installed Peopletools under D:\PT8.49, then you must installed the application in D:\PT8.49 also ! </B><BR/><BR/>Pleas, I dont understand this ... can you please show me how the directory will look like?<BR/><BR/>D:\PT8.49 .....FSCM9.0 ... does all the content of FSCM9.0 go in D:\PT8.49????? or what????<BR/><BR/>Make it clearer please.<BR/><BR/>Regards.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-81815974183041263092009-01-19T10:54:00.000+01:002009-01-19T10:54:00.000+01:00No, no and no.If you installed Peopletools under ...No, no and no.<BR/>If you installed Peopletools under D:\PT8.49, then you must installed the application in D:\PT8.49 also !Nicolas Gasparottohttps://www.blogger.com/profile/06634519580752248909noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-90627554117709665392009-01-19T10:37:00.000+01:002009-01-19T10:37:00.000+01:00Gasparotto Nicolas said... jmechols, if you don't ...<B>Gasparotto Nicolas</B> said... <BR/>jmechols, if you don't see the crm one with in the database setup, that means you didn't install crm application in same folder as the Peopletools you are running.<BR/><BR/>I'm facing same problem here ... I installed FSCM 9 in PS_HOME but when I'm about to run the Data Mover ... the FSCM database doesn't pop up. My directory looks like this D:\PT8.49\FSCM9.0 ... is this okay??<BR/><BR/>Need some assistance please.<BR/><BR/>Regards.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31216575.post-78451488968086471782009-01-15T03:30:00.000+01:002009-01-15T03:30:00.000+01:00Thanks for the reply. I found out what the problem...Thanks for the reply. I found out what the problem was you have to run the data mover from the directory where the database dumps are. Yesterday I used a link to data mover from Fin file structure so data mover only saw the Fin database dump files. Today I used the data mover exe from the CRM directory and it saw my CRM dump files. Thanks again pass this on to others. CRM 9.0 tools 8.48.11jmecholshttps://www.blogger.com/profile/14511548527892029625noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-2975207249116753002009-01-14T08:11:00.000+01:002009-01-14T08:11:00.000+01:00jmechols, if you don't see the crm one with in the...jmechols, if you don't see the crm one with in the database setup, that means you didn't install crm application in same folder as the Peopletools you are running.Nicolas Gasparottohttps://www.blogger.com/profile/06634519580752248909noreply@blogger.comtag:blogger.com,1999:blog-31216575.post-70714343352163244612009-01-14T04:27:00.000+01:002009-01-14T04:27:00.000+01:00Good information What files does data mover look f...Good information What files does data mover look for when you want to choose a database type. I am having that problem it see my fin but not my crm database which is the one I want to create.jmecholshttps://www.blogger.com/profile/14511548527892029625noreply@blogger.com