A quick scan of it looks ok.
Not sure about copying the password file.
Too easy to create it to bother I think.
BTW, export the Oracle registry key to a file first.
It comes in useful on occasion. :)
Jared
Jack van Zanen <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2003 01:10 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K
I have a few databases in Home0 and a few in Home1 and need to move one
from
Home0 to Home1
So if I understand correct I can do:
Oradim -delete -sid <SID>
Remove the entries that look like
ORA_<SID>_AUTOSTART
ORA_<SID>_SHUTDOWN
ORA_<SID>_SHUTDOWNTYPE
ORA_<SID>_SHUTDOWN_TIMEOUT
>From Home0(if not done by oradim)
Put the init<SID>.ora file in the new home location
Create a new service
<NEW_HOME>\bin\oradim.exe -new -sid <SID> -startmode m
<NEW_HOME>\bin\oradim.exe -edit -sid <SID> -startmode a
<NEW_HOME>\bin\orapwd.exe file=d:\oracle\ora90\database\PWD<SID>.ora
password=<password> (Or can I just copy the password file?)
Change the listener.ora
Start the database
Run catalog/catproc/catexp etc....
Is this Correct???
TIA
Jack
-----Original Message-----
Sent: Tuesday, July 01, 2003 11:07 PM
To: Multiple recipients of list ORACLE-L
Assuming that you are changing the second Oracle Home, ie. Home1.
Change the following entries in the registry:
HKLM\Software\Oracle\ALL_HOMES\ID1\PATH
HKLM\Software\Oracle\HOME1\ORACLE_HOME
Depending on how you've located init and dump files, etc., you may see
other
entries in HKLM\Software\Oracle\HOME1 that
need to be changed as well.
You then need to remove and re-create the service.
oradim -delete -sid SID
oradim -new -sid SID -pfile <path to init.ora>
type oradmin on a command line to get all options.
Then check HKLM\System\CurrentControlSet\Services\OracleService<SID>
to ensure that the correct binary is in use.
Edit your tnsnames.ora/names registry or whatever you use for name
resolution.
That should about do it.
Jared
Jack van Zanen <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/01/2003 08:55 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K
Hi All,
We have a test machine with both the 81730 and 81741 software in their own
oracle homes.
We now want to move a database from the 81730 home to 81741
I know I have to run the catalog.sql, catproc.sql from the new home etc...
But how do I tell the registry that the database moved homes??
TiA
Jacob A. van Zanen
Oracle DBA
Quant Systems Europe b.v.
Tel : +31 (0) 251 - 268 268
Mobile: +31 (0) 6 51308813
Fax: +31 (0) 251 - 268 269
E-mail: [EMAIL PROTECTED]
Visit our web site at http://www.quantsystems.nl/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jack van Zanen
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
