Skip to Main Content

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PeopleTools 8.49.22 with Oracle 11gR2

1002377Apr 10 2013 — edited Apr 12 2013
Hello. 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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 10 2013
Added on Apr 10 2013
7 comments
422 views