Saturday, December 17, 2011 6:14:41 PM
12.1.3, stop, start
Starting and stopping Process For Oracle E-Business Suite 12.1.3 in LINUX
To start Oracle EBS Follow the Steps
Used SID = VIS
1)Run Oracle RDBMS database home environment file
/u01/oracle/VIS/db/tech_st/11.1.0/VIS_appsys.env
2)start the listener
lsnrctl start VIS
3)start the database
connect sqlplus
sqlplus / as sysdba
sql>startup;
4)Run the application environment file
/u01/oracle/VIS/apps/apps_st/appl/APPSVIS_appsys.env
5) start the application using following commands
cd /u01/oracle/VIS/inst/apps/VIS_appsys/admin/scripts
adstrtal.sh apps/apps
6)check the status using following command
cd /u01/oracle/VIS/inst/apps/VIS_appsys/admin/scripts
adopmnctl.sh status
To stop Oracle EBS Follow the Steps
1.Run the application environment file
/u01/oracle/VIS/apps/apps_st/appl/APPSVIS_appsys.env
2.stop the application using following commands
cd /u01/oracle/VIS/inst/apps/VIS_appsys/admin/scripts
adstpall.sh apps/apps
3.stop the database
connect sqlplus
sqlplus / as sysdba
sql>shutdown immediate;
4.stop the listener
lsnrctl stop VIS
Regards,
Jaffer Ali
Saturday, December 17, 2011 5:09:48 PM
12.1.3
TO apply ORACLE E-BUSINESS SUITE 12.1.3 RELEASE UPDATE PACK (Patch Number: 9239090 )
Document
Oracle E-Business Suite Release 12.1.3 Readme [ID 1080973.1]
Applies to: 12.1
Our Application version :12.1.1
Our Database version :11.1.0.7
1.Set Application Environment
/u01/oracle/ORCL/apps/apps_st/appl/APPSORCL_appsys.env
2. stop all application process.
/u01/oracle/ORCL/inst/apps/ORCL_appsys/admin/scripts/adstpall.sh apps/apps
3. set environment to RDBMS oracle_home.
/u01/oracle/ORCL/db/tech_st/11.1.0/ORCL_appsys.env
4.Shutdown Database as following
sqlplus / as sysdba
SQL>shutdown immediate;
5.Stop Database Listener
lsnrctl stop ORCL
6. edit the init parameter file in the database(Using 11gR1 follow doc.761570.1)
/u01/oracle/ORCL/db/tech_st/11.1.0/dbs/initORCL.ora
vi initORCL.ora
add (_disable_fast_validate=TRUE).
7. set pga and sga size in init parameter file (initORCL.ora file)
pga_aggregate_target=2G
Note:
(If errorlike below:
ORA-04030: out of process memory when trying to allocate 822904 bytes (pga heap, kco buffer)
ORA-07445: exception encountered: core dump [dbgtfdFileWrite()+48]
set the _pga_max_size initialization parameter to a larger value as follows: _pga_max_size=104857600
and restart your database.)
8.start Database Listener
lsnrctl start ORCL
9. restart the database.
sqlplus / as sysdba
sql> startup pfile='/u01/oracle/ORCL/db/tech_st/11.1.0/dbs/initORCL.ora'
10.Use AutoPatch to apply R12.AD.B.DELTA.3 Patch 9239089
Pre Install Steps as per Patch readmefile & Doc.1077769.1
(i)create a dir on $ORACLE_HOME/appustil/admin
/u01/oracle/ORCL/db/tech_st/11.1.0/appsutil/admin
(ii)Copy adgrants.sql from this patch directory to $ORACLE_HOME/appsutil/admin
cp /u01/12.1.3/9239089/admin/adgrants.sql /u01/oracle/ORCL/db/tech_st/11.1.0/appsutil/admin/adgrants.sql
(iii) Set the database environment
/u01/oracle/ORCL/db/tech_st/11.1.0/ORCL_appsys.env
(iv)logon to sqlplus and run adgrants.sql with apps schema password as below
sqlplus /nolog
sql> connect as sysdba
sql> @/u01/oracle/ORCL/db/tech_st/11.1.0/appsutil/admin/adgrants.sql apps
11.Disable maintanance mode using adadmin utility
12.set application environment.
Run Patch 9239089 using adpatch
*u9239089.drv
(Check Log file in /u01/oracle/ORCL/apps/apps_st/appl/admin/ORCL/log/u9239089_12122011.log)
13.Compile APPS schema
Run adadmin > Compile/Reload Applications Database Entities menu >Compile APPS schema.
*Choose "No" at the following prompt:Run Invoker Rights processing in incremental mode [No]
14.Apply patch 9239090 using adpatch
*u9239090.drv
(When adrelink error chose "Yes" to continue)
15.Post STep (There is no any pre or post install steps)
Apply Patches *Patch 9817770
*Patch 9966055
16.Remove _disable_fast_validate=TRUE parameter from initORCL.ora file
17.Disable Maintanence mode
18.Run Autocnfig both database and application tier
Regards,
Jaffer Ali
My Opera
