Oracle Open World 2009

Today is the last day of Oracle Open World 2009. Some exciting bloggers have taken time to keep us updated on this. You may wish to visit them for sure:

Grey Sparling Blog
Graham's PeopleSoft Blog
PeopleSoft Corner Blog
PeopleSoft Wisdom
Arun Gupta's Miles to go...
Official Oracle OpenWorld Blog

App Server boot problem - PSCLOCK

Last week I faced an issue while trying to boot the application server. I checked for all the common things that could have caused the problem like password, connectivity, path etc. But everything looked well. I configured the app server for SQL trace and issued the boot command.

From trace file, it was observed that the app server boot was stuck up at SELECT CURRENT TIMESTAMP FROM PSCLOCK command. While issued the command SELECT * FROM PSCLOCK, PSCLOCK table was found blank and was responsible for this problem.

I imported PSCLOCK table from another environment and started the app server to success.

Incidentally, the reason for how data from PSCLOCK table have been deleted was not identified.