<<Oracle Applications DBA 基础（第二期）>>Week 15 exercise

1. Add a new app node to your exsiting EBS installation to create a shared appl_top configuration.
ie. the final configuration will be :
node 1 :DB + App
node 2 : App

1. Prepare existing node
Execute Rapid Clone on the existing node
As the APPLMGR user, log in to the node that is sharing the file system and execute the following commands:
$ cd/admin/scripts/
$ perl adpreclone.pl appsTier

2. Make the Applications files accessible
Mount the shared file system disk to the Application node that you want to add. For example, after mounting the shared file system disk, the following file system is visible from both the application nodes:
    Shared COMMON_TOP: /d01/shared_mount/apps/apps_st/viscomn
    Shared APPL_TOP: /d01/shared_mount/apps/apps_st/visappl
    Shared OracleAS 10.1.2 ORACLE_HOME: /d01/shared_mount/apps/tech_st/visora/10.1.2
    Shared OracleAS 10.1.3 ORACLE_HOME: /d01/shared_mount/apps/tech_st/visora/10.1.3
Note: User ID and group ID should be consistent across nodes in a shared file system to avoid file access permission issues. You must retain the same absolute path for the mount points of the shared file system on each node. The value for the context variable "s_atName" must be same in the context file for all the application tier nodes.

3. Configure the node to be added
You will have to copy the Applications context file for the existing node to the current node if the Applications context file for the existing node is not accessible from the current node. Execute the commands listed below in the table. Refer to Appendix A for an example on prompts while running adclonectx.pl.
As the APPLMGR user, log in to the node that you want to add.
$ cd $COMMON_TOP/clone/bin
$ perl adclonectx.pl addnode \
contextfile=/SLOTS/slot03/appmgr/inst/apps/txkr12d1/appl/admin/txkr12d1.xml
The above command will create a new context file for the node you were adding to the multi-node system. The next step is to run the AutoConfig utility which will generate the new Instance Home for this node and update the required tables in the database.
$ perl $AD_TOP/bin/adconfig.pl \
contextfile=
The next step is to run the AutoConfig utility on all the other nodes so that the required configuration files on those are updated with the new node information.

参考:

Sharing The Application Tier File System in Oracle E-Business Suite Release 12 (Doc ID 384248.1)

Section 4: Adding a Node to a Shared Application Tier File System

--EOF--

2. When we use PCP, we need to put these two to a shared file system:
  $APPLCSF and $FNDREVIVERPID
  what 's the benefit if we have $APPLCSF in a shared file system ?

If we have $APPLCSF in a shared file system, we can view log/output of requests from any node.

Or we may face permission errors while viewing request logs that are not located in primary node.

--EOF--

3. When we use PCP with RAC database, we would set these options as below
'Concurrent: PCP Instance Check' to off
'Concurrent: TM Transport Type' to 'QUEUE'  

What's the implication of setting like as this?

QUEUE is best for RAC environment where we don’t have to tie concurrent manager nodes to any specific database node (PIPE). In this configuration, concurrent manager can talk to any of the database nodes. If any of the database nodes crashed that can failover to surviving database nodes. But in this configuration, we need change the profile option “Concurrent: TM Transport Type” to QUEUE and “PCP: Instance Check” to OFF (This is required to avoid the concurrent manager failover if database crash). Apart from that cp_twotask in context file need to set SID_806_BALANCE, so that concurrent manager shadow processes will be balance to all database nodes in RAC and we did the enable the reviver process by setting s_cp_reviver to enable in the context file. Reviver process is a daemon process which keeps monitoring the concurrent processes tied to database, if any database crashes the reviver process is responsible to tie up the concurrent manager to surviving database nodes.

Reference:

Parallel Concurrent Processing (PIPE and QUEUE)

http://sparwez.wordpress.com/2010/02/12/parallel-concurrent-processing/

--EOF--

4. Upgrade your R12.1.1 installation to R12.1.3

FROM MY BLOG: http://blog.csdn.net/t0nsha/article/details/25560837

0.
Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)
admsi.pl -patch_top="`pwd`" -appspass=apps -cli

1.
Document 761570.1
add _disable_fast_validate=TRUE

2.
--enable maintenance
create table invalids_b_9239089 as select * from dba_objects where status='INVALID';
Required Code levels
R12.AD.B.delta.3
(R12.AD.B.DELTA.3, Patch 9239089) (Doc ID 1077769.1)
create table invalids_a_9239089 as select * from dba_objects where status='INVALID';
select bug_number,last_update_date from ad_bugs where bug_number = 9239089;
select object_name,object_type,status from invalids_a_9239089 where object_id not in (select object_id from invalids_b_9239089);

3.
create table invalids_b_9239090 as select * from dba_objects where status='INVALID';
Doc.DI 1080973.1
Patch 9239090
create table invalids_a_9239090 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9239090 where object_id not in (select object_id from invalids_b_9239090);
select object_name,object_type,status from dba_objects where object_id not in (select object_id from invalids_b_9239090);

=================================================
Doc ID 1303269.1
During the relink phase of the installation of EBS Release 12 (12.1.1) on SLES
10 or Oracle Linux/RHEL 5.4 (Update 4 or higher), failures will result while
relinking the Advanced Supply Chain Planning (ASCP) executables MSO, MSC, MSR
and FEM.

 To fix this problem, users are required to replace the following line under
the Linux section of the $AD_TOP/bin/adrelinknew.sh:

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'

with

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh
-Wl,--noinhibit-exec'

=================================================
adpatch.log
...
The following Oracle Reports objects did not generate successfully:

au      plsql   FABAL.pll
au      plsql   FARSV.pll
au      plsql   fadolif.pll
...
-------------------------------------------------
adwork001.log
Generating Oracle Reports files...


Generating report "FASUOPHI.rdf" with command:

/u01/apps/tech_st/10.1.2/bin/rwconverter userid=APPS/***** source=/u01/apps/apps
_st/appl/fa/12.0.0/reports/US/FASUOPHI.rdf dest=/u01/apps/apps_st/appl/admin/PRO
D/out/tmp001.rdf stype=rdffile dtype=rdffile overwrite=yes batch=yes compile_all
=yes
/u01/apps/tech_st/10.1.2/bin/rwconverter: error while loading shared libraries:
libXm.so.2: cannot open shared object file: No such file or directory

ERROR [code=127] generating report "FASUOPHI.rdf" from input file
/u01/apps/apps_st/appl/fa/12.0.0/reports/US/FASUOPHI.rdf


Generated    0 files successfully.
Generated    0 files with non-fatal warnings.
Generated    1 files with fatal errors.

adrepgen is exiting with status 1
...
rpm -ivh openmotif21-2.1.30-11.EL5.i386.rpm

=================================================
Invalid FFP Objects (Doc ID 1331911.1)

Latest Oracle HRMS Legislative Data Patch Available (HR Global / hrglobal)
(Doc ID 145837.1)
java oracle.apps.per.DataInstall apps apps thin oel57vis.example.com:1521:VIS
cd  $PER_TOP/patch/115/driver
adpatch hrglobal.drv

How To Compile Oracle Fast Formulas (Doc ID 155737.1)
$FF_TOP/bin/FFXBCP apps/apps 0 Y %% %%

=================================================

4.
create table invalids_b_9239095 as select * from dba_objects where status='INVALID';
Patch 9239095
create table invalids_a_9239095 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9239095 where object_id not in (select object_id from invalids_b_9239095);

5.
create table invalids_b_9817770 as select * from dba_objects where status='INVALID';
Patch 9817770
create table invalids_a_9817770 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9817770 where object_id not in (select object_id from invalids_b_9817770);

create table invalids_b_9966055 as select * from dba_objects where status='INVALID';
Patch 9966055
create table invalids_a_9966055 as select * from dba_objects where status='INVALID';
select object_name,object_type,status from invalids_a_9966055 where object_id not in (select object_id from invalids_b_9966055);

6.
. ./<APPL_TOP>/APPS<CONTEXT_NAME>.env
Run AutoConfig on the APPL_TOP
adautocfg.sh

Run the admkappsutil.pl utility to create the file appsutil.zip in the <INST_TOP>/admin/out directory.
perl <AD_TOP>/bin/admkappsutil.pl
perl $AD_TOP/bin/admkappsutil.pl

cd <RDBMS ORACLE_HOME>
. ./<RDBMS ORACLE_HOME>/<CONTEXT_NAME>.env

cd <ORACLE_HOME>
unzip -o appsutil.zip

perl adpreclone.pl dbTier
perl adpreclone.pl appsTier

7.
remove add _disable_fast_validate=TRUE
--disable maintenance

Reference:

Oracle E-Business Suite Release 12.1.3 Readme (Doc ID 1080973.1)

--EOF--

5. When we upgrade 11i to R12.1.1, how many times we need to run the "rapidwiz" command and why ?

Run Rapid Install first time to lay down R12 file systems and tech stacks
Run Rapid Install the second time to configure the R12 instance

--EOF--