APP-OFA-48676

Error 
----------------------- 
APP-OFA-48676: You are attempting to overlap this amortization with a previous transaction. Proceed with this amortization? 

Problem Description 
---------------------------------------------------
When trying to change the date placed in service (DPIS) for a group asset in the addition period the following errors are received:


Problem Summary 
---------------------------------------------------
APP-OFA-48676


Solution from oracle SR
-----------------------

You said that you cannot change DPIS for a group asset in the addition period, but the asset trace uploaded is not for a group asset type (not even a member asset).
Also the addition period of that asset, Capitalized asset, is 736113 (30-Sep-16) and the current period is 736479 (1-Oct-17).
DPIS for asset number = 1000680 is 01-AUG-2008
Depreciation was run for the asset in case.
So, you cannot change the DPIS for the asset number = 1000680

Please review :
Oracle Assets User Guide Changing Financial and Depreciation Information (pag 3-7)

"Before running depreciation (in the period in which you added the asset), you can
change any field.

After you have run depreciation (in any period after the one in which you added the
asset), you can change asset cost, salvage value, prorate convention, depreciation
method, life, capacity and unit of measure (in the corporate book), rate, bonus rule,
depreciation ceiling, and revaluation ceiling."

As I said, after the Depreciation is run, the only fields that can be update are:
asset cost, salvage value, prorate convention, depreciation
method, life, capacity and unit of measure (in the corporate book), rate, bonus rule,
depreciation ceiling, and revaluation ceiling.

Setup RMAN backup in EBS R12.2.4 database

RMAN CONFIGURATION
==================


RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name JTCPROD are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/JTCPROD/ora_prod/11204/dbs/snapcf_JTCPROD.f'; # default


CRON JOB FOR RMAN BACKUP
=======================


[oraprod@proddb122 ~]$ crontab -l

00 02 * * * /u01/JTCPROD/ora_prod/scripts/rmanbackup_full.sh >> /u01/JTCPROD/ora_prod/scripts/rmanbackup_full.log


( to edit $crontab -e , the above cron job will run daily at 2:00 am)


SCRIPT for level 0 full backup including archive and controlfile
============================================================

[oraprod@proddb122 ~]$ vi /u01/JTCPROD/ora_prod/scripts/rmanbackup_full.sh

#!/bin/bash
ORACLE_HOME=/u01/JTCPROD/ora_prod/11204; export ORACLE_HOME
ORACLE_SID=JTCPROD; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
/u01/JTCPROD/ora_prod/11204/bin/rman  target / @'/u01/JTCPROD/ora_prod/scripts/rmanscript.sh'



[oraprod@proddb122 ~]$ vi /u01/JTCPROD/ora_prod/scripts/rmanscript.sh

run
{
backup incremental level 0 database format '/u01/BACKUP/RMANBKP/%d_DB_%T_%u_s%s_p%p';
sql 'alter system archive log current';
backup archivelog all format '/u01/BACKUP/RMANBKP/%d_ARCH_%T_%u_s%s_p%p';
backup current controlfile format '/u01/BACKUP/RMANBKP/control_%t.bak';


Compress the RMAN Backup and delete the obsolete backup and schedule it using cron job
=================================================================

[root@proddb122 TARRMANBKP]# crontab -l

30 02 * * * /u01/JTCPROD/ora_prod/scripts/tarbkp.sh >> /u01/JTCPROD/ora_prod/scripts/tarbkp.log


[root@proddb122 TARRMANBKP]# vi /u01/JTCPROD/ora_prod/scripts/tarbkp.sh


#Compress of backup files ###

echo "Timestamp : `date` :Backedup Database files compression in process ..."

tar -czvf /u01/BACKUP/RMANBKP/JTCPROD_Backup_`date +%d%m%Y`.tgz /u01/BACKUP/RMANBKP/*

echo "Timestamp : `date` :Backedup Database files compression completed successfully..."


echo "Timestamp : `date` :Copying tar file in process ..."

cp  -r /u01/BACKUP/RMANBKP/*.tgz /u01/BACKUP/TARRMANBKP # copying backup files from backup location to other directory

echo "Timestamp : `date` :Successfully copied tar files"

Removing tar and backup files to release space #######

echo "Timestamp : `date` :removing files from backup location in process ..."

rm -rf /u01/BACKUP/RMANBKP/*

echo "Timestamp : `date` :Successfully removed files from backup location"
~

Download EBS R12.2.7 Software from new oracle cloud website

Download R12.2.7

LOGIN  to https://edelivery.oracle.com

Type the required software in search tab and add to cart and click on select software

Just select all here, in the next page you can select the required packages to download

Select following packages to download.

DOCUMENTS FOR R12.2

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1).docx

R12.2 How To Create the Stage In Preparation For Installation (Doc ID 1596433.1).docx

Download EBS R12.1.1 software from new oracle cloud website

Download R12.1.1 

 LOGIN  to https://edelivery.oracle.com

Type the required software in search tab and add to cart and click on select software

 Just select all here , in the next page you can select the required packages to download

  

Select following packages to download.

Oracle E-Business Suite 12.1.1.0.0 for Linux x86-64

             

B53824-01_1of4.zip    Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here, 29.3 MB

B53824-01_3of4.zip    Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here, 393.1 MB

             

B53824-01_2of4.zip    Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here, 97.3 MB

             

B53824-01_4of4.zip    Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here, 81.6 MB

             

V15688-01_1of2.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 9, 1.6 GB

             

V15688-01_2of2.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 9, 1.1 GB

             

V15684-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 5, 834.6 MB

             

V15684-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 5, 1.4 GB

             

V15684-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 5, 1.4 GB

             

V35224-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install RDBMS - Disk 1, 1.2 GB

             

V35224-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install RDBMS - Disk 1, 1.7 GB

             

V35224-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install RDBMS - Disk 1, 762.8 MB

             

V15686-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 7, 1.5 GB

             

V15686-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 7, 541.1 MB

V15686-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 7, 1.5 GB

V15691-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 2, 1.2 GB

             

V15691-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 2, 1.2 GB

             

V15691-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 2, 1.2 GB

             

V15681-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 2, 1.5 GB

V15681-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 2, 1.7 GB

             

V15681-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 2, 508.8 MB

             

V15687-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 8, 1.4 GB

             

V15687-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 8, 1.5 GB

             

V15687-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 8, 950.1 MB

             

V15690-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 1, 283.1 MB

             

V15690-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 1, 1.6 GB

             

V15690-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install APPL_TOP - Disk 1, 1.6 GB

             

V15685-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 6, 1.2 GB

             

V15685-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 6, 1.3 GB

             

V15685-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 6, 1.4 GB

             

V15689-01.zip Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Tools - Disk 1, 1.5 GB

             

V15683-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 4, 1.5 GB

             

V15683-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 4, 744.5 MB

             

V15683-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 4, 1.5 GB

 V15682-01_3of3.zip   Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 3, 1.0 GB

             

V15682-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 3, 1.4 GB

             

V15682-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux Rapid Install Databases - Disk 3, 1.3 GB

             

V15680-01_1of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 1, 1.7 GB

             

V15680-01_2of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 1, 1.4 GB

             

V15680-01_3of3.zip    Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Databases - Disk 1, 588.2 MB

DOCUMENTS FOR R12.1

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

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 (Doc ID 761566.1)

MD5 Checksums For R12.1.1 Rapid Install Media (Doc ID 802195.1)
R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)

 Oracle E-Business Suite Release 12 Installation Guidelines (Doc ID 405565.1)

Oracle E-Business Suite Release 12 High Availability Documentation Roadmap (Doc ID 1072636.1)

Interoperability Notes E-Business Suite R12 with Oracle Database 11gR1 (11.1.0) [ID 735276.1].docx  -- to upgrade ebs r12 database.

Java heap Space error in Journal Entries report EBS R12.2.4

Java heap Space error in Journal Entries report EBS R12.2.4

Error:
-============================

Journal Entries report standard was completing with error.

Reason:
================================

java memory issue .

Solution:
=================================


a) checked the following patch is applied on EBS R12.2.4 environment.

SQL> select bug_number from ad_bugs where bug_number='20518047';

BUG_NUMBER
------------------------------
20518047

SQL> select BUG_ID from ad_bugs where bug_number='20518047';

    BUG_ID
----------
    495937




b) Check your heap , Are you using 32 bit or 64 bit JRE
See below KM doc:Sizing Business Intelligence Publisher Components To Handle Large Volumes of Data with E-Business Suite XML Publisher / BI Publisher ( Doc ID 1630732.1 )

SQL> select DEVELOPER_PARAMETERS from FND_CP_SERVICES
2 where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
3 where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

DEVELOPER_PARAMETERS
--------------------------------------------------------------------------------
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2560m

in my case, already the max heap size  is set to 2.5 GB


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


followed these steps to prevent JAVA Heap Space error:



1. in XML Publisher Administrator responsibility navigate to Administration > Configuration

- under : Properties -> General -> set a temporary directory

This directory should be at least 5 times larger than the largest anticipated data file.

Support recommends the directory to be at least 20GB.



2. in XML Publisher Administrator responsibility navigate to Data Definition

Although the scalable feature of the XSLT can be set at the Site level, it is recommended to enable it rather at the Data Definition level for those concurrent programs that are expected to produce large XML data files.

Navigation Path : XML Publisher Administrator responsibility

- query the data definition used by the report with large data

- on the View Data Definition page select Edit Configuration button

- set 'Use XML Publisher's XSLT processor' to True

- set 'Enable scalable feature of XSLT processor' to True

- set 'Enable XSLT runtime optimization' to True

Note that these property values, when set at the Data Definition level, takes precedence over values set at the Site level.



3. Then, in System Administrator resp, navigate to Profile > System

- set Concurrent:OPP Process Timeout = 43200 ( in my case , increased from 7200 to 43200)

- set Concurrent:OPP Response Timeout = 43200 ( in my case , increased from 7200 to 43200)

(these values are for 12 hours in seconds)


4. 1)Log into EBS
   2)Navigate following window.
     Responsibility: System Administrator
     N)Concurrent -> Program -> Define
    3)Search the following concurrent.

      Program : <Program name>
      Short Name : < program short name>

     Entry the following to Options of Executable region.

      -ms1024m -mx1024m

    Note : About specifying -ms and -mx ( -ms and -mx is same as -Xms -Xmx.)
          -Xms (-ms): initial heap size
          -Xmx (-mx): maximum heap size

in my case the value( -ms1024m -mx1024m ) worked for me.

Note : If this error still happens, you can use the following Option ins above Step4.
(a) -Xmx512m -Xss1024k
(b) -Xmx512m -Xss2048k
(c) -Xmx512m -Xss4096k
(d) -Xmx1024m -Xss1024k
(e) -Xmx1024m -Xss2048k
(f) -Xmx1024m -Xss4096k

-Xmx (-mx): maximum heap size
-Xss : Java stack size

5.bounced the concurrent manager ./adcmctl.sh stop/start


6. rerun the journal entries report now , completed normal successfully.

RFC 2068 Hypertext Transfer Protocol - HTTP/1.1 10.4.1.400 Bad Request

RFC 2068 Hypertext Transfer Protocol - HTTP/1.1 10.4.1.400 Bad Request in EBS R12.2.4

Error :
==============================================
In R12.2.4, User trying to do LOV from GL account forms using quick customer responsibility, and he was hit by below error.

From RFC 2068 Hypertext Transfer Protocol - HTTP/1.1 10.4.1.400 Bad Request

the request could not be understood by the server due to malformed
syntax. the client should not repeat the request without modification.

Followed the action plan from ERROR-400 Bad Request while Selecting LOV for GL Code Combinations ( Doc ID 2286951.1 ).

solution :
===============================================
[applprod@prodapp122 ~]$ cd $OA_HTML

[applprod@prodapp122 html]$ $FND_TOP/patch/115/bin/ojspCompile.pl --compile -s 'frameRedirect.jsp' --flush
logfile set: /u01/JTCPROD/appl_prod/fs1/inst/apps/JTCPROD_prodapp122/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10.3.6.0
synchronizing dependency file:
loading deplist...7829
enumerating jsps...7829
updating dependency...0
initializing compilation:
enumerating jsps...1
eliminating children...1 (-0)
translating and compiling:
translating jsps...1/1 in 28s
compiling jsps...1/1 in 4s
Finished!

[applprod@prodapp122 scripts]$ ./adadminsrvctl.sh stop

You are running adadminsrvctl.sh version 120.10.12020000.10

Enter the WebLogic Admin password:
Enter the APPS Schema password:
Stopping WLS Admin Server...
Refer /u01/JTCPROD/appl_prod/fs1/inst/apps/JTCPROD_prodapp122/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/JTCPROD/appl_prod/fs1/FMW_Home/user_projects/domains/EBS_domain_JTCPROD/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/JTCPROD/appl_prod/fs1/inst/apps/JTCPROD_prodapp122/logs/appl/admin/log/adadminsrvctl.txt for more information ...

[applprod@prodapp122 scripts]$ ./adadminsrvctl.sh start

You are running adadminsrvctl.sh version 120.10.12020000.10

Enter the WebLogic Admin password:
Enter the APPS Schema password:
Starting WLS Admin Server...
Refer /u01/JTCPROD/appl_prod/fs1/inst/apps/JTCPROD_prodapp122/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/JTCPROD/appl_prod/fs1/FMW_Home/user_projects/domains/EBS_domain_JTCPROD/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/JTCPROD/appl_prod/fs1/inst/apps/JTCPROD_prodapp122/logs/appl/admin/log/adadminsrvctl.txt for more information ...

and restest the issue with user , problem remain the same.

So , restarted all the application services, issue resolved.

Hot Cloning EBS R12.2.4 by using RMAN and dualfs

 Cloning EBS R12.2.4 dbiter by using RMAN backup and application tier by dualfs

CLONING DB TIER

v  Run the preclone script on db tier and take the full backup of following except the data folder from source system…(/u01/JTCPROD/ora_prod)

v  11204     admin  cfgtoollogs  checkpoints  data  diag  oradata  oraInventory  scripts

v  Delete the all the files from oraInventory.(make sure you have created the inventory location /etc/oraInst.loc )

v  Copy the RMAN backup and $O_H files to specific folders on target system

o    (eg : /u01/JTCDEV/ora_dev and /u01/RMANBKP)

v  Change the permissions and ownership of the files.

1. Configure the database Oracle Home.

$ cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
$ perl adcfgclone.pl dbTechStack

[oradev@dev1224 ~]$ export PATH=/u01/JTCDEV/ora_dev/11204/perl/bin:$PATH

[oradev@dev1224 ~]$ export PERL5LIB=/u01/JTCDEV/ora_dev/11204/perl/lib/5.10.0

[oradev@dev1224 ~]$ export PATH=/u01/JTCDEV/ora_dev/11204/bin:$PATH

[oradev@dev1224 ~]$ cd /u01/JTCDEV/ora_dev/11204/appsutil/clone/bin

[oradev@dev1224 bin]$ perl adcfgclone.pl dbTechStack

                     Copyright (c) 2002, 2015 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Running: Context clone...

Log file located at /u01/JTCDEV/ora_dev/11204/appsutil/clone/bin/CloneContext_0916185106.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [dev1224] : dev1224.xxxx.com

Target Instance is RAC (y/n) [n] : n

Target System Database SID : DEV2

Target System Base Directory : /u01/JTCDEV/ora_dev

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [1] :

Target System DATA_TOP Directory 1 [/u01/JTCDEV/ora_dev/data] :

Target System RDBMS ORACLE_HOME Directory [/u01/JTCDEV/ora_dev/11.2.0] : /u01/JTCDEV/ora_dev/11204

Do you want to preserve the Display [proddb122:0.0] (y/n)  : n

Target System Display [dev1224:0.0] :

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 66

Checking the port pool 66

done: Port Pool 66 is free

Report file located at /u01/JTCDEV/ora_dev/11204/appsutil/temp/portpool.lst

The new database context file has been created :

  /u01/JTCDEV/ora_dev/11204/appsutil/DEV2_dev1224.xml

Check Clone Context logfile /u01/JTCDEV/ora_dev/11204/appsutil/clone/bin/CloneContext_0916185106.log for details.

Running Rapid Clone with command:

Running:

perl /u01/JTCDEV/ora_dev/11204/appsutil/clone/bin/adclone.pl java=/u01/JTCDEV/ora_dev/11204/appsutil/clone/bin/../jre mode=apply stage=/u01/JTCDEV/ora_dev/11204/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/JTCDEV/ora_dev/11204/appsutil/DEV2_dev1224.xml showProgress contextValidated=true

Beginning rdbms home Apply - Sat Sep 16 18:52:43 2017

/u01/JTCDEV/ora_dev/11204/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/u01/JTCDEV/ora_dev/11204/oui -classpath /u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/xmlparserv2.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/ojdbc6.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/java:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/oui/ewt3.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/oui/share.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/oui/srvm.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTechStack -e /u01/JTCDEV/ora_dev/11204/appsutil/DEV2_dev1224.xml -stage /u01/JTCDEV/ora_dev/11204/appsutil/clone   -showProgress

APPS Password : Log file located at /u01/JTCDEV/ora_dev/11204/appsutil/log/DEV2_dev1224/ApplyDBTechStack_09161852.log

  /      0% completed      

Completed Apply...

Sat Sep 16 18:54:59 2017

Starting database listener for DEV2:

Running:

/u01/JTCDEV/ora_dev/11204/appsutil/scripts/DEV2_dev1224/addlnctl.sh start DEV2

Logfile: /u01/JTCDEV/ora_dev/11204/appsutil/log/DEV2_dev1224/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process DEV2 ...

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 16-SEP-2017 18:54:59

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Starting /u01/JTCDEV/ora_dev/11204/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production

System parameter file is /u01/JTCDEV/ora_dev/11204/network/admin/DEV2_dev1224/listener.ora

Log messages written to /u01/JTCDEV/ora_dev/11204/admin/DEV2_dev1224/diag/tnslsnr/dev1224/dev2/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dev1224.xxxx.com)(PORT=1587)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dev1224.xxxx.com)(PORT=1587)))

STATUS of the LISTENER

------------------------

Alias                     DEV2

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                16-SEP-2017 18:55:00

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/JTCDEV/ora_dev/11204/network/admin/DEV2_dev1224/listener.ora

Listener Log File         /u01/JTCDEV/ora_dev/11204/admin/DEV2_dev1224/diag/tnslsnr/dev1224/dev2/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dev1224.xxxx.com)(PORT=1587)))

Services Summary...

Service "DEV2" has 1 instance(s).

  Instance "DEV2", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/JTCDEV/ora_dev/11204/appsutil/log/DEV2_dev1224/addlnctl.txt for more information ... 

Running ETCC to check status of DB technology patches...

WARNING: ETCC does not exist under /u01/JTCDEV/ora_dev/11204/appsutil/etcc.

Download patch 17537119 from My Oracle Support, unzip it under /u01/JTCDEV/ora_dev/11204/appsutil/etcc and run ETCC to avoid ADOP related issues.

[oradev@dev1224 bin]$

2. Restored the database with RMAN backup.( RMAN backup is full level 0 backup with controlfile, archivelog, dbfs)

Add the below lines to init<SID>.ora file of target system.($O_H/dbs)

*.db_file_name_convert='/u01/JTCPROD/ora_prod/data','/u01/JTCDEV/ora_dev/data'

*.log_file_name_convert='/u01/JTCPROD/ora_prod/data','/u01/JTCDEV/ora_dev/data'

Source the environment file db.env ( ** the environment file copied to the oradev home location /home/oradev from the location $O_H/sid_host.env)

 sql > startup nomount pfile =’ $O_H/dbs/init<SID>.ora’

$ rman auxiliary /

RMAN > duplicate target database to DEV2 backup location ‘/u01/RMANBKP’ nofilenamecheck;

…….

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

database opened

Finished Duplicate Db at 16-SEP-17

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

3 .Run AutoConfig in the INSTE8_SETUP mode on the database tier as follows:

On UNIX:

$ sh <RDBMS_ORACLE_HOME>/appsutil/bin/adconfig.sh contextfile=<CONTEXT_FILE> run=INSTE8_SETUP

 [oradev@dev1224 ~]$ sh /u01/JTCDEV/ora_dev/11204/appsutil/bin/adconfig.sh contextfile=/u01/JTCDEV/ora_dev/11204/appsutil/DEV2_dev1224.xml run=INSTE8_SETUP

Enter the APPS user password:     Script execution phase specified: INSTE8_SETUP

The log file for this session is located at: /u01/JTCDEV/ora_dev/11204/appsutil/log/DEV2_dev1224/09162025/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

                Using ORACLE_HOME location : /u01/JTCDEV/ora_dev/11204

                Classpath                   : :/u01/JTCDEV/ora_dev/11204/jdbc/lib/ojdbc6.jar:/u01/JTCDEV/ora_dev/11204/appsutil/java/xmlparserv2.jar:/u01/JTCDEV/ora_dev/11204/appsutil/java:/u01/JTCDEV/ora_dev/11204/jlib/netcfg.jar:/u01/JTCDEV/ora_dev/11204/jlib/ldapjclnt11.jar

                Using Context file          : /u01/JTCDEV/ora_dev/11204/appsutil/DEV2_dev1224.xml

Context Value Management will now update the Context file

                Updating Context file...COMPLETED

                Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

4. Run the library update script against the database.

$ cd <RDBMS ORACLE_HOME>/appsutil/install/<CONTEXT NAME>
$ sqlplus "/ as sysdba" @adupdlib.sql <libext>

Where <libext> should be set to sl for HP-UX, so for any other UNIX platform, or dll for Windows.

[oradev@dev1224 ~]$ . db.env

[oradev@dev1224 ~]$ cd $ORACLE_HOME

[oradev@dev1224 11204]$ cd appsutil

[oradev@dev1224 appsutil]$ cd install/

[oradev@dev1224 install]$ cd DEV2_dev1224/

[oradev@dev1224 DEV2_dev1224]$ sqlplus "/ as sysdba" @adupdlib.sql so

SQL*Plus: Release 11.2.0.4.0 Production on Sun Sep 17 09:07:53 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

PL/SQL procedure successfully completed.

SQL>exit

5 . Configure the Target database.

The database must be running and open before performing this step.

$ cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
$ perl adcfgclone.pl dbconfig <Database Target Context File>

Where "Database Target Context File" is: <RDBMS ORACLE_HOME>/appsutil/<Target CONTEXT_NAME>.xml.

[oradev@dev1224 DEV2_dev1224]$ cd /u01/JTCDEV/ora_dev/11204/appsutil/clone/bin/

[oradev@dev1224 bin]$ ls

adcfgclone.pl  adclonectx.pl  CloneContext_0612123926.log

adchkutl.sh    adclone.pl     CloneContext_0916185106.log

[oradev@dev1224 bin]$ perl adcfgclone.pl dbconfig /u01/JTCDEV/ora_dev/11204/appsutil/DEV2_dev1224.xml

                     Copyright (c) 2002, 2015 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Running Rapid Clone with command:

Running:

perl /u01/JTCDEV/ora_dev/11204/appsutil/clone/bin/adclone.pl java=/u01/JTCDEV/ora_dev/11204/appsutil/clone/bin/../jre mode=apply stage=/u01/JTCDEV/ora_dev/11204/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/u01/JTCDEV/ora_dev/11204/appsutil/DEV2_dev1224.xml showProgress contextValidated=false

Beginning dbconfig Apply - Sun Sep 17 09:11:14 2017

/u01/JTCDEV/ora_dev/11204/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/u01/JTCDEV/ora_dev/11204/oui -classpath /u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/xmlparserv2.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/ojdbc6.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/java:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/oui/ewt3.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/oui/share.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/oui/srvm.jar:/u01/JTCDEV/ora_dev/11204/appsutil/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyDatabase -e /u01/JTCDEV/ora_dev/11204/appsutil/DEV2_dev1224.xml -stage /u01/JTCDEV/ora_dev/11204/appsutil/clone   -showProgress   -noRmanRecovery yes -checkDBConnection

APPS Password : Log file located at /u01/JTCDEV/ora_dev/11204/appsutil/log/DEV2_dev1224/ApplyDatabase_09170911.log

  |      0% completed      

Log file located at /u01/JTCDEV/ora_dev/11204/appsutil/log/DEV2_dev1224/ApplyDatabase_09170911.log

  -     30% completed      

Completed Apply...

Sun Sep 17 09:12:23 2017

Starting database listener for DEV2:

Running:/u01/JTCDEV/ora_dev/11204/appsutil/scripts/DEV2_dev1224/addlnctl.sh start DEV2

Logfile: /u01/JTCDEV/ora_dev/11204/appsutil/log/DEV2_dev1224/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process DEV2 ...

Listener DEV2 has already been started.

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/JTCDEV/ora_dev/11204/appsutil/log/DEV2_dev1224/addlnctl.txt for more information ... 

Running ETCC to check status of DB technology patches...

WARNING: ETCC does not exist under /u01/JTCDEV/ora_dev/11204/appsutil/etcc.

Download patch 17537119 from My Oracle Support, unzip it under /u01/JTCDEV/ora_dev/11204/appsutil/etcc and run ETCC to avoid ADOP related issues.

CLOINIG APPLICATION TIER

1.Run preclone on application tier

2. for cloning apps tier with dualfs option , you must have txk delta 7 .

SQL> select abbreviation, codelevel from ad_trackable_entities where abbreviation in ('txk','ad'); 

ABBREVIATI CODELEVEL 
---------- ---------- 
ad C.7 
txk C.7 

3. Copy the run file system folder ( /u01/JTCPROD/ora_prod/fs1/EBSapps) ..in my case fs1 is the run file system. You can copy the folder while application services are up , no need of downtime.

 export PATH=/u01/JTCDEV/appl_dev/fs1/EBSapps/10.1.2/perl/bin:$PATH
 export PERL5LIB=/u01/JTCDEV/appl_dev/fs1/EBSapps/10.1.2/perl/lib/5.6.1
 export PATH=/u01/JTCDEV/appl_dev/fs1/EBSapps/10.1.2/bin:$PATH
 cd /u01/JTCDEV/appl_dev/fs1/EBSapps/comn/clone/bin

 perl adcfgclone.pl appsTier dualfs

 

 

Postcloning steps :

1. Update profile options ,Update to avoid JSP error in xml reports

$ sqlplus apps/xxxx

SQL> select PROPERTY_CODE,value from apps.XDO_CONFIG_VALUES where

PROPERTY_CODE like '%SYSTEM_TEMP_DIR%';

SQL> update XDO_CONFIG_VALUES set VALUE='custom_top/12.0.0/out' where PROPERTY_CODE like 'SYSTEM_TEMP_DIR';

SQL > commit;

2. Update other profile options like sitename, color, workflow etc.

Done with cloning. Happy learning