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;

Also confirm that the database owner and name correctly matches the databases you are in - particularly if working with a refreshed environment.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License