RE: Windohs client problems

> From: Eric D. Pierce [mailto:eric_d_pierce_at_pacbell.net]
> Sent: Wednesday, July 24, 2002 4:58 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Windohs client problems
>
>
> are you talking about reinstalling windows, or oracle?
>
> did you take it down to bare metal, and remove all
> oracle products, including following the instructions
> from oracle tech support for doing a manual cleanout?
>
> do you have a production db installed on that box?

"Just" Oracle. I don't have an instance running, but I don't fancy attempting to uninstall/delete/reinstall/reconfigure 9i, because I'm running OEM (server and client w/remote repository) and an ONames backup. According to Oracle Support, I should just be able to nab the .ora files before the uninstall to maintain the config of OEM, but this isn't true. The GUI settings appear to be local to the client, especially the "Groups" settings (e.g. background images). ONames is a little simpler.

The last time I wiped Oracle and reinstalled on Windohs, it took a few *days*. Hell, even with the supremely icky Oracle installs on VMS I could have that done in a couple of hours. <sigh> Perhaps I just bite the bullet and reinstall. To do this correctly on WinTuke, I have a few questions:

1. If more than one ORACLE_HOME is required (in my case, due to differences in 8i/9i), is the order of installation important? Should I install 8.1.7 client before or after 9i EE? Or doesn't it matter?
2. From a Registry monitor program, I saw that the MS ODBC for Oracle driver only looked at HKLM/SOFTWARE/ORACLE/ORACLE_HOME for it's ORACLE_HOME. This key doesn't change it's value when the active ORACLE_HOME is changed thru Oracle Home Selector. So, how do I get the MS ODBC driver to point to other ORACLE_HOMEs? And what exactly does the Oracle Home Selector change? How should a client program identify the current ORACLE_HOME?

WHY THE HELL IS THIS SO FREAKING COMPLEX? K.I.S.S.! <grumble grumble> Maybe I need to start a "rant-rant-rant" thread? ;)

> backups?

Backups of my PC? Ha! At the very least I should be getting an Winders box for testing Oracle stuff now that this has happened a few times.

Thx!

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).