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]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, August 23, 2000 16:13
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Renaming Oracle Instance
>
> Don't forget to change the global_name as well.
> --- Philip West <P.West_at_g-icap.com> wrote:
> > You must change the line which starts
> > CREATE CONTROLFILE REUSE DATABASE "OLDNAME"
> > NORESTLOGS...........
> >
> > to read
> >
> > CREATE CONTROLFILE SET DATABASE "NEWNAME"
> > RESETLOGS............
> >
> > Phil West - Impex IT ltd
> > Unix Sys Admin and Oracle Financials DBA Services
> >
> > all opinions are worth [at most] what you paid for
> > them
> >
> >
> >
> > -----Original Message-----
> > Sent: 23 August 2000 10:46
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > 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 = ORA8
> > Change the control file names.
> > Shutdown the database and startup with nomount
> > Run the trace file
> > Alter database open
> >
> > Follow the above steps. U can rename the database as
> > per ur requirement.
> >
> >
> > Thanks & Regards
> > ----------------------------
> > Ram
> > Tel:4236953
> >
> >
> > ---------------------------------------- Message
> > History
> > ----------------------------------------
> >
> >
> >
> > Please respond to ORACLE-L_at_fatcity.com
> >
> > To: ORACLE-L_at_fatcity.com
> > cc:
> >
> >
> >
> > Hi All
> >
> > How to rename an Oracle Instance , Currently my
> > Oracle instance is ORCL ,
> > Now i want to change it as ORA8.
> >
> > Regards
> > Magesh
> >
> >
> >
> >
> **************************************************************************
> *****
> > 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.
> > 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.
> >
> > 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.
> >
> **************************************************************************
> *****
> > --
> > Author: Philip West
> > INET: P.West_at_g-icap.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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> --
> Author: james ellis
> INET: jellis24_gso_at_yahoo.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
Received on Wed Aug 23 2000 - 08:33:30 CDT
