oracle ebs&db克隆
2022-02-15 本文已影响0人
与狼共舞666
参照https://www.cnblogs.com/wanghang/p/6299085.html
EBS系统克隆主要分为三个步骤来做：准备源系统-》拷贝源系统-》配置目标系统
1.准备源系统（预克隆prepare）
ebsapp:
进入/u01/oracle/ebsapp/fs1/inst/apps/UAT_rhuat/admin/scripts
perl adpreclone.pl appsTier
db:
/u01/oracle/ebsdb/12.1.0/appsutil/scripts/UAT_rhdbuat
perl adpreclone.pl dbTier
2.停服务
[appluat@rhuat ~]ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps << EOF
manager0
EOF
随后查看 ps -ef |grep FNDLIBR、 ps -fu appluat，如果有对应的服务存在，可以kill掉
cd /u01/oracle/ebsapp/fs1 打包对应的/u01/oracle/ebsapp/fs1/EBSapps目录待用
db:
停止tns监听器
./addlnctl.sh stop UAT
ps -ef |grep tns
lsnrctl stop
./addbctl.sh stop immediate关闭数据库
ps -fu orauat
打包对应的tar包
nohup tar -zcvf /mnt/hand/ebsdb20220215.tar.gz ebsdb &
2.配置目标系统
目标系统为centos7.9，首先安装对应依赖包，然后在db server上执行db tier的clone操作（ perl adcfgclone.pl dbTier），日志文件位置/u01/TEST/ebsdb/12.1.0/appsutil/etcc/checkDBpatch_32264.log
[oratest@testdb ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 16 14:57:37 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oratest@testdb ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 16 14:57:41 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
allow_group_access_to_sga boolean FALSE
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 2G
sga_target big integer 2G
unified_audit_sga_queue_size integer 1048576
SQL> show prameter pga
SP2-0158: unknown SHOW option "prameter"
SP2-0158: unknown SHOW option "pga"
SQL> show parameter pga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_limit big integer 0
pga_aggregate_target big integer 1G
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oratest@testdb ~]$ free -g
total used free shared buff/cache available
Mem: 15 0 0 2 14 12
Swap: 7 0 7
[oratest@testdb ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 16 14:58:06 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
cell_offload_processing boolean TRUE
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 2
log_archive_max_processes integer 4
processes integer 200
processor_group_name string
SQL> show parameter session
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
session_cached_cursors integer 500
session_max_open_files integer 10
sessions integer 400
shared_server_sessions integer
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
接着在app server上执行app tier（perl adcfgclone.pl appsTier dualfs）的clone操作，
[appltest@testweblogic bin]$ perl adcfgclone.pl appsTier dualfs
Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.56
Enter the APPS password :
Enter the Weblogic AdminServer password :
Do you want to add a node (yes/no) [no] :
Running: Context clone...
Log file located at /u01/TEST/app/fs1/EBSapps/comn/clone/bin/CloneContext_0216150005.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [testweblogic] :
Target System Database SID : TEST
Target System Database Server Node [testweblogic] : testdb
Target System Database Domain Name [rha-test.com] :
Target System Base Directory : /u01/TEST/app
Target System Base Directory set to /u01/TEST/app
Target System Current File System Base set to /u01/TEST/app/fs1
Target System Other File System Base set to /u01/TEST/app/fs2
Target System Fusion Middleware Home set to /u01/TEST/app/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /u01/TEST/app/fs2/FMW_Home
Target System Web Oracle Home set to /u01/TEST/app/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /u01/TEST/app/fs2/FMW_Home/webtier
Target System Appl TOP set to /u01/TEST/app/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /u01/TEST/app/fs2/EBSapps/appl
Target System COMMON TOP set to /u01/TEST/app/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /u01/TEST/app/fs2/EBSapps/comn
Target System Instance Home Directory [/u01/TEST/app] :
Target System Current File System Instance Top set to /u01/TEST/app/fs1/inst/apps/TEST_testweblogic
Do you want to preserve the Display [rhuat:0.0] (y/n) : n
Target System Display [testweblogic:0.0] :
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 the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 0
Checking the port pool 0
done: Port Pool 0 is free
Report file located at /u01/TEST/app/fs1/inst/apps/TEST_testweblogic/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /u01/TEST/ebsdb/12.1.0/appsutil/outbound/TEST_testdb
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
The new APPL_TOP context file has been created :
/u01/TEST/app/fs1/inst/apps/TEST_testweblogic/appl/admin/TEST_testweblogic.xml
Check Clone Context logfile /u01/TEST/app/fs1/EBSapps/comn/clone/bin/CloneContext_0216150005.log for details.
Creating Patch file system context file.....
Log file located at /u01/TEST/app/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0216150140.log
Target System Other File System Instance Top set to /u01/TEST/app/fs2/inst/apps/TEST_testweblogic
Target System Port Pool [0-99] : 10
Checking the port pool 10
done: Port Pool 10 is free
Report file located at /u01/TEST/app/fs2/inst/apps/TEST_testweblogic/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/u01/TEST/app/fs2/inst/apps/TEST_testweblogic/appl/admin/TEST_testweblogic.xml
Check Clone Context logfile /u01/TEST/app/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0216150140.log for details.
FMW Pre-requisite check log file location : /u01/TEST/app/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check...
Configuring: Run file system....
LogFile located at /u01/TEST/app/fs1/inst/apps/TEST_testweblogic/admin/log/clone/run/RCloneApplyAppstier_02161501.log
Configuring: Patch file system....
LogFile located at /u01/TEST/app/fs1/inst/apps/TEST_testweblogic/admin/log/clone/patch/RCloneApplyAppstier_02161552.log
Do you want to startup the Application Services for TEST? (y/n) [n] :
配置环境变量，日志文件位置
[appltest@testweblogic ~]ADMIN_SCRIPTS_HOME
./adstrtal.sh apps/apps <<EOF
manager0
EOF
[appltest@testweblogic ~]ADMIN_SCRIPTS_HOME
./adstpall.sh apps/apps <<EOF
manager0
EOF
