Monday, November 29, 2010

Procedure to start and stop ERP OR ORACLE APPS R12

Procedure to start the ERP.

Login as oracle user.

Source the environment.
Start the database sqlplus '/as sysdba'
sql> startup
Come out of sql prompt
start the database listener.
by using command : lsnrctl start Database_SID

Login as apps user

source the enviroment.
got to cd $INST_TOP/admin/scripts.
$./adstrtall.sh apps_uername/apps_password


Procedure to stop ERP

Login as apps user

source the enviroment.
got to cd $INST_TOP/admin/scripts.
$./adstplall.sh apps_uername/apps_password

Login as oracle user

stop database listener
$ lsnrctl stop DB_SID
sqlplus '/as sysdba'
shutdown the database
using shutdown immediate
or Shutdown