This discussion is archived
8 Replies Latest reply: Dec 2, 2013 5:50 AM by 9709df4d-e746-4b20-a0f2-b1cabe6a238c RSS

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

9709df4d-e746-4b20-a0f2-b1cabe6a238c Newbie
Currently Being Moderated

I have installed People tool 8.53 with 64bit db, 32bit client. Oracle path and the pointing to db in regedit are proper with only one db home with 32bit path,also 32bit path is include in the beginning in environment variable. I am able to log into db through sqlplus using proper sid, also able to login into Application designer with PS as userid and password.

But when i try to create and boot app server I receive the below error:

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

PSAPPSRV.3228 (0) [2013-11-26T16:47:27.376](0) Database Options: override_connection_reset: 0

PSAPPSRV.3228 (0) [2013-11-26T16:47:27.376](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PSPROD with user PS.

PSAPPSRV.3228 (0) [2013-11-26T16:47:27.376](0) Server failed to start

PSADMIN.3660 (0) [2013-11-26T16:47:34.770](0) End boot attempt on domain PSPROD

 

Note: for .dll file of app-server i have given the 64bit path.

Also i refereed previous thread for the same issue but no luck

 

Please give any feed back on the same how to resolve this issue

Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points