RE: Renaming Oracle Instance

From: Philip West <P.West_at_g-icap.com>
Date: Wed, 23 Aug 2000 10:05:08 +0100
Message-Id: <10598.115330@fatcity.com>

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-----
From: ramakrishna.gv_at_db.com [mailto:ramakrishna.gv_at_db.com] Sent: 23 August 2000 10:46
To: Multiple recipients of list ORACLE-L Subject: Re: Renaming Oracle Instance

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.

---

Received on Wed Aug 23 2000 - 04:05:08 CDT