Clone Oracle 8i Home from Solaris 10 to anothr zone

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

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

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.

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,

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,

Here are the instructions to clone an Oracle Home from the fine Oracle® Database Installation Guide 11g Release 2 (11.2) for Oracle Solaris

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.

Thanks for the help. Regards

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

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.

The comments helpful to install oracle 8i libararies.