?
Solved

Clone Oracle 8i Home from Solaris 10 to anothr zone

Posted on 2014-12-22
12
Medium Priority
?
200 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

762 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