Search the web
Sign In
New User? Sign Up
psftdba · PeopleSoft DBA Forum
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 55 - 84 of 3932   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
55
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...
gaffman90 <justin_v_g...
gaffman90
Offline Send Email
Feb 11, 2003
3:49 pm
56
Sure are. And lets leave it at that. Dick Goulet Senior Oracle DBA/Oracle Certified 8i DBA ____________________Reply Separator____________________ Subject:...
dgoulet@...
Send Email
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. ...
David Kurtz
davidkurtz
Offline Send Email
Feb 12, 2003
11:44 am
58
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...
pierrevanelswijk <pie...
pierrevanels...
Offline Send Email
Feb 12, 2003
12:41 pm
59
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 ...
Roger Baker
rogbak_er
Offline Send Email
Feb 12, 2003
2:01 pm
60
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...
litbighor <lehuyluan@...
litbighor
Offline Send Email
Feb 18, 2003
8:53 am
61
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...
litbighor <lehuyluan@...
litbighor
Offline Send Email
Feb 18, 2003
10:53 am
62
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...
CBenson <charles.bens...
cnbenson
Online Now Send Email
Feb 18, 2003
11:42 am
63
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...
litbighor <lehuyluan@...
litbighor
Offline Send Email
Feb 18, 2003
12:10 pm
64
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....
sroderick1@...
sean_roderick
Offline Send Email
Feb 18, 2003
1:24 pm
65
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...
litbighor <lehuyluan@...
litbighor
Offline Send Email
Feb 18, 2003
1:48 pm
66
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...
sroderick1@...
sean_roderick
Offline Send Email
Feb 18, 2003
4:00 pm
67
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...
Henry Poras <hporas@....
hporas
Offline Send Email
Feb 18, 2003
5:33 pm
68
Hi We run the script below in Datamover after changing at Oracle level. Rgs Shirley update PSSTATUS set OWNERID = 'SYSADM'; update PSOPRDEFN set SYMBOLICID =...
shirley.mcgregor@...
oradba33
Offline Send Email
Feb 19, 2003
12:32 am
69
... 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...
litbighor <lehuyluan@...
litbighor
Offline Send Email
Feb 19, 2003
10:10 am
70
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...
litbighor <lehuyluan@...
litbighor
Offline Send Email
Feb 19, 2003
10:16 am
71
Thanks Shirley. Can you explain the lines "encrypt_password *;" ? I understand SQL but not "encrypt_password *;"....
litbighor <lehuyluan@...
litbighor
Offline Send Email
Feb 19, 2003
10:20 am
72
LMTs really add more to ease of administration rather than a benefit in performance. See the following article from Jonathan Lewis ...
Henry Poras <hporas@....
hporas
Offline Send Email
Feb 19, 2003
3:01 pm
73
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....
Ron Cetnar
rcetnar
Offline Send Email
Feb 19, 2003
4:46 pm
74
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....
rcetnar <rcetnar@...>
rcetnar
Offline Send Email
Feb 19, 2003
4:46 pm
75
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 De Atley
jamesdeatley
Offline Send Email
Feb 19, 2003
5:13 pm
76
James, LMT should help with performance if there is contention for ST enqueues. ( a Space Transaction enqueue. Basically a data dictionary lock used when...
Henry Poras <hporas@....
hporas
Offline Send Email
Feb 19, 2003
10:04 pm
77
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...
shirley.mcgregor@...
oradba33
Offline Send Email
Feb 20, 2003
12:17 am
78
I'm not a Peoplesoft "technical" person, so I'll point you at a link that explains things a lot better than I can...... ...
shirley.mcgregor@...
oradba33
Offline Send Email
Feb 20, 2003
1:42 am
79
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...
litbighor <lehuyluan@...
litbighor
Offline Send Email
Feb 20, 2003
8:54 am
80
Data Guard / Standby DatabaseRon, good morning ( uk time ). We run peoplesoft 8.18 on AIX 4.3.3 using oracle 8.1.7.4. We have a server running...
Ken Warren
bunnyboing
Offline Send Email
Feb 20, 2003
11:03 am
81
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...
James De Atley
jamesdeatley
Offline Send Email
Feb 20, 2003
2:01 pm
82
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 Kurtz
davidkurtz
Offline Send Email
Feb 20, 2003
9:57 pm
83
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 ...
Pijnappels, Marc
mirmar25
Offline Send Email
Feb 21, 2003
11:18 am
84
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...
Ron Cetnar
rcetnar
Offline Send Email
Feb 21, 2003
2:55 pm
Messages 55 - 84 of 3932   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help