Cloning interview questions

What is cloning and why is it required?

• Cloning is the process of creating an identical copy of the Oracle application system.

It is required due to following reasons

• Creating a test copy of your production system before upgrading.

• Moving an existing system to a different machine.

• To test some patches

• Creating a development copy of your environment to be used by the developers.

 What is the location of adpreclone.pl for RDBMS_ORACLE_HOME?

 $RDBMS_ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

 What is the location of adcfgclone.pl for RDBMS_ORACLE_HOME?

 $RDBMS_ORACLE_HOME/appsutil/clone/bin

 What is the location of adpreclone.pl for applmgr user?

 $COMMON_TOP/admin/scripts/$CONTEXT_AME

What is the location of adcfgclone.pl for applmgr user?

 $COMMON_TOP/clone/bin

How to scrap the target database?

Login to database as sysdba, 

1)shutdown database (shutdown immediate)

2) startup restrict mount

3)drop database

SQL> startup restrict mount;

ORACLE instance started.

Total System Global Area 2021117952 bytes

Fixed Size 2229704 bytes

Variable Size 1728055864 bytes

Database Buffers 268435456 bytes

Redo Buffers 22396928 bytes

Database mounted.

SQL> select name from v$database;

NAME

---------

EBSTEST1

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL>

What are the scripts do you use while Apps cloning?

• adpreclone.pl prepares the source system

• adpreclone.pl collects information about the database.

• It also creates generic templates of files containing source specified hardcore values.

• adcfgclone.pl configures the target system

adpreclone.pl is in $COMMON_TOP/admin/scripts/$CONTEXT_NAME directory and     adcfgclone.pl located in $COMMON_TOP/clone/bin.

How often Do you clone?
Cloning happens biweekly or monthly depending on the organization requirement.

 How do we find adpreclone is run in source or not ?

 If clone directory exists under $RDBMS_ORACLE_HOME/appsutil for oracle user and $COMMON_TOP/clone for applmgr user.

When do you run adpreclone on Production?

If any changes made to either TechStack,database or any patches applied.

When we run perl adpreclone.pl dbTier why it requires apps password?

It requires a database connection to validate apps schema.

When we run perl adpreclone.pl appTier why it will not prompt for apps password?

It doesn’t require db a connection.

What happens after running adcfgclone.pl?

It will take inputs and creates xml file.

after creating xml file,it runs autoconfig.

It registers the ORALCE_HOME with GLOBAL INVENTORY.

When you moved oracle binary files from one ORACLE_HOME server to another server then which oracle utility will be used to make this new ORACLE_HOME usable?

Relink all.

what Perl adcfgclone.pl dbTechStack do?

Perl adcfgclone.pl dbTechStack will do below things.

1)Create context file

2)Register ORACLE_HOME

3)Relink ORACLE_HOME

4)Configure ORACLE_HOME

5)Start SQL*NET listener

what Perl adcfgclone.pl dbTier do?

1)Create context file

2)Register ORACLE_HOME

3)Relink ORACLE_HOME

4)Configure ORACLE_HOME

5)Recreate controlfile

6)Configure database

7)Start SQL*NET listener

what Perl adcfgclone.pl appsTier do?

perl adcfgclone.pl appsTier will do below things.

1)Create context file

2)Register ORACLE_HOME

3)Relink ORACLE_HOME

4)Configure ORACLE_HOME

5)Create INST_TOP

6)Configure APPL_TOP

7)Start Apps Processses

How to register a node as Concurrent manager ?

SQL> @afcpnode_ctssd11.sql

Enter value for 1: apps

Enter value for 2: apps#man

Enter value for 3: ebstest1

Connected.

Register a node ...
11 args...
Registered Node - erptest1 - as Concurrent Manager recognizable node
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

When we run adcfgclone.pl which script it will call?

It will call adclone.pl which is located at $AD_TOP/bin .

To use RMAN DUPLICATE what parameters are mandatory in 11g?

*.db_file_name_convert='/ebsoltp1/oradata/dbdata/data1','/ebstest1/oradata/dbdata/data1','/ebsoltp1/dbdata/temp','/ebstest1/dbdata/temp'

*.log_file_name_convert='/ebsoltp1/oradata/dbdata/redo1','/ebstest1/oradata/dbdata/redo1','/ebsoltp1/dbdata/redo2','/ebstest1/dbdata/redo2'

*.diagnostic_dest='/ebstest1/oracle/11.2.0/admin/ebstest1_ebstest1'

*.event='10298 trace name context forever, level 32'

What is rman duplicate?

rman log /ebstest1/oracle/recovery.log

==>By default rman writes output to screen but we are sending the output to log file.

connect target sys/*****@ebsoltp1

==> connect to production database

connect catalog cataloguser/cataloguser@catalogdb

==>Connect to catalog database.

connect auxiliary /

Connect to target database.

run {

ALLOCATE auxiliary CHANNEL ch00 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch01 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch02 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch03 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch04 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch05 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch06 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch07 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch08 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch09 TYPE DISK;

ALLOCATE auxiliary CHANNEL ch10 TYPE DISK;

set until time '30-DEC-2012 23:35:00';

duplicate target database to ebstest1;

RELEASE CHANNEL ch01;

RELEASE CHANNEL ch02;

RELEASE CHANNEL ch03;

RELEASE CHANNEL ch04;

RELEASE CHANNEL ch05;

RELEASE CHANNEL ch06;

RELEASE CHANNEL ch07;

RELEASE CHANNEL ch08;

RELEASE CHANNEL ch09;

RELEASE CHANNEL ch10;

}

Does clone preserve the patch history?

• Yes, Rapid clone preserves the patch history in following locations

• RDBMS ORACLE_HOME: preserves the OUI oraInventory.

• iAS ORACLE_HOME: preserves the OUI oraInventory

• 806 ORACLE_HOME: preserves the patch level and Oracle inventory

• APPL_TOP and Database: preserves the patch level and history tables.