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 and adcfgclone.pl configures the target system.
• adpreclone.pl is located in $COMMON_TOP/admin/scripts/$CONTEXT_NAME directory and adcfgclone.pl located in $COMMON_TOP/clone/bin.
• Adpreclone.pl collects information about the database.
• It also creates generic templates of files containing source specified hardcore values.
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.
What adpreclone.pl does on appsTier?
Adpreclone.pl ?adclone.pl?StageAppsTier.java
?StageApplTop.java
?StageAppsTechStack.java
What adpreclone.pl does on dbTier?
Adpreclone.pl ?adclone.pl?StageDBTier.java
?StageDtabase.java
?StageDBTechStack.java
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;
}
When do we run FND_CONC_CLONE.SETUP_CLEAN?
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.
Quote of the day
===========
First they ignore you, then they laugh at you, then they fight you, then you win.
!!!!!!!!!!!!!!!!!!! !!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!
hi abdul
ReplyDeletei run admakeappsutil.pl in $AD_TOP/bin
and i unzip it db $ORACLE_HOME what it wil
updates i need with example...
assalam bhai great ho yar
ReplyDelete