Database Signon Error
While attempting to start the application server on an Oracle database, the following error message kept appearing in the application sever logs:
File: /vob/peopletools/src/pssys/stmget.cppSQL error. Stmt #: 2736 Error Position: 23
Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt:SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1
PSAPPSRV.9554 (0) [05/26/11 09:48:10](1) GenMessageBox(200, 0, M):
/vob/peopletools/src/pssys/stmget.cpp: A SQL error occurred.
Please consult your system log for details.
PSAPPSRV.9554 (0) [05/26/11 09:48:10](1) GenMessageBox(0, 0, M):
Database Signon: Could not sign on to database <DBNAME> with user <USERID>
PSAPPSRV.9554 (0) [05/26/11 09:48:10](0) Server failed to start
One of the things that can cause this is if the public synonym for PS.PSDBOWNER has not been created or granted public access. To fix, run the following in the database:
CREATE PUBLIC SYNONYM PSDBOWNER FOR PS.PSDBOWNER;
GRANT SELECT ON PS.PSDBOWNER TO PUBLIC;
No Comments