美文网首页
oracle ebs&db克隆

oracle ebs&db克隆

作者: 与狼共舞666 | 来源:发表于2022-02-15 16:25 被阅读0次

    参照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 ~]cat stopAPP.shADMIN_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 ~]cat startapp.sh cdADMIN_SCRIPTS_HOME
    ./adstrtal.sh apps/apps <<EOF
    manager0
    EOF
    [appltest@testweblogic ~]cat stopapp.sh cdADMIN_SCRIPTS_HOME
    ./adstpall.sh apps/apps <<EOF
    manager0
    EOF

    相关文章

      网友评论

          本文标题:oracle ebs&db克隆

          本文链接:https://www.haomeiwen.com/subject/zwhllrtx.html