| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 2 Instances of Personal Oracle?
Hi Folks,
I have Personal Oracle 8 running on Windows98
and was wondering if it is possible to have
2 instances on the same machine.
(could I "clone" my existing db on the machine
and rename it for instance??)
Any help appreciated.
Thanks!
David L. Ledford, Jr.
Data Management Consultant
Analytika - A Division of Dendrite International
"Extracting Value From Data"
Phone (919) 549-0270 EXT. 286
Fax (919) 549-0271
From: Norwood Bradly A <Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV>
Date: Thu, 25 May 2000 12:53:47 -0400
Subject: RE: Re[4]: Big Whoops
In 13 years of DBA work, the event has never ruined my day and I think it is due to paranoia...I am always concerned about the current sid to the point of checking it too frequently during crucial activities.
I also look both ways on a one-way street.
Perhaps, there is a third type of DBA: the Paranoiac!
-----Original Message-----
From: Robert Eskridge [mailto:bryny_at_dfweahs.net]
Sent: Thursday, May 25, 2000 12:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re[4]: Big Whoops
Steve,
Thursday, May 25, 2000, 10:38:38 AM, you wrote:
S> I'd like to post a question for everyone on the list.
S> How many of you have ever dropped a table, or done something like that in
S> the wrong database(thinking you were connected to say the test DB), and S> hosed production?
I'm guessing there are two types of DBA's, those who have done something like this and those who don't administer production databases.
I'd had a pretty good streak going, about 9 years since my last production trash when I slipped in late December.
We had about a dozen databases both production and test that we were re-arranging on various machines and storage devices in order to move equipment to a co-location. I was supposed to be copying the datafiles for a test instance but was in a sub-directory shallower than where the script I intended to run was, I'd forgotten that I'd modified my path in that session and wound up running the script set up for a production one. I didn't realize it for about 5 minutes by which time my system tablespace had been trashed. Unfortunately our standby database had been taken down to free equipment for the move. <sigh>
Of course the moral was, "Explicitly include the SID in the name of dangerous scripts and never put them on your path."
It didn't take too long to restore from snapshot and apply the archive logs, but it sure was embarrassing. It did give me an opportunity to turn to one of the junior DBA's that had trashed production on 9/1/97 and say, "See, I wasn't lying when I said it happens to everyone."
-rje
-- Author: Robert Eskridge INET: bryny_at_dfweahs.net 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-LReceived on Thu May 25 2000 - 11:44:24 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). ------------------------------ From: "Shockey, David" <DShockey_at_jwrinc.com> Date: Thu, 25 May 2000 11:52:04 -0500 Subject: RE: Developer 2000 upgrade for 300+ Clients This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFC66B.2CBF9D7E Content-Type: text/plain; charset="iso-8859-1" Hmmm. Maybe our installations are simpler than yours but the only problem we've had with WinInstall was in installing some VB applications. It missed some ODBC driver settings. Once we figured it out the fix was simple... install the ODBC drivers separately. So far, all of our Oracle updates have gone without a hitch. -----Original Message----- From: Steve Boyd [mailto:pimaco_oracle_at_hotmail.com] Sent: Thursday, May 25, 2000 11:15 AM To: Multiple recipients of list ORACLE-L Subject: RE: Developer 2000 upgrade for 300+ Clients Yeah, winistall works great... It overwrites everything. Oracle has the registry set up to store different oracle homes whenever you install a new version, and wininstall will just overwrite all this. If you create the wininstall package on a machine that has nothing on it, it will just throw stuff into the first oracle home "HOME0", and hose you up good. Oh, and don't even think about uninstalling with it. It will remove dll's that are needed by other programs simply because the dll was included in the install package. Yes, I love wininstall. >From: "Shockey, David" <DShockey_at_jwrinc.com> >Reply-To: ORACLE-L_at_fatcity.com >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> >Subject: RE: Developer 2000 upgrade for 300+ Clients >Date: Thu, 25 May 2000 07:18:26 -0800 > >Four words: WinInstall, off hours installation. Even if there are no off >hours and you are stuck with touching each machine, you can use WinInstall >to simplify the installation process. The downside is that it takes some >work to get WinInstall set up correctly. Once done, it is well worth the >effort. > >-----Original Message----- >Sent: Wednesday, May 24, 2000 7:57 PM >To: Multiple recipients of list ORACLE-L > > >Hi Gurus, > >I have tremendous task of upgrading 300-400 clients Running Developer2000 >Ver2.0 to Developer2000 Ver2.1, and then apply a patch to make them up to >current level. > >I am trying to find out easy/better way of doing this. > >Here is some info on the clients >1) All of them are on a LAN >2) 95% of them run Windows 95. >3) Network Install is not an option as management is worried about network >load. >4) All these clients should have only Runtime version of developer2000 ( I >mean no Forms Builder, no Report Builder no Builders ) > >My biggest concern is, if we have to do it manually, a lot of time will be >spent on selecting multiple pieces in Installer asset manager window. So is >there any way to reduce the number of steps involved. > > >Any info, suggestions, pointers would save us hours of work > >TAI >Deen > >-- >Author: Dayal, Deen > INET: DDayal_at_dolsun.dol.state.nj.us > >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). ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Author: Steve Boyd INET: pimaco_oracle_at_hotmail.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). ------_=_NextPart_001_01BFC66B.2CBF9D7E Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: Developer 2000 upgrade for 300+ Clients</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Hmmm. Maybe our installations are simpler than = yours but the only problem we've had with WinInstall was in installing = some VB applications. It missed some ODBC driver settings. = Once we figured it out the fix was simple... install the ODBC drivers = separately. So far, all of our Oracle updates have gone without a = hitch. </FONT></P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Steve Boyd [<A = HREF=3D"mailto:pimaco_oracle_at_hotmail.com">mailto:pimaco_oracle_at_hotmail.c= om</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, May 25, 2000 11:15 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: Developer 2000 upgrade for 300+ = Clients</FONT> </P> <BR> <P><FONT SIZE=3D2>Yeah, winistall works great...</FONT> </P> <P><FONT SIZE=3D2>It overwrites everything. Oracle has the = registry set up to store different </FONT> <BR><FONT SIZE=3D2>oracle homes whenever you install a new version, and = wininstall will just </FONT> <BR><FONT SIZE=3D2>overwrite all this. If you create the = wininstall package on a machine that </FONT> <BR><FONT SIZE=3D2>has nothing on it, it will just throw stuff into the = first oracle home </FONT> <BR><FONT SIZE=3D2>"HOME0", and hose you up good.</FONT> </P> <P><FONT SIZE=3D2>Oh, and don't even think about uninstalling with = it. It will remove dll's </FONT> <BR><FONT SIZE=3D2>that are needed by other programs simply because the = dll was included in the </FONT> <BR><FONT SIZE=3D2>install package.</FONT> </P> <P><FONT SIZE=3D2>Yes, I love wininstall.</FONT> </P> <BR> <P><FONT SIZE=3D2>>From: "Shockey, David" = <DShockey_at_jwrinc.com></FONT> <BR><FONT SIZE=3D2>>Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=3D2>>To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>>Subject: RE: Developer 2000 upgrade for 300+ = Clients</FONT> <BR><FONT SIZE=3D2>>Date: Thu, 25 May 2000 07:18:26 -0800</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Four words: WinInstall, off hours = installation. Even if there are no off</FONT> <BR><FONT SIZE=3D2>>hours and you are stuck with touching each = machine, you can use WinInstall</FONT> <BR><FONT SIZE=3D2>>to simplify the installation process. The = downside is that it takes some</FONT> <BR><FONT SIZE=3D2>>work to get WinInstall set up correctly. = Once done, it is well worth the</FONT> <BR><FONT SIZE=3D2>>effort.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>>Sent: Wednesday, May 24, 2000 7:57 PM</FONT> <BR><FONT SIZE=3D2>>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Hi Gurus,</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>I have tremendous task of upgrading 300-400 = clients Running Developer2000</FONT> <BR><FONT SIZE=3D2>>Ver2.0 to Developer2000 Ver2.1, and then apply a = patch to make them up to</FONT> <BR><FONT SIZE=3D2>>current level.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>I am trying to find out easy/better way of doing = this.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Here is some info on the clients</FONT> <BR><FONT SIZE=3D2>>1) All of them are on a LAN</FONT> <BR><FONT SIZE=3D2>>2) 95% of them run Windows 95.</FONT> <BR><FONT SIZE=3D2>>3) Network Install is not an option as = management is worried about network</FONT> <BR><FONT SIZE=3D2>>load.</FONT> <BR><FONT SIZE=3D2>>4) All these clients should have only Runtime = version of developer2000 ( I</FONT> <BR><FONT SIZE=3D2>>mean no Forms Builder, no Report Builder = no Builders )</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>My biggest concern is, if we have to do it = manually, a lot of time will be</FONT> <BR><FONT SIZE=3D2>>spent on selecting multiple pieces in Installer = asset manager window. So is</FONT> <BR><FONT SIZE=3D2>>there any way to reduce the number of steps = involved.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Any info, suggestions, pointers would save us = hours of work</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>TAI</FONT> <BR><FONT SIZE=3D2>>Deen</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>--</FONT> <BR><FONT SIZE=3D2>>Author: Dayal, Deen</FONT> <BR><FONT SIZE=3D2>> INET: = DDayal_at_dolsun.dol.state.nj.us</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Fat City Network Services -- =
(858) 538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>>-----------------------------------------------------------= ---------</FONT> <BR><FONT SIZE=3D2>>To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>>the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>>(or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>>also send the HELP command for other information =
(like subscribing).</FONT>
</P> <P><FONT = SIZE=3D2>_______________________________________________________________= _________</FONT> <BR><FONT SIZE=3D2>Get Your Private, Free E-mail from MSN Hotmail at <A = HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Steve Boyd</FONT> <BR><FONT SIZE=3D2> INET: pimaco_oracle_at_hotmail.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information =
 |
 |