Hello All, Just a quicky, does anyone use the Payroll Interface for ADP connection that is mentioned in customer connection. We are looking at possibly using...
Sure are. And lets leave it at that. Dick Goulet Senior Oracle DBA/Oracle Certified 8i DBA ____________________Reply Separator____________________ Subject:...
dgoulet@...
Feb 11, 2003 5:58 pm
57
At the recent PSFT UK Tech SIG I asked for a show of hands for which webserver were people using. The result was that the vast majority were using weblogic. ...
Hello, I saw from the poll results on David's forum that there are still some of you that run PeopleSoft on the apache webserver. We currently have a big...
Pierre, We are actually using the Weblogic webserver, so I don't know much about the Apache. Did you look in the www.PeopleSoft.com discussion groups and on ...
Hi, I would like to know what to do to change SYSADM password. I know i must change the database password of SYSADM (RDBMS=Oracle for me) and the Access...
Hi, I've read from the paper "PeopleSoft for the Oracle DBA", that it is not advisable to make PSTEMP a temporary tablespace bc Peoplesofts stores some tables...
SYSADM, or whatever schema owner id you are using, shouldn't exist anywhere on the webserver. The only possibility is if you're using the id for a batch...
Hi, With PTools 8.18, just need to use Access Profile. But with Ptools 8.41, changing the Access profile does not change the password of the user SYSADM in the...
Peoplesoft temporary tables (ending in TMP) are "permanent" as far as Oracle is concerned, and reside in a tablespace which must be defined as permament....
Thanks Sean. I understand : PSTEMP must be a permanent tablespace for Oracle because Peoplesoft stores some Oracle tables in in a temporarily manner. Can I...
Not all Peoplsoft installations necessarily have a PSTEMP tablespace, you can name it want you want. But by default it's used to house the _TMP and _TAO...
In 8.41 PTools, ddlspacename is no longer a field in psrecdefn. Henry ... tablespace, you can name it want you want. But by default it's used to house the _TMP...
Hi We run the script below in Datamover after changing at Oracle level. Rgs Shirley update PSSTATUS set OWNERID = 'SYSADM'; update PSOPRDEFN set SYMBOLICID =...
... With PT 8.18 : SQL> select RECNAME,DDLSPACENAME from psrecdefn where DDLSPACENAME='PSTEMP'; no rows selected => So I don't need to have a permanent...
Hi, I would like to have feedback/experience about PS with a Oracle database with Loc. Managed Tablespaces ? Do you use autoallocate ? It seems difficult to me...
Just wondering if anyone is using Data Guard or standby database with PeopleSoft. We are interested if there are problems or pitfalls in using the above two....
Just wondering if anyone is using Data Guard or standby database with PeopleSoft. We are interested if there are problems or pitfalls in using the above two....
Henry, Worked with it a bit while tuning a WF process that was running long in a HR environment. PeopleSoft was called in to help and after initial look at...
James, LMT should help with performance if there is contention for ST enqueues. ( a Space Transaction enqueue. Basically a data dictionary lock used when...
We are using Data Guard (8.1.7.2 oracle version), on all of our production Oracle DB's - some Peoplesoft, some not. It works fine. We had Oracle sales out...
Thanks Shirley The procedure you describe is only for "PT 7.03 and 7.52 and below" and for "2 tier env" only. I have a "Pure Internet Architecture" . What is...
Henry, It was a few years ago and I wasn't that close to the Oracle end of things. I was just relaying the fact that during this tuning exercise of WF, we saw...
Hello I haven't recreated PeopleSoft delivered tables as LMTs in a production environment, but that is mainly due to not getting there early enought. I have...
David, A small remark. As far as I can see Oracle does not fully ignore the initial size when a table is created. I tried to create a table in a local managed ...
Ken, as of today pt 8.1.8 with OS of AIX 4.3.3 Go to PeopleSoft connection and check the DBMS certification list. If you don't mind, send me all the scripts...