PeopleTools 8.49.22 with Oracle 11gR2
1002377Apr 10 2013 — edited Apr 12 2013Hello. We have an installation of peoplesoft using peopletools 8.49.22 with Oracle 10.2.0.4.0 on Solaris 10
Recenlty the DBAs are migrating the databases to Oracle 11.2.0.3.0. Our demo database was upgraded and they installed the Oracle Client 11.2.0.1 in our unix and windows servers.
In the peoplesoft installation I just pointed to the new oracle home. However we cannot boot the application server and process scheduler in unix and windows, they show this error:
File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 8097 - Oracle initialization error
In Oracle Support i found that we need to install an older oracle client (11.1.x ) in order to make it work.
I installed the 11.1.0.6 and yes both application an process scheduler boot OK, and we were able to navigate the application and send sqr, AE, cobol, etc.
BUT the problem is that our DBA team says that we MUST use the client 11.2 , and the ITIL group says that the combination of 8.49 with 11.2 is certificated in Oracle site.
So i write to all you to ask if someone in the community is using the above combination and what steps were done in order to make it work.
Thanks in advance.
JRAL