RE: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K

From: <Jared.Still_at_radisys.com>
Date: Wed, 02 Jul 2003 12:37:57 -0700
Message-ID: <F001.005C1176.20030702122545@fatcity.com>

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
---------------------------------------------------------------------

--

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
---------------------------------------------------------------------