Configuring and Managing Oracle E-Business Suite Release 12.2.x Forms and Concurrent Processing for Oracle RAC

 Configuring and Managing Oracle E-Business Suite Release 12.2.x Forms and Concurrent Processing for Oracle RAC (Doc ID 2029173.1)

Step 1:- No active ADOP cycle

adop -status

Step 2:- Create Services (Database)

srvctl add service -db vis_a -service UATERP_OACORE_ONLINE -preferred "UATERP1,UATERP2" -notification TRUE -role "PRIMARY,SNAPSHOT_STANDBY" -failovermethod BASIC -failovertype SELECT -failoverretry 10 -failoverdelay 3

srvctl add service -db vis_a -service UATERP_PCP_BATCH1 -preferred "UATERP1" -notification TRUE -role "PRIMARY,SNAPSHOT_STANDBY" -failovermethod BASIC -failovertype SELECT -failoverretry 10 -failoverdelay 3

srvctl add service -db vis_a -service UATERP_PCP_BATCH2 -preferred "UATERP2" -notification TRUE -role "PRIMARY,SNAPSHOT_STANDBY" -failovermethod BASIC -failovertype SELECT -failoverretry 10 -failoverdelay 3

Step 3:- Check the configuration

select inst_id,service_name, count(*)

from gv$session

where service_name not like 'SYS%'

group by inst_id,service_name

order by 1

/

srvctl config service -d UATERP -s UATERP_OACORE_ONLINE 

srvctl config service -d UATERP -s UATERP_PCP_BATCH1

srvctl config service -d UATERP -s UATERP_PCP_BATCH2

Step 4:- Configure Net Services

lsnrctl status UATERP1

lsnrctl status UATERP2

lsnrctl status listener_scan1

lsnrctl status listener_scan2

lsnrctl status listener_scan3

Step 5:- Create a TNS alias for database service

UATERP_OACORE_ONLINE =(DESCRIPTION=(ADDRESS_LIST= (FAILOVER=YES) (ADDRESS=(PROTOCOL=tcp)(HOST=<SCAN IP1>)(PORT=<SCAN PORT>)) (ADDRESS=(PROTOCOL=tcp)(HOST=<SCAN IP2>)(PORT=<SCAN PORT>)) (ADDRESS=(PROTOCOL=tcp)(HOST=<SCAN IP3>)(PORT=<SCAN PORT>)) (CONNECT_DATA= (SERVICE_NAME=UATERP_OACORE_ONLINE)))

"Create Service UATERP_OACORE_ONLINE a and add it to $TNS_ADMIN/<%s_dbSid%>_<%s_hostname%>_ifile.ora file Add tnsentry on both database node."

Step 6:- Copy the default database connection file

"Copy the default database connection file, which is normally $FND_SECURE/DB_NAME.dbc to the database service UATERP_OACORE_ONLINE.dbc"

Step 7:- Context File backup

Step 8:- Edit the context file on each application tier node

s_apps_jdbc_connect_descriptor = <jdbc_url oa_var="s_apps_jdbc_connect_descriptor">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=exaa-scan3)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=UATERP_OACORE_ONLINE )))</jdbc_url>  

s_jdbc_connect_descriptor_generation - false

s_tools_twotask - UATERP_OACORE_ONLINE

s_cp_twotask - UATERP_PCP_BATCH1

s_cp_twotask - UATERP_PCP_BATCH2

Step 9:- Run autoconfig primary and secondary node of application

Step 10:- Stop application services and database services

Step 11:- Start database services and application services

Step 12- HA testing

srvctl relocate service -d <db_name> -s <service_name> -i <instance1> -t <instance2>

srvctl modify service -d <db_name> -s <service_name> -n -i <preferred_list> -a <available_list>

srvctl modify service -d prod -s TestService1 -n -i prod2,prod4 -a prod1,prod3