Shulou(Shulou.com)05/31 Report--

This article will explain in detail the case analysis of EBS online cloning DB and its application. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

One point has been learned from this clone.

As long as A database can be started normally, make sure that A database files (redo, undo, datafile, archivelog, tempfile) and control files are not in the ORACLE_HOME directory

After backing up the pfile of A database, you can delete the ORACLE_HOME of An and copy the ORACLE_HOME from somewhere else to clone the software. A new pfile will be generated in the process of software cloning. Just take the original pfile and overwrite it.

This clone was cloned from 21.16 to 128.118, and the clone was a test environment, so the test environment was closed after DB duplicate.

21.16 Server Information

96CPU, 256g, CentOS release 6.5g (Final), hostname is ebsdba, base is / db/PROD,SID is PROD, data file path / db/prod/db/apps_st/data, oracle user oraprod, application user is applprod

128.118 Server Information

48CPU, 64G, Red Hat Enterprise Linux Server release 5.4g (Tikanga), hostname is ebsdev, base is / db/DEV,SID is DEV, data file path / db/DEV/db/apps_st/data, oracle user oradev, application user is appldev, ORACLE_HOME is / u01/DEV/db/tech_st/11.2.0/

1: ORACLE software cloning (this process generates a new pfile file, which is generally not required for cloning, except in the following two cases)

1. The newly built OS environment without ORACLE software installed

2. The DB software has been installed, and DB has been duplicate, but the software needs to be cloned again. For example, the data file directory of DB is different from the software environment variable DATA_TOP. For example, the / U02 directory of the target database is found to be insufficient during the duplicate process, and a new directory / u03 has been added. However, the DATA_TOP of the target database is still a directory / u02 before duplicate, and the pfile of DB should be backed up first, because a new pfile file will be generated in the process of software cloning.

1.

128.118 the server establishes / db/DEV/db/tech_st, / db/DEV/apps, / db/DEV/inst and authorizes them as oradev.dba, appldev.dba and appldev.dba, respectively.

two。

21.16 pairs of ORACLE_HOME package

Cd / db/prod/db/tech_st

Tar-zcvf primy.tar.gz 11.2.0

And copy the package to / db/DEV/db/tech_st in 128.118

3.

128.118 sign in using oradev

Cd / db/DEV/db/tech_st

Tar-zxvf primy.tar.gz

Cd / db/DEV/db/tech_st/11.2.0/appsutil/clone/bin

PERL5LIB=/u01/DEV/db/tech_st/11.2.0/perl/lib/5.10.0:/u01/DEV/db/tech_st/11.2.0/perl/lib/site_perl/5.10.0:/db/DEV/db/tech_st/11.2.0/appsutil/perl

PATH=/u01/DEV/db/tech_st/11.2.0/perl/bin:$PATH

-- PERL5LIB does not represent linux5, so when the OS version of the target environment of the clone is linux6, it cannot be set to PERL6LIB. If the / u01/DEV/db/tech_st/11.2.0/perl/lib/5.10.0 directory does not exist, only / u01/DEV/db/tech_st/11.2.0/perl/lib/5.8.3 exists. Then set it to / u01/DEV/db/tech_st/11.2.0/perl/lib/5.10.0 first, no matter if there is no error, and then set it to / u01/DEV/db/tech_st/11.2.0/perl/lib/5.8.3 if an error is reported.

Perl adcfgclone.pl dbTechStack (this process creates a new pfile)

Enter the APPS password:

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

Target Instance is RAC (yPay) [n]:

Target System Database SID: DEV

Target System Base Directory: / u01/DEV

Target System utl_file_dir Directory List: / usr/tmp

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

Target System DATA_TOP Directory 1: / u01/DEV/db/apps_st/data

Target System RDBMS ORACLE_HOME Directory [/ u01/DEV/db/db/tech_st/11.1.0]: / u01/DEV/db/tech_st/11.2.0

Do you want to preserve the Display [0. 0] (yPao): n

Target System Display [ebsdev:0.0]:

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

Target System Port Pool [0-99]: 30

If there are two directories for the data file, U01 and U02, then

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

Target System DATA_TOP Directory 2: / u01/DEV/db/apps_st/data,/u02/DEV/db/apps_st/data

4.

Then reuse the original database pfile backup to overwrite the newly generated database pfile

Increased ~ / .bash_profle of 5.oradev

. / u01/DEV/db/tech_st/11.2.0/DEV_ebsdev.env

2: database duplicate (check whether the patch of the clone environment DB is the same as the patch of the formal environment DB, which is different from the patch of the formal environment DB.) 21.16 regenerated a life cycle on the 27th. There was a level 0 backup on the 25th, and a level 1 backup on the 28th.

1.

Nohup rman target sys/XX@prod auxiliary sys/XX@8030_DEV_DUPlICATE cmdfile=duplica_8030_dev_from_backup.rman msglog=duplica_8030_dev_from_backup.log &

The contents of duplicate are as follows (Lifecycle 4 is used)

Run {

Duplicate database PROD incarnation 4 to DEV

Pfile=/ebsbak/rmanbackup/duplicate/initDEV.ora

Db_file_name_convert= ('/ db/prod/db/apps_st/','/u01/DEV/db/apps_st/')

LOGFILE

'/ u01 size DEV _ size _ DB _

'/ u01 size DEV _ size _ DB _

'/ u01 size' DEV _ size _ DB _

NOFILENAMECHECK UNTIL TIME "TO_DATE ('2016-11-29 10-10-12-00-10-12-12-11-29-10-12-12-12-12-12-11-29-10-10-12-12-12-11-29-10-10-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-12-11-11-29, 2016-11-29, 10-15, 00-00, 000, 12, 000, 12, 12, 12, 12, 12, 12, 6, 6, 6,

}

two。 Rebuild tempfile

Alter tablespace temp1 drop tempfile'/ u01According to DEV _

Alter tablespace temp1 drop tempfile'/ u01According to DEV _

Alter tablespace temp1 add tempfile'/ u01According to DEV _

Alter database tempfile'/ u01 autoextend on next DEV _ autoextend on next _ DB _

Alter tablespace temp1 add tempfile'/ u01According to DEV _

Alter database tempfile'/ u01 autoextend on next DEV _ autoextend on next _ DB _ maxsize _

Alter tablespace temp1 drop tempfile'/ u01According to DEV _

Alter tablespace temp1 add tempfile'/ u01According to DEV _

Alter database tempfile'/ u01 autoextend on next

Alter tablespace temp2 drop tempfile'/ u01According to DEV _

Alter tablespace temp2 drop tempfile'/ u01According to DEV _

Alter tablespace temp2 add tempfile'/ u01According to DEV _

Alter database tempfile'/ u01 autoextend on next DEV _ autoextend on next _ DB _

Alter tablespace temp2 add tempfile'/ u01According to DEV _

Alter database tempfile'/ u01 autoextend on next DEV _ autoextend on next _ DB _

Alter tablespace temp2 drop tempfile'/ u01According to DEV _

Alter tablespace temp2 add tempfile'/ u01According to DEV _

Alter database tempfile'/ u01 autoextend on next DEV _ autoextend on next _ DB _ qqapps_

3. Close archiving

Three: database clone configuration (this process modifies the database pfile file, so overwrite the newly generated pfile with backup pfile)

1.

Cd $ORACLE_HOME/appsutil/install/DEV_ebsdev

Sqlplus "/ as sysdba" @ adupdlib.sql 'so'

two。

Cd $ORACLE_HOME/appsutil/clone/bin

Mv / u01/DEV/db/tech_st/11.2.0/bin/unzip / u01/DEV/db/tech_st/11.2.0/bin/unzip_6.00

Scp orapft@192.168.3.1:/u03/PFT/db/tech_st/11.2.0/bin/unzip $ORACLE_HOME/bin/

Which unzip must be from $ORACLE_HOME/bin/unzip

Which perl must be from $ORACLE_HOME/perl/bin/perl

-- Unzip must be 5.52 (or higher), but cannot be higher than 6.0

Perl adcfgclone.pl dbconfig $ORACLE_HOME/appsutil/DEV_ebsdev.xml (this process must use $ORACLE_HOME/bin/unzip, not / usr/bin/unzip)

Enter the APPS password:

3. Reuse the original database pfile backup to overwrite the newly generated database pfile

4: application cloning (using application user appldev)

1.

21.16 package application directories / app/prod/apps and / app/prod/inst

Cd / app/prod

Tar-zcvf prod_erp_20161126.tar.gz apps inst

And copy the package to / u01/DEV in 128.118

128.118 decompress the application package

Cd / db/DEV

Tar-zxvf prod_erp_20161126.tar.gz

2. (you do not need to start the application in the last step)

Cd / u01/DEV/apps/apps_st/comn/clone/bin

Perl adcfgclone.pl appsTier (do not need to use your own / u01/NPS/apps/tech_st/10.1.3/perl/bin/perl, find your own / usr/bin/perl)

Enter the APPS password:

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

Target System Database SID: DEV

Target System Database Server Node [ebsdev]:

Target System Database Domain Name [huaqin.com]:

Target System Base Directory: / u01/DEV

Target System Tools ORACLE_HOME Directory [/ u01/DEV/apps/tech_st/10.1.2]:

Target System Web ORACLE_HOME Directory [/ u01/DEV/apps/tech_st/10.1.3]:

Target System APPL_TOP Directory [/ u01/DEV/apps/apps_st/appl]:

Target System COMMON_TOP Directory [/ u01/DEV/apps/apps_st/comn]:

Target System Instance Home Directory [/ u01/DEV/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 [proderp:0.0] (yPao): n

Target System Display [ebsdev:0.0]:

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

Target System Port Pool [0-99]: 30

Checking the port pool 30

Done: Port Pool 30 is free

Report file located at / u01/DEV/inst/apps/DEV_ebsdev/admin/out/portpool.lst

Complete port information available at / u01/DEV/inst/apps/DEV_ebsdev/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. / usr/tmp

2. / u01/DEV/db/tech_st/11.2.0/appsutil/outbound/DEV_ebsdev

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

...

Completed Apply...

Mon Feb 26 16:59:27 2018

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

Services not started

Increased ~ / .bash_profle of 3.appldev

. / u01/DEV/apps/apps_st/appl/APPSDEV_ebsdev.env

Five: wrap-up work (if the application is not started)

1.

Database modification information (change the password of system)

Su-oradev

Sqlplus / as sysdba

Alter user system identified by kkk

two。

Application modification information

Su-appldev

Source / .bash_profile

Vi $AF_JRE_TOP/lib/xdo.cfg modify path path

Vi $FORMS_WEB_CONFIG_FILE adds archive2=,/OA_JAVA/hand.jar.sig

3. Change the password of all ERP-related database users in the target test environment to yyy, including the password of apps users from the original xxx to yyy

FNDCPASS apps/xxx 0 Y system/kkk SYSTEM APPLSYS yyy

FNDCPASS apps/yyy 0 Y system/kkk ALLORACLE yyy

4.

Sqlplus apps/apps

Update FND_FORM_FUNCTIONS_TL set user_function_name='8030 ERP Test 'where function_id=20569

Commit

UPDATE fnd_concurrent_requests SET phase_code = 'Che, status_code =' X' WHERE phase_code ='P'

COMMIT

5.

Cd ~

Sqlplus apps/apps

@ cmclean.sql-- this action must not be operated in a formal environment

6.

-- configure the password xxx of asadmin if the asadmin feature is enabled

Vi $INST_TOP/ora/10.1.3/j2ee/oafm/config/system-jazn-data.xml modifies the value of credentials corresponding to ASADMIN to! XXX

7.

If the OS versions on the source side and the destination side are different, you need to do the following two sentences

After installation, users must update the stub libraries in the 10.1.2 and 10.1.3 Oracle Homes using the patch 12415211. In following the instructions below, please note that Opatch should not be used to install this patch.

Users must specifically copy the files in the patch to the specified directories as follows for the 10.1.2 Oracle Home:

$cd / apps/tech_st/10.1.2/lib

$cp-p-R stubs stubsORIG

$cd stubs

$cp / 12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so.

$ln-s libgcc_s-2.3.2-stub.so libgcc_s.so.1

$ln-s libgcc_s.so.1 libgcc_s.so

After this is done and sourcing the APPS.env file, users should relink all 10.1.2 executables by running the $ORACLE_HOME/appsutil/clone/adlnktools.sh script and ensuring that there are now no errors in the make log file output from the script.

The instructions for the 10.1.3 Oracle Home are:

$cd / apps/tech_st/10.1.3/lib

$cp-p-R stubs stubsORIG

$cd stubs

$cp / 12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so.

$ln-s libgcc_s-2.3.2-stub.so libgcc_s.so.1

$ln-s libgcc_s.so.1 libgcc_s.so

After this, users should relink sqlplus by running the / apps/tech_st/10.1.3/appsutil/clone/adlnkweboh.sh script and ensuring that there are now no errors in the make log file output from the script.

8. Start ERP

Su-appldev

Cd $ADMIN_SCRIPTS_HOME

. / adstrtal.sh apps/apps

9.

Configure the ASADMIN integrated SOA gateway

Find $APPL_TOP-name "soagenerate.sh"

/ u01/DEV/apps/apps_st/appl/fnd/12.0.0/bin/soagenerate.sh

Cd / u01/DEV/apps/apps_st/appl/fnd/12.0.0/bin

Soagenerate.sh irepname=CUX_FND_MSG_CALL_CENTER_PKG

Log in to the WEB page of ERP to see if the configuration in step 6 above is normal

Asadmin/XXX

Integrate SOA Gateway-Integrated Information Base-CUX Developer-CUX Developer-CUX Developer-SOAP Web Services-View the WSDL- page and click on it.

10.

Enter the window to modify the following information

ERP-- profile-system-profile box enter% roll call%-click find-modify the location to XX test environment (8030) 2016-11-18

ERP-- profile-system-profile box enter% Java color design%-click find-select the location as purple

Remarks

If you want to change the server name, domain name, db_name, and port for an existing application, perform the following steps

1. Database software cloning

2. The database reconstruction control file modifies db_name, pulls up the database, and adds tempfile

3. Database cloning

4. Application cloning

If it is duplicate to the target server, the target server needs to change the server name, domain name, db_name, port, and perform the following steps

1. After duplicate the target server, the server pulls up the database.

2. Database software cloning

3. The database reconstruction control file modifies db_name, pulls up the database, and adds tempfile

4. Database cloning

5. Application cloning

This is the end of the case analysis of EBS online cloning DB and applications. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.