The instance name is established in the tnsnames.ora generated by the =
EASYCFG program. In that file the instance name points to the database =
name, ip address, and port. Be sure to change the tnsnames on the client =
and the ODBC as well to reflect the changes.
ROR
>>> ddorr.cs_at_clearstream.com 08/23/00 10:57AM >>>
The initial request was " how do I change the instance name", which has
nothing to do, neither with the database name, nor with the global_name.
> ----------
> From: james ellis[SMTP:jellis24_gso_at_yahoo.com]=20
> Reply To: ORACLE-L_at_fatcity.com=20
> Sent: Wednesday, August 23, 2000 16:13
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Renaming Oracle Instance
>=20
> Don't forget to change the global_name as well.=20
> --- Philip West <P.West_at_g-icap.com> wrote:
> > You must change the line which starts=20
> > CREATE CONTROLFILE REUSE DATABASE "OLDNAME"
> > NORESTLOGS...........
> >=20
> > to read
> >=20
> > CREATE CONTROLFILE SET DATABASE "NEWNAME"
> > RESETLOGS............
> >=20
> > Phil West - Impex IT ltd
> > Unix Sys Admin and Oracle Financials DBA Services
> >=20
> > all opinions are worth [at most] what you paid for
> > them
> >=20
> >=20
> >=20
> > -----Original Message-----
> > Sent: 23 August 2000 10:46
> > To: Multiple recipients of list ORACLE-L
> >=20
> >=20
> > Hi
> > Take a backup of the database.
> > Alter database backup controlfile to trace;
> > Edit the trace file.
> > change ORCL to ORA8.
> > change noresetlogs to resetlogs
> > Change your init file from initorcl.ora to
> > initora8.ora.
> > Change paramter db_name =3D ORA8
> > Change the control file names.
> > Shutdown the database and startup with nomount
> > Run the trace file
> > Alter database open
> >=20
> > Follow the above steps. U can rename the database as
> > per ur requirement.
> >=20
> >=20
> > Thanks & Regards
> > ----------------------------
> > Ram
> > Tel:4236953
> >=20
> >=20
> > ---------------------------------------- Message
> > History
> > ----------------------------------------
> >=20
> >=20
> >=20
> > Please respond to ORACLE-L_at_fatcity.com=20
> >=20
> > To: ORACLE-L_at_fatcity.com=20
> > cc:
> >=20
> >=20
> >=20
> > Hi All
> >=20
> > How to rename an Oracle Instance , Currently my
> > Oracle instance is ORCL ,
> > Now i want to change it as ORA8.
> >=20
> > Regards
> > Magesh
> >=20
> >=20
> >=20
> >
> *************************************************************************=
*
> *****
> > The information in this Internet e-mail is
> > confidential and may be legally privileged. It is
> > intended solely for the addressee. Access to this
> > Internet e-mail by anyone else is unauthorised and
> > any disclosure, copying, distribution or any action
> > taken or omitted to be taken in reliance on it, is
> > prohibited and may be unlawful.=20
> > When addressed to our clients any opinions or
> > advice contained in this Internet e-mail are subject
> > to the terms and conditions expressed in any
> > applicable documentation or market practices
> > governing the relationship between Garban
> > Intercapital plc and its clients.
> >=20
> > Any views expressed in this message are those of the
> > individual sender except where they are stated to be
> > the views of Garban Intercapital plc.
> >
> *************************************************************************=
*
> *****
> > --=20
> > Author: Philip West
> > INET: P.West_at_g-icap.com=20
> >=20
> > 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).
>=20
>=20
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/=20
> --=20
> Author: james ellis
> INET: jellis24_gso_at_yahoo.com=20
>=20
> 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).
>=20
--=20
Author:=20
INET: ddorr.cs_at_clearstream.com=20
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
Received on Wed Aug 23 2000 - 10:39:42 CDT
