Showing posts with label Database Signon: Could not sign on to database HCMDEV with user PSAPPS. Return: 8097 - Oracle initialization error. Show all posts
Showing posts with label Database Signon: Could not sign on to database HCMDEV with user PSAPPS. Return: 8097 - Oracle initialization error. Show all posts

Tuesday, 12 November 2013

Database Signon: Could not sign on to database HCMDEV with user PSAPPS. Return: 8097 - Oracle initialization error

Errors  :Database Signon: Could not sign on to database HCMDEV with user PSAPPS.
Return: 8097 - Oracle initialization error


PSAPPSRV Fails to Boot - Return: 8097 - Oracle initialization error


Solution: 
Case #1- Same error message. Tnsping was able to connect to the DB OK.
The application server user on the Unix box needs read accesss to all files under $ORACLE_HOME.Please make sure that.

Case #2 - if Appserver is on 32bit Windows & Oracle client installed is 11.2.
This Oracle client version was never certified for 32bit Windows OS.
Installing Oracle client 11.1 or lower resolves the problem.

Oracle Client 11.2 is certified for Windows 64bit OS only.