Start / Stop Services in Oracle Applications R12 ( Database & Application Tier)
Step by step instructions of How to Start/Stop services in Oracle Applications R12 are shown Below.
Specifications :
Application Tier O.S. User : applmgr (applmgr is default password )
Database Tier O.S. User : oracle (oracle is default password )
R12 install base : /oracle/apps/r12/Testr12
Database SID : Test
Database Version : 11.1.0
Hostname : hostr12
Operating System : Unix/Linux
Apps Schema Password : apps (apps is default password)
1.Start-Up Order :
1.1.Start the database tier
1.2.Start the Application tier.
2.Shut-down Order :
2.1.Stop the Application tier
2.2.Stop the database tier.
1.Start-Up Order:
1.1.Start Database Tier
(i) Login as database tier user (oracle)
(ii) Set environment variable
- cd /oracle/apps/r12/Testr12/db/tech_st/11.1.0 (
$Home/db/tech_st/11.1.0 )
- . Test_hostr12.com ( $SID_hostname.env )
(iii) Start database
- sqlplus “/as sysdba”
- SQL> startup
(iv) Start Database Listener (lsnrctl start $SID)
- lsnrctl start Test
1.2.Start Application Tier
(i) Login as application tier user (oracle)
(ii) Set environment variable
- cd /oracle/apps/r12/Testr12/apps/apps_st/appl
- . Test_hostr12.com ( $SID_hostname.env )
(iii) Start Application Tier
Step by step instructions of How to Start/Stop services in Oracle Applications R12 are shown Below.
Specifications :
Application Tier O.S. User : applmgr (applmgr is default password )
Database Tier O.S. User : oracle (oracle is default password )
R12 install base : /oracle/apps/r12/Testr12
Database SID : Test
Database Version : 11.1.0
Hostname : hostr12
Operating System : Unix/Linux
Apps Schema Password : apps (apps is default password)
1.Start-Up Order :
1.1.Start the database tier
1.2.Start the Application tier.
2.Shut-down Order :
2.1.Stop the Application tier
2.2.Stop the database tier.
1.Start-Up Order:
1.1.Start Database Tier
(i) Login as database tier user (oracle)
(ii) Set environment variable
- . Test_hostr12.com ( $SID_hostname.env )
(iii) Start database
- sqlplus “/as sysdba”
- SQL> startup
(iv) Start Database Listener (lsnrctl start $SID)
- lsnrctl start Test
1.2.Start Application Tier
(i) Login as application tier user (oracle)
(ii) Set environment variable
- . Test_hostr12.com ( $SID_hostname.env )
(iii) Start Application Tier
- cd $ADMIN_SCRIPTS_HOME
- . /adstrtal.sh apps/apps (adstrtall.sh apps/appspassword)
2.Shut-down Order :
2.1.Stop the Application tier
(i) Login as application tier user (oracle)
(ii) Set environment variable
- cd /oracle/apps/r12/Testr12/apps/apps_st/appl
- . Test_hostr12.com ( $SID_hostname.env )
(iii) Stop Application Tier
(i) Login as application tier user (oracle)
(ii) Set environment variable
- . Test_hostr12.com ( $SID_hostname.env )
(iii) Stop Application Tier
- cd $ADMIN_SCRIPTS_HOME
- . /adstpall.sh apps/apps (adstpall.sh apps/appspassword)
- . /adstpall.sh apps/apps (adstpall.sh apps/appspassword)
2.2.Stop the database tier
(i) Login as database tier user (oracle)
(ii) Set environment variable
- cd /oracle/apps/r12/Testr12/db/tech_st/11.1.0 ( $Home/db/tech_st/11.1.0 )
- . Test_hostr12.com ( $SID_hostname.env )
(iii) Stop database
- sqlplus “/as sysdba”
- SQL> Shutdown immediate
(iv) Stop Database Listener
- lsnrctl stop Test
delete all the log files from
$IAS_ORACLE_HOME/Apache/Apache/logs
$IAS_ORACLE_HOME/Apache/Jserv/logs/jvm
$IAS_ORACLE_HOME/Apache/Jserv/logs
Start the Apache
(i) Login as database tier user (oracle)
(ii) Set environment variable
- . Test_hostr12.com ( $SID_hostname.env )
(iii) Stop database
- sqlplus “/as sysdba”
- SQL> Shutdown immediate
(iv) Stop Database Listener
- lsnrctl stop Test
Delete Apache log files :
Stop the Apache.delete all the log files from
$IAS_ORACLE_HOME/Apache/Apache/logs
$IAS_ORACLE_HOME/Apache/Jserv/logs/jvm
$IAS_ORACLE_HOME/Apache/Jserv/logs
Start the Apache
No comments:
Post a Comment