Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Thursday, December 20, 2007

Startup DB in restrict mode before running adgrants.sql

adgrants.sql is a script which is usually run after every AD.I patch or ATG_PF.H Rollup. From prior experience I have seen this script hang for a long time whenever it is executed on a running Apps 11i instance. You should shutdown all service first. Shutdown database. Startup database in restrict mode and then run adgrants.sql. In RESTRICT mode, it executes quickly.

To Enable Restricted Session

Alter system enable restricted session;

To Disable Restricted Session

Alter system disable restricted session;

To Start the Database in Restricted Mode

STARTUP RESTRICT

No comments: