Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How best to move oracle9 db and binaries between similiar unix servers?

Re: How best to move oracle9 db and binaries between similiar unix servers?

From: Lane Lesperance <llesperance_at_cooperpower.com>
Date: 11 Jul 2003 08:38:59 -0700
Message-ID: <66feb5c.0307110738.e797e26@posting.google.com> 





Ian, I just upgraded from 7.3.4 to 8.1.7. I installed and tested on a
test server, and then installed into production by copying and
relinking. This WAS sanctioned by Oracle and I have included the Tar
that I opened with metalink about this issue. Hope this helps.






Abstract
 


[06-03]INSTALL IN PRODUCTION BY COPYING ORACLE_HOME FROM TEST ??  

    
Resolution History 



12-MAY-03 14:20:13 GMT


### Problem Description: ###


I am upgrading from 7.3.4 on AIX 4.3.3 (32 bit) to 8.1.7. I am
installing and


testing on a computer called TSTSVR which is a system used for
testing. After


the install and migration I will be installing patchset 8.1.7.4 and
the patch


set for security fixes 48-51. If I run rootpre.sh on our production
machine


PRDSVR to install the post wait kernel extension, can I then copy the 
ORACLE_HOME from TSTSVR (test) to PRDSVR (prod) to install the fully
patched


software, or do I need to run a full install process and apply the
patches?



12-MAY-03 16:06:29 GMT



UPDATE






Lane,



EXPLANATION






Yes, you can copy your Oracle Home from your Test Unix box to your
Production Unix box, but you must to relink it



ACTION PLAN






    
  
  1.   After copy your Oracle Software, please relink it:






Example:



$ORACLE_HOME/bin/relink all > $HOME/relink.out 2> $HOME/relink.out 



Thank You!



STATUS





@SCL




13-MAY-03 19:57:04 GMT


New info : Will I also need to run the root.sh script from the test
computer


(TSTSVR) on the production computer (PRDSVR)?



13-MAY-03 20:07:53 GMT



UPDATE






Lane,



EXPLANATION






Question 1: Will I also need to run the root.sh script from the test
computer (TSTSVR) on the production computer (PRDSVR)?



Answer 1: Yes, the "root.sh" is necessary to complete the
installation. This file is located under "?/orainst". It creates an
"oratab" file or appends to it if this file already exists with an
entry for the new instance that was created. It also copies some
executables to the local "bin" directory specified by the user in the
installation. This script should be run by "root" after installation.



Thank You!



STATUS





@SCL





15-MAY-03 19:07:05 GMT


New info : Let me summarize where I am.


Environment is 2 AIX servers that are configured nearly identical.
TSTSVR(test)


and PRDSVR(prod).


I am upgrading from 7.3.4 to 8.1.7 using ODMA.
I installed from the CDROM on TSTSVR.


I migrated the database on TSTSVR using ODMA.
I am going to install the 8.1.7.4 patch set and security fixes 48-51
and 54.


I will then complete my testing.


Based on previous info in this tar, to install in prod (PRDSVR):
I will run rootpre.sh from the CDROM on PRDSVR and reboot.
I will copy the directory $ORACLE_HOME from TSTSVR to PRDSVR
I will run $ORACLE_HOME/bin/relink all


I will run $ORACLE_HOME/root.sh as root on PRDSVR
My ORACLE_HOME=/oracle/app/oracle/product/8.1.7
Can you confirm for me that:


I should copy /oracle/app/oracle/product/jre from TSTSVR to PRDSVR
I should copy /oracle/app/oracle/product/oraInventory from TSTSVR to
PRDSVR



I should copy /oracle/app/oracle/product/oui from TSTSVR to PRDSVR
I should copy /etc/oraInst.loc from TSTSVR to PRDSVR
Are there any relinks required for the above copied directories?



Thanks, Lane Lesperance





15-MAY-03 19:30:05 GMT



UPDATE






Lane,



EXPLANATION






    
  
  1.   Yes, the above steps are OK, also you can include the /etc/oratab
file.

  
  2.   You just need to relink Oracle Server.

  
  3.   Also, it is very import to coy the Oracle Inventory and the
oraInst.loc file






If you have additional questions please let me know.



Thank you.



STATUS





@SCL




28-MAY-03 15:30:47 GMT


Country: UNITED STATES


The customer has uploaded the following file via MetaLink:
H:\Oracle\log\relink.out





28-MAY-03 15:32:32 GMT


Country: UNITED STATES


The customer has uploaded the following file via MetaLink:
H:\Oracle\log\relink-errs.out





28-MAY-03 15:33:13 GMT


New info : I did a "relink all" and got some error and warning
messages. I have


uploaded the results of the relink. Are these messages anything that I
need to


be concerned about?





28-MAY-03 16:09:49 GMT



UPDATE






Lane,



Relink.out




ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0711-224 WARNING: Duplicate symbol: vppm
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.


ld: 0706-027 The -R /oracle/app/oracle/product/8.1.7/lib/ flag is
ignored.

ld: 0711-224 WARNING: Duplicate symbol: .pw_wait
ld: 0711-224 WARNING: Duplicate symbol: pw_wait
ld: 0711-224 WARNING: Duplicate symbol: .pw_post
ld: 0711-224 WARNING: Duplicate symbol: pw_post
ld: 0711-224 WARNING: Duplicate symbol: .pw_config
ld: 0711-224 WARNING: Duplicate symbol: pw_config
ld: 0711-224 WARNING: Duplicate symbol: .aix_ora_pw_version3_required
ld: 0711-224 WARNING: Duplicate symbol: aix_ora_pw_version3_required
ld: 0711-224 WARNING: Duplicate symbol: ksmsgl_
ld: 0711-224 WARNING: Duplicate symbol: kcbkclx_
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more


information.





EXPLANATION






Basically there are not errors or fatal errors in your relink.out file
and the above messages (warnings) can be ignored without problem.



If you have additional questions, please let me know.



Thank you.



STATUS





@SCL



28-MAY-03 17:56:26 GMT


Email Update button has been pressed -- Sending email. 



12-JUN-03 00:09:30 GMT


TAR passed SCL review date. Setting to HCL.  
    





ianm2_at_shaw.ca (Ian) wrote in message news:<23b28adc.0307100941.26b310f5_at_posting.google.com>...

> Hi - we need to move a 9.2.0.3 database from one AIX server to
> another. Both servers have similiar hardware and are at the same O/S
> level (AIX4.3.3).
> 
> Our change window is short so ideally we would simply like to tarball
> $ORACLE_BASE on Server A and untar on server B.
> 
> Does anyone have experience with this approach? Is this method
> supported? And is there any documentation available specifically
> describing the files and directories the rdbms accesses outside of
> $ORACLE_BASE such as the ones in /etc/ and /usr/local/ .
> 
> thanks very much


Received on Fri Jul 11 2003 - 10:38:59 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US