RE: Need to update the ORACLE SID on W2000 Registry

From: <Jared.Still_at_radisys.com>
Date: Fri, 16 Nov 2001 12:03:41 -0800
Message-ID: <F001.003C7AC0.20011116102021@fatcity.com>

Whoa Mark!

You really want Ken to much around in the registry?

I think what he's asking is how to use 'oradim'?

Ken, just type 'oradim' on the command line, and you will get a help screen. Look it up in the docs if you have to, but it supplies a pretty good help screen.

Don't mess with the registry unless you have to. It's not terribly dangerous, but like Mark said, back it up first via File->Export.

Jared

                                                                                       
                             
                    "Mark Leith"                                                       
                             
                    <mark_at_cool-too       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    ls.co.uk>            cc:                                           
                             
                    Sent by:             Subject:     RE: Need to update the ORACLE 
SID on W2000 Registry           
                    root_at_fatcity.c                                                     
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    11/16/01 08:00                                                     
                             
                    AM                                                                 
                             
                    Please respond                                                     
                             
                    to ORACLE-L

Ken,

You need to "run" (Start/Run..) either of the programs regedit (my personal favourite), or regedt32. The registry is essentially the "file" that holds all of the config/licenses etc. settings for your programs, O/S, services etc.

regedit is an "Explorer" type interface, so you will need to navigate through the directory type interface to
HKEY_LOCAL_MACHINE/SOFTWARE/Oracle/ALL_HOMES.. or whatever it is off the top
of my head, and modify the string by double clicking it on the right hand window, and editing it in there..

It is ALWAYS a good idea to take a backup of your registry before modifying it!! If you use regedit to do this, simply pull down you file menu, and export the registry to a nice safe location :)

HTH Mark

-----Original Message-----

Sent: 16 November 2001 15:15
To: Multiple recipients of list ORACLE-L

I will be creating a new database from a DDL SQL script on a W2000 server using 8.1.7.

My previous experience has been in the Unix world so the Registry is something new to me. The server has the Oracle demo DB installed. I need to create this new DB and the Oracle Post-Installation DB Creation guide says that I need to update the ORACLE SID in the Registry if I am going to create a new DB.

So, I need to become familiar with this Registry thing. Is the Registry located on my client PC or the server? And, how do I access it and make the
necessary changes to the SID? I have administrator access on the server.

Keep your answers simple please because I am new the Registry

Thanks,

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN
.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ken Janusz
INET: ken.janusz_at_sufsys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (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.com
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message