Bob, What is the status of this issue on T2000? Were you able to resolve it? ... Is that a batch job? If not, how are you scheduling it to run on the DB ...
We were not able to resolve the performance issue with the T2000, thus, we put all tiers on the V490 database servers. The web and app server processes really...
Hi all - I am interested in how your organization splits Roles and Responsibilities between the PS Admin and the DBA. We are running 8.9 HR and Payroll. Who...
Hi, In our place, we split the responsibility between psoft admin and dba. I am a dba (learning to be psoft admin as part of the psoft 9 upgrade going in our...
At our place, we have combined the two roles to increase the number of support people covering the systems, making holiday and out of hours support easier to...
In a previous job, I was the PS admin and not the DBA. Since the PeopleSoft system owned the data, the PS admin had the sysadm (schema owner) password and...
We are looking to move from Sun SPARC servers running Solaris to Intel based servers running Linux. I would be very interested in what Intel based servers...
I have seen many models... At one (very small) company, I was the dba, Unix admin and PS admin. At another company, I was the PS admin, but I had root access...
We have been running on OEL 4.5 with Oracle 10.2.0.3 on DELL 2950's now for about 6 months supporting an upgrade to PS HR89 / PeopleTools 849. With the Install...
Many employers do have many different models, as I have seen as well, however the model that works the best for the support of PeopleSoft (or any other vendor...
HELP!!!!!! I've fallen and I can't get up!!! OK, I have 3 direct connect vendors. One of them decided to change their "digital certificate" because the one...
Hi Clark, When you say direct connect what exactly do you mean? Do they connect to PeopleSoft or do you have a content ref pointing to the vendor? Or ...
Bob, Direct connect is a method to punch out to a client site. Using integration broker and e-procurement setup, the user is able to create a requsition from...
So it looks like it's the public key and probably the trust for the CA . PeopleTools, Security, Security Objects, Digital Certificates. Create a new row as...
Hi Friends, I want to know 1.how / what to query to find the PS Queries created in Database (oracle or Db2 (such as Name of Query, Owner,Date of creation)). ...
Queries are held a various pieces of meta data held in the PSQRY% tables. Start with PSQRYDEFN. However, you will not be able to list the SQL in the queries -...
Q-1) how/what to query to find the PS Queries created in Database (oracle or Db2 (such as Name of Query, Owner,Date of creation)). A-1) SELECT DISTINCT...
Renu, If you have run it once and would look up the database table v#sql ( you may not have privileges) - contact you dba it is stored as sql_ext. hope this...
Robert , - thanks - but that didn't work. I created a Root CA for the vendor, imported their root certificate and bounced everything and I am still getting...
The root certificate needs to be installed to provide a path to trust the web server certificate. I would guess the emarketplace.... certificate is their web...
The original error I get is this : OK, have to put it in a word attachment... At the bottom of this thread I have posted the actual error messages from...
OK, got rid of the old one - evidently PS didn't like when I came through the virtual server and I had to pick one of my load balanced servers and log directly...
Robert, This issue is resolved - the method you were suggesting, Robert, was the correct one for a gateway that started with https://, but for one that is just...
We have turned ON query access listc caching and have found that if you add or remove a role from a user that the version number of the QAL control gets...
Hi all, Â We have two PeopleSoft environments. With the following settings in init.ora (just the difference appears here). Â ENV1 db_16k_cache_size: 150M ...
There is more to speed than init settings, although if you could make the setting the same, then you could eliminate those as a bottleneck. What are the...
Hi, Our client has reported apperv is not avaiable this morning around 9:00 am. The problem was immediately went away later. I checked the appser log and found...
my gut feel would be a network hiccough. But, who knows. You've given us no information about your paltform and environment, so it could be anything from...
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.
