配置EBS 12.1.3 DataGuard
1. 关闭应用。
2. EBS 主库修改归档模式。
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/PROD/PROD/db/archivelog
Oldest online log sequence 51
Next log sequence to archive 52
Current log sequence 52
SQL>
3. 修改FOCE LOGGIN
SQL> alter database force logging;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> select FORCE_LOGGING from v$database;
FOR
---
YES
4. 建STANDBY LOGFILE
Alter database add standby logfile thread 1 group 8 ('/u01/PROD/PROD/db/apps_st/data/redo_st_05.log') size 1G;
Alter database add standby logfile thread 1 group 9 ('/u01/PROD/PROD/db/apps_st/data/redo_st_06.log') size 1G;
Alter database add standby logfile thread 1 group 10 ('/u01/PROD/PROD/db/apps_st/data/redo_st_07.log') size 1G;
5. 执行DB预CLONE。
[ebsdb@gd1ebs132 data]$ cd /u01/PROD/PROD/db/oracle11g/appsutil/scripts/PROD_gd1ebs132/
[ebsdb@gd1ebs132 PROD_gd1ebs132]$ perl adpreclone.pl dbTier
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adpreclone Version 120.20.12010000.5
Enter the APPS User Password:
Running:
perl /u01/PROD/PROD/db/oracle11g/appsutil/bin/adclone.pl java=/u01/PROD/PROD/db/oracle11g/jdk/jre mode=stage stage=/u01/PROD/PROD/db/oracle11g/appsutil/clone component=dbTier method=CUSTOM dbctx=/u01/PROD/PROD/db/oracle11g/appsutil/PROD_gd1ebs132.xml showProgress
APPS Password :
Beginning database tier Stage - Sat Jun 8 08:57:03 2013
/u01/PROD/PROD/db/oracle11g/jdk/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/u01/PROD/PROD/db/oracle11g/oui -classpath /u01/PROD/PROD/db/oracle11g/lib/xmlparserv2.jar:/u01/PROD/PROD/db/oracle11g/jdbc/lib/ojdbc5.jar:/u01/PROD/PROD/db/oracle11g/appsutil/java:/u01/PROD/PROD/db/oracle11g/oui/jlib/OraInstaller.jar:/u01/PROD/PROD/db/oracle11g/oui/jlib/ewt3.jar:/u01/PROD/PROD/db/oracle11g/oui/jlib/share.jar:/u01/PROD/PROD/db/oracle11g/oui/jlib/srvm.jar:/u01/PROD/PROD/db/oracle11g/jlib/ojmisc.jar oracle.apps.ad.clone.StageDBTier -e /u01/PROD/PROD/db/oracle11g/appsutil/PROD_gd1ebs132.xml -stage /u01/PROD/PROD/db/oracle11g/appsutil/clone -tmp /tmp -method CUSTOM -showProgress
APPS Password :
Log file located at /u01/PROD/PROD/db/oracle11g/appsutil/log/PROD_gd1ebs132/StageDBTier_06080857.log
- 55% completed
Completed Stage...
Sat Jun 8 08:57:29 2013
6. COPY ORACLE_HOME到目标端：
scp -r root@10.19.131.106:/u01/PROD/PROD/db/oracle11g .
7. 设置目标端的环境变量：
export ORACLE_HOME=/u01/PROD/PROD/db/oracle11g
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export SHLIB_PATH=$ORACLE_HOME/lib:$SHLIB_PATH
unset ORA_TZFILE
[ebsdb@gd1ebs131 db]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jun 8 09:01:37 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL>
6. 配置备库的PFILE文件：
在参数文件中增加以下内容：
*.db_unique_name='PROD02'
*.log_archive_config='dg_config=(PROD,PROD02)'
*.log_archive_dest_2='service=PROD valid_for=(online_logfiles,primary_role) db_unique_name=PROD'
*.fal_server='PROD'
*.fal_client='PROD02'
*.db_file_name_convert='/u01/PROD/PROD/db/apps_st/data/','/u01/PROD/PROD/db/apps_st/data'
*.log_file_name_convert='/u01/PROD/PROD/db/apps_st/data', '/u01/PROD/PROD/db/apps_st/data/'
7. 将备库启动到NOMOUNT状态。
[ebsdb@gd1ebs131 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jun 8 09:19:06 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 6509562544 bytes
Database Buffers 4160749568 bytes
Redo Buffers 16924672 bytes
SQL> create spfile from pfile;
File created.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 6509562544 bytes
Database Buffers 4160749568 bytes
Redo Buffers 16924672 bytes
SQL>
8. RMAN 备份原库。
将主库停掉以后，将数据文件，控制文件，日志文件等移至备库。
SQL> alter database create standby controlfile as '/home/ebsdb/control01.dbf';
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> select thread#, sequence#-1 from v$log where status ='CURRENT';
THREAD# SEQUENCE#-1
---------- -----------
1 53
9.在备库执行CLONE：
[ebsdb@gd1ebs131 bin]$ perl adcfgclone.pl dbTechStack
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.8
Enter the APPS password :
Running:
/u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/java:/u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/xmlparserv2.jar:/u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_5480.lst -stage /u01/PROD/PROD/db/oracle11g/appsutil/clone -dbTechStack 2> /tmp/adcfgclone_5480.err; echo $? > /tmp/adcfgclone_5480.res
Log file located at /u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/CloneContext_0608125029.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [gd1ebs131] :
Target Instance is RAC (y/n) [n] : n
Target System Database SID : PROD
Target System Base Directory : /u01/PROD/PROD
Target System utl_file_dir Directory List : /tmp
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/u01/PROD/PROD/db/apps_st/data] :
Target System RDBMS ORACLE_HOME Directory [/u01/PROD/PROD/db/tech_st/11.2.0] : /u01/PROD/PROD/db/oracle11g
Do you want to preserve the Display [:1.0] (y/n) : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : y
Complete port information available at /u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/out/PROD_gd1ebs131/portpool.lst
Backing up /u01/PROD/PROD/db/oracle11g/appsutil/PROD_gd1ebs131.xml to /u01/PROD/PROD/db/oracle11g/appsutil/PROD_gd1ebs131.xml.bak
Creating the new Database Context file from :
/u01/PROD/PROD/db/oracle11g/appsutil/template/adxdbctx.tmp
The new database context file has been created :
/u01/PROD/PROD/db/oracle11g/appsutil/PROD_gd1ebs131.xml
Log file located at /u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/CloneContext_0608125029.log
Check Clone Context logfile /u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/CloneContext_0608125029.log for details.
Running Rapid Clone with command:
perl /u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/adclone.pl java=/u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/../jre mode=apply stage=/u01/PROD/PROD/db/oracle11g/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/PROD/PROD/db/oracle11g/appsutil/PROD_gd1ebs131.xml showProgress contextValidated=true
Running:
perl /u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/adclone.pl java=/u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/../jre mode=apply stage=/u01/PROD/PROD/db/oracle11g/appsutil/clone component=dbTechStack method=CUSTOM dbctxtg=/u01/PROD/PROD/db/oracle11g/appsutil/PROD_gd1ebs131.xml showProgress contextValidated=true
APPS Password :
Beginning rdbms home Apply - Sat Jun 8 12:51:14 2013
/u01/PROD/PROD/db/oracle11g/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/u01/PROD/PROD/db/oracle11g/oui -classpath /u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/xmlparserv2.jar:/u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/ojdbc5.jar:/u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/java:/u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/oui/ewt3.jar:/u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/oui/share.jar:/u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/oui/srvm.jar:/u01/PROD/PROD/db/oracle11g/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTechStack -e /u01/PROD/PROD/db/oracle11g/appsutil/PROD_gd1ebs131.xml -stage /u01/PROD/PROD/db/oracle11g/appsutil/clone -showProgress
APPS Password : Log file located at /u01/PROD/PROD/db/oracle11g/appsutil/log/PROD_gd1ebs131/ApplyDBTechStack_06081251.log
/ 0% completed
Completed Apply...
Sat Jun 8 12:54:48 2013
Starting database listener for PROD:
Running:
/u01/PROD/PROD/db/oracle11g/appsutil/scripts/PROD_gd1ebs131/addlnctl.sh start PROD
Logfile: /u01/PROD/PROD/db/oracle11g/appsutil/log/PROD_gd1ebs131/addlnctl.txt
You are running addlnctl.sh version 120.1.12010000.4
Starting listener process PROD ...
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 08-JUN-2013 12:54:48
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/PROD/PROD/db/oracle11g/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/PROD/PROD/db/oracle11g/network/admin/PROD_gd1ebs131/listener.ora
Log messages written to /u01/PROD/PROD/db/oracle11g/admin/PROD_gd1ebs131/diag/tnslsnr/gd1ebs131/prod/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gd1ebs131.vipshop.com)(PORT=1528)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gd1ebs131.vipshop.com)(PORT=1528)))
STATUS of the LISTENER
------------------------
Alias PROD
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 08-JUN-2013 12:54:48
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/PROD/PROD/db/oracle11g/network/admin/PROD_gd1ebs131/listener.ora
Listener Log File /u01/PROD/PROD/db/oracle11g/admin/PROD_gd1ebs131/diag/tnslsnr/gd1ebs131/prod/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gd1ebs131.vipshop.com)(PORT=1528)))
Services Summary...
Service "PROD" has 1 instance(s).
Instance "PROD", 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/PROD/PROD/db/oracle11g/appsutil/log/PROD_gd1ebs131/addlnctl.txt for more information ...
10.将主库生成的控制文件传至备库，启动备库
SQL> alter database mount standby database;
Database altered.
SQL> alter database mount standby database;
Database altered.
SQL> alter database open read only;
Database altered.
11.修改主库参数：
SQL> alter system set log_archive_config='dg_config=(PROD,PROD02)' scope=memory;
System altered.
SQL> alter system set log_archive_config='dg_config=(PROD,PROD02)' scope=both;
System altered.
SQL> alter system set log_archive_dest_2='service=PROD02 valid_for=(all_logfiles,all_roles) db_unique_name=PROD02' scope=memory;
System altered.
SQL> alter system set log_archive_dest_2='service=PROD02 valid_for=(all_logfiles,all_roles) db_unique_name=PROD02' scope=both;
System altered.
SQL> alter system set fal_server='PROD02' scope=memory;
System altered.
SQL> alter system set fal_server='PROD02' scope=both;
System altered.
SQL> alter system set fal_client='PROD' scope=memory;
System altered.
SQL> alter system set fal_client='PROD' scope=both;
System altered.
12. 启动备库实时恢复：
启动实时恢复：
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
13. 测试， 建测试表：
SQL> create table test24 as select * from dba_objects;
Table created.
备库查询：
SQL> select count(*) from test24;
COUNT(*)
----------
328561
查询备库的打开状态：
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
14. 尝试切换：
14.1 在这里首先把应用给停掉。
[ebsapp@gd1ebs132 ~]$ /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adstpall.sh apps/apps
You are running adstpall.sh version 120.10.12010000.4
The logfile for this session is located at /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstpall.log
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/jtffmctl.sh stop
script returned:
****************************************************
You are running jtffmctl.sh version 120.3
Shutting down Fulfillment Server for PROD on port 9300 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adcmctl.sh stop
script returned:
****************************************************
You are running adcmctl.sh version 120.17.12010000.5
Shutting down concurrent managers for PROD ...
ORACLE Password:
Submitted request 402133 for CONCURRENT FND SHUTDOWN
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adcmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoafmctl.sh stop
script returned:
****************************************************
You are running adoafmctl.sh version 120.8
Stopping OPMN managed OAFM OC4J instance ...
adoafmctl.sh: exiting with status 0
adoafmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoafmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adformsctl.sh stop
script returned:
****************************************************
You are running adformsctl.sh version 120.16.12010000.3
Stopping OPMN managed FORMS OC4J instance ...
adformsctl.sh: exiting with status 0
adformsctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adformsctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoacorectl.sh stop
script returned:
****************************************************
You are running adoacorectl.sh version 120.13
Stopping OPMN managed OACORE OC4J instance ...
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoacorectl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adapcctl.sh stop
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.2
Stopping OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is not running.
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adapcctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adalnctl.sh stop
script returned:
****************************************************
adalnctl.sh version 120.3
Listener APPS_PROD has already been stopped.
adalnctl.sh: exiting with status 2
adalnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adalnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adopmnctl.sh stop
script returned:
****************************************************
You are running adopmnctl.sh version 120.6.12010000.5
Stopping Oracle Process Manager (OPMN) and the managed processes ...
opmnctl: opmn is not running.
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adopmnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
All enabled services on this node are stopped.
adstpall.sh:Exiting with status 0
adstpall.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstpall.log for more information ...
14.2 主库切换备库。
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
TO STANDBY
SQL> alter database commit to switchover to physical standby;
Database altered.
SQL> shutdown immediate;
14。3 备库切换成主库：
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
TO PRIMARY
SQL> alter database commit to switchover to primary;
Database altered.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
14.4 启动备库：
[ebsdb@gd1ebs132 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jun 8 16:38:48 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 6509562544 bytes
Database Buffers 4160749568 bytes
Redo Buffers 16924672 bytes
SQL> alter database mount standby database;
Database altered.
SQL> alter database open read only;
Database altered.
SQL>
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
14.5 启动主库
SQL> startup
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 6509562544 bytes
Database Buffers 4160749568 bytes
Redo Buffers 16924672 bytes
Database mounted.
Database opened.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
14.6 在新的主库执行：
SQL> exec fnd_net_services.remove_system('PROD');
PL/SQL procedure successfully completed.
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
14.7 在应用层执行：perl adcfgclone.pl appsTier
[ebsapp@gd1ebs132 bin]$ perl adcfgclone.pl appsTier
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.8
Enter the APPS password :
Running:
/u01/PROD/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/PROD/PROD/apps/apps_st/comn/clone/jlib/java:/u01/PROD/PROD/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/PROD/PROD/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /u01/PROD/PROD/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_8473.lst -stage /u01/PROD/PROD/apps/apps_st/comn/clone 2> /tmp/adcfgclone_8473.err; echo $? > /tmp/adcfgclone_8473.res
Log file located at /u01/PROD/PROD/apps/apps_st/comn/clone/bin/CloneContext_0609174242.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [gd1ebs132] :
Target System Database SID : PROD
Target System Database Server Node [gd1ebs132] : gd1ebs131
Target System Database Domain Name [vipshop.com] : vipshop.com
Target System Base Directory : /u01/PROD/PROD
Target System Tools ORACLE_HOME Directory [/u01/PROD/PROD/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/u01/PROD/PROD/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/u01/PROD/PROD/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/u01/PROD/PROD/apps/apps_st/comn] :
Target System Instance Home Directory [/u01/PROD/PROD/inst] :
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want to preserve the Display [gd1ebs132:0.0] (y/n) : y
RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /u01/PROD/PROD/inst/apps/PROD_gd1ebs132. A directory with this name already exists and is not empty.
Do you want to continue (y/n) : y
Target System Port Pool [0-99] : 7
Checking the port pool 7
done: Port Pool 7 is free
Report file located at /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/temp/portpool.lst
Complete port information available at /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/temp/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /u01/PROD/PROD/db/tech_st/11.1.0/appsutil/outbound/PROD_gd1ebs131
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
Backing up /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/appl/admin/PROD_gd1ebs132.xml to /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/appl/admin/PROD_gd1ebs132.xml0.bak
Creating the new APPL_TOP Context file from :
/u01/PROD/PROD/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/appl/admin/PROD_gd1ebs132.xml
Log file located at /u01/PROD/PROD/apps/apps_st/comn/clone/bin/CloneContext_0609174242.log
Check Clone Context logfile /u01/PROD/PROD/apps/apps_st/comn/clone/bin/CloneContext_0609174242.log for details.
Running Rapid Clone with command:
perl /u01/PROD/PROD/apps/apps_st/comn/clone/bin/adclone.pl java=/u01/PROD/PROD/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u01/PROD/PROD/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/appl/admin/PROD_gd1ebs132.xml showProgress contextValidated=true
Running:
perl /u01/PROD/PROD/apps/apps_st/comn/clone/bin/adclone.pl java=/u01/PROD/PROD/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u01/PROD/PROD/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/appl/admin/PROD_gd1ebs132.xml showProgress contextValidated=true
APPS Password :
Beginning application tier Apply - Sun Jun 9 17:43:17 2013
/u01/PROD/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/PROD/PROD/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/PROD/PROD/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/u01/PROD/PROD/apps/apps_st/comn/clone/jlib/java:/u01/PROD/PROD/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/u01/PROD/PROD/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/u01/PROD/PROD/apps/apps_st/comn/clone/jlib/oui/share.jar:/u01/PROD/PROD/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/u01/PROD/PROD/apps/apps_st/comn/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/appl/admin/PROD_gd1ebs132.xml -stage /u01/PROD/PROD/apps/apps_st/comn/clone -showProgress
APPS Password : Log file located at /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/log/ApplyAppsTier_06091743.log
- 89% completed
Completed Apply...
Sun Jun 9 17:46:22 2013
Do you want to startup the Application Services for PROD? (y/n) [y] : y
Starting application Services for PROD:
Running:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adstrtal.sh -nopromptmsg
You are running adstrtal.sh version 120.15.12010000.3
The logfile for this session is located at /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstrtal.log
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adopmnctl.sh start
script returned:
****************************************************
You are running adopmnctl.sh version 120.6.12010000.5
Starting Oracle Process Manager (OPMN) ...
opmnctl: opmn started.
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adopmnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_PROD.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adalnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adapcctl.sh start
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adapcctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoacorectl.sh start
script returned:
****************************************************
You are running adoacorectl.sh version 120.13
Starting OPMN managed OACORE OC4J instance ...
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoacorectl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adformsctl.sh start
script returned:
****************************************************
You are running adformsctl.sh version 120.16.12010000.3
Starting OPMN managed FORMS OC4J instance ...
Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...
Program : /u01/PROD/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl started @ Sun Jun 9 17:47:36 2013
*** Log File = /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/rgf/TXK/txkChkFormsDeployment_Sun_Jun_9_17_47_35_2013/txkChkFormsDeployment_Sun_Jun_9_17_47_35_2013.log
File "/u01/PROD/PROD/apps/tech_st/10.1.3/j2ee/forms/applications/forms/formsweb/WEB-INF/lib/frmsrv.jar" exists. Proceeding to check the size...
=============================================
*** Latest formsapp.ear has been deployed ***
=============================================
Program : /u01/PROD/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Sun Jun 9 17:47:36 2013
Perl script txkChkFormsDeployment.pl got executed successfully
adformsctl.sh: exiting with status 0
adformsctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adformsctl.txt for more information ...
.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/rgf/TXK/txkChkFormsDeployment_Sun_Jun_9_17_47_35_2013/txkChkFormsDeployment_Sun_Jun_9_17_47_35_2013.log
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoafmctl.sh start
script returned:
****************************************************
You are running adoafmctl.sh version 120.8
Starting OPMN managed OAFM OC4J instance ...
adoafmctl.sh: exiting with status 0
adoafmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoafmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 120.17.12010000.5
Starting concurrent manager for PROD ...
Starting PROD_0609@PROD Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adcmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/jtffmctl.sh start
script returned:
****************************************************
You are running jtffmctl.sh version 120.3
Validating Fulfillment patch level via /u01/PROD/PROD/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for PROD on port 9307 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstrtal.log for more information ...
