PeopleTools: Publish/Subscribe Servers Crashing Intermittently on Oracle 10.2.0.1

After upgrading the DBMS server to Oracle 10.2.0.1, the application server publication/subscription servers crash intermittently.
The following is an example shown in app server log.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:54:59](0) Unhandled exception occurred. Writing crash dump to PSPUBDSP_dflt.8912\dump
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 1400.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 3123.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 2206.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 3803.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 2253.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 3082.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) PSAFFIRM(!nSqlRecurse) failed at f:\pt84605b-retail\peopletools\SRC\pssam\samlib.cpp, line 2037.
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) SQL error. Stmt #: 2475 Error Position: 28 Return: 24909 – ORA-24909: call in progress. Current operation cancelled
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](1) GenMessageBox(200, 0, M): f:\pt84605b-retail\peopletools\SRC\pspubsub\pubsubdispatcher.cpp: SQL error. Stmt #: 2475 Error Position: 28 Return: 24909 – ORA-24909: call in progress. Current operation cancelled
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](0) Sam SqlError: SELECT TO_CHAR(SYSDATE,’YYYY-MM-DD-HH24.MI.SS.”000000″‘) FROM PSCLOCK
PSPUBDSP_dflt.8912 (0) [02/17/06 11:55:02](1) GenMessageBox(200, 0, M): SQL Access Manager: A SQL error occurred. Please consult your system log for details.

But there is nothing specific in crash dump.

On the application server box the database client is at Oracle 10.1.0.1 while the database server had been upgraded to 10.2.0.1. Peoplesoft requires that the database client and server are on the same patch level.
In this case, applying the Oracle 10.2.0.1 patch to the database client on the application server resolved the issue.

The following are some notes for Oracle 10g patches for PT8.46.

Note, after applying the patch the libclntsh lib will need to be re-generated.

NOTE: Problems applying the Oracle Patch. The following instructions, provided by Oracle database group, resolved the install problem.
1. Make backup copies of 4425566/etc/config/actions and 4425566/etc/config/inventory
2. Edit 4425566/etc/config/actions, change two occurrances of the string “oracle.rdbms” to
“oracle.client”
3. Edit 4425566/etc/config/inventory, change one occurrance of the string “oracle.rdbms” to “oracle.client”
4. Retry “opatch apply”
____________________

For Oracle 10g
The minimum version of Oracle 10g and patches required for PT8.46 are:
For all Platforms but HP-Itanium and Windows Oracle 10.1.0.3.0 + (Merged patch 4113001 comprised of one-off patches 3612581 and 3907008) will be the minimum requirement.
For Windows 32bit Oracle 10.1.0.3.0 + (Patch# 4074232) which is a cumulative patch that includes patches 3612581 and 3907008) will be the minimum requirement.
For Windows 64bit Oracle 10.1.0.3.0 + (Patch# 3990812) which is a cumulative patch that includes patches 3612581 and 3907008) will be the minimum requirement.
For HP-Itanium Oracle 10.1.0.3.0 + (Merged patch 4113001 comprised of the following one-off patches 3612581, 3907008, and 3975759) will be the minimum requirement.
HP-Itanium Oracle 10.1.0.4.0 patchset + (Interim patch# 3975759) Note: These minimum requirements apply to both the Server and Client installations.

Patch#4113001 comprised of one-off patches 3612581 and 3907008 addresses the following issues.

Patch# 3612581 addresses randomly generated ORA-00600 error messages and core dumps when running SQR with Oracle 10g.

Patch# 3907008 addresses a problem of writing a specific range of Unicode characters into a column.

Patch# 3975759 addresses a problem of connecting to the DB server via the Oracle client library on the HP-Itanium platform only. This patch was originally generated for Oracle patchset 10.1.0.2.0 and subsequently rolled up into a bundled interim patch# 4113001 to be applied on top of the 10.1.0.3.0 patchset. This interim patch# 3975759 did not get rolled up into the 10.1.0.4.0 patchset for the HP-Itanium platform. Need to apply interim patch# 3975759 to the 10.1.0.4.0 patchset for the HP-Itanium platform.