NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Running Autoconfig in R12.2

No comments
In R12.2 we have 2 file systems RUN and PATCH. Whenever we are making any changes in context file always make those in both RUN and PATCH context file to keep them in sync.

Below are the steps to execute autoconfig in R12.2 Environments
In below example I am making changes to forms trace directory.

Steps:

1.Make sure your application services are down.
2.Database services and Listener should be up and running.
3.Identify the Context which needs to be modified.
4.In R12.2 make sure you run Autoconfig on both run and patch file.
5.Getting context file use below
Source Run File system
. EBSapps.env run
echo $CONTEXT_FILE ( This will give you full path with Context file name in run file system)

Source Patch File System
. EBSapps.env patch
echo $CONTEXT_FILE ( This will give you full path with Context file name in patch file system)
6.Make the necessary parameter changes in Both the context files. But always ensure to take a copy of the respective context files(Run and  Patch) before changing.
7.Connect to putty as applmgr.
8.Change Run Context file

[applmgr@sebs admin]$ diff SEBS122_sebs.xml_orig SEBS122_sebs.xml
142c142
<          <forms_trace_dir oa_var="s_forms_trace_dir">/u01/application/SEBS122/fs2/inst/apps/SEBS122_sebs/logs/ora/10.1.2/forms</forms_trace_dir>
---
>          <forms_trace_dir oa_var="s_forms_trace_dir">/u01/application/SEBS122/trace</forms_trace_dir>
[applmgr@sebs admin]$ echo $FILE_EDITION
run

Change the Patch Context file

[applmgr@sebs admin]$ diff SEBS122_sebs.xml_orig SEBS122_sebs.xml
142c142
<          <forms_trace_dir oa_var="s_forms_trace_dir">/u01/application/SEBS122/fs1/inst/apps/SEBS122_sebs/logs/ora/10.1.2/forms</forms_trace_dir>
---
>          <forms_trace_dir oa_var="s_forms_trace_dir">/u01/application/SEBS122/trace</forms_trace_dir>

9.Verify all application services are down.
10.Run autoconfig
Source RUN file system 
cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh

Make sure it completes successfully.

11.Connect to sqlplus using system user.
sqlplus system/manager
alter trigger ebs_logon disable;

12.Run autoconfig
Source Patch file system 
cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh

Make sure it completes successfully.


13.Connect to sqlplus using system user.
sqlplus system/manager

alter trigger ebs_logon enable;

1     


No comments :

Post a Comment