Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_mediaone.net
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_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> </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> 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> </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_at_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_at_fatcity.com=20
[mailto:root_at_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> </DIV> <DIV><FONT face=3DArial size=3D2>A couple of questions :</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>I have a 8.1.5 installation on NT and =a DataBase=20
<DIV> </DIV> <DIV><FONT face=3DArial size=3D2>The questions are : </FONT></DIV> <DIV><FONT face=3DArial size=3D2> How do i change the =ORACLE_HOME ?=20
![]() |
![]() |