Solved

Clone Oracle 8i Home from Solaris 10 to anothr zone

Posted on 2014-12-22
12
187 Views
Last Modified: 2015-03-16
I have Oracle 8i up and running on Solaris 10 which is previously migrated from solaris 8. Now i want to clone this oracle home to th same same physical server within th another solaris zone.

I believe oracle 8i is not supportd however this has been done previously and can see the oracle home up and running.

Do I need to relink the libarray after copying the oracle home ?

Please advise with detail how can we migrate oracle 8i home to another server

regards,
0
Comment
Question by:arv124
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 3
12 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 40513397
Procedure to clone Oracle Home:
1) Shutdown all services using the source Oracle Home.
2) logon as "root' and Zip the entire Oracle Home.
3) copy to target server, logon as root and unzip
4) Logon as Oracle Home owner and re-link all
5) edit $ORACLE_HOME/oraInst.loc to point to the OraInventory on that server (copy from /etc/oraInst.loc or /var/opt/oracle/oraInst.loc)
6) cd $ORACLE_HOME/oui/bin and execute "./attachHome.sh"
:p
0
 

Author Comment

by:arv124
ID: 40513404
Thanks for the prompt answer, however wondering if we need to change the ownership on target if we Zip the source oracle home as root user?

Also am new to this, so relink command and if any log file location would be much appreciatd.

Would really appreciate if you please provide detail step to copy, any change and relink command

Thanks in advance.

Best Regards,

Arvind
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 40513447
it will keep the source ownership. the reason for using "root" is that some Oracle binaries and links are owned by root.
just copy over the zip file.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 40515340
I've usually done this without the zip, unzip, re-link and "attachHome.sh" steps.  I've usually done a simply file copy, of not only the $ORACLE_HOME directory tree, but also any other directories that include Oracle database files.  Depending on who did the original Oracle software install and database creation, and on how the database has been managed since then, the Oracle datafiles could be in almost any directory (or file system) on the source server.  Also, I do file/directory copies with the "-p" option to preserve file ownership and timestamps.  This assumes that you already have an Oracle owner and DBA group account created on the new system with userID and groupID values matching those on the source system,
0
 

Author Comment

by:arv124
ID: 40520068
Dies that mean that oracle user id and group id have to be the same? What action do i have to take if owner/group id is not the same though the name is same. Again this is Oracle 8i on Solaris 10 assuming 8i is not compatible to solaris 10 however copying the binaries and data file as per the solution above might work.

Regards,
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 40521874
Here are the instructions to clone an Oracle Home from the fine Oracle® Database Installation Guide 11g Release 2 (11.2) for Oracle Solaris
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 40521969
No, the userid and groupid do not have to be the same on the new server.  But, if they are different, then on the new server you will have to "chown -R" all of the files you copy so they get the userid and groupid values they need on the new server.

And no, I would not assume that Oracle8i is incompatible with Solaris10 (but I'm not an expert on Solaris).  If Oracle8i is compatible with an earlier version of Solaris, I would expect that it would also work on a later version of Solaris.
0
 

Author Comment

by:arv124
ID: 40551028
Thanks for the help. Regards
0
 

Author Comment

by:arv124
ID: 40551038
I am getting error & database does not start

WARNING: Not enough physical memory for SHM_SHARE_MMU segment of size 0x00000000476ba000

For the initial workout reduce the size of SGA and this works - There is 16g memory on server however not able to strat another instance of the database on the same server?

sysresv

IPC Resources for ORACLE_SID "test3" :
Shared Memory
ID              KEY
No shared memory segments used
Semaphores:
ID              KEY
33554465        0x400507c4
Oracle Instance not alive for sid "test3"


Please let me know if you need more information.

Thanks in advance
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 40551202
I am not an expert on Solaris (or any other *nix O/S).  I have some Linux experience, so I recognize that most of these O/Ses require changes to some memory-related parameters for Oracle and for your hardware.  What exactly those values should be for your O/S and your hardware, I can't help you with.

Then, if you want to run not just one, but two (or maybe more?) Oracle instances on the same host and from the same O/S user account, that can add some complexities, and it may require you to set some memory-related values differently.  In the days of 32-bit Linux, we found it simpler to use different O/S user accounts to run different Oracle instances when we wanted multilpe instances on the same host.  These days, with 64-bit O/Ses, you may not need separate O/S user accounts.
0
 

Accepted Solution

by:
arv124 earned 0 total points
ID: 40658479
Thanks this is now resolved
0
 

Author Closing Comment

by:arv124
ID: 40667496
The comments helpful to install oracle 8i libararies.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question