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).
Received on Wed Aug 23 2000 - 07:50:45 CDT
