Oracle Database 19c Single Node Standby Build with RAC as Primary

StickyAugust 29, 2023Oracle DatabaseFarhan Shaikh

This blog aims to outline the Disaster Recovery Operational procedures for Oracle 19c Database with Multi-Tenant Architecture single PDB for EBS Database

Standby Database

A standby database is a transactionally consistent copy of the primary database. Using a backup copy of the primary database, you can create up to 30 standby databases and incorporate them in an Oracle Data Guard configuration.

There are three types of standby database:

Physical standby — Provides a physically identical copy of the primary database, with on-disk database structures that are identical to the primary database on a block-for-block basis. The database schema, including indexes, is the same. A physical standby database is kept synchronized with the primary database by recovering the redo data received from the primary. This document details the steps for setting up a physical standby database.
Logical standby — Contains the same logical information as the primary database, although the physical organization and structure of the data can be different. It is kept synchronized with the primary database by transforming the data in the redo logs received from the primary database into SQL statements and then executing the SQL statements on the standby database. Logical standby databases are not supported with Oracle E-Business Suite standard functionality.
Snapshot standby — A fully updatable standby database. Like a physical or logical standby database, a snapshot standby database receives and archives redo data from a primary database. However, unlike a physical or logical standby, a snapshot standby does not apply the redo data it receives. This means it will be out of sync with the primary, so using a snapshot standby for disaster recovery risks recovery being incomplete.

Oracle Data Guard

Oracle Data Guard is a set of services that create, manage, and monitor one or more standby databases to enable a primary database to survive disasters and data corruption. If the primary database becomes unavailable due to a planned or an unplanned outage, Oracle Data Guard can switch a standby database to the primary role, minimizing the downtime.

Oracle Data Guard offers three modes of data protection:

Maximum Protection — This mode offers the highest level of data protection and guarantees no data will be lost. Data is synchronously transmitted from the primary database to one or more standby databases, and transactions are not committed on the primary database unless the redo data is available on at least one standby database configured in this mode. If the last standby database configured in this mode becomes unavailable, processing stops on the primary database.
Maximum Availability — This mode is similar to the maximum protection mode, including a guarantee of no data loss. However, if a standby database becomes unavailable (for example, due to network connectivity problems), processing continues on the primary database. After the fault is corrected, the standby database is resynchronized with the primary database. However, if there is a need to fail over before the standby database is resynchronized, some data may be lost.

Maximum Performance — This mode offers slightly less data protection on the primary database, but higher performance than maximum availability mode. In maximum performance mode, as the primary database processes transactions the redo data is asynchronously shipped to the standby database. The commit operation on the primary database does not wait for the standby database to acknowledge receipt of redo data before completing write operations on the primary database. If any standby destination becomes unavailable, processing continues on the primary database, and there is little effect on primary database performance.

Oracle Data Guard Broker

The Oracle Data Guard broker is a distributed management framework that automates and centralizes the creation, maintenance, and monitoring of Data Guard configurations. It logically groups the primary and standby databases into a broker configuration that allows the broker to manage and monitor them together as an integrated unit.

The Data Guard broker consists of the following three components:

Data Guard graphical user interface (GUI) through Enterprise Manager
Data Guard command-line interface (DGMGRL)
Data Guard monitor

The broker automates and simplifies the following operations:

Standby database creation — The Oracle Enterprise Manager wizards automate and simplify the steps required to create a configuration with an Oracle database on each site, including creating the standby control file, online redo log files, data files, and server parameter files.

Note: This document contains specific steps to set up a physical standby with Oracle E-Business Suite for both Oracle RAC and single-node databases.

Role transitions — This simplifies the switchover and failover process, including automatically setting up redo transport and log apply services, and automating failover.

Note: Fast-start failover is currently not supported with Oracle E-Business Suite.

Monitoring — This provides continuous monitoring of the configuration health, database health, and other runtime parameters.

Typical Oracle Data Guard Flow

1) On Primary : Transactions start on Primary and all the buffer cache locks (exclusive locks) that are required for the transaction are acquired.

2) On Primary : The redo blocks that hold the changes (or change vectors) are generated and stored in the processes PGA. After successfully acquiring the redo allocation latch, space is then allocated in the redo log buffer. The redo generated then gets copied from the processes PGA into the redo log buffer.

3) On Primary : Oracle foreground process tells the LGWR to flush the redo log buffers to disk. Remember that the database blocks in the database have not yet been updated with DML changes. The LGWR flushes the redo buffers to the ORL and acknowledges the completion to the session. At this point, the transaction is persistent on disk. No commit has occurred so far.

4) On Primary : the LNS process reads the recently flushed redo from the redo log buffer and sends the redo data to the standby database using the redo transport destination (LOG_ARCHIVE_DEST_n) that we defined during standby database creation. We are using ASYNC transport method, so the LGWR does not wait for any acknowledgment from the LNS for this network send operation. It does not communicate with the LNS except to start it up at the database start stage and after a failure of a standby connection.

5) On Standby : The RFS reads the redo stream from the network socket into the network buffers, and then it writes this redo stream to the SRL.

6) On Standby : The ARCH process archives the SRLs into archive log files when a log switch occurs at the primary database. The generated archive log file is then registered with the standby control file.

7) On Standby : The actual recovery process starts from this step. The managed recovery process (MRP) will asynchronously read ahead the redo from the SRLs or the archived redo logs (when recovery falls behind or is not in real-time apply mode). The blocks that require redo apply are parsed out and placed into appropriate in-memory map segments.

8) On Standby: the MRP process ships redo to the recovery slaves using the parallel query (PQ) inter-process communication framework. Parallel media recovery (PMR) causes the required data blocks to be read into the buffer cache, and subsequently redo will be applied to these buffer cache buffers. At the checkpoint phase, the recently modified buffers (modified by the parallel recovery slaves) will be flushed to disk and update of datafile headers to record checkpoint completion.

Background Processes On the Primary Database:

LGWR : The log writer process flushes log buffers from the SGA to Online Redo Log files.
LNS : The Log Writer Network Service (LNS) reads the redo being flushed from the redo buffers by the LGWR and sends the redo over network to the standby database. The main purpose of the LNS process is to free up the LGWR process from performing the redo transport role.
ARCH : The archiver processes archives the ORL files to archive log files. Up to 30 ARCH processes can exist, and these ARCH processes are also used to fulfill gap resolution requests. Note that one ARCH process has a special role in that it is dedicated to local redo log archiving only and never communicates with a standby database.

Background Processes On the Standby Database:

RFS : The main objective of the Remote File Server process is to perform a network receive of redo transmitted from the primary site and then writes the network buffer (redo data) to the standby redo log (SRL) files.
ARCH : The archive processes on the standby site perform the same functions performed on the primary site, except that on the standby site, an ARCH process generates archived log files from the SRLs.
MRP : The managed recovery process coordinates media recovery management. Remember that a physical standby is in perpetual recovery mode.

Basically, we can categorize physical standby database into three major components:

1) Data Guard Redo Transport Services

– To transfer the redo that is generated by the primary database to the standby database. (Point 4 and 5 in the above diagram are where Redo Transport works.)

2) Data Guard Apply Services

– To receive and apply the redo sent by Redo Transport Services to the standby database. (Point 7 and 8 in the above diagram are where Redo Apply works.)

3) Data Guard Role Management Services

– To assist in the database role changes in switchover and failover scenarios.

This service works in the background and takes care of switchover/failover scenarios.

ORACLE STANDBY BUILD PROCEDURE

Task	Command Reference
Backup PRIMARY pfile and copy it to Standby server	PRODUCTION:oraprod@PRIM_DB_N1:*scp -rp oraprod@SBY_DB_N1:/Stage/PRDSBY** Authorized users only. All activity may be monitored and reported. Password: pfile_PRIM_DB_N1_cdb_21082023.ora 100% 4550 550.7KB/s 00:00 pfile_PRIM_DB_N1_pdb_21082023.ora 100% 957 127.9KB/s 00:00 PRODUCTION:oraprod@PRIM_DB_N1:
Enable Forced Logging on PRIMARY	Set the environment to the Container Database: $ source <RDBMS_ORACLE_HOME>/<cdb_name>.env Use the following SQL command to set FORCE LOGGING on the primary database: SQL> ALTER DATABASE FORCE LOGGING;
Configure Oracle Net Communication to and From the Standby System on PRIMARY	Standby LISTENER.ORA file when server is running as standby # listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/network/admin/listener.ora # Generated by Oracle configuration tools. # # $Header: listener_ora_cdb_db19_rac.tmp 120.0.12020000.1 2019/03/25 07:46:16 lmanda noship $ # # +===========================================================================+ # \| Copyright (c) 2016, 2019 Oracle Corporation, Redwood Shores, California, USA \| # \| All rights reserved \| # \| Applications Division \| # +===========================================================================+ # # $AutoConfig$ # #################################### # Definition for database listener #################################### CDBPRD = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = PRIM_DB_N1-vip.corp.prod.com)(PORT = 1529)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1529)) ) ) TRACE_DIRECTORY_CDBPRD = /u01/app/oracle/product/19.0.0/network/admin STARTUP_WAIT_TIME_CDBPRD = 0 TRACE_FILE_CDBPRD = CDBPRD TRACE_LEVEL_CDBPRD = OFF LOG_FILE_CDBPRD = CDBPRD ADMIN_RESTRICTIONS_CDBPRD = ON SUBSCRIBE_FOR_NODE_DOWN_EVENT_CDBPRD = OFF USE_SID_AS_SERVICE_CDBPRD = ON LOG_DIRECTORY_CDBPRD = /u01/app/oracle/product/19.0.0/network/admin CONNECT_TIMEOUT_CDBPRD = 10
TNS Aliases	For single-node, the standby and primary alias must have the physical hostname or VIP name. Configuration of TNS Aliases for Oracle RAC Database The TNS alias requirements are different for Oracle RAC. If you are not using SCAN, then all the physical or VIP host name should be used for the primary alias CDBPROD and standby alias, which is CDBSTDBY in this example. When the production and standby are connected using SCAN Listeners, the TNS alias must use the actual DNS-registered SCAN name at their respective sites. These must be specified when configuring TNS aliases for redo-transmission between primary and standby databases. Create <CDBNAME>_<NODE>_ifile.ora under $ORACLE_HOME/network/admin directory and add TNS aliases as example shown in the following code block. Also add <SID>_LOCAL alias with physical host names to this IFILE. CDBPRDSBY=(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=SBY_DB_N1.corp.prod.com)(PORT=1529))) (CONNECT_DATA= (SERVICE_NAME=CDBPRD) (UR=A) ) )
Configure Secure Connections on PRIMARY	$ cd $ORACLE_HOME/dbs $ orapwd file=$ORACLE_HOME/dbs/orapwCDBPRD password=M4n4g3r# entries=10 force=yes ignorecase=y PRODUCTION:oraprod@PRIM_DB_N1:scp -rp orapwCDBPRD oraprod@SBY_DB_N1:/u01/app/oracle/product/19.0.0/dbs Authorized users only. All activity may be monitored and reported. Password: orapwCDBPRD 100% 6144 1.5MB/s 00:00 PRODUCTION:oraprod@PRIM_DB_N1
Set the PRIMARY Database Initialization Parameters	log_archive_dest_1 log_archive_dest_2 log_archive_dest_state_2 log_archive_format log_archive_min_succeed_dest log_archive_config db_unique_name fal_server fal_client standby_file_management db_file_name_convert, log_file_name_convert Remote_login_passwordfile set linesize 500 pages 500 col value for a90 col name for a50 select name, value from v$parameter where name in (‘db_name’,’db_unique_name’,’log_archive_config’, ‘log_archive_dest_1′,’log_archive_dest_2’, ‘log_archive_dest_state_1′,’log_archive_dest_state_2’, ‘remote_login_passwordfile’, ‘log_archive_format’,’log_archive_max_processes’,’fal_server’,’db_file_name_convert’, ‘log_file_name_convert’, ‘standby_file_management’,’fal_server’,’fal_client’); log_archive_dest_3=’SERVICE=PRDSBY NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRDSBY’ The following example shows the relevant initialization parameters of the primary database: db_unique_name = CDBPROD — You need to change this to the standby db_unique_name (such as dg19s) when you copy this file to the physical standby. log_archive_dest_1 =”LOCATION=/arch1/CDBPROD/ MANDATORY” log_archive_dest_2 =”SERVICE=CDBSTDBY LGWR ASYNC=20480 DB_UNIQUE_NAME=CDBSTDBY OPTIONAL REOPEN=15 MAX_FAILURE=10 NET_TIMEOUT=30″ log_archive_config=’dg_config=(CDBPROD,CDBSTDBY)’ log_archive_min_succeed_dest = 1 standby_file_management = AUTO Remote_login_passwordfile = exclusive log_archive_format = <name>%s_%t_%r. <ext> —- Or you can just leave it set to the default. # db_file_name_convert: —- you do not need to specify this if you use the same directory structure # log_file_name_convert: —- you do not need to specify this if you use the same directory structure fal_server = CDBPROD log_file_name_convert = xx,xx —- Specify dummy values to trigger log clearing
Enable Archive Logging on the PRIMARY System	Already enabled on PRIMARY database
Add Standby Redo Logs (SRL’s) on PRIMARY Database	Redo data transmitted from the primary database is received by the remote file server (RFS) process on the standby system. The RFS process writes the redo data to archived log files or standby redo log files. Redo data can be applied either after the redo is written to the archived redo log file or standby redo log file, or, if real-time apply is enabled, directly from the standby redo log file as it is being filled. Standby redo logs are required if you want to use, for example, maximum protection and maximum availability levels of data protection, or real-time apply. A best practice is to add them to both the primary and the standby database so that switchover between the environments is quicker and easier. In this case, you will add them to production, so that they are in place and will be cloned to the standby. There are two considerations: On the primary — The standard Oracle recommendation is to multiplex redo logs on the primary when using normal redundancy, but not when using ASM with high redundancy. On the standby — Standby redo log files can be multiplexed using multiple members, thereby improving reliability over archived log files. However, multiplexing redo logs adds more I/O overhead that could impact the standby’s redo apply rate, given that multiplexing generates N3 writes write I/Os (where N is the number of multiplex redo logs). This is why some references state “Do not multiplex the standby redo logs”. Given that there are several factors to consider, you should test in advance whichever solution you decide to implement. As a general rule, follow the same best practice as for the primary for online redo logs: Create standby redo log files with the same sizes, groups and number of members as on the primary. The standby redo log must have at least one more redo log group than the redo log at the redo source database, for each redo thread at the redo source database. That is to say: number of standby redo logs = the number of redo log groups in the primar + 1. SQL> select b.thread#, a.group#, a.member, b.bytes/1024/1024 FROM v$logfile a, v$log b WHERE a.group# = b.group#; PRODUCTION:oraprod@PRIM_DB_N1: sqlplus / as sysdba* SQLPlus: Release 18.0.0.0.0 – Production on Tue Aug 22 14:40:30 2023 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.16.0.0.0 SQL> show user* USER is “SYS” SQL> !hostname PRIM_DB_N1 SQL> !date Tuesday, August 22, 2023 at 2:40:41 PM +04 SQL> alter database add standby logfile group 5 (‘+REDO’,’+RECO’,’+DATA’) size 300M; Database altered. SQL> alter database add standby logfile group 6 (‘+REDO’,’+RECO’,’+DATA’) size 300M; Database altered. SQL> alter database add standby logfile group 7 (‘+REDO’,’+RECO’,’+DATA’) size 300M; Database altered.
Gather Temporary File Informationfrom thePRIMARY	SQL> select file_name, bytes from dba_temp_files; SQL> alter session set container=”PDB$SEED”; SQL> select file_name, bytes from dba_temp_files; SQL> alter session set container=”<EBS PDB name>”; SQL> select file_name, bytes from dba_temp_files;
Run Database Tier Pre-Clone Scripts on PRIMARY	As the oracle user, run the database pre-clone utility on the primary database server. $ cd $RDBMS_ORACLE_HOME/appsutil/scripts/<context_name> $ perl adpreclone.pl dbTier
Copy the ORACLE_HOME and Database from PRIMARY to the Standby Database Server
Generate a Standby Control File on PRIMARY and Copy it to the Standby Database Server (Conditional)	SQL> alter database create standby controlfile as <directory>/<controlfile name>; SQL> alter system switch logfile; SQL> select thread#, sequence#-1 from v$log where status = ‘CURRENT’; Now copy the control file to the standby database server, noting the thread# and sequence# for later use. You will only be able to open the standby database after this log has been applied on the standby. SQL> select thread#, sequence#-1 from v$log where status = ‘CURRENT’; THREAD# SEQUENCE#-1 ———- ———– 1 9906 2 9894 SQL> alter database create standby controlfile as ‘/u01/oradata/Stage/PRD_BKP/SBY/CDBPRD_SBY_controlfile_23AUG23.ctl’; Database altered. SQL> alter system switch logfile; System altered. SQL> select thread#, sequence#-1 from v$log where status = ‘CURRENT’; THREAD# SEQUENCE#-1 ———- ———– 1 9907 2 9894 SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.16.0.0.0 PRODUCTION:oraprod@PRIM_DB_N1:ls -lrth /Stage/BKP/SBY/CDBPRD_SBY_controlfile_23AUG23.ctl -rw-r—– 1 oraprod oinstall 35.1M Aug 23 11:56 /Stage/BKP/SBY/CDBPRD_SBY_controlfile_23AUG23.ctl PRODUCTION:oraprod@PRIM_DB_N1:scp -rp /Stage/BKP/SBY/CDBPRD_SBY_controlfile_23AUG23.ctl oraprod@SBY_DB_N1:/Stage/PRDSBY Authorized users only. All activity may be monitored and reported. Password: CDBPRD_SBY_controlfile_23AUG23.ctl 100% 35MB 18.9MB/s 00:01 PRODUCTION:oraprod@PRIM_DB_N1: Standby Server: PRODUCTION-DR:oraprod@SBY_DB_N1:cd $BKP PRODUCTION-DR:oraprod@SBY_DB_N1:ls -lrth total 120980 -rw-r–r– 1 oraprod oinstall 4.44K Aug 21 20:32 pfile_PRIM_DB_N1_cdb_21082023.ora -rw-r–r– 1 oraprod oinstall 957 Aug 21 20:32 pfile_PRIM_DB_N1_pdb_21082023.ora -rw-r–r– 1 oraprod oinstall 3.48K Aug 22 14:00 initPRDSBY.ora -rw-r—– 1 oraprod oinstall 23.8M Aug 22 15:18 CDBPRD_SBY_controlfile_22AUG23.ctl -rw-r–r– 1 oraprod oinstall 3.63K Aug 22 23:04 initCDBPRDSBY.ora_FS -rw-r–r– 1 oraprod oinstall 3.05K Aug 23 09:58 initCDBPRDSBY.ora_23Aug23 -rw-r–r– 1 oraprod oinstall 3.27K Aug 23 11:23 initCDBPRDSBY.ora -rw-r—– 1 oraprod oinstall 35.1M Aug 23 11:56 CDBPRD_SBY_controlfile_23AUG23.ctl PRODUCTION-DR:oraprod@SBY_DB_N1:pwd /Stage/BKP PRODUCTION-DR:oraprod@SBY_DB_N1:ls -lrth CDBPRD_SBY_controlfile_23AUG23.ctl -rw-r—– 1 oraprod oinstall 35.1M Aug 23 11:56 CDBPRD_SBY_controlfile_23AUG23.ctl PRODUCTION-DR:oraprod@SBY_DB_N1:
Configuration of the STANDBY Oracle Home for a Single-Node	$ cd $ORACLE_HOME/appsutil/clone/bin $ perl adcfgclone.pl dbTechStack Enter values, as appropriate for the following prompts: Do you want the inputs to be validated (y/n) [n] ? :n Target Instance is RAC (y/n) [y] :y Target System CDB Name : Target System PDB Name : Do you want to enable SCAN addresses (y/n) [y] ? :y Specify value for Scan Name : Specify value for Scan Port : Target System Base Directory : Target System Port Pool [0-99] : Provide information for the initial RAC node: Host name [] : Virtual Host name [null] : Instance number [1] : Private interconnect name [] : Oracle OS User [oracle] : Oracle OS Group [oinstall] : Target System utl_file_dir Directory List : Number of DATA_TOP’s on the Target System [3] : Target System DATA_TOP Directory 1 [] : Target System DATA_TOP Directory 2 [] : Target System DATA_TOP Directory 3 [] : Target System RDBMS ORACLE_HOME Directory [] : Do you want to preserve the Display [localhost:0.0] (y/n) : n Target System Display [dbsystem:0.0] :
Stop the Database Listener on the STANDBY Database Server	$ lsnrctl stop <EBSCDB listener name> PRODUCTION-DR:oraprod@SBY_DB_N1:lsnrctl stop CDBPRD LSNRCTL for Solaris: Version 19.0.0.0.0 – Production on 22-AUG-2023 18:16:41 Copyright (c) 1991, 2022, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SBY_DB_N1.corp.prod.com)(PORT=1529))) The command completed successfully PRODUCTION-DR:oraprod@SBY_DB_N1:
Disable RAC option on STANDBY if building Standby from Primary as RAC to Standby as Single Node Non-RAC	1. Login as the Oracle software owner and shutdown all database instances (if running). 2. cd $ORACLE_HOME/rdbms/lib 3. make -f ins_rdbms.mk rac_off If this step did not fail with fatal errors then proceed to step 4. 4. make -f ins_rdbms.mk ioracle
Configure Oracle Net for Redo Transmission and Start the ListeneronSTANDBY	CDBPROD = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <standby hostname>)(PORT = <PORT>)(IP = FIRST))) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <standby Physical-VIP hostname>)(PORT = <PORT>)(IP = FIRST))) ) ) SID_LIST_CDBPROD = (SID_LIST = (SID_DESC = (ORACLE_HOME = [ORACLE_HOME])(GLOBAL_NAME=<standby db_unique_name>)(SID_NAME = <instance name>)) ) USE_SID_AS_SERVICE_CDBPROD = ON STARTUP_WAIT_TIME_CDBPROD = 0 CONNECT_TIMEOUT_CDBPROD = 10 TRACE_LEVEL_CDBPROD = OFF LOG_DIRECTORY_CDBPROD = [ORACLE_HOME]/network/admin LOG_FILE_CDBPROD = STDBY TRACE_DIRECTORY_CDBPROD = [ORACLE_HOME]/network/admin TRACE_FILE_CDBPROD = STDBY ADMIN_RESTRICTIONS_CDBPROD = ON SUBSCRIBE_FOR_NODE_DOWN_EVENT_CDBPROD = OFF Next start the database listener on the standby: $ lsnrctl start <standby listener>
Run root.sh on 19c OHofSTANDBY	$ cd $ORACLE_HOME $ ls -l root.sh # sh root.sh — needs to be executed as ROOT user
Start the STANDBY Database in nomount	PRODUCTION-DR:oraprod@SBY_DB_N1: sqlplus / as sysdba SQLPlus: Release 19.0.0.0.0 – Production on Wed Aug 23 12:20:43 2023 Version 19.16.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount pfile=’/Stage/BKP/initCDBPRDSBY.ora* ORACLE instance started. Total System Global Area 5.3687E+10 bytes Fixed Size 37438264 bytes Variable Size 6308233216 bytes Database Buffers 4.7245E+10 bytes Redo Buffers 96772096 bytes SQL> Disconnected from Oracle Database 19c Enterprise Edition Release Version 19.16.0.0.0
Restore STANDBY Control file	PRODUCTION-DR:oraprod@SBY_DB_N1:rman target / Recovery Manager: Release 19.0.0.0.0 – Production on Wed Aug 23 12:21 Version 19.16.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights r connected to target database: CDBPRD (not mounted) RMAN> RESTORE STANDBY CONTROLFILE FROM ‘/Stage/BKP/CDBPRD_SBY_controlfile_23AUG23.ctl’; Starting restore at 23-AUG-23 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1 device type=DISK channel ORA_DISK_1: copied control file copy output file name=/u01/PRD/oradata/control01.dbf output file name=/u02/PRD/oradata/control02.dbf output file name=/u03/PRD/oradata/control03.dbf Finished restore at 23-AUG-23 RMAN> ALTER DATABASE MOUNT; released channel: ORA_DISK_1 Statement processed RMAN> select name,open_mode from v$database; NAME OPEN_MODE ——— ——————– CDBPRD MOUNTED RMAN> exit Recovery Manager complete. PRODUCTION-DR:oraprod@SBY_DB_N1: SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED MOUNTED 3 PRD MOUNTED SQL> select name,open_mode from v$database; NAME OPEN_MODE ——— ——————– CDBPRD MOUNTED SQL> !date Wednesday, August 23, 2023 at 12:24:49 PM +04 SQL>

Modify the Database init.ora Parameters on the STANDBY Server	SQL> alter system set <parameter>=<value>; As the ORACLE user on the standby database server, create an ifile for the standby database based on the one created earlier for the primary database: $ cd <ORACLE_HOME>/dbs $ cp <CONTEXT_NAME>_ifile.ora <STNDBY_CONTEXT>_ifile.ora Update the following parameters: DB_UNIQUE_NAME should be updated to a name different from the primary: for example, CDBSTDBY LOG_ARCHIVE_DEST_2 should point to the primary service. This is necessary when the servers are reversed, as the standby is changed to act as the primary and will now ship redo to the new standby. For example, LOG_ARCHIVE_DEST_2 for ‘service=CDBPROD ASYNC REGISTER VALID_FOR=(online_logfile,primary_role) DB_UNIQUE_NAME=CDBPROD’. Add an entry to the standby control file that was created on the primary and now copied to this server :control_files = <control file directory>/<standby control file>, <control file directory>/<standby control file> set linesize 500 pages 500 col value for a90 col name for a50 select name, value from v$parameter where name in (‘db_name’,’db_unique_name’,’log_archive_config’, ‘log_archive_dest_1′,’log_archive_dest_2’, ‘log_archive_dest_state_1′,’log_archive_dest_state_2’, ‘remote_login_passwordfile’, ‘log_archive_format’,’log_archive_max_processes’,’fal_server’,’db_file_name_convert’, ‘log_file_name_convert’, ‘standby_file_management’,’fal_server’,’fal_client’);
Run restore and recoveryfor STANDBY Database	SQL> alter database mount; ISSUE / FIX ————— RMAN-00571: =========================================================== RMAN-03002: failure of sql statement command at 08/23/2023 12:13:54 ORA-65093: multitenant container database not set up properly RMAN> exit Recovery Manager complete. SQL> alter system set enable_pluggable_database=true scope=spfile; cleanup restored control file and re-invoke restore and try mounting the database and then invoke restore. rman target / MSGLOG=db_restore_for_dr_buid.log <<EOF run { set newname FOR DATABASE TO ‘/u01/PRD/oradata/%b’; restore database; switch datafile all; } EOF exit Restore Archive and Recover —————————————- rman target / MSGLOG=restore_arch_for_dr_buid.log <<EOF run { recover database; } EOF exit
	As the oracle user on the standby database server, perform the following after the standby database creation has completed: Set the the CDB environment and mount the standby database. $ . <ORACLE HOME>/<CDB INSTANCE>_<physical hostname1>.env Put the standby database into managed recovery mode on the first node in the cluster. $ sqlplus / as sysdba SQL> alter database recover managed standby database disconnect from session;
Start Shipping Redo from the Primary to the PRIMARY Database Server	$ . <ORACLE HOME>/<CDB INSTANCE>_<physical hostname1>.env $ sqlplus / as sysdba On Primary : *alter system set log_archive_dest_3=’SERVICE=PRDSBY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRDSBY’ scope=both sid=’’;**
Verify that Redo is Shipping from PRIMARY	SQL> alter system switch logfile; While still on the primary, check the status of the most recently archived redo log file at each of the redo transport destinations. The most recently archived redo log file should be the same at each destination. If it is not, a status other than VALID may identify an error was encountered during the archival operation to that destination. Resolve any errors before continuing. SQL> *select from v$archive_dest_status where status != ‘INACTIVE’; On each database server, the following query will show which logs have been sent/received and applied: SQL > select sequence#, applied, to_char(first_time, ‘mm/dd/yy hh24:mi:ss’) first from v$archived_log order by first_time;** On the standby database server, monitor the database alert log to review the recovery progress.
Add the Temp Files to the STANDBY Database (Conditional) – This requires ADG license option	Execute the following commands: SQL> alter database recover managed standby database cancel; SQL> alter database open read only; SQL> alter tablespace temp add tempfile ‘ <file spec>’ size <size> reuse; [enter as many lines as you have temporary data files] SQL> shutdown immediate; SQL> startup mount; SQL> alter database recover managed standby database disconnect from session;

Important Commands for Standby

Basic information of database (primary or standby)	SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; select status,instance_name,database_role,protection_mode from v$database,v$instance;
Check for messages/errors	SELECT MESSAGE FROM V$DATAGUARD_STATUS;
To display current status information for specific physical standby database background processes.	SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY ;
Show received archived logs on physical standby (Run this query on physical standby)	select registrar, creator, thread#, sequence#, first_change#, next_change# from v$archived_log;
To check the log status	select ‘Last Log applied : ‘ Logs, to_char(next_time,’DD-MON-YY:HH24:MI:SS’) Time from v$archived_log where sequence# = (select max(sequence#) from v$archived_log where applied=’YES’) union select ‘Last Log received : ‘ Logs, to_char(next_time,’DD-MON-YY:HH24:MI:SS’) Time from v$archived_log where sequence# = (select max(sequence#) from v$archived_log);
To display various information about the redo data. This includes redo data generated by the primary database that is not yet available on the standby database and how much redo has not yet been applied to the standby database.	set lines 132 col value format a20 select name, value from V$DATAGUARD_STATS;
To monitor efficient recovery operations as well as to estimate the time required to complete the current operation in progress:	select to_char(start_time, ‘DD-MON-RR HH24:MI:SS’) start_time,item, round(sofar/1024,2) “MB/Sec” from v$recovery_progress where (item=’Active Apply Rate’ or item=’Average Apply Rate’);
To find last applied log	select to_char(max(FIRST_TIME),‘hh24:mi:ss dd/mm/yyyy’) FROM V$ARCHIVED_LOG where applied=’YES’;
To see if standby redo logs have been created. The standby redo logs should be the same size as the online redo logs. There should be (( # of online logs per thread + 1) * # of threads) standby redo logs. A value of 0 for the thread# means the log has never been allocated.	SELECT thread#, group#, sequence#, bytes, archived, status FROM v$standby_log order by thread#, group#;
To produce a list of defined archive destinations. It shows if they are enabled, what process is servicing that destination, if the destination is local or remote, and if remote what the current mount ID is. For a physical standby we should have at least one remote destination that points the primary set.	column destination format a35 wrap column process format a7 column ID format 99 column mid format 99 SELECT thread#, dest_id, destination, gvad.status, target, schedule, process, mountid mid FROM gv$archive_dest gvad, gv$instance gvi WHERE gvad.inst_id = gvi.inst_id AND destination is NOT NULL ORDER BY thread#, dest_id;
Verify the last sequence# received and the last sequence# applied to standby database.	SELECT al.thrd “Thread”, almax “Last Seq Received”, lhmax “Last Seq Applied” FROM (select thread# thrd, MAX(sequence#) almax FROM v$archived_log WHERE resetlogs_change#=(SELECT resetlogs_change# FROM v$database) GROUP BY thread#) al, (SELECT thread# thrd, MAX(sequence#) lhmax FROM v$log_history WHERE resetlogs_change#=(SELECT resetlogs_change# FROM v$database) GROUP BY thread#) lh WHERE al.thrd = lh.thrd; SELECT al.thrd “Thread”, almax “Last Seq Received”, lhmax “Last Seq Applied” FROM (select thread# thrd, MAX(sequence#) almax FROM v$archived_log WHERE resetlogs_change#=(SELECT resetlogs_change# FROM v$database) GROUP BY thread#) al, (SELECT thread# thrd, MAX(sequence#) lhmax FROM v$log_history WHERE resetlogs_change#=(SELECT resetlogs_change# FROM v$database) GROUP BY thread#) lh WHERE al.thrd = lh.thrd;
Query to apply redo log on standby. Following command useful for real time apply	ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;
To Start the MRP process using archive log	alter database recover managed standby database disconnect from session;
Cancel the MRP Process	alter database recover managed standby database cancel;
Status of MRP Process	select process,status,client_process,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby;
To get the difference between Received and applied logs.	select MAX_RECEIVED,MAX_APPLIED,(MAX_RECEIVED – MAX_APPLIED) as “Difference” from (SELECT ARCHIVED_THREAD#, MAX(ARCHIVED_SEQ#) as MAX_RECEIVED, APPLIED_THREAD#, MAX(APPLIED_SEQ#) as MAX_APPLIED FROM V$ARCHIVE_DEST_STATUS) ARCH ;
Check the difference in sequence	SELECT ARCH.THREAD# “Thread”, ARCH.SEQUENCE# “Last Sequence Received”, APPL.SEQUENCE# “Last Sequence Applied”, (ARCH.SEQUENCE# – APPL.SEQUENCE#) “Difference” FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;

References

https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/creating-oracle-data-guard-physical-standby.html#GUID-B511FB6E-E3E7-436D-94B5-071C37550170 – Creating a Physical Standby Database

https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/index.html#Oracle%C2%AE-Data-Guard – Concepts and Administration

https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/sql-statements-used-by-oracle-data-guard.html#GUID-F690B602-6582-465B-8E86-0B0A52838D66 – SQL Statements Relevant to Oracle Data Guard

https://docs.oracle.com/en/database/oracle/oracle-database/19/dgbkr/index.html#Oracle%C2%AE-Data-Guard – DGB
Business Continuity for Oracle E-Business Suite Release 12.2 on Oracle Database 19c Using Physical Host Names (Doc ID 2617787.1)

Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.2 and Oracle Database 19c (Doc ID 2608030.1)

Creating a Physical Standby database using RMAN restore database from service (Doc ID 2283978.1)

12c Create Dataguard Broker Configuration – DGMGRL (Doc ID 1583588.1)

http://www.br8dba.com/dg-broker-configuration/ – How to setup Data Guard Broker Configuration

With this DR build for RAC Primary with Non-RAC Standby should be in sync and functional.

Feel free to share feedback on farhan20@gmail.com

Oracle EBS 12.2 Cloning

Introduction to Cloning

Cloning is the process of creating a copy of an existing Oracle E-Business Suite system. The cloning methodology described in this document covers the process used to clone an Oracle E-Business Suite Release 12.2 system.

Note: An Oracle E-Business Suite system can only be cloned to the same, or a higher, major release of a platform (operating system). For example, you can clone a system running on Oracle Solaris 10 to run on Oracle Solaris 11, but it is not supported to clone a system running on Solaris 11 to run on Solaris 10.

There are various scenarios that require cloning an Oracle E-Business Suite system:

Standard cloning – Copying an existing Oracle E-Business Suite system, for example, to test updates against a duplicate of a production system.

Note: Be aware that standard cloning is different from file system cloning. Standard cloning is creating a copy of an Oracle E-Business Suite system using Rapid Clone (for example, cloning a complete Oracle E-Business Suite system to create a test copy from your production environment). In contrast, file system cloning is copying the run file system to the patch file system in online patching, and can only be undertaken with the adop phase=fs_clone command.

System scale-up – Adding new machines to an Oracle E-Business Suite system to provide capacity for processing increased workloads.
System transformations – Altering system data or file systems, including actions such as platform migration, provisioning of high availability architectures, and data scrambling (or the preferred alternative of data masking, as described in My Oracle Support Knowledge Document 1437485.1, Using Oracle E-Business Suite Release 12.1.3 Template for the Data Masking Pack with Oracle Enterprise Manager 11g).
Patching and upgrading – Delivering new versions of Oracle E-Business Suite components, and providing a mechanism to create rolling environments that minimize downtimes.

An important principle in Oracle E-Business Suite cloning is that the system is cloned, rather than the topology. Producing an exact copy of the patch level and data is much more important than creating an exact copy of topology, as a cloned system must be able to provide the same output to the end user as the Source System. However, while a cloned system does not need to have the full topology of its Source, it must have available all of the topology components that are available to the Source.

Note: When cloning, ensure that you specify the actual locations for the directories involved, so that AD utilities can properly identify the directories afterward. Do not use symbolic links to specify directory locations.

High Level Standard Cloning Process for Application Tier

In addition to cloning the database tier node, the standard cloning process for application tier basically involves the following two key processes:

Copy the application tier node from the Source Run Edition File System to the Target Run Edition File System.
Copy the application tier node from the Target Run Edition File System to the Target Patch Edition File System.

This high level cloning process specific to application tier can be illustrated in the following diagram:

Prepare the Source System database tier for cloning
1. Log on to the Source System as the oracle user.
2. Source the Database tier environment file.
3. Execute the following commands:

$ cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>
$ perl adpreclone.pl dbTier

[oracle@source_dbhost CRP1_source_dbhost]$ perl adpreclone.pl dbTier

Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone

Version 12.2

adpreclone Version 120.31.12020000.16

Enter the APPS User Password:

Running:

perl /u01/install/PROD/11.2.0/appsutil/bin/adclone.pl java=/u01/install/PROD/11.2.0/appsutil/jre mode=stage stage=/u01/install/PROD/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/u01/install/PROD/11.2.0/appsutil/CRP1_source_dbhost.xml showProgress

Beginning database tier Stage – Tue Mar 31 16:22:17 2015

/u01/install/PROD/11.2.0/appsutil/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false
-Doracle.installer.oui_loc=/u01/install/PROD/11.2.0/oui
-classpath /u01/install/PROD/11.2.0/lib/xmlparserv2.jar:
/u01/install/PROD/11.2.0/jdbc/lib/ojdbc6.jar:
/u01/install/PROD/11.2.0/appsutil/java:
/u01/install/PROD/11.2.0/oui/jlib/OraInstaller.jar:
/u01/install/PROD/11.2.0/oui/jlib/ewt3.jar:
/u01/install/PROD/11.2.0/oui/jlib/share.jar:
/u01/install/PROD/11.2.0/oui/jlib/srvm.jar:
/u01/install/PROD/11.2.0/jlib/ojmisc.jar oracle.apps.ad.clone.StageDBTier -e /u01/install/PROD/11.2.0/appsutil/CRP1_source_dbhost.xml -stage /u01/install/PROD/11.2.0/appsutil/clone -tmp /tmp -method CUSTOM -showProgress

APPS Password :

Log file located at /u01/install/PROD/11.2.0/appsutil/log/CRP1_source_dbhost/StageDBTier_03311622.log

– 50% completed

Completed Stage…

Tue Mar 31 16:22:47 2015

[oracle@source_dbhost CRP1_source_dbhost]$

Prepare the Source System application tier for cloning

Log on to the primary node of the Source System as the applmgr user.
Source the environment file of the Run Edition File system.
You can use the following command to confirm that the environment variable FILE_EDITION points to the Run Edition File System:

$ echo $FILE_EDITION
It should return the value: run

Execute the following commands:

[root@source_appshost ~]# su – applmgr

E-Business Suite Environment Information

—————————————-

RUN File System : /u01/install/APPS/fs1/EBSapps/appl
PATCH File System : /u01/install/APPS/fs2/EBSapps/appl
Non-Editioned File System : /u01/install/APPS/fs_ne
DB Host: source_dbhost.domain Service/SID: CRP1

E-Business Suite Environment Setting
————————————

– Enter [R/r] for sourcing Run File System Environment file, or

– Enter [P/p] for sourcing Patch File System Environment file, or

– Enter anything else to exit

Please choose the environment file you wish to source [R/P]:R

Sourcing the RUN File System …

[applmgr@source_appshost ~]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@source_appshost scripts]$ perl adpreclone.pl appsTier

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adpreclone Version 120.31.12020000.16

Enter the APPS User Password:

Enter the Weblogic AdminServer password :

Checking the status of the Oracle WebLogic Administration Server….

Running perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/install/APPS/fs1/inst/apps/CRP1_source_appshost/appl/admin/CRP1_source_appshost.xml -servername=AdminServer -promptmsg=hide

The Oracle WebLogic Administration Server is up.

Running:

perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/install/APPS/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/u01/install/APPS/fs1/EBSapps/comn/clone component=appsTier
method=appctx=/u01/install/APPS/fs1/inst/apps/CRP1_source_appshost/appl/admin/CRP1_source_appshost.xml showProgress

Setting the wls environment

Beginning application tier Stage – Thu Mar 19 09:47:15 2015

/u01/install/APPS/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui
-classpath /u01/install/APPS/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:
/u01/install/APPS/fs1/EBSapps/comn/java/classes:
/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/share.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/jlib/ojmisc.jar:
/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/APPS/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /u01/install/APPS/fs1/inst/apps/CRP1_source_appshost/appl/admin/CRP1_source_appshost.xml -stage /u01/install/APPS/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg

Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_source_appshost/admin/log/clone/StageAppsTier_03190947.log

\ 20% completed

Completed Stage…

Thu Mar 19 09:55:17 2015

[applmgr@source_appshost scripts]$

Copy both database tier and application tier nodes from the Source System to the Target System

Copy the application tier file system from the Source node to the Target node by executing the following steps in the order listed. Ensure the application tier files copied to the Target System are owned by the Target applmgr user, and that the database node files are owned by the Target oracle user.

Copy the database node file system

Log on to the Source System database node as the oracle user, and then:

Perform a normal shut down of the Source System database.
Copy the database (.dbf) files from the Source System to the Target System.
Copy the Source System database ORACLE_HOME to the Target System.
Start the Source applications system database and application tier processes.

Copy the application tier file from the Source “Run Edition File System” to the Target “Run Edition File System”
Log on to Run Edition File System in the Source System application tier nodes as the applmgr user.

Copy the following application tier directories from the Source Node to the Target Run Edition File System application tier node:

<APPL_TOP>
<COMMON_TOP>
<OracleAS Tools 10.1.2 ORACLE_HOME>

Configure the Target System Database

Run the following commands to configure the Target System. You will be prompted for specific Target System values such as SID, paths, and ports.

Configure the Target System database server

Log on to the Target System as the oracle user and enter the following commands:

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

[oracle@dbhost ~]$ cd /u01/install/DEV/11.2.0/appsutil/clone/bin
[oracle@dbhost bin]$ perl adcfgclone.pl dbTier

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.35

Enter the APPS password :

Running:

/u01/install/DEV/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/DEV/11.2.0/appsutil/clone/jlib/java:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/ojdbc5.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/ojmisc.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/java:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/install/DEV/11.2.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_1471.lst -stage /u01/install/DEV/11.2.0/appsutil/clone 2> /tmp/adcfgclone_1471.err; echo $? > /tmp/adcfgclone_1471.res

Log file located at /u01/install/DEV/11.2.0/appsutil/clone/bin/CloneContext_0331162811.log

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

Target System Hostname (virtual or normal) [dbhost] : dbhost

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

Target System Database SID : DEV

Target System Base Directory : /u01/install/DEV

Target System utl_file_dir Directory List : /usr/tmp

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

Target System DATA_TOP Directory 1 [/u01/install/PROD/data] : /u01/install/DEV/data

Target System RDBMS ORACLE_HOME Directory [/u01/install/DEV/11.2.0] : /u01/install/DEV/11.2.0

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

Target System Display [dbhost:0.0] : dbhost:1.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] : 2

Checking the port pool 2

done: Port Pool 2 is free

Report file located at /u01/install/DEV/11.2.0/appsutil/temp/portpool.lst

Complete port information available at /u01/install/DEV/11.2.0/appsutil/temp/portpool.lst

Backing up /u01/install/DEV/11.2.0/appsutil/DEV_dbhost.xml to /u01/install/DEV/11.2.0/appsutil/DEV_dbhost.xml.bak

Creating the new Database Context file from : /u01/install/DEV/11.2.0/appsutil/clone/context/db/adxdbctx.tmp

The new database context file has been created : /u01/install/DEV/11.2.0/appsutil/DEV_dbhost.xml

Log file located at /u01/install/DEV/11.2.0/appsutil/clone/bin/CloneContext_0331194625.log

Check Clone Context logfile /u01/install/DEV/11.2.0/appsutil/clone/bin/CloneContext_0331194625.log for details.

Running Rapid Clone with command:

Running:

perl /u01/install/DEV/11.2.0/appsutil/clone/bin/adclone.pl java=/u01/install/DEV/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/u01/install/DEV/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/u01/install/DEV/11.2.0/appsutil/DEV_dbhost.xml showProgress contextValidated=true

Beginning database tier Apply – Tue Mar 31 19:48:04 2015

/u01/install/DEV/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/u01/install/DEV/11.2.0/oui
-classpath /u01/install/DEV/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/ojdbc6.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/java:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/oui/share.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/oui/srvm.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/ojmisc.jar
oracle.apps.ad.clone.ApplyDBTier
-e /u01/install/DEV/11.2.0/appsutil/DEV_dbhost.xml
-stage /u01/install/DEV/11.2.0/appsutil/clone -showProgress

APPS Password : Log file located at /u01/install/DEV/11.2.0/appsutil/log/DEV_dbhost/ApplyDBTier_03311948.log

| 0% completed Determining Source system database type (“single” or “rac”).

Source system indentified as being of type “single”!

| 50% completed

Completed Apply…

Tue Mar 31 19:54:47 2015

Starting database listener for DEV:

Running:

/u01/install/DEV/11.2.0/appsutil/scripts/DEV_dbhost/addlnctl.sh start DEVLogfile: /u01/install/DEV/11.2.0/appsutil/log/DEV_dbhost/addlnctl.txt

You are running addlnctl.sh version 120.4
Starting listener process DEV …

Listener DEV has already been started.
addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/DEV/11.2.0/appsutil/log/DEV_dbhost/addlnctl.txt for more information …

Do you want to change the password for all EBS Schemas? (y/n) [n]) : n

Do you want to change the apps password? (y/n) [n]) : n

Do you want to change the sys and system passwords? (y/n) [n]) : n

[oracle@dbhost bin]$

Configure the Target System application tier server nodes (RUN File System)

Log on to the Run Edition File System in the Target System as the applmgr user and enter the following commands:

$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier

[applmgr@target_appshost apps]$ cd /u01/install/DEV/fs1/EBSapps/comn/clone/bin
[applmgr@target_appshost bin]$ perl adcfgclone.pl appsTier

Version 12.2

adcfgclone Version 120.63.12020000.37

Enter the APPS password :

Running:

/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M
-classpath /u01/install/DEV/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/install/DEV/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt

Enter the Weblogic AdminServer password :

Running:

/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M
-classpath /u01/install/DEV/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/DEV/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt

Running:

/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M
-classpath /u01/install/DEV/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/DEV/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] : no

Running:

/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/install/DEV/fs1/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml
-validate -pairsfile /tmp/adpairsfile_2838.lst
-stage /u01/install/DEV/fs1/EBSapps/comn/clone 2> /tmp/adcfgclone_2838.err;
echo $? > /tmp/adcfgclone_2838.res

Log file located at /u01/install/DEV/fs1/EBSapps/comn/clone/bin/CloneContext_0401050637.log

Target System File Edition type [run] : run

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

Target System Hostname (virtual or normal) [target_appshost] : target_appshost

Target System Database SID : DEV

Target System Database Server Node [target_appshost] : dbhost

Target System Database Domain Name [domain] : domain

Target System Base Directory : /u01/install/DEV

Target System Base Directory set to /u01/install/DEV

Target System Current File System Base set to /u01/install/DEV/fs1

Target System Other File System Base set to /u01/install/DEV/fs2

Target System Fusion Middleware Home set to /u01/install/DEV/fs1/FMW_Home

Target System Web Oracle Home set to /u01/install/DEV/fs1/FMW_Home/webtier

Target System Appl TOP set to /u01/install/DEV/fs1/EBSapps/appl

Target System COMMON TOP set to /u01/install/DEV/fs1/EBSapps/comn

Target System Instance Home Directory [/u01/install/DEV] : /u01/install/DEV

Target System Instance Top set to /u01/install/DEV/fs1/inst/apps/DEV_target_appshost

Do you want to preserve the Display [localhost:5.0] (y/n) : n

Target System Display [target_appshost:0.0] : target_appshost:1.0

Target System Root Service [enabled] : enabled

Target System Web Administration [enabled] : enabled

Target System Web Entry Point Services [enabled] : enabled

Target System Web Application Services [enabled] : enabled

Target System Batch Processing Services [enabled] : enabled

Target System Other Services [disabled] : disabled

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] : 2

Checking the port pool 2

done: Port Pool 2 is free

Report file located at /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/admin/out/portpool.lst

Complete port information available at /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

/usr/tmp
/usr/tmp
/u01/install/DEV/11.2.0/appsutil/outbound/DEV_dbhost
/usr/tmp

Choose a value which will be set as APPLPTMP value on the target node [1] : 1
Creating the new APPL_TOP Context file from : /u01/install/DEV/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created : /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml

Log file located at /u01/install/DEV/fs1/EBSapps/comn/clone/bin/CloneContext_0401051142.log

Check Clone Context logfile /u01/install/DEV/fs1/EBSapps/comn/clone/bin/CloneContext_0401051142.log for details.

Running Rapid Clone with command:

Running:

perl /u01/install/DEV/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/install/DEV/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/install/DEV/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/install/DEV/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml -stage /u01/install/DEV/fs1/EBSapps/comn/clone -log /u01/install/DEV/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Wed Apr 1 05:12:31 2015

/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/install/DEV/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/oui/share.jar:
/u01/install/DEV/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml -stage /u01/install/DEV/fs1/EBSapps/comn/clone -showProgress -nopromptmsg

Log file located at /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/admin/log/clone/ApplyAppsTier_04010512.log

/ 100% completed

Completed Apply…

Wed Apr 1 05:32:51 2015

Executing command: /u01/install/DEV/fs1/EBSapps/10.1.2/bin/sqlplus @/u01/install/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql

Do you want to startup the Application Services for DEV? (y/n) [n] : y

Services not started

[applmgr@target_appshost bin]$

When asked the question:
“Do you want to startup the Application Services for mult35? (y/n)” you should answer ‘y’.

Configure the Target System application tier server nodes (PATCH File System)
1. Source the environment file of the Run Edition File System and run plon the Run Edition File System.

[root@target_appshost ~]# su – applmgr

E-Business Suite Environment Information

—————————————-

RUN File System : /u01/install/DEV/fs1/EBSapps/appl

PATCH File System : /u01/install/DEV/fs2/EBSapps/appl

Non-Editioned File System : /u01/install/DEV/fs_ne

DB Host: dbhost.domain Service/SID: DEV

E-Business Suite Environment Setting

————————————

– Enter [R/r] for sourcing Run File System Environment file, or
– Enter [P/p] for sourcing Patch File System Environment file, or
– Enter anything else to exit

Please choose the environment file you wish to source [R/P]:R

Sourcing the RUN File System …

[applmgr@target_appshost ~]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@target_appshost scripts]$ perl adpreclone.pl appsTier

Oracle E-Business Suite Rapid Clone

Version 12.2

adpreclone Version 120.31.12020000.16

Enter the APPS User Password:

Enter the Weblogic AdminServer password :

Checking the status of the Oracle WebLogic Administration Server….

Running perl /u01/install/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml -servername=AdminServer -promptmsg=hide

The Oracle WebLogic Administration Server is up.

Running:

perl /u01/install/DEV/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/install/DEV/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/u01/install/DEV/fs1/EBSapps/comn/clone component=appsTier method= appctx=/u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml showProgress

Setting the wls environment

Beginning application tier Stage – Wed Apr 1 07:38:32 2015

/u01/install/DEV/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/install/DEV/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:
/u01/install/DEV/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:
/u01/install/DEV/fs1/EBSapps/comn/java/classes:
/u01/install/DEV/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:
/u01/install/DEV/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:
/u01/install/DEV/fs1/FMW_Home/webtier/oui/jlib/share.jar:
/u01/install/DEV/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/DEV/fs1/FMW_Home/webtier/jlib/ojmisc.jar:
/u01/install/DEV/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/DEV/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml -stage /u01/install/DEV/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg

Log file located at /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/admin/log/clone/StageAppsTier_04010738.log

– 20% completed

Completed Stage…

Wed Apr 1 07:45:41 2015

[applmgr@target_appshost scripts]$

Shutdown the Application running on RUN file system

Copy Oracle E-Business Suite application directories from the Run Edition File System to the Patch Edition File System.

Note: Make sure you pay attention to symbolic links under <OracleAS Tools 10.1.2 ORACLE_HOME> and <COMMON_TOP> directories when copying files.

Log on to the Patch Edition File System in the Target System as the applmgr user and enter the following commands:

$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier

[applmgr@target_appshost bin]$ cd /u01/install/DEV/fs2/EBSapps/comn/clone/bin
[applmgr@target_appshost bin]$ perl adcfgclone.pl appsTier

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.37

Enter the APPS password :

Running:

/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/DEV/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/install/DEV/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt

Enter the Weblogic AdminServer password :

Running:

/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/DEV/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/DEV/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt

Running:

/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/DEV/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/DEV/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] : no

Running:

/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/install/DEV/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml
-validate -pairsfile /tmp/adpairsfile_31120.lst
-stage /u01/install/DEV/fs2/EBSapps/comn/clone 2> /tmp/adcfgclone_31120.err;
echo $? > /tmp/adcfgclone_31120.res

Log file located at /u01/install/DEV/fs2/EBSapps/comn/clone/bin/CloneContext_0401144631.log

Target System File Edition type [run] : patch

Enter the full path of Run File System Context file : /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml

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

Target System Fusion Middleware Home set to /u01/install/DEV/fs2/FMW_Home

Target System Web Oracle Home set to /u01/install/DEV/fs2/FMW_Home/webtier

Target System Appl TOP set to /u01/install/DEV/fs2/EBSapps/appl

Target System COMMON TOP set to /u01/install/DEV/fs2/EBSapps/comn

Target System Instance Top set to /u01/install/DEV/fs2/inst/apps/DEV_target_appshost

Target System Port Pool [0-99] : 1

Checking the port pool 1
done: Port Pool 1 is free

Report file located at /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/admin/out/portpool.lst
Complete port information available at /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

/usr/tmp
/usr/tmp
/u01/install/DEV/11.2.0/appsutil/outbound/DEV_dbhost
/usr/tmp

Choose a value which will be set as APPLPTMP value on the target node [1] : 1

Creating the new APPL_TOP Context file from : /u01/install/DEV/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp

The new APPL_TOP context file has been created : /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml

Log file located at /u01/install/DEV/fs2/EBSapps/comn/clone/bin/CloneContext_0401144631.log

Check Clone Context logfile /u01/install/DEV/fs2/EBSapps/comn/clone/bin/CloneContext_0401144631.log for details.

Running Rapid Clone with command:

Running:

perl /u01/install/DEV/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/install/DEV/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/install/DEV/fs2/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/install/DEV/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/install/DEV/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml
-stage /u01/install/DEV/fs2/EBSapps/comn/clone -log /u01/install/DEV/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Wed Apr 1 14:48:10 2015

/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/install/DEV/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/oui/share.jar:
/u01/install/DEV/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml -stage /u01/install/DEV/fs2/EBSapps/comn/clone -showProgress -nopromptmsg

Log file located at /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/admin/log/clone/ApplyAppsTier_04011448.log

\ 100% completed

Completed Apply…

Wed Apr 1 15:06:46 2015

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is no rows selected

[applmgr@target_appshost bin]$

Reset Password
SYSADMIN Password

[applmgr@target_appshost ~]$ AFPASSWD -f SYSADMIN

Enter the ORACLE password of Application Object Library ‘APPSUSER’:

Connected successfully to APPS.

Log file: AFPWD_DEV_868117.log

Enter new password for user [SYSADMIN]:

Verify new password for user [SYSADMIN]:

[applmgr@target_appshost ~]$ cat AFPWD_DEV_868117.log

+—————————————————————————-+

Application Object Library – AFPASSWD

+—————————————————————————-+

Current system time is 01-APR-15 12:01:56

+—————————————————————————-+

Working…

Password is changed successfully for user SYSADMIN.

AFPASSWD completed successfully.

+—————————————————————————-+

Current system time is 01-APR-15 12:02:24

+—————————————————————————-+

[applmgr@target_appshost ~]$

APPS Password
Source Run Filesystem and execute AFPASSSWD

[root@target_appshost ~]# su – applmgr

E-Business Suite Environment Information

—————————————-

RUN File System : /u01/install/DEV/fs1/EBSapps/appl

PATCH File System : /u01/install/DEV/fs2/EBSapps/appl

Non-Editioned File System : /u01/install/DEV/fs_ne

DB Host: dbhost.domain Service/SID: DEV

E-Business Suite Environment Setting

————————————

– Enter [R/r] for sourcing Run File System Environment file, or

– Enter [P/p] for sourcing Patch File System Environment file, or

– Enter anything else to exit

Please choose the environment file you wish to source [R/P]:R

Sourcing the RUN File System …

[applmgr@target_appshost ~]$ AFPASSWD -c APPS -s APPLSYS

Enter the ORACLE password of Application Object Library ‘APPSUSER’:

Connected successfully to APPS.

Enter the password for your ‘SYSTEM’ ORACLE schema:

Connected successfully to SYSTEM.

Log file: AFPWD_DEV_158811.log

Enter new password for user: <Enter new APPS password>

Verify new password for user: <Re-Enter new APPS password>

AFPASSWD completed successfully.

[applmgr@target_appshost ~]$ sqlplus apps/****

SQL*Plus: Release 10.1.0.5.0 – Production on Sat Apr 4 14:47:09 2015

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

SQL> show user

USER is “APPS”

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

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

[applmgr@target_appshost ~]$ cat AFPWD_DEV_158811.log

+—————————————————————————-+

Application Object Library – AFPASSWD

+—————————————————————————-+

Current system time is 04-APR-15 14:46:50

+—————————————————————————-+

Working…

AFPASSWD completed successfully.

+—————————————————————————-+

Current system time is 04-APR-15 14:47:02

+—————————————————————————-+

[applmgr@target_appshost ~]$

Run autoconfig with the newly changed password.

[applmgr@target_appshost ~]$ adautocfg.sh -appspass=devapps

iii. Start AdminServer
[applmgr@target_appshost ~]$ $INST_TOP/admin/scripts/adadminsrvctl.sh start
Change the “apps” password in WLS Datasource as follows
Log in to WLS Administration Console.
Click Lock & Edit in Change Center.
In the Domain Structure tree, expand Services, then select Data Sources.
On the “Summary of JDBC Data Sources” page, select EBSDataSource.
On the “Settings for EBSDataSource” page, select the Connection Pool tab.
Enter the new password in the “Password” field.
Enter the new password in the “Confirm Password” field.
Click Save.
Click Activate Changes in Change Center.

Update Below Profiles at Site Level

Profile Option Name	Value
Java Color Scheme	Red
Site Name	:::::::::::: [ DEV ] – Cloned from CRP1 on 01-April-2015 ::::::::::::
Signon Password Length	6
Signon Password Hard To Guess	Yes
Signon Password No Reuse	180
Sign-On:Notification	Yes
ICX:Session Timeout	30

Check the Login and release the environment 🙂

Oracle EBS 12.2.4 Installation using VM Template from eDelivery

April 21, 2015EBS on ODAFarhan Shaikh

Installing Oracle™ E-Business Suite 12.2.4 from Oracle VM Template on ODA X4-2

Install Oracle VM Server
• Install Oracle VM Manager
• Download the EBS 12.2.4 templates
• Import the relevant template in to VM Server– using VM Manager
• Create a Virtual Machine from the Template
• Start the newly created VM which is an EBS machine.
• Confirm OS Pre-Req
• Configure the network through the prepared scripts
• Configure the EBS’s Database Tier through the prepared scripts
• Configure the EBS’s Application Tier through the prepared scripts

Download the EBS 12.2.4 templates
The Oracle E-Business Suite Release 12.2.4 VM Virtual Appliances are delivered in a single media pack, “Oracle VM Virtual Appliances for Oracle E-Business Suite Release 12.2.4 Media Pack for x86 (64-bit)”. This media pack contains a series of downloadable components or packages, and each package contains one or more zip files.
For the Production database install, you will need the following six component packages:

V56218-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V56218-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
• V56219-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V56219-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
• V56220-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V56220-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64

For the application tier install, you will need the following ten component packages:
• V59635-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V59635-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
• V59636-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V59636-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
• V59637-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V59637-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
• V59638-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V59638-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
• V59639-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V59639-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
For the sparse application tier install, you will need the following component package:
• V55217-01 Oracle E-Business Suite Release 12.2.4 Sparse Tier/OS Install X86 (64 bit) Linux x86-64
To download the VM Virtual Appliances for Oracle E-Business Suite Release 12.2.4:
1. On the Oracle Software Delivery Cloud (https://edelivery.oracle.com/) page, use the “Cloud Portal (Main)” drop-down menu to select “Oracle Linux/VM”.
2. Click the Sign In/Register button.
3. Read and accept the Terms and Restrictions and click the Continue button.
4. On the Media Pack Search page, select the following values:
o Select a Product Pack: Oracle VM Templates
o Platform: x86 64 bit
5. Select the “Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.4 for x86 (64-bit)” media pack from the search result table, and click the Continue button.
The packages listed above, corresponding to the 5 available Oracle E-Business Suite 12.2.4 appliances, appear.
6. Download the desired packages and thus the zip files which contain the associated appliances.
For example, download the eight component packages for “Oracle E-Business Suite Release 12.2.4 Vision Demo Database Tier Install X86 (64 bit)”.

Confirm OS Pre-Req

If not using the pre-install rpm, the following packages (or versions of packages) which are not part of the OS distribution media must be downloaded separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/) for both Oracle Linux 6 and RHEL 6 and installed manually on the application tier:
• openmotif21-2.1.30-11.EL6.i686 (32-bit)1
• xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386 (32-bit)
Additionally, the following rpm needs to be installed from the Oracle Linux 6 or RHEL 6 distribution media on the application tier:
• libXrender-0.9.5-1.el6.i686
If not using the pre-install rpm, the following packages must be installed from the Oracle Linux 6 or RHEL 6 distribution media on both the application and database tiers:
• binutils-2.20.51.0.2-5.20.el6.x86_64
• compat-libstdc++-296-2.96-144.el6.i686
• compat-libstdc++-33-3.2.3-69.el6.i686
• gcc-4.4.5-6.el6.x86_64
• gcc-c++-4.4.5-6.el6.x86_64
• glibc-2.12-1.7.el6.i686 (32-bit)
• glibc-2.12-1.7.el6.x86_64
• glibc-common-2.12-1.7.el6.x86_64
• glibc-devel-2.12-1.7.el6.i686 (32-bit)
• glibc-devel-2.12-1.7.el6.x86_64
• libgcc-4.4.4-13.el6.i686
• libgcc-4.4.4-13.el6.x86_64
• libstdc++-devel-4.4.4-13.el6.i686
• libstdc++-devel-4.4.4-13.el6.x86_64
• libstdc++-4.4.4-13.el6.i686
• libstdc++-4.4.4-13.el6.x86_64
• libXi-1.3-3.el6.i686
• libXp-1.0.0-15.1.el6.i686
• libXp-1.0.0-15.1.el6.x86_64
• libaio-0.3.107-10.el6.i686
• libaio-0.3.107-10.el6.x86_64
• libgomp-4.4.4-13.el6.x86_64
• make-3.81-19.el6.x86_64
• gdbm-1.8.0-36.el6.i686
• gdbm-1.8.0-36.el6.x86_64
• redhat-lsb-4.0-3.0.1.el6.x86_64
• sysstat-9.0.4-11.el6.x86_64
• util-linux-ng-2.17.2-6.el6.x86_64
Additionally, the following RPMs are required for the database tier (running Oracle Database 11gR2):
• compat-libcap1-1.10-1.x86_64
• compat-libstdc++-33-3.2.3-69.el6.x86_64
• elfutils-libelf-devel-0.148.1-el6.x86_64
• libaio-devel-0.3.107-10.el6.i686
• libaio-devel-0.3.107-10.el6.x86_64
• unixODBC-2.2.14-11.el6.i686
• unixODBC-devel-2.2.14-11.el6.i686
• xorg-x11-utils-7.4-8.el6.x86_64
Alternatively on the database tier, users can install the following pre-install rpm (available via ULN on http://linux.oracle.com or the Oracle Public yum repository on http://public-yum.oracle.com) :
• oracle-rdbms-server-11gR2-preinstall.x86_64
The E-Business Suite Pre-Install RPM includes all the above required rpms and dependencies for running the application and database tiers – see the ‘E-Business Suite Pre-Install RPM’ section below for more details.
Note:
The openmotif package version must be 2.1.30 (for example, openmotif-2.3.3-1 is not supported).
Swap Space
It is recommended that the swap space on the system be 16 GB or more. To determine the size of the configured swap space, enter the following command:
# grep SwapTotal /proc/meminfo

Kernel Settings
Edit the /etc/sysctl.conf file to configure your kernel settings to the minimum values shown below. After editing the file, use the “sysctl -p” command or restart the system to invoke the new settings.
Note: If the current value for any parameter is higher than the value listed in the following table, then do not change the value of that parameter.
The following table lists the kernel settings for Oracle Linux 5 and 6, Red Hat Enterprise Linux 5 and 6, and SUSE Linux Enterprise Server 10 and 11:
Parameter Value
kernel.semmsl 2561
kernel.semmns 320001
kernel.semopm 1001
kernel.semmni 1421
kernel.shmall 20971524
kernel.shmmax Half the size of the physical memory (in bytes), and at least 42949672952
kernel.shmmni 4096
kernel.msgmax 8192
kernel.msgmnb 65535
kernel.msgmni 2878
fs.file-max 6815744
fs.aio-max-nr 1048576
net.ipv4.ip_local_port_range 9000 655003
net.ipv4.tcp_tw_recycle 05
net.core.rmem_default 262144
net.core.rmem_max 4194304
net.core.wmem_default 262144
net.core.wmem_max 1048576
set using the following entry in the /etc/sysctl.conf file
kernel.sem = 256 32000 100 142

Domain Name System (DNS) Resolver Parameters
Two Domain Name System (DNS) resolver parameters (timeout and attempts) are set by default to low values when the operating system is installed. These low values may cause network connections to an Oracle database to fail. If this happens, add or update the following entries to these minimum settings in the /etc/resolv.conf file on each server node:
options attempts:5
options timeout:15

For Oracle Linux 5 and 6, and Red Hat Enterprise Linux 5 and 6:
1. Verify that the /etc/hosts file is formatted as follows:
127.0.0.1 localhost.localdomain localhost
[ip_address] [node_name].[domain_name] [node_name]
2. Verify that the /etc/sysconfig/network file is formatted as follows:
HOSTNAME=[node_name].[domain_name]

or as follows:
HOSTNAME=[node_name]
NISDOMAIN=[domain_name]

If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.
4. If you changed any files in the previous steps, restart the system.
Modifying the Number of Open File Descriptors
Open the /etc/security/limits.conf file and change the existing values for “hard” and “soft” parameters as follows. Restart the system after making changes.
Note: If the current value for any parameter is higher than the value listed below, do not change the value of that parameter as the following are suggested minimum values.
* hard nofile 65536
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047
* hard stack 16384

Link to Motif library in Oracle Application Server 10.1.2 (on Oracle Linux 5, 6 and RHEL 5, 6 only)
Perform the following command (as root on your system) to update a required link to a Motif library prior to relinking or patching the 10.1.2 Application Server Oracle Home:
# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

Configure EBS Database Tier

Run script visiondbconfig.sh from /u01/install/VISION/scripts
Add your SID or Database Name (i.e.: VIS)

[root@dbhost scripts]# sh proddbconfig.sh

Pinging the Host dbhost.domain.com…
The Host dbhost.domain.com is responding
proceeding with the configuration…

==================================================
Prepare the Pairs File for Database Tier Clone…
===================================================

===========================================
ORACLE_SID is not set in the Pairs File
Enter the Oracle Database SID :CRP1

==========================================================
Starting DB Tier configuration
==========================================================
Parameters Used for this Configuration…
The Pairs File :/u01/install/PROD/scripts/inst_db_pairs.txt
The Source context file used :/u01/install/PROD/11.2.0/appsutil/clone/context/db/CTXORIG.xml
The Target context file :/u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml
==========================================================
The Configuration Used to Create this VM…
The Oracle E-Business Suite DBSID : CRP1
The Oracle E-Business Suite DB HostName : <Enter Database Host Server Name>
The Oracle E-Business Suite DB Domain Name :<Enter Server Domain>
The Oracle E-Business Suite DB TNS Port :1521
==========================================================
/u01/install/PROD/11.2.0/oui/bin/detachHome.sh: line 5: cd: /u01/install/VISION/db/tech_st/11.2.0/oui/bin: No such file or directory
/u01/install/PROD/11.2.0/oui/bin/detachHome.sh: line 6: ./runInstaller: No such file or directory

==========================================================
Cloning the DB Tier Context File
==========================================================

Oracle E-Business Suite Rapid Clone

Version 12.2

adclonectx Version 120.30.12020000.8

Running:
/u01/install/PROD/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/PROD/11.2.0/appsutil/clone/bin/../jlib/ojdbc5.jar:/u01/install/PROD/11.2.0/appsutil/clone/bin/../jlib/xmlparserv2.jar:/u01/install/PROD/11.2.0/appsutil/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext -e /u01/install/PROD/11.2.0/appsutil/clone/context/db/CTXORIG.xml -pairsfile /u01/install/PROD/scripts/inst_db_pairs.txt -out /u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml -noprompt

Log file located at /u01/install/PROD/11.2.0/appsutil/log/CloneContext_0319065452.log
Report file located at /u01/install/PROD/11.2.0/appsutil/temp/portpool.lst
Complete port information available at /u01/install/PROD/11.2.0/appsutil/temp/portpool.lst

Creating the new Database Context file from :
/u01/install/PROD/11.2.0/appsutil/clone/context/db/adxdbctx.tmp

The new database context file has been created :
/u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml

Log file located at /u01/install/PROD/11.2.0/appsutil/log/CloneContext_0319065452.log
contextfile=/u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml
Check Clone Context logfile /u01/install/PROD/11.2.0/appsutil/log/CloneContext_0319065452.log for details.

Executing adcfgclone.pl on the Database Tier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.35
stty: standard input: Inappropriate ioctl for device

Enter the APPS password :
stty: standard input: Inappropriate ioctl for device

Running Rapid Clone with command:
Running:
perl /u01/install/PROD/11.2.0/appsutil/clone/bin/adclone.pl java=/u01/install/PROD/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/u01/install/PROD/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml showProgress contextValidated=false

Beginning database tier Apply – Thu Mar 19 06:54:54 2015

/u01/install/PROD/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/u01/install/PROD/11.2.0/oui -classpath /u01/install/PROD/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/install/PROD/11.2.0/appsutil/clone/jlib/ojdbc6.jar:/u01/install/PROD/11.2.0/appsutil/clone/jlib/java:/u01/install/PROD/11.2.0
/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/install/PROD/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/install/PROD/11.2.0/appsutil/clone/jlib/oui/share.jar:/u01/install/PROD/11.2.0/appsutil/

clone/jlib/oui/srvm.jar:/u01/install/PROD/11.2.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml -stage /u01/install/PROD/11.2.0/appsutil/clone -showProgress
APPS Password : Log file located at /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/ApplyDBTier_03190654.log
| 0% completed
Log file located at /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/ApplyDBTier_03190654.log
Determining Source system database type (“single” or “rac”).
Source system indentified as being of type “single”!
\ 15% completed

Completed Apply…
Thu Mar 19 07:02:52 2015

Starting database listener for CRP1:
Running:
/u01/install/PROD/11.2.0/appsutil/scripts/CRP1_dbhost/addlnctl.sh start CRP1
Logfile: /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process CRP1 …

Listener CRP1 has already been started.

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt for more information …

Do you want to change the password for all EBS Schemas? (y/n) [n]) :
Do you want to change the apps password? (y/n) [n]) :
Do you want to change the sys and system passwords? (y/n) [n]) :

Cloning the DB Tier Completed SuccessfullyLogfile: /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt

You are running addlnctl.sh version 120.4

Shutting down listener process CRP1 …

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 19-MAR-2015 07:02:53

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost.domain.com)(PORT=1521)))
The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt for more information …

You are running addbctl.sh version 120.1

Shutting down database CRP1 …

SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 19 07:02:53 2015

Connected.
Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

addbctl.sh: exiting with status 0

========================================================== Enabling the DB Service Startup on Boot ==========================================================

==========================================================
Starting the Oracle E-Business Suite DB Tier Services
==========================================================
Logfile: /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process CRP1 …

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 19-MAR-2015 07:03:32

Starting /u01/install/PROD/11.2.0/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 11.2.0.4.0 – Production
System parameter file is /u01/install/PROD/11.2.0/network/admin/CRP1_dbhost/listener.ora
Log messages written to /u01/install/PROD/11.2.0/admin/CRP1_dbhost/diag/tnslsnr/dbhost/crp1/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbhost.domain.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost.domain.com)(PORT=1521)))
STATUS of the LISTENER
————————
Alias CRP1
Version TNSLSNR for Linux: Version 11.2.0.4.0 – Production
Start Date 19-MAR-2015 07:03:32
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/install/PROD/11.2.0/network/admin/CRP1_dbhost/listener.ora
Listener Log File /u01/install/PROD/11.2.0/admin/CRP1_dbhost/diag/tnslsnr/dbhost/crp1/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbhost.domain.com)(PORT=1521)))
Services Summary…
Service “CRP1” has 1 instance(s).
Instance “CRP1”, 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/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt for more information …

You are running addbctl.sh version 120.1

Starting the database CRP1 …

SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 19 07:03:32 2015

Connected to an idle instance.
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size 2254952 bytes
Variable Size 486541208 bytes
Database Buffers 1627389952 bytes
Redo Buffers 21700608 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

addbctl.sh: exiting with status 0

=====================INSTALLATION SUMMARY============

The Oracle E-Business Suite DB HostName : dbhost.domain.com
The Base Installation Directory : /u01/install/PROD
The Oracle Home Location : /u01/install/PROD/11.2.0
The Oracle E-Business Suite Data File Dir: /u01/install/PROD/data
The Oracle E-Business Suite DBSID : CRP1
The Oracle E-Business Suite DB TNS Port : 1521
==========================================================
[root@dbhost scripts]#

Configure EBS Application Tier
Run script appsconfig.sh from /u01/install/APPS/scripts

[root@appshost scripts]# pwd
/u01/install/APPS/scripts
[root@appshost scripts]# ls
appscleanup.sh appsconfig.sh appspairs.txt apps.rc inst_apps_pairs.txt startapps.sh stopapps.sh
[root@appshost scripts]# hostname
appshost.domain.com
[root@appshost scripts]# sh appsconfig.sh
===================ATTENTION====================================
Successful Configuration of this Virtual Machine requires
connectivity to the E-Business Suite Database Tier
Please Ensure that this host can connect to the DB Tier before
proceeding with the configuration. The sqlnet.ora file on the
Database Tier need to contain the hostname you are going
to use for this Virtual Machine.
============================================================
Press any key to continue…

=======================================
Configuring Oracle E-Business Suite…

==================================================
Prepare the Pairs File for Application Tier Clone…
===================================================

Pinging the Host appshost.domain.com…
The Host appshost.domain.com is responding
proceeding with the configuration…

==================================================
Checking if the FQDN is > 30 chars…
===================================================

The FQDN is less than 30 characters. Proceeding with the configuration
Database Tier Information is not set in the Pairs File
Prompting the user for Database Tier Information

Enter the IP Address of the DB Tier Host:**.**.**.**

Enter the Database Tier Host Name (without the domain) :dbhost

Enter the Database Tier Domain Name :domain.com

Enter the Oracle Database SID :CRP1

Enter the TNS Listener Port Number :1521

Updating /etc/hosts file with DB Tier Information

==========================================================
Starting Apps Tier configuration
==========================================================
Parameters Used for this Configuration…
The Pairs File :/u01/install/APPS/scripts/inst_apps_pairs.txt
The Source context file used :/u01/install/APPS/fs1/EBSapps/comn/clone/context/apps/CTXORIG.xml
The Target context file :/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml

==========================================================
Checking for the DB Host and Database
==========================================================

Pinging the Database Host dbhost.domain.com…

The Database Host dbhost.domain.com seem to be up
Proceeding with rest of the configuration…

Connected to Database CRP1 on dbhost…

==========================================================
Configuring the VM as a new Application Tier Node
==========================================================

==========================================================
Configuring the Application Tier File System (fs1)
==========================================================

==========================================================
Cloning the Application Tier Context File
==========================================================

Executing the command su applmgr -c echo apps|./adclonectx.pl contextfile=/u01/install/APPS/fs1/EBSapps/comn/clone/context/apps/CTXORIG.xml pairsfile=/u01/install/APPS/scripts/inst_apps_pairs.txt outfile=/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml nopromptmsg
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adclonectx Version 120.30.12020000.10

Running:
/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/ojdbc6.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/xmlparserv2.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext -e /u01/install/APPS/fs1/EBSapps/comn/clone/context/apps/CTXORIG.xml -pairsfile /u01/install/APPS/scripts/inst_apps_pairs.txt -out /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -noprompt

Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/log/CloneContext_0319064602.log

Target System Base Directory set to /u01/install/APPS

Target System Current File System Base set to /u01/install/APPS/fs1

Target System Other File System Base set to /u01/install/APPS/fs2

Target System Fusion Middleware Home set to /u01/install/APPS/fs1/FMW_Home

Target System Web Oracle Home set to /u01/install/APPS/fs1/FMW_Home/webtier

Target System Appl TOP set to /u01/install/APPS/fs1/EBSapps/appl

Target System COMMON TOP set to /u01/install/APPS/fs1/EBSapps/comn

Target System Instance Top set to /u01/install/APPS/fs1/inst/apps/CRP1_appshost
Report file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/out/portpool.lst
Complete port information available at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/out/portpool.lst

Creating the new APPL_TOP Context file from :
/u01/install/APPS/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp

The new APPL_TOP context file has been created :
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml

Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/log/CloneContext_0319064602.log
contextfile=/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml
Check Clone Context logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/log/CloneContext_0319064602.log for details.

Executing the command perl adcfgclone.pl appsTier /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.37
stty: standard input: Inappropriate ioctl for device

Enter the APPS password :
stty: standard input: Inappropriate ioctl for device
Running:
/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt

stty: standard input: Inappropriate ioctl for device

Enter the Weblogic AdminServer password :
stty: standard input: Inappropriate ioctl for device
Running:
/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Running Rapid Clone with command:
Running:
perl /u01/install/APPS/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre mode=apply
stage=/u01/install/APPS/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml showProgress contextValidated=false

FMW Pre-requisite check log file location : /u01/install/APPS/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/install/APPS/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -stage /u01/install/APPS/fs1/EBSapps/comn/clone -log /u01/install/APPS/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Thu Mar 19 06:46:11 2015

/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/install/APPS/fs1/EBSapps/comn/
clone/jlib/oui/share.jar:/u01/install/APPS/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -stage /u01/install/APPS/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/log/clone/ApplyAppsTier_03190646.log
| 0% completed
Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/log/clone/ApplyAppsTier_03190646.log
/ 100% completed

Completed Apply…
Thu Mar 19 07:05:06 2015

Executing command: /u01/install/APPS/fs1/EBSapps/10.1.2/bin/sqlplus @/u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql

Do you want to startup the Application Services for CRP1? (y/n) [n] :
Services not started

==========================================================
Configuring the Application Tier File System (fs2) appsconfig.sh: line 373: print: command not found

Copying the Application Tier File System from fs1 to fs2

/u01/install/APPS/fs2/FMW_Home exists. Proceeding to detach and remove the Home
Starting Oracle Universal Installer…

Checking swap space: must be greater than 500 MB. Actual 10239 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/install/oraInventory
‘DetachHome’ was successful.
Starting Oracle Universal Installer…

Executing the command su applmgr -c perl adcfgclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.37
stty: standard input: Inappropriate ioctl for device

Enter the APPS password :
stty: standard input: Inappropriate ioctl for device
Running:
/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/install/APPS/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
stty: standard input: Inappropriate ioctl for device

Enter the Weblogic AdminServer password :
stty: standard input: Inappropriate ioctl for device
Running:
/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs2/EBSapps/comn/
clone/jlib/java:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/APPS/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs2/EBSapps/comn/
clone/jlib/java:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/APPS/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] :

Running:
/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/APPS/fs2/EBSapps/comn/clone/jlib/java:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext
-e /u01/install/APPS/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_15345.lst
-stage /u01/install/APPS/fs2/EBSapps/comn/clone 2> /tmp/adcfgclone_15345.err; echo $? > /tmp/adcfgclone_15345.res

Log file located at /u01/install/APPS/fs2/EBSapps/comn/clone/bin/CloneContext_0319070637.log

Target System File Edition type [patch] :
Enter the full path of Run File System Context file :
Provide the values required for creation of the new APPL_TOP Context file.

Target System Fusion Middleware Home set to /u01/install/APPS/fs2/FMW_Home

Target System Web Oracle Home set to /u01/install/APPS/fs2/FMW_Home/webtier

Target System Appl TOP set to /u01/install/APPS/fs2/EBSapps/appl

Target System COMMON TOP set to /u01/install/APPS/fs2/EBSapps/comn

Target System Instance Top set to /u01/install/APPS/fs2/inst/apps/CRP1_appshost

Target System Port Pool [0-99] :
Checking the port pool 1
done: Port Pool 1 is free
Report file located at /u01/install/APPS/fs2/inst/apps/CRP1_appshost/admin/out/portpool.lst
Complete port information available at /u01/install/APPS/fs2/inst/apps/CRP1_appshost/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

/usr/tmp
2. /usr/tmp
3. /u01/install/PROD/11.2.0/appsutil/outbound/CRP1_dbhost
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : RC-00208: Error: Not a valid number

UTL_FILE_DIR on database tier consists of the following directories.

/usr/tmp
2. /usr/tmp
3. /u01/install/PROD/11.2.0/appsutil/outbound/CRP1_dbhost
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : RC-00200: Error: Exception occurred while taking input from user

Creating the new APPL_TOP Context file from :
/u01/install/APPS/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp

The new APPL_TOP context file has been created :
/u01/install/APPS/fs2/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml

Log file located at /u01/install/APPS/fs2/EBSapps/comn/clone/bin/CloneContext_0319070637.log
Check Clone Context logfile /u01/install/APPS/fs2/EBSapps/comn/clone/bin/CloneContext_0319070637.log for details.

Running Rapid Clone with command:
Running:
perl /u01/install/APPS/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre mode=apply
stage=/u01/install/APPS/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/install/APPS/fs2/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/install/APPS/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/install/APPS/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/install/APPS/fs2/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -stage /u01/install/APPS/fs2/EBSapps/comn/clone -log /u01/install/APPS/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Thu Mar 19 07:06:48 2015

/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/install/APPS/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u01/install/APPS/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/install/APPS/fs2/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -stage /u01/install/APPS/fs2/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/install/APPS/fs2/inst/apps/CRP1_appshost/admin/log/clone/ApplyAppsTier_03190706.log
/ 100% completed

Completed Apply…
Thu Mar 19 07:25:07 2015

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is no rows selected

==========================================================
Enabling the Apps Tier Service Startup on Boot
==========================================================

==========================================================
Starting the Oracle E-Business Suite Application tier Services
==========================================================
Starting the Oracle E-Business Suite Application Tier Services
You are running adstrtal.sh version 120.24.12020000.10

The logfile for this session is located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adstrtal.log

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/jtffmctl.sh start
Timeout specified in context file: 100 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running jtffmctl.sh version 120.3.12020000.4

Validating Fulfillment patch level via /u01/install/APPS/fs1/EBSapps/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for CRP1 on port 9300 …

jtffmctl.sh: exiting with status 0

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adopmnctl.sh start
Timeout specified in context file: 100 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running adopmnctl.sh version 120.0.12020000.2

Starting Oracle Process Manager (OPMN) …

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adopmnctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adapcctl.sh start
Timeout specified in context file: 100 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running adapcctl.sh version 120.0.12020000.6

Starting OPMN managed Oracle HTTP Server (OHS) instance …

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adapcctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adnodemgrctl.sh start -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running adnodemgrctl.sh version 120.11.12020000.11

Calling txkChkEBSDependecies.pl to perform dependency checks for ALL MANAGED SERVERS
Perl script txkChkEBSDependecies.pl got executed successfully

Starting the Node Manager…
Refer /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adnodemgrctl.txt for details

adnodemgrctl.sh: exiting with status 0

adnodemgrctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adnodemgrctl.txt for more information …

.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/rgf/TXK/txkChkEBSDependecies_Thu_Mar_19_07_25_16_2015/txkChkEBSDependecies_Thu_Mar_19_07_25_16_2015.log

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adalnctl.sh start
Timeout specified in context file: 100 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

adalnctl.sh version 120.3.12020000.2

Checking for FNDFS executable.
Starting listener process APPS_CRP1.

adalnctl.sh: exiting with status 0

adalnctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adalnctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adcmctl.sh start
Timeout specified in context file: 1000 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running adcmctl.sh version 120.19.12020000.3

Starting concurrent manager for CRP1 …
Starting CRP1_0319@CRP1 Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0

adcmctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adcmctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adadminsrvctl.sh start -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running adadminsrvctl.sh version 120.10.12020000.9

Starting WLS Admin Server…
Refer /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adadminsrvctl.txt for details

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adadminsrvctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/admanagedsrvctl.sh start forms_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running admanagedsrvctl.sh version 120.14.12020000.9

Starting forms_server1…

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adformsctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/admanagedsrvctl.sh start forms-c4ws_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running admanagedsrvctl.sh version 120.14.12020000.9

Starting forms-c4ws_server1…

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adforms-c4wsctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/admanagedsrvctl.sh start oafm_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running admanagedsrvctl.sh version 120.14.12020000.9

Starting oafm_server1…

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adoafmctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/admanagedsrvctl.sh start oacore_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running admanagedsrvctl.sh version 120.14.12020000.9

Starting oacore_server1…

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adoacorectl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adstrtal.log for more information …

===================INSTALLATION SUMMARY=============================
Oracle E-Business Suite Installation Top Level Directory : /u01/install/APPS
Oracle E-Business Suite Context File : /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml
Oracle E-Business Suite Login Page : http://appshost.domain.com:8000/OA_HTML/AppsLogin
Oracle E-Business Suite Database Tier Host : dbhost.domain.com
Oracle E-Business Suite Database SID : CRP1
Oracle E-Business Suite TNS_PORT : 1521
==================================================================

Press any key to continue…
[root@appshost scripts]#

5. Run PreClone on Application Tier
[root@appshost ~]# su – applmgr

E-Business Suite Environment Information
—————————————-
RUN File System : /u01/install/APPS/fs1/EBSapps/appl
PATCH File System : /u01/install/APPS/fs2/EBSapps/appl
Non-Editioned File System : /u01/install/APPS/fs_ne

DB Host: dbhost.domain.com Service/SID: CRP1

E-Business Suite Environment Setting
————————————
– Enter [R/r] for sourcing Run File System Environment file, or
– Enter [P/p] for sourcing Patch File System Environment file, or
– Enter anything else to exit

Please choose the environment file you wish to source [R/P]:R

Sourcing the RUN File System …
[applmgr@appshost ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@appshost scripts]$ perl adpreclone.pl appsTier

Oracle E-Business Suite Rapid Clone

Version 12.2

adpreclone Version 120.31.12020000.16

Enter the APPS User Password:
Enter the Weblogic AdminServer password :

Checking the status of the Oracle WebLogic Administration Server….

Running perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -servername=AdminServer -promptmsg=hide

The Oracle WebLogic Administration Server is up.

Running:
perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/install/APPS/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/u01/install/APPS/fs1/EBSapps/comn/clone component=appsTier method= appctx=/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml showProgress

Setting the wls environment

Beginning application tier Stage – Thu Mar 19 09:47:15 2015

/u01/install/APPS/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/install/APPS/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/install/APPS/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:
/u01/install/APPS/fs1/EBSapps/comn/java/classes:/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/share.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/APPS/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/APPS/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -stage /u01/install/APPS/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg

Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/log/clone/StageAppsTier_03190947.log

\ 20% completed

Completed Stage…
Thu Mar 19 09:55:17 2015
[applmgr@appshost scripts]$

Take Cold Backup

Growth of DB

March 12, 2012UncategorizedFarhan Shaikh

— SQL to find Historical Growth Of Oracle Database
set echo off
set pagesize 9999
set lines 9999
col Month for a10
col year for a8
clear breaks
break on year nodup skip 1

select
to_char(creation_time,’RRRR’) Year
,to_char(creation_time,’MM’) Month
,sum(bytes) / 1024/1024 “Size in MB”
from v$datafile
group by to_char(creation_time,’RRRR’)
,to_char(creation_time,’MM’)
order by 1,2;

E-Business Suite 12.2

June 8, 2011UncategorizedFarhan Shaikh

There are lots of updates coming in this release, but from a technology stack perspective, EBS 12.2 will be notable for two things:

1) Replacing Oracle Containers for Java (OC4J) 10g with WebLogic Server 11g
2) Online Patching support via 11gR2 Edition-Based Redefinition

1. Replacing OC4J with WebLogic Server

EBS 12.2 will use WebLogic Server from Fusion Middleware 11g in place of OC4J 10g as part of the release’s internal technology stack. Other additional new Fusion Middleware 11g components used will include WebLogic JSP and UIX 11g.

2. Online Patching support via 11gR2 Edition-Based Redefinition

EBS 12.2 will use the 11gR2 Database’s Edition-Based Redefinition features to provide support for Online Patching. Edition-Based Redefinition is really exciting new technology. From the 11gR2 Application Developer’s Guide:

“Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.

“To upgrade an application while it is in use, you copy the database objects that comprise the application and redefine the copied objects in isolation. Your changes do not affect users of the application—they continue to run the unchanged application. When you are sure that your changes are correct, you make the upgraded application available to all users.”

Online Patching means that patches that change EBS database objects can be applied while the E-Business Suite production instance is fully operational. Only a short downtime will be required to complete the patching process. This will make your patching downtimes more predictable.

SQL to get details of Concurrent Program (FND_CONC_REQ_SUMMARY_V)

May 31, 2011UncategorizedFarhan Shaikh

Hi Friends,

I have framed a sql query with help of my technical friends to get below details

1. Request id

2. Concurrent program full name

3. Concurrent program short name

4. Start time, and End time.

5. Runtime

6. Parameters passed to the request

7. Submitted by

8. Status code and Phase code

SELECT request_id,
user_concurrent_program_name Concurrent_Program_Full_Name,
program_short_name Concurrent_Program_Short_Name,
actual_start_date,
actual_completion_date,
FLOOR( ( (actual_completion_date – actual_start_date) * 24 * 60 * 60)
/ 3600)
|| ‘ HOURS ‘
|| FLOOR( ( ( (actual_completion_date – actual_start_date)
* 24
* 60
* 60)
– FLOOR( ( (actual_completion_date – actual_start_date)
* 24
* 60
* 60)
/ 3600)
* 3600)
/ 60)
|| ‘ MINUTES ‘
|| ROUND( ( ( (actual_completion_date – actual_start_date)
* 24
* 60
* 60)
– FLOOR( ( (actual_completion_date – actual_start_date)
* 24
* 60
* 60)
/ 3600)
* 3600
– (FLOOR( ( ( (actual_completion_date – actual_start_date)
* 24
* 60
* 60)
– FLOOR( ( (actual_completion_date
– actual_start_date)
* 24
* 60
* 60)
/ 3600)
* 3600)
/ 60)
* 60)))
|| ‘ SECS ‘
time_difference,
argument_text Parameter,
requestor submited_by,
status_code,
phase_code
FROM FND_CONC_REQ_SUMMARY_V

Concurrent Manager showing status “System Hold, Fix Manager before resetting counters”.

May 31, 2011UncategorizedFarhan Shaikh

Hi friends,

Recently after EBS upgrade to 12.1.3 CM were not functional and was showing status “System Hold, Fix Manager before resetting counters”.

Issue:
Concurrent Manager showing status “System Hold, Fix Manager before resetting counters”.

Solution:
To implement the solution, please execute the following steps:

1. Stop all middle tier services including the concurrent managers.
Please make sure that no FNDLIBR, FNDSM, or any dead process is
running.

2. Go to cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y “fnd FNDLIBR”
$ adrelink.sh force=y link_debug=y “fnd FNDFS”
$ adrelink.sh force=y link_debug=y “fnd FNDCRM”
$ adrelink.sh force=y link_debug=y “fnd FNDSM”

3. Run the CMCLEAN.SQL script from the referenced note below (don’t forget to commit).
Note 134007.1 CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables

4. Start the concurrent manager.

5. Retest the issue.

Reference :
SCHEDULE/PRERELEASER MANAGER STATUS : SYSTEM HOLD, FIX MANAGER BEFORE RESETTING [ID 985835.1]

Command to remove ^M character from a file on Unix

May 31, 2011UncategorizedFarhan Shaikh

perl -p -i -e ‘s/\r//’ *

SQL to get details of Scheduled Concurrent Program

May 31, 2011UncategorizedFarhan Shaikh

Hi Friends,

I have found a interesting sql query which gives details of scheduled concurrent requests in EBS.

/*SQL 1*/

SELECT r.request_id
, CASE
WHEN pt.user_concurrent_program_name = ‘Report Set’
THEN DECODE(
r.description
, NULL, pt.user_concurrent_program_name
, r.description
|| ‘ (‘
|| pt.user_concurrent_program_name
|| ‘)’
)
ELSE pt.user_concurrent_program_name
END job_name
, u.user_name requestor
, u.description requestor_description
, u.email_address
, frt.responsibility_name requested_by_resp
, r.request_date
, r.requested_start_date
, DECODE(
r.hold_flag
, ‘Y’, ‘Yes’
, ‘N’, ‘No’
) on_hold
, CASE
WHEN r.hold_flag = ‘Y’
THEN SUBSTR(
u2.description
, 0
, 40
)
END last_update_by
, CASE
WHEN r.hold_flag = ‘Y’
THEN r.last_update_date
END last_update_date
, r.argument_text PARAMETERS
, NVL2(
r.resubmit_interval
, ‘Periodically’
, NVL2(
r.release_class_id
, ‘On specific days’
, ‘Once’
)
) AS schedule_type
, r.resubmit_interval resubmit_every
, r.resubmit_interval_unit_code resubmit_time_period
, DECODE(
r.resubmit_interval_type_code
, ‘START’, ‘From the start of the prior run’
, ‘END’, ‘From the Completion of the prior run’
) apply_the_update_option
, r.increment_dates
, TO_CHAR((r.requested_start_date), ‘HH24:MI:SS’) start_time
FROM applsys.fnd_concurrent_programs_tl pt
, applsys.fnd_concurrent_programs pb
, applsys.fnd_user u
, applsys.fnd_user u2
, applsys.fnd_printer_styles_tl s
, applsys.fnd_concurrent_requests r
, applsys.fnd_responsibility_tl frt
WHERE pb.application_id = r.program_application_id
AND pb.concurrent_program_id = r.concurrent_program_id
AND pb.application_id = pt.application_id
AND r.responsibility_id = frt.responsibility_id
AND pb.concurrent_program_id = pt.concurrent_program_id
AND u.user_id = r.requested_by
AND u2.user_id = r.last_updated_by
AND s.printer_style_name(+) = r.print_style
AND r.phase_code = ‘P’
AND 1 = 1;

/*SQL 2*/

select r.request_id,
p.user_concurrent_program_name || nvl2(r.description,’ (‘||r.description||’)’,null) Conc_prog,
s.user_name REQUESTOR,
r.argument_text arguments,
r.requested_start_date next_run,
r.last_update_date LAST_RUN,
r.hold_flag on_hold,
r.increment_dates,
decode(c.class_type,
‘P’, ‘Periodic’,
‘S’, ‘On Specific Days’,
‘X’, ‘Advanced’,
c.class_type) schedule_type,
case
when c.class_type = ‘P’ then
‘Repeat every ‘ ||
substr(c.class_info, 1, instr(c.class_info, ‘:’) – 1) ||
decode(substr(c.class_info, instr(c.class_info, ‘:’, 1, 1) + 1, 1),
‘N’, ‘ minutes’,
‘M’, ‘ months’,
‘H’, ‘ hours’,
‘D’, ‘ days’) ||
decode(substr(c.class_info, instr(c.class_info, ‘:’, 1, 2) + 1, 1),
‘S’, ‘ from the start of the prior run’,
‘C’, ‘ from the completion of the prior run’)
when c.class_type = ‘S’ then
nvl2(dates.dates, ‘Dates: ‘ || dates.dates || ‘. ‘, null) ||
decode(substr(c.class_info, 32, 1), ‘1’, ‘Last day of month ‘) ||
decode(sign(to_number(substr(c.class_info, 33))),
‘1’, ‘Days of week: ‘ ||
decode(substr(c.class_info, 33, 1), ‘1’, ‘Su ‘) ||
decode(substr(c.class_info, 34, 1), ‘1’, ‘Mo ‘) ||
decode(substr(c.class_info, 35, 1), ‘1’, ‘Tu ‘) ||
decode(substr(c.class_info, 36, 1), ‘1’, ‘We ‘) ||
decode(substr(c.class_info, 37, 1), ‘1’, ‘Th ‘) ||
decode(substr(c.class_info, 38, 1), ‘1’, ‘Fr ‘) ||
decode(substr(c.class_info, 39, 1), ‘1’, ‘Sa ‘))
end as schedule,
c.date1 start_date,
c.date2 end_date
from fnd_concurrent_requests r,
fnd_conc_release_classes c,
fnd_concurrent_programs_tl p,
fnd_user s,
(with date_schedules as (
select release_class_id,
rank() over(partition by release_class_id order by s) a, s
from (select c.class_info, l,
c.release_class_id,
decode(substr(c.class_info, l, 1), ‘1’, to_char(l)) s
from (select level l from dual connect by level 0)
where s is not null)
SELECT release_class_id, substr(max(SYS_CONNECT_BY_PATH(s, ‘ ‘)), 2) dates
FROM date_schedules
START WITH a = 1
CONNECT BY nocycle PRIOR a = a – 1
group by release_class_id) dates
where r.phase_code = ‘P’
and c.application_id = r.release_class_app_id
and c.release_class_id = r.release_class_id
and nvl(c.date2, sysdate + 1) > sysdate
and c.class_type is not null
and p.concurrent_program_id = r.concurrent_program_id
and p.language = ‘US’
and dates.release_class_id(+) = r.release_class_id
and r.requested_by = s.user_id
order by conc_prog, on_hold, next_run;

SELECT fcr.request_id
, fcpt.user_concurrent_program_name|| NVL2(fcr.description, ‘ (‘ || fcr.description || ‘)’, NULL) conc_prog
, fu.user_name requestor
, fu.description requested_by
, fu.email_address
, frt.responsibility_name requested_by_resp
, trim(fl.meaning) status
, fcr.phase_code
, fcr.status_code
, fcr.argument_text “PARAMETERS”
, ‘——>’ dates
, TO_CHAR(fcr.request_date, ‘DD-MON-YYYY HH24:MI:SS’) requested
, TO_CHAR(fcr.requested_start_date, ‘DD-MON-YYYY HH24:MI:SS’) requested_start
, TO_CHAR((fcr.requested_start_date), ‘HH24:MI:SS’) start_time
, ‘——>’ holds
, DECODE(fcr.hold_flag, ‘Y’, ‘Yes’, ‘N’, ‘No’) on_hold
, CASE
WHEN fcr.hold_flag = ‘Y’
THEN SUBSTR(
u2.description
, 0
, 40
)
END last_update_by
, CASE
WHEN fcr.hold_flag = ‘Y’
THEN fcr.last_update_date
END last_update_date
, ‘——>’ prints
, fcr.number_of_copies print_count
, fcr.printer
, fcr.print_style
, ‘——>’ schedule
, fcr.increment_dates
, CASE WHEN fcrc.CLASS_INFO IS NULL THEN
‘Yes: ‘ || TO_CHAR(fcr.requested_start_date, ‘DD-MON-YYYY HH24:MI:SS’)
ELSE
‘n/a’
END run_once
, CASE WHEN fcrc.class_type = ‘P’ THEN
‘Repeat every ‘ ||
substr(fcrc.class_info, 1, instr(fcrc.class_info, ‘:’) – 1) ||
decode(substr(fcrc.class_info, instr(fcrc.class_info, ‘:’, 1, 1) + 1, 1),
‘N’, ‘ minutes’,
‘M’, ‘ months’,
‘H’, ‘ hours’,
‘D’, ‘ days’) ||
decode(substr(fcrc.class_info, instr(fcrc.class_info, ‘:’, 1, 2) + 1, 1),
‘S’, ‘ from the start of the prior run’,
‘C’, ‘ from the completion of the prior run’)
ELSE
‘n/a’
END set_days_of_week
, CASE WHEN fcrc.class_type = ‘S’ AND instr(substr(fcrc.class_info, 33),’1′,1) > 0 THEN
‘Days of week: ‘ ||
decode(substr(fcrc.class_info, 33, 1), ‘1’, ‘Sun, ‘) ||
decode(substr(fcrc.class_info, 34, 1), ‘1’, ‘Mon, ‘) ||
decode(substr(fcrc.class_info, 35, 1), ‘1’, ‘Tue, ‘) ||
decode(substr(fcrc.class_info, 36, 1), ‘1’, ‘Wed, ‘) ||
decode(substr(fcrc.class_info, 37, 1), ‘1’, ‘Thu, ‘) ||
decode(substr(fcrc.class_info, 38, 1), ‘1’, ‘Fri, ‘) ||
decode(substr(fcrc.class_info, 39, 1), ‘1’, ‘Sat ‘)
ELSE
‘n/a’
end days_of_week
, CASE WHEN fcrc.class_type = ‘S’ AND instr(substr(fcrc.class_info, 1, 31),’1′,1) > 0 THEN
‘Set Days of Month: ‘ ||
decode(substr(fcrc.class_info, 1, 1), ‘1’, ‘1st, ‘) ||
decode(substr(fcrc.class_info, 2, 1), ‘1’, ‘2nd, ‘) ||
decode(substr(fcrc.class_info, 3, 1), ‘1’, ‘3rd, ‘) ||
decode(substr(fcrc.class_info, 4, 1), ‘1’, ‘4th, ‘) ||
decode(substr(fcrc.class_info, 5, 1), ‘1’, ‘5th, ‘) ||
decode(substr(fcrc.class_info, 6, 1), ‘1’, ‘6th, ‘) ||
decode(substr(fcrc.class_info, 7, 1), ‘1’, ‘7th, ‘) ||
decode(substr(fcrc.class_info, 8, 1), ‘1’, ‘8th, ‘) ||
decode(substr(fcrc.class_info, 9, 1), ‘1’, ‘9th, ‘) ||
decode(substr(fcrc.class_info, 10, 1), ‘1’, ’10th, ‘) ||
decode(substr(fcrc.class_info, 11, 1), ‘1’, ’11th, ‘) ||
decode(substr(fcrc.class_info, 12, 1), ‘1’, ’12th, ‘) ||
decode(substr(fcrc.class_info, 13, 1), ‘1’, ’13th, ‘) ||
decode(substr(fcrc.class_info, 14, 1), ‘1’, ’14th, ‘) ||
decode(substr(fcrc.class_info, 15, 1), ‘1’, ’15th, ‘) ||
decode(substr(fcrc.class_info, 16, 1), ‘1’, ’16th, ‘) ||
decode(substr(fcrc.class_info, 17, 1), ‘1’, ’17th, ‘) ||
decode(substr(fcrc.class_info, 18, 1), ‘1’, ’18th, ‘) ||
decode(substr(fcrc.class_info, 19, 1), ‘1’, ’19th, ‘) ||
decode(substr(fcrc.class_info, 20, 1), ‘1’, ’20th, ‘) ||
decode(substr(fcrc.class_info, 21, 1), ‘1’, ’21st, ‘) ||
decode(substr(fcrc.class_info, 22, 1), ‘1’, ’22nd, ‘) ||
decode(substr(fcrc.class_info, 23, 1), ‘1’, ’23rd,’ ) ||
decode(substr(fcrc.class_info, 24, 1), ‘1’, ’24th, ‘) ||
decode(substr(fcrc.class_info, 25, 1), ‘1’, ’25th, ‘) ||
decode(substr(fcrc.class_info, 26, 1), ‘1’, ’26th, ‘) ||
decode(substr(fcrc.class_info, 27, 1), ‘1’, ’27th, ‘) ||
decode(substr(fcrc.class_info, 28, 1), ‘1’, ’28th, ‘) ||
decode(substr(fcrc.class_info, 29, 1), ‘1’, ’29th, ‘) ||
decode(substr(fcrc.class_info, 30, 1), ‘1’, ’30th, ‘) ||
decode(substr(fcrc.class_info, 31, 1), ‘1’, ’31st. ‘)
ELSE
‘n/a’
END days_of_month
, CASE WHEN fcrc.class_type = ‘S’ AND substr(fcrc.class_info, 32, 1) = ‘1’ THEN
‘Yes’
ELSE
‘n/a’
END last_day_of_month_ticked
, fcrc.CLASS_INFO
FROM applsys.fnd_concurrent_requests fcr
, applsys.fnd_user fu
, applsys.fnd_user u2
, applsys.fnd_concurrent_programs fcp
, applsys.fnd_concurrent_programs_tl fcpt
, applsys.fnd_printer_styles_tl fpst
, applsys.fnd_conc_release_classes fcrc
, applsys.fnd_responsibility_tl frt
, apps.fnd_lookups fl
WHERE fcp.application_id = fcpt.application_id
AND fcr.requested_by = fu.user_id
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.program_application_id = fcp.application_id
AND fcr.concurrent_program_id = fcpt.concurrent_program_id
AND fcr.responsibility_id = frt.responsibility_id
AND fcr.last_updated_by = u2.user_id
AND fcr.print_style = fpst.printer_style_name(+)
AND fcr.release_class_id = fcrc.release_class_id(+)
AND fcr.status_code = fl.lookup_code
AND fl.lookup_type = ‘CP_STATUS_CODE’
AND fcr.phase_code = ‘P’
AND 1=1
ORDER BY fu.description, fcr.requested_start_date asc;

How To Enable/Disable “Submit Another Request ?”

April 6, 2011UncategorizedFarhan Shaikh

Profile Option “Concurrent: Show Requests Summary After Each Request” controls the behaviour of the application after request submission:

Sysdamin: Profile> System > Query for “Concurrent: Show Requests Summary After Each Request”

If set to Yes, the View Requests form displayed.

If set to No, the Decision Window displayed.

Enjoy Reading ….

Important Views when using Oracle RMAN

March 31, 2011UncategorizedFarhan Shaikh

RC_ARCHIVED_LOG information about all archivelogs.

RC_BACKUP_CONTROLFILE backup control files in backup sets.

RC_BACKUP_CORRUPTION corrupt blocks in datafile backups and copies.

RC_BACKUP_DATAFILE datafile backups (in backup sets).

RC_BACKUP_PIECE backup pieces.

RC_BACKUP_REDOLOG redo log backups (in backup sets).

RC_BACKUP_SET backup sets.

RC_CHECKPOINT rc_checkpoint is replaced by rc_resync, but is still used by some tests.

RC_CONTROLFILE_COPY controlfile copies.

RC_COPY_CORRUPTION corrupt block ranges in datafile copies for all database incarnations.

RC_DATABASE information about databases and their current incarnations.

RC_DATABASE_INCARNATION information about all incarnations registered in recovery catalog.

RC_DATAFILE information about all datafiles registered in recovery catalog.

RC_DATAFILE_COPY datafile copies (on disk).

RC_LOG_HISTORY information about redo log history.

RC_OFFLINE_RANGE offline ranges for datafiles.

RC_REDO_LOG information about online redo logs.

RC_REDO_THREAD information about redo threads.

RC_RESYNC information about recovery catalog resyncs (checkpoints).

RC_STORED_SCRIPT stored scripts.

RC_STORED_SCRIPT_LINE each line of each stored script.

RC_TABLESPACE information about all tablespaces registered in recovery catalog.

How to Turn Archiving ON and OFF

February 9, 2011UncategorizedFarhan Shaikh

Turning Archiving On and Off
You set a database’s initial archiving mode as part of database creation. Usually, you can use the default of NOARCHIVELOG mode at database creation
because there is no need to archive the redo information generated at that time. After creating the database, decide whether to change from the initial archiving mode.

After a database has been created, you can switch the database’s archiving mode on demand. However, you should generally not switch the database between archiving modes.

NOTE: If a database is automatically created during Oracle installation, the initial archiving mode of the database is operating system specific. See your operating system-specific Oracle documentation.

ARCHIVELOG mode is necessary for creating on-line backups and for certain types of database recovery. Configuring the database to operate in
ARCHIVELOG mode allows the user to perform complete and point-in-time recovery from media (disk) failures using off-line or on-line backups. If
ARCHIVELOG mode is disabled, the database can be restored from a backup in case of failure, but it cannot be rolled forward from that to a point when failure occurred.

Oracle recommends ARCHIVELOG mode for all production databases

Setting the Initial Database Archiving Mode
When you create the database, you set the initial archiving mode of the redo log in the CREATE DATABASE statement. If you do not specify either ARCHIVELOG or NOARCHIVELOG, NOARCHIVELOG is the default. To verify database mode, execute following statement:

SQL> Select NAME, CREATED, LOG_MODE, CHECKPOINT_CHANGE#, ARCHIVE_CHANGE# from V$DATABASENAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#——— ——— ———— —————— —————O112 19-MAR-09 NOARCHIVELOG 1438426 135961

Changing the Database Archiving Mode
There are “init.ora” parameters you need to modify in order to properly handle your database being in archive log mode. They are:

LOG_ARCHIVE_DEST LOG_ARCHIVE_FORMAT LOG_ARCHIVE_DEST:
This parameter specifies the directory where your archive logs will be placed.

LOG_ARCHIVE_FORMAT:
This parameter names the archive logs in this format. For example, if your format is: arch%s.arc

Your log files will be called: arch1.arc, arch2.arc, arch3.arc where the ‘1’, ‘2’, ‘3’, etc is the sequence number.

To Prepare to Switch Database Archiving Mode
1. Shut down the database instance.

SQL> shutdown immediateAn open database must be closed and dismounted and any associated instances shut down before the database’s archiving mode can be switched. Archiving cannot be disabled if any datafiles need media recovery.

2. Backup the database.

This backup can be used with the archive logs that you will generate.

3. Perform any operating system specific steps (optional).

4. Start up a new instance and mount, but do not open the database.

SQL> startup mountNOTE: If you are using the Oracle Parallel Server, you must mount the database exclusively using one instance to switch the database’s archiving mode.

5. Put the database into archivelog mode

SQL> alter database archivelog; NOTE: You can also use

alter database noarchivelog to take the database out of archivelog mode

6. Open the database.

SQL> alter database open; 7. Verify your database is now in archivelog mode.

SQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 22Next log sequence to archive 24Current log sequence 248. Archive all your redo logs at this point.

SQL> archive log all; 9. Ensure these newly created Archive log files are added to the backup process.

Ref: Metalink ID 69739.1

What Happens When A Tablespace/Database Is Kept In Begin Backup Mode

February 9, 2011UncategorizedFarhan Shaikh

To perform online/hot backup we have to put the tablespace in begin backup mode followed by copying the datafiles and then putting the tablespace to end backup.

In 8i, 9i we have to put each tablespace individually in begin/end backup mode to perform the online backup. From 10g onwards the entire database can be put in begin/end backup mode.

Make sure that the database is in archivelog mode

Example :

Performing a single tablespace backup

+ sql>alter tablespace system begin backup;
+ Copy the corresponding datafiles using appropriate O/S commands.
+ sql>alter tablespace system end backup;

Performing a full database backup (starting from 10g)

+ sql> alter database begin backup;
+ Copy all the datafiles using appropriate O/S commands.
+ sql> alter database end backup;

One danger in making online backups is the possibility of inconsistent data within a block. For example, assume that you are backing up block 100 in datafile users.dbf. Also, assume that the copy utility reads the entire block while DBWR is in the middle of updating the block. In this case, the copy utility may read the old data in the top half of the block and the new data in the bottom top half of the block. The result is called a fractured block, meaning that the data contained in this block is not consistent. at a given SCN.

Therefore oracle internally manages the consistency as below :

1. The first time a block is changed in a datafile that is in hot backup mode, the entire block is written to the redo log files, not just the changed bytes. Normally only the changed bytes (a redo vector) is written. In hot backup mode, the entire block is logged the first time. This is because you can get into a situation where the process copying the datafile and DBWR are working on the same block simultaneously.

Lets say they are and the OS blocking read factor is 512bytes (the OS reads 512 bytes from disk at a time). The backup program goes to read an 8k Oracle block. The OS gives it 4k. Meanwhile — DBWR has asked to rewrite this block. the OS schedules the DBWR write to occur right now. The entire 8k block is rewritten. The backup program starts running again (multi-tasking OS here) and reads the last 4k of the block. The backup program has now gotten an fractured block — the head and tail are from two points in time.

We cannot deal with that during recovery. Hence, we log the entire block image so that during recovery, this block is totally rewritten from redo and is consistent with itself atleast. We can recover it from there.

2. The datafile headers which contain the SCN of the last completed checkpoint are not updated while a file is in hot backup mode. This lets the recovery process understand what archive redo log files might be needed to fully recover this file.

To limit the effect of this additional logging, you should ensure you only place one tablepspace at a time in backup mode and bring the tablespace out of backup mode as soon as you have backed it up. This will reduce the number of blocks that may have to be logged to the minimum possible.

Ref : Metalink ID 469950.1

Query to find number of archive logs getting generated every day

January 31, 2011UncategorizedFarhan Shaikh

SELECT A.*,
Round(A.Count#*B.AVG#/1024/1024) Daily_Avg_Mb
FROM
(
SELECT
To_Char(First_Time,’YYYY-MM-DD’) DAY,
Count(1) Count#,
Min(RECID) Min#,
Max(RECID) Max#
FROM
v$log_history
GROUP
BY To_Char(First_Time,’YYYY-MM-DD’)
ORDER
BY 1 DESC
) A,
(
SELECT
Avg(BYTES) AVG#,
Count(1) Count#,
Max(BYTES) Max_Bytes,
Min(BYTES) Min_Bytes
FROM
v$log
) B;

What Tables Are Involved In Using The System Profile ‘Sign-On:Audit Level’

January 31, 2011UncategorizedFarhan Shaikh

Applies to:

Oracle Application Object Library – Version: 11.5.0 to 11.5.10.2 – Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 29-MAY-2010

Goal

What tables are involved in using the system profile ‘Sign-On:Audit Level’?

Solution

There are three primary tables:

FND_LOGINS
FND_LOGIN_RESPONSIBILITIES
FND_LOGIN_RESP_FORMS

1. Least detailed level: User.
When the profile is set to User, the only table that gets updated is the table FND_LOGINS and only one record per user session.

2. Next level: Responsibility.
When the profile is set to Responsbility both FND_LOGINS and FND_LOGIN_RESPONSIBILITIES will be updated.
FND_LOGINS gets only one record per user session.
FND_LOGIN_RESPONSIBILITIES will be updated with one record for each
responsibility selected during the session.

3. Most detailed level: Form.
When the profile is set to Form all three tables are involved.
FND_LOGINS gets only one record per user session.
FND_LOGIN_RESPONSIBILITIES will be updated with one record for each
responsibility selected during the session.
FND_LOGIN_RESP_FORMS will be updated with one record for each form selected during the session.

Reference: Metalink Note 368260.1

Helpful SQL for Users Monitoring

January 31, 2011UncategorizedFarhan Shaikh

— Current Forms Based Users in ERP

SELECT TIME, user_name, responsibility_name, user_form_name
FROM apps.fnd_form_sessions_v ORDER BY 1;

— Users Count Who Logged in to ERP

select count(distinct d.user_name)
from apps.fnd_logins a, v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid and a.spid = b.process
and d.user_id = a.user_id and (d.user_name = ‘USER_NAME’ OR 1=1);

— Users Who Logged in to ERP

select distinct d.user_name
from apps.fnd_logins a, v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = ‘USER_NAME’ OR 1=1);

Query to list of Responsibilities attached to a particular Oracle Application User

January 9, 2011UncategorizedFarhan Shaikh

Hi Friends,

Kindly run below sql query as apps user for listing all the responsibilities attached to a particular user (prompted by query).

set pages 300 lines 300
col USER_NAME for a40
col RESPONSIBILITY_NAME for a50

select fu.user_name, fr.responsibility_name, furg.START_DATE, furg.END_DATE
from fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr
where fu.user_name = ‘&user_name’
and furg.user_id = fu.user_id
and furg.responsibility_id = fr.responsibility_id
and fr.language = userenv(‘LANG’);

Happy Reading !!

Farhan Shaikh

Trace a Concurrent Request And Generate TKPROF File

January 9, 2011UncategorizedFarhan Shaikh

Enable Tracing For The Concurrent Manager Program

Responsibility: System Administrator
Navigate: Concurrent > Program > Define
Query Concurrent Program
Select the Enable Trace Checkbox
Turn On Tracing
Responsibility: System Administrator
Navigate: Profiles > System
Query Profile Option Concurrent: Allow Debugging
Set profile to Yes
Run Concurrent Program With Tracing Turned On
Logon to the Responsibility that runs the Concurrent Program
In the Submit Request Screen click on Debug Options (B)
Select the Checkbox for SQL Trace

Find Trace File Name
Run the following SQL to find out the Raw trace name and location for the concurrent program. The SQL prompts the user for the request id

SELECT ’Request id: ’||request_id , ‘Trace id: ’||oracle_Process_id, ‘Trace Flag: ’||req.enable_trace, ‘Trace Name: ‘||dest.value||’/’||lower(dbnm.value)||’_ora_’||oracle_process_id||’.trc’,
‘Prog. Name: ’||prog.user_concurrent_program_name, ‘File Name: ’||execname.execution_file_name|| execname.subroutine_name , ‘Status : ’||decode(phase_code,’R’,’Running’) ||’-‘||decode(status_code,’R’,’Normal’), ‘SID Serial: ’||ses.sid||’,’|| ses.serial#, ‘Module : ’||ses.module from fnd_concurrent_requests req, v$session ses, v$process proc, v$parameter dest,
v$parameter dbnm, fnd_concurrent_programs_vl prog, fnd_executables execname where req.request_id = &request and req.oracle_process_id=proc.spid(+) and proc.addr = ses.paddr(+)
and dest.name=’user_dump_dest’ and dbnm.name=’db_name’ and req.concurrent_program_id = prog.concurrent_program_id and req.program_application_id = prog.application_id
and prog.application_id = execname.application_id and prog.executable_id=execname.executable_id;

TKPROF Trace File
Once you have obtained the Raw trace file you need to format the file using TKPROF.

$tkprof raw_trace_file.trc output_file explain=apps/ sort=(exeela,fchela) sys=no

Where: raw_trace_file.trc: Name of trace file
output_file: tkprof out file
explain: This option provides the explain plan for the sql statements
sort: his provides the sort criteria in which all sql statements will be sorted. This will bring the bad sql at the top of the outputfile.
sys=no:Disables sql statements issued by user SYS

Another example: To get (TKPROF) sorted by longest running queries first and limits the results to the “Top 10″ long running queries

$ tkprof raw_trace_file.trc output_file sys=no explain=apps/ sort=’(prsela,exeela,fchela)’ print=10

Usage: tkprof tracefile outputfile [explain= ] [table= ]
[print= ] [insert= ] [sys= ] [sort= ]
table=schema.tablename Use ‘schema.tablename’ with ‘explain=’ option.
explain=user/password Connect to ORACLE and issue EXPLAIN PLAN.
print=integer List only the first ‘integer’ SQL statements.
aggregate=yes|no
insert=filename List SQL statements and data inside INSERT statements.
sys=no TKPROF does not list SQL statements run as user SYS.
record=filename Record non-recursive statements found in the trace file.
sort=option Set of zero or more of the following sort options:
prscnt number of times parse was called
prscpu cpu time parsing
prsela elapsed time parsing
prsdsk number of disk reads during parse
prsqry number of buffers for consistent read during parse
prscu number of buffers for current read during parse
prsmis number of misses in library cache during parse
execnt number of execute was called
execpu cpu time spent executing
exeela elapsed time executing
exedsk number of disk reads during execute
exeqry number of buffers for consistent read during execute
execu number of buffers for current read during execute
exerow number of rows processed during execute
exemis number of library cache misses during execute
fchcnt number of times fetch was called
fchcpu cpu time spent fetching
fchela elapsed time fetching
fchdsk number of disk reads during fetch
fchqry number of buffers for consistent read during fetch
fchcu number of buffers for current read during fetch
fchrow number of rows fetched
userid userid of user that parsed the cursor

Enjoy Reading

Farhan Shaikh

Cloning Multi Node to Single Node

May 10, 2010UncategorizedFarhan Shaikh

Description :
With Oracle Applications 11.5.10 the ability to clone from a multi node to a single node system using rapid clone has now been certified.
This is accomplished by the Shared APPL_TOP and Merging APPL_TOP features.
The information mentioned here is the steps which i have used and found them to be successful for a more elaborate explanation you might want to refer to the Metalink notes mentioned at the end of this document.

Source System here refers to the multi node Production system to be cloned Target System refers to the newly to be created T&D single node system
Applications Version 11.5.10.2
Database Version 10.2.0.4.0
Operating System RedHat Enterprise Linux Advance Server 5 update 4

Source Setup Information:

192.168.200.2 Database
192.168.200.2 Concurrent Manager & Report (Admin Node)
192.168.200.3 Forms & Apache (Web Node)

Step 1: Check OS configuration and utilities
Red Hat Enterprise Linux 5* (base and Advanced Platform) Update 1 (RHEL 5.1) or higher is
required.
The following packages are not part of the OEL 5 or RHEL 5 distribution media and must be installed
manually:
• compat-libstdc++-egcs-1.1.2-11
• compat-libcwait-2.1-11
• compat-oracle-el5-1.0-51
• openmotif21-2.1.30-11.EL51
• binutils-2.152
The following packages must be installed from the OEL 5 or RHEL 5 distribution media:
• libXp-1.0.0-8.1.el5
• compat-libgcc-296-2.96-138
• compat-libstdc++-33-3.2.3-61
• compat-db-4.2.52-5.1
Note :
1: Download from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/ (for both OEL 5 and RHEL 5)
2: GNU linker (ld) version 2.15 is required for relinking the modules in Advanced Planning &
Scheduling (MSC, MSO, MSR) – download binutils-2.15 from http://oss.oracle.com/projects/compat oracle/files/Enterprise_Linux/ (for both OEL 5 and RHEL 5)
glibc Requirements Oracle Enterprise Linux 5 2.3.4-2.26

Domain Name System (DNS) Resolver Parameters
Two Domain Name System (DNS) resolver parameters (timeout and attempts) are set by default to low values when the operating system is installed. These low values may cause attempted network connections to an Oracle database to fail. If this happens, add or update the following entries to these
minimum settings in the /etc/resolv.conf file on each server node:
options attempts:5
options timeout:15

Net Service Listeners in Multi-user Installations
Give all users in a multi-user installation write privileges to the .oracle directory:
$ chmod 777 /var/tmp/.oracle

Verifying Host Names
Use the following to verify host name settings:
For Oracle Enterprise Linux 4 and 5, Red Hat Enterprise Linux 3, 4 and 5:
1. Verify that the /etc/hosts file is formatted as follows:
127.0.0.1 localhost.localdomain localhost
.
2. Verify that the /etc/sysconfig/network file is formatted as follows:
HOSTNAME=.
3. If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.
4. If you changed any files in the previous steps, restart the system.

Modifying the Number of Open File Descriptors
Open the /etc/security/limits.conf file and change the existing values for “hard” and “soft” parameters
as follows. Restart the system after making changes.
For Oracle Enterprise Linux 4 and 5, Red Hat Enterprise Linux 3, 4 and 5 and SUSE Linux Enterprise
Server 9 and 10:
* hard nofile 65535
* soft nofile 4096
Modifying the Port Range Values
Open the /etc/sysctl.conf file and change the value of net.ipv4.ip_local_port_range as follows. Restart the system after making changes.
net.ipv4.ip_local_port_range = 10000 65000
Please note that this range is a recommended range, and may need to be adjusted according to the specific needs of the user’s environment in order to avoid port conflicts.

Setting the Environment
Perform the following tasks to set the environment before you run Rapid Install.
1. Create symbolic links For Oracle Enterprise Linux 5 and Red Hat Enterprise Linux 5 only :
# ln -s /usr/bin/ld215 /usr/bin/ld
Download and apply the OS library patch 6078836 from Oracle MetaLink and create the following symbolic link:
# ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3
2. Verify that the host name setting is correct. The command should return a fully qualified hostname.
For example: ..
# hostname -f

For Oracle Enterprise Linux 5, Red Hat Enterprise Linux 5 and SUSE Linux Enterprise Server 10 customers, the LD_ASSUME_KERNEL environment variable should be unset before starting the installation. The installation fails when the LD_ASSUME_KERNEL variable is set by the adgetlnxver.sh file during the course of the installation. Patch 6365595 contains the fix for adgetlnxver.sh file. The procedure below is a guideline for replacing the adgetlnxver.sh file in the
Oracle Applications 11i ship home.

Merging existing APPL_TOPs into a single APPL_TOP
In preparation for sharing a file system in an existing system with multiple APPL_TOPs, you can use the Rapid Clone utility to merge the multiple APPL_TOP (and COMMON_TOP) file systems into a single APPL_TOP file system. See Oracle MetaLink Doc ID: 230672.1 for more information. Oracle
recommends that the different APPL_TOPs should be merged into a completely new APPL_TOP to facilitate rollback incase of merge failure.
Note : We have considered Web Node ie 192.168.200.3 as our primary node (Node A mentioned in below steps)

Step 2: Maintain snapshot information
Log in to each application tier node as the APPLXXX user and run the maintain snapshot task in AD Administration.

Step 3: Merge existing APPL_TOPs
I) Prepare the source system application tier for merging
Choose one of the source system nodes to be the primary node. This document refers to it as “Node A”.
o Log in to Node A as the APPLXXX (applprod in our case) user and run:
$ cd /admin/scripts/
$ perl adpreclone.pl appsTier merge
This will create clone directory under $COMMON_TOP on 192.168.200.3

o Log in as the APPLMGR user to each of the secondary nodes being merged and run:
$ cd /admin/scripts/
$ perl adpreclone.pl appltop merge

This will create clone directory under $COMMON_TOP on 192.168.200.2

Step 4: Perform Backup of Source System
II) Copy the Source System to the Target System
Copy the application tier file system from the source Applications system to the target node by executing the following steps in the order listed. Ensure the application tier files copied to the target system are owned by the target APPLXXX user, and that the database tier files are owned by the ORAXXX user.

III) Create a copy of Node A (preferred)
If you want to place the merged APPL_TOPs in a new location instead of using an existing APPL_TOP location, create a copy of Node A (the other nodes in the system do not need to be copied). Include the following directories from Node A:

Step 5: Restore the backup on Target Node

IV) Copy the database tier file system
Log on to the source system database node as the ORACLE user.
• Perform a normal shutdown of the source system database
• Copy the database (DBF) files from the source to the target system
• Copy the source database ORACLE_HOME to the target system
• Start up the source Applications system database and application tier processes

V) Copy the required files for merging
Log in as the APPLMGR user to each source node and recursively copy:
directory /clone/appl
– to –
directory /clone/appl on Node A (or the copy of Node A).

VI) Configure target Database and Application
f. Configure the Target System
Execute the following commands to configure the target system.
You will be prompted for the target system specific values (SID, Paths, Ports, etc)
o Configure the target system database server
Log on to the target system as the ORACLE user and type the following commands
to configure and start the database:
cd /appsutil/clone/bin
perl adcfgclone.pl dbTier
o Configure the application tier server nodes
Log in to the merged APPL_TOP node as the APPLMGR user and execute the
following commands:
$ cd /clone/bin
$ perl adcfgclone.pl appsTier

Step 6: Finishing tasks
• Log in to the target system application tier node as the APPLMGR user.
• Run the following tasks in adadmin for all products:
o generate JAR files
o generate message files
o relink executables
o copy files to destination
• Depending on which tier you chose as the primary node, certain files may be missing. Run
adadmin to verify files required at runtime. If any files are listed as missing files, you must
manually copy them to the merged APPL_TOP.
• Remove the temporary directory /clone/appl to reduce disk space usage.
• Update Profile options
• Update Printer Settings
• Update the workflow configuration settings
• Verify the APPLCSF variable setting
• Update the session_cookie_domain value in icx_parameters

Reference Metalink Note :
316806.1 – Oracle Applications Installation Update Notes, Release 11i (11.5.10.2)
233428.1 – Sharing the Application Tier File System in Oracle Applications 11i
230672.1 – Cloning Oracle Applications Release 11i with Rapid Clone

19.017656
72.856178

One comment so far

How to reset or Unlock the orcladmin password

March 18, 2010Oracle Application (EBS)Farhan Shaikh

Recently while upgrading Discoverer to 10.1.2.3 CP4 , we got stuck at one of the step.
This step asks for orcladmin password which was not known to us.

So , we need to reset that password.Here are the steps which we followed ;

Error:
orcladmin password lost or account locked

Cause:
orcladmin password not known to us.

Solution :
1. Login as OAS user [ here testbi ] and
sqlplus “/as sysdba”
SQL>> alter user ODS identified by [new password]

2. Execute $ORACLE_HOME/bin/oidpasswd create_wallet=true

3. oidpasswd connect=[connect string] change_oiddb_pwd=true
This will prompt us for old password and new password.
old password you can give the same as ODS user and unique new password.

4. To unlock the orcladmin account :
oidpasswd connect=[connect string] unlock_su_acct=trueThis will prompt for password ; enter the ODS password.Which will inturn unlock your orcladmin account.

5. To reset the password :
oidpasswd connect=[connect string] reset_su_password=true
This will prompt for new password. [keep the password same as ODS user.] and your are done.

You have successfully changed the orcladmin password.
Now, to test the password :
cd $ORACLE_HOME/bin/oidadmin
The window will prompt for orcladmin password.

Refer : http://eldapo.blogspot.com/2007/08/forcing-orcladmin-password.html

19.017656
72.856178

Leave a comment

Posts navigation

← Older posts

Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Email Address:

Join 33 other subscribers

Archives
Archives
Calender
May 2024

M T W T F S S

1 2 3 4 5

6 7 8 9 10 11 12

13 14 15 16 17 18 19

20 21 22 23 24 25 26

27 28 29 30 31

« Aug