Re: Renaming Oracle Instance

From: <ramakrishna.gv_at_db.com>
Date: Wed, 23 Aug 2000 14:13:40 +0530
Message-Id: <10598.115328@fatcity.com>

--0__=JXiNzfMEuJuYCM4bwGs1zQnNbBCEOkXzP9uprfLd7msh0znn7QGz3eBW
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

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 ----------------------------------------

From: magesh_at_garoo.ne.jp on 23/08/2000 07:04 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: Renaming Oracle Instance

Hi All

  How to rename an Oracle Instance , Currently my Oracle instance is ORCL , Now i want to change it as ORA8.

Regards
Magesh

--0__=JXiNzfMEuJuYCM4bwGs1zQnNbBCEOkXzP9uprfLd7msh0znn7QGz3eBW
Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWlz by0yMDIyLWpwIiBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZT4NCjxNRVRBIGNvbnRlbnQ9Ik1TSFRN TCA1LjAwLjI5MTkuNjMwNyIgbmFtZT1HRU5FUkFUT1I+DQo8U1RZTEU+PC9TVFlMRT4NCjwvSEVB RD4NCjxCT0RZIGJnQ29sb3I9I2ZmZmZmZj4NCjxESVY+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+ SGkgQWxsPC9GT05UPjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1B cmlhbCBzaXplPTI+Jm5ic3A7IEhvdyB0byByZW5hbWUmbmJzcDthbiAgT3JhY2xlIEluc3RhbmNl ICwgDQpDdXJyZW50bHkgbXkgT3JhY2xlIGluc3RhbmNlIGlzIE9SQ0wgLCBOb3cgaSB3YW50IHRv IGNoYW5nZSBpdCBhcyANCk9SQTguPC9GT05UPjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxE SVY+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+UmVnYXJkczwvRk9OVD48L0RJVj4NCjxESVY+PEZP TlQgZmFjZT1BcmlhbCBzaXplPTI+TWFnZXNoPC9GT05UPjwvRElWPjwvQk9EWT48L0hUTUw+DQo=

--0__=JXiNzfMEuJuYCM4bwGs1zQnNbBCEOkXzP9uprfLd7msh0znn7QGz3eBW--
Received on Wed Aug 23 2000 - 03:43:40 CDT