RE: Windohs client problems
On 24 Jul 2002 at 13:32, Jesse, Rich wrote: ... > > The kind of complex combo you are attempting is probably > > inherently going to be problematic, and I would definitely > > have asked Oracle tech support about install sequence issues ... > Yeah, I know I need to place a TAR. But the last one I placed was a > *dream*, thanks to Cathy@Oracle. Not only did she actually e-mail me > directly (as opposed to only updating the TAR), but she even called to see > that her fix actually worked. And it did (STATSPACK install f'ed up a > couple dozen SYS packages)! I closed the TAR pleading that she forward my > comments to her super because this was the way a TAR should be handled. haa haa haa! :) When I reread the install docs, I did see something about how deinstall of Intersolve (ODBC drivers?) would sometimes mes stuff up. > > I guess I'm afraid to try for another TAR because I know it'll be back to > The Old Way of handling a TAR. ya. tease the larger/complex problem apart, and try simple combos of 2 of each of the "problem" components, and get TARs going for each? > > BTW, I've installed the 9i EE S/W in order to get the ONames Server and not > to run a DB. I also wanted the ability to build a quick test DB for OiD if > needed. ok. I sort of knew that, was just in such horror/shock/denial that my brain wouldn't allow recognition. :) I did read the whole section on networking in the Oracle9i/Windows 2000 book ( http://mhorder.com/oracle9i/0072194626.html ) yesterday. He doesn't address the specific problem, but there is excellent explanation of the underlying network architecture, and knowing that might help understand how to set up and go through trace logs during testing of various component combinations? regards, ep > > Thx! > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] 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: [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).
RE: Windohs client problems / (Fwd) RE: Reports 9i and Reports 6 on
also see: http://mhorder.com/oracle9i/0072194626.html --- Forwarded message follows --- Most of it was trial and error. Apparently, the old ORANT stuff(dev6) has to be in default_home. I ran into a lot of problems when that was not HOME0 in the registry. OEM was installed by default. I also discovered that oracle agent and oracleids agent can not run at the same time. Depending on what I am trying to do, I have to start and stop various jobs and http servers. This is my development box for trying out new things. I would not recommend this configuration for production. David Peck Baker Hughes Inc. BHBSS-BASIS (713) 625-6649 -Original Message- Sent: Wednesday, July 24, 2002 2:38 PM To: Peck, David; [EMAIL PROTECTED] On 24 Jul 2002 at 11:29, Peck, David wrote: > I have 9i r2 of the database, 9idw r2, dev 6i and discoverer 6i on the same > Win 2000 box. ok. >I have found that you should install the dev 6i first into > default_home. Is that documented, or did you determine that from trial-and-error, or hear about it from someone, or ?? >I created a separate home for the 9i database and a separate > home for 9ids. Did you patch everything? If so, did that go well? >Believe it or not, everything works! cool. there are people that will be interested in hearing this. Any chance that ODBC and/or OEM was in the mix? fwiw, on a Win2000 client machine, I had v7 client stuff installed (Y2K installer), then "mistakenly" installed a trial version of 9i db, uninstalled it (using the 9i OUI , v?), then installed client stuff from 8.1.7.x with the 8.1.7 OUI, and even with that mess, it still works. :) regards, ep > -Original Message- > Sent: Wednesday, July 24, 2002 1:49 PM > To: Multiple recipients of list ODTUG-DEV2K-L > > Hello List!! > Has any one tried installing Reports 9i along with 6i or 6 on the same > machine? > Do these two go together? Any input will be appreciated. ... -- Author: Peck, David INET: [EMAIL PROTECTED] ... --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] 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: [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).
RE: Windohs client problems
> -Original Message- > From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 24, 2002 1:07 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Windohs client problems > > > Dude, > > Tisk, tisk, sounds like you didn't read all 25,000 pages of > documentation before starting your install/deinstall/reinstall > hell. 25K pages is a lot of time in the bathroom... > VAX?! Well, the versions of early Oracle products were quite > simple back then, no? Installing Oracle stuff on Netware or > DOS/Windows back in the old days was pretty easy too. Nay, my good man. I stated "VMS", which != "VAX". One of our Oracle servers here is an Alpha running VMS (or "OpenVMS" as the marketing cronies call it). And my other workstation, also an OpenVMS/Alpha runs 9.0.1 quite happily. Oracle won't let me D/L 9iR2 for VMS yet (they say it's a space issue on OTN), but when I can, I'll install that for testing, too. Or I could just order it. (eh.) > The kind of complex combo you are attempting is probably > inherently going to be problematic, and I would definitely > have asked Oracle tech support about install sequence issues > (as well as the ODBC problems, etc.). My assumption is that > the earlier product(s) should be installed first, but that may > or may not be much of a factor. You've got a lot of stuff to > tease out to find the "real" problem. I would go through > separate clean installs of each pair of programs, looking for > glitches, then add anothe component, etc. Yeah, I know I need to place a TAR. But the last one I placed was a *dream*, thanks to Cathy@Oracle. Not only did she actually e-mail me directly (as opposed to only updating the TAR), but she even called to see that her fix actually worked. And it did (STATSPACK install f'ed up a couple dozen SYS packages)! I closed the TAR pleading that she forward my comments to her super because this was the way a TAR should be handled. I guess I'm afraid to try for another TAR because I know it'll be back to The Old Way of handling a TAR. BTW, I've installed the 9i EE S/W in order to get the ONames Server and not to run a DB. I also wanted the ability to build a quick test DB for OiD if needed. Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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).
RE: Windohs client problems
Just in case it might matter: Also note that the Oracle 8.1.7 install docs say under "Deinstalling with the OUI" that it is possible for the OUI inventory to get trashed, and OUI will be confused about what is and isn't installed. Not sure if that is the same for the 9.x OUI. regards, ep > (also see file:///E:/doc/Output/deinstal.htm#1088513 > "Deinstalling Oracle Components with Oracle Universal > Installer") ... > file:///E:/doc/Output/deinstal.htm#1096331 > file:///E:/doc/Output/ch2.htm#1093249 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] 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: [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).
RE: Windohs client problems
the system variable path and modify the Path variable. > > Remove any Oracle entries from the path. For example, if JRE was > installed by Oracle, remove the %ORACLE_HOME%\BIN path and the JRE > path. You may see a path similar to this one: > > C:\ORACLE\ORA81\BIN;G:\PROGRAM FILES\ORACLE\JRE\1.1.7\BIN > > Exit the Control Panel. > > Go to SYSTEM_DRIVE:\WINNT\PROFILES\ALL USERS\START MENU\PROGRAMS. > > Delete the following icons: > > Oracle - HOME_NAME > > Oracle Installation Products > > where HOME_NAME is the previous Oracle home name. > > Delete SYSTEM_DRIVE:\Program Files\Oracle through Windows NT Explorer. > > Delete all ORACLE_BASE directories on your hard drive. > > Reboot your computer. ---end--- Don't know if the following 8.1.7 instructions are relevant to a co-install with 9.x stuff, but check it out: ---begin--- file:///E:/doc/Output/ch2.htm#1093249 > Single Oracle Home Components > Most Oracle components can be installed multiple times on the same computer. >However, the following components can only be installed once per > computer: > > Oracle Performance Monitor for Windows NT > > Oracle Objects for OLE > > Oracle Open Database Connectivity (ODBC) Driver > > Oracle Provider for OLE DB > > Oracle SNMP Agent > > If you attempt to install these components a second time, Oracle > Universal Installer detects that these products are already installed > in another Oracle home and automatically removes them from the > installation process without prompting you. The following information > is logged to the INSTALLACTIONS.LOG file in the X:\PROGRAM > FILES\ORACLE\INVENTORY\LOGS directory. > > # product_name is a single oracle home product. It is already > installed in currently_installed_location. > > > If you are performing an installation and notice that one or more > single Oracle home components are not available for installation > during the current session, check to see if any of these components or > any previous versions of these components are installed in another > Oracle home. If you want to install these in the currently selected > Oracle home, you must first deinstall the conflicting version(s). > > See Also: > Appendix A, "Individual Components Available for Installation" for the installation >types under which these components are installed. > > ---end--- On 24 Jul 2002 at 6:38, Jesse, Rich wrote: Date sent: Wed, 24 Jul 2002 06:38:29 -0800 To: Multiple recipients of list ORACLE-L Send reply to: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California > > From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] > > 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.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 i
RE: Windohs client problems
> From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] > 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.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.! 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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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).
RE: Windohs client problems
BTW, 9iAS is not required for OWB. I'm running it on a 9.0.1 database with no 9iAS. You lose a couple of features, but nothing major. Beth -Original Message- Sent: Wednesday, July 24, 2002 5:58 AM To: Multiple recipients of list ORACLE-L 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? backups? On 23 Jul 2002 at 13:34, Jesse, Rich wrote: > OK, my hair is thinning fast enough without this. On WinTuke SP2, I've got > a 9.0.1 full install of EE. I also have an install of the 8.1.7 client in a > second ORACLE_HOME. > > I've been using this setup fine and well until I installed Oracle Warehouse > Builder into a separate ORACLE_HOME, then de-installed it after finding out > it needs 9iAS. Then Quest products started flaking out, so Quest had me > fiddle with the "LAST_HOME" registry entry. After that, the Microslop ODBC > for Oracle driver fails to find the Oracle driver, stating: > > [Microsoft][ODBC Driver Manager] The driver doesn't support the version of > ODBC behavior that the application requested (see SQLSetEnvAttr) > > And now, after uninstalling the 8.1.7 client, cleaning the registry, > reinstalling and rebooting, I can only connect *HALF OF THE TIME* using 9i. > The other half I get a TNS-12154, net name not found error. I'm using > ONames for names resolution, but I don't understand what the hell is going > on here. And seeing that it'll take me days to uninstall, reinstall, and > reconfig I'd just as soon not do it. > > Anyone else have to deal with this hoo-ha that has a solution? > > I'd rather be at home diazinoning earwigs... > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > 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: [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.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] 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: [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.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] 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: [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).
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? backups? On 23 Jul 2002 at 13:34, Jesse, Rich wrote: > OK, my hair is thinning fast enough without this. On WinTuke SP2, I've got > a 9.0.1 full install of EE. I also have an install of the 8.1.7 client in a > second ORACLE_HOME. > > I've been using this setup fine and well until I installed Oracle Warehouse > Builder into a separate ORACLE_HOME, then de-installed it after finding out > it needs 9iAS. Then Quest products started flaking out, so Quest had me > fiddle with the "LAST_HOME" registry entry. After that, the Microslop ODBC > for Oracle driver fails to find the Oracle driver, stating: > > [Microsoft][ODBC Driver Manager] The driver doesn't support the version of > ODBC behavior that the application requested (see SQLSetEnvAttr) > > And now, after uninstalling the 8.1.7 client, cleaning the registry, > reinstalling and rebooting, I can only connect *HALF OF THE TIME* using 9i. > The other half I get a TNS-12154, net name not found error. I'm using > ONames for names resolution, but I don't understand what the hell is going > on here. And seeing that it'll take me days to uninstall, reinstall, and > reconfig I'd just as soon not do it. > > Anyone else have to deal with this hoo-ha that has a solution? > > I'd rather be at home diazinoning earwigs... > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > 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: [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.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] 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: [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).
