E-AS: PSAPPSRV Process Failes to Boot With - " Return: 8097 - Oracle initialization error"

(Doc ID 1614967.1)

Last updated on OCTOBER 22, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.


PSAPPSRV server fails to start when booting up a Tuxedo Domain. The following error is logged to the APPSRV LOG file:

SQL Access ManagerSQL error. Stmt #: 2  Error Position: 0  Return: 8097 - Oracle initialization error

The Following messages are logged to the PSAPPSRV tracesql file:

PSAPPSRV.2960 (0) 1-3      13.44.03    0.001000 Cur#0.2960.F92DMO RC=8097 Dur=0.001000 Create Connection Info=Primary/F92DMO/people/ Handle=0000000000000000
PSAPPSRV.2960 (0) 1-4      13.44.03    0.011000 Cur#0.2960.F92DMO RC=-1 Dur=0.000000 XER rtncd=3 msg=
PSAPPSRV.2960 (0) 1-5      13.44.03    0.000000 Cur#0.2960.F92DMO RC=0 Dur=0.000000 ERR rtncd=8097 msg=Oracle initialization error


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms