Message-Id: <10504.106168@fatcity.com>
From: "Maheshwara Rao, L., Teki" <teki01@mediaone.net>
Date: Sun, 21 May 2000 09:23:59 -0400
Subject: RE: Installation issues on WinNT 

This is a multi-part message in MIME format.

------=_NextPart_000_0006_01BFC306.4B9C0740
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

To Change Oracle SID on NT -- STEPS.

Go to MS DOS Prompt. Give
 Set Oracle_SID=your sid (Example: Set Oracle_SID = ORCL8).

Now, go to svrmgr30 and connect internal.
Issue the following command.
Select name from v$database.
You should see the name of your desired database.
Now, you can perform what you want.
Maheshwara Rao, L., Teki
E Mail : teki01@mediaone.net

  -----Original Message-----
  From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Andrey
Bronfin
  Sent: Sunday, May 21, 2000 9:24 AM
  To: Multiple recipients of list ORACLE-L
  Subject: Installation issues on WinNT


  Dear DBAs !

  A couple of questions :

  I have a 8.1.5 installation on NT and a DataBase called ORA1 .
  I want to install 8.1.6 as well on the same server .

  The questions are :
     How do i change the ORACLE_HOME ?
     Can i operate the "old" ORA1 just using the 8.1.6 software ?

  I also want to create a different DB . How do i change the ORACLE_SID ?

  Many thanks in advance !



------=_NextPart_000_0006_01BFC306.4B9C0740
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3017.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D450292013-21052000>To=20
Change Oracle SID on NT -- STEPS.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D450292013-21052000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D450292013-21052000>Go to=20
MS DOS Prompt. Give</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D450292013-21052000>&nbsp;Set Oracle_SID=3Dyour sid (Example: Set =
Oracle_SID=20
=3D ORCL8).</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D450292013-21052000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D450292013-21052000>Now,=20
go to svrmgr30 and connect internal. </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D450292013-21052000>Issue=20
the following command.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D450292013-21052000>Select=20
name from v$database.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D450292013-21052000>You=20
should see the name of your desired database.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D450292013-21052000>Now,=20
you can perform what you want.</SPAN></FONT></DIV>
<P><FONT size=3D2>Maheshwara Rao, L., Teki<BR>E Mail : =
teki01@mediaone.net=20
</FONT></P>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root@fatcity.com=20
  [mailto:root@fatcity.com]<B>On Behalf Of </B>Andrey =
Bronfin<BR><B>Sent:</B>=20
  Sunday, May 21, 2000 9:24 AM<BR><B>To:</B> Multiple recipients of list =

  ORACLE-L<BR><B>Subject:</B> Installation issues on WinNT =
<BR><BR></DIV></FONT>
  <DIV><FONT face=3DArial size=3D2>Dear DBAs !</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>A couple of questions :</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>I have a 8.1.5 installation on NT and =
a DataBase=20
  called ORA1 .</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>I want to install 8.1.6 as well on =
the same=20
  server .</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>The questions are : </FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; How do i change the =
ORACLE_HOME ?=20
  </FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; Can i operate the "old" =
ORA1 just=20
  using the 8.1.6 software ?</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>I also want to create a different DB =
. How do i=20
  change the ORACLE_SID ?</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>Many thanks in advance !</FONT></DIV>