Saturday, June 18, 2011

Cloning Oracle database software or Oracle home to different server

In a situation where you need to create testing Oracle database environment, the best option is to have exactly same ORACLE_HOME that is in production because many running productions are heavily patched.

Here in this post we will see how to clone the oracle home from server 1 to server 2:

Source database server (sour)
ORACLE_HOME location is: D:\app\oracle\product\11.2.0\dbhome_1
·         Zip this complete folder i.e. dbhome_1

Target database server (tart)
Create the directory: D:\app\vishwanaths\product\11.2.0\clone
·         Copy the zipped file and uncompress in the above location.

Since we have moved files to different directory and different server, many Oracle paths are wrong. Beside that many libraries point to invalid place what will prevent Oracle form normal functioning. So this will be fixed with script, which is placed in $ORACLE_HOME/clone/bin directory:


Goto D:\app\oracle\product\11.2.0\clone\dbhome_1\clone\bin\

C :\>:perl D:\app\oracle\product\11.2.0\clone\dbhome_1\clone\bin\ ORACLE_BASE=D:\app\oracle ORACLE_HOME=D:\app\oracle\product\11.2.0\clone\dbhome_1 ORACLE_HOME_NAME=11GR2_HOME
....................................................................................................Dll to load is C:\DOCUME~1\VISHWA~1.RAM\LOCALS~1\Temp\OraInstall2011-06-17_04-39-37PM\Win32RunProcesses.dll
Loading psapi.dll from C:\DOCUME~1\VISHWA~1.RAM\LOCALS~1\Temp\OraInstall2011-06-17_04-39-37PM\psapi.dll
 100% Done.

Installation in progress (Friday, June 17, 2011 4:57:27 PM IST)
.............................................................................                                                   77% Done.
Install successful

Setup in progress (Friday, June 17, 2011 4:58:31 PM IST)

Unable to open symbol file D:\app\oracle\product\11.2.0\clone\dbhome_1\dbs\opctrn11.hSetup successful

End of install phases.(Friday, June 17, 2011 5:19:16 PM IST)
Starting to execute configuration assistants
The following configuration assistants have not been run. This can happen because Oracle Universal Installer was invoked with the -noConfig option.
The "D:\app\oracle\product\11.2.0\clone\dbhome_1\cfgtoollogs\configToolFailedCommands" script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.
The "D:\app\oracle\product\11.2.0\clone\dbhome_1\cfgtoollogs\configToolAllCommands" script contains all commands to be executed by the configuration assistants. This file may be used to run the configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.

The cloning of 11GR2_HOME was successful.
Please check 'C:\Program Files\Oracle\Inventory\logs\cloneActions2011-06-17_04-39-37PM.log' for more details.

How to check that cloning was successful?

Goto C:\Program Files\Oracle\Inventory\ContentsXML\

Open inventory.xml file…

<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2009, Oracle. All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<HOME NAME="OraDb11g_home1" LOC="D:\app\oracle\product\11.2.0\dbhome_1" TYPE="O" IDX="1"/>
<HOME NAME="11GR2_HOME" LOC="D:\app\oracle\product\11.2.0\clone\dbhome_1" TYPE="O" IDX="2"/>

Above  marked text shows that new home with name “11GR2_HOME” has been created.



oakleyses said...

cheap oakley sunglasses, nike air max, jordan shoes, polo outlet, longchamp outlet, louis vuitton, ray ban sunglasses, tory burch outlet, longchamp pas cher, oakley sunglasses, replica watches, longchamp outlet, nike free run, louis vuitton outlet, nike air max, polo ralph lauren, christian louboutin outlet, nike outlet, oakley sunglasses, burberry pas cher, oakley sunglasses, tiffany jewelry, louis vuitton, prada outlet, replica watches, ray ban sunglasses, jordan pas cher, sac longchamp pas cher, chanel handbags, tiffany and co, ugg boots, oakley sunglasses wholesale, longchamp outlet, uggs on sale, polo ralph lauren outlet online, christian louboutin uk, michael kors pas cher, gucci handbags, christian louboutin, christian louboutin shoes, prada handbags, nike roshe, nike free, air max, kate spade outlet, ray ban sunglasses, ugg boots, louboutin pas cher

oakleyses said...

michael kors outlet, hollister pas cher, ralph lauren uk, michael kors, north face uk, coach outlet store online, true religion outlet, mulberry uk, abercrombie and fitch uk, guess pas cher, true religion outlet, lululemon canada, ray ban pas cher, michael kors, uggs outlet, vans pas cher, nike free uk, michael kors outlet, michael kors outlet online, replica handbags, nike tn, michael kors outlet, oakley pas cher, burberry outlet, polo lacoste, nike air max uk, nike blazer pas cher, hollister uk, michael kors outlet online, sac hermes, uggs outlet, michael kors outlet online, burberry handbags, new balance, coach purses, true religion jeans, north face, kate spade, ray ban uk, michael kors outlet online, true religion outlet, nike air max, converse pas cher, nike air force, nike air max uk, nike roshe run uk, sac vanessa bruno

oakleyses said...

ghd hair, hollister clothing, ray ban, iphone cases, celine handbags, oakley, insanity workout, converse, abercrombie and fitch, instyler, gucci, lululemon, ferragamo shoes, baseball bats, nike huaraches, beats by dre, babyliss, louboutin, new balance shoes, mac cosmetics, hollister, herve leger, hermes belt, giuseppe zanotti outlet, timberland boots, vans, valentino shoes, nike trainers uk, asics running shoes, p90x workout, nfl jerseys, nike air max, vans outlet, reebok outlet, soccer shoes, north face outlet, soccer jerseys, converse outlet, longchamp uk, nike roshe run, wedding dresses, ralph lauren, hollister, bottega veneta, north face outlet, mont blanc pens, nike air max, jimmy choo outlet, mcm handbags, chi flat iron

oakleyses said...

canada goose outlet, canada goose, toms shoes, links of london, karen millen uk, doudoune moncler, pandora jewelry, louis vuitton, marc jacobs, montre pas cher, canada goose outlet, moncler uk, moncler, pandora charms, juicy couture outlet, louis vuitton, thomas sabo, replica watches, canada goose jackets, ugg uk, ugg, canada goose, ugg,uggs,uggs canada, louis vuitton, wedding dresses, juicy couture outlet, canada goose, swarovski, moncler, canada goose outlet, supra shoes, moncler outlet, lancel, coach outlet, canada goose uk, louis vuitton, moncler outlet, moncler, louis vuitton, swarovski crystal, ugg pas cher, barbour, pandora uk, barbour uk, ugg,ugg australia,ugg italia, moncler, hollister, pandora jewelry

roba gad said...

Blogger said...

BlueHost is definitely the best hosting provider for any hosting services you need.