Solved

Clone Oracle 8i Home from Solaris 10 to anothr zone

Posted on 2014-12-22
12
146 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
  • 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
 
LVL 34

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 34

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 34

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

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…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now