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 clone.pl script, which is placed in $ORACLE_HOME/clone/bin directory:

Now,

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

C :\>:perl D:\app\oracle\product\11.2.0\clone\dbhome_1\clone\bin\clone.pl 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. -->
<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>11.2.0.1.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<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"/>
</HOME_LIST>
</INVENTORY>

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

EnjoyJ



14 comments:

Onlive Server said...

Outstanding and mindblowing, this information is very much help full for me. I love this blog posting. I wanna say thanks for sharing your information, keep it up.
Germany VPS Hosting

Anonymous said...

Great blog. We also share information about Domain Name Registration, if anyone looking for the online presence of your business or website then it is vital that you get a domain name registered so Onlive Server offer you best Domain Name registration services.

Anonymous said...

Thanks, A lot for introducing your best information, i hope you keep it up.......
Check Domain Registration

Anonymous said...

Really a very interesting and helpful article if you have looked at anything about the USA maps cities then this blog cloud gives you excellent information. and you have any kind of plan stat in the USA the Onlive Server offer book a unique domain name and give an opportunity to become a business owner.
Book Domain Name Online

Anonymous said...

Thanks a lot for sharing your blog posting it amazing everyone does appreciate your blog posting and says that really helpful posting. So you can read it and get more info with onlive server they have gives a golden opportunity to book domain name online free of cost, so I think you should try it one time.
Book Domain Name Online

Anonymous said...

I am very interested to read your post. Your Post is very nice and very valuable for every user. Thanks for sharing good information related to the database server.
Cheap VPS Hosting

Anonymous said...

Thanks For sharing your great information, I like your blog post that is too much valuable and helpful for all business users.
Book Domain Name Registration Online

Anonymous said...

One of the most sophisticated blog postings, you can control your overall windows setups with their tips. if you haven't cleared this the onlive server gives your full help in your business setups.
Book Domain Name Online

Anonymous said...

Your post is amazing i tell you truly that i enjoy you whole post and increase my knowledge from your blog post.
Book Domain Name Registration Online

Onlive Server said...

Such a wonderful information blog post on this topic, I am really impressed with your blog article. I appreciate your work. Thanks for sharing and keep it up like this.
UK VPS Hosting

Anonymous said...

Thanks for introducing your great experience, that is very interesting and help full. you could improve your business awareness with web hosting services Onlive server gives you a lot of the newest online business tactics.

UK Dedicated Server Hosting

Anonymous said...

I see many of your blogs posted..and I must say that your topics are good, the contents are good, the level of research is very good, the presentation is good to explain.
Domain Name Registration

Anonymous said...

Wah! what a post I have to get a piece of excellent information about the web hosting services, such a good explanation. I appreciate your post. Thanks for sharing your experience.
USA Dedicated Server Hosting

Anonymous said...

There is a lot of information that is a very helpful blog post, We appreciated your blog post. Thanks for sharing your amazing information.
Book Domain Name Online