Re: Upgrade 8.1.7.3.0 to 8.1.7.4.1 on W2K

From: <Jared.Still_at_radisys.com>
Date: Tue, 01 Jul 2003 13:27:21 -0700
Message-ID: <F001.005BD7EB.20030701130720@fatcity.com>

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). Received on Tue Jul 01 2003 - 15:27:21 CDT