Database Adının değiştirilmesi

Database Adının değiştirilmesi

1. Database kapatılır ve mount modda açılır.
shutdown immediate;
startup mount;


2. export $ORACLE_SID=new_db_name olmalıdır

3. nid target=/ dbname=new_db_name

DBNEWID: Release 10.2.0.4.0 - Production on Wed Aug 13 17:20:55 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Database name changed to PROVKURS.
Modify parameter file and generate a new password file before restarting.
Database ID for database PROVKURS changed to 3460159672.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.

4. initnew_db_name.ora dosyasında

db_name= 'new_db_name' yapılır

tnsnames.ora gerekirse değiştirilir.


5. spfile yaratılıp database open resetlog ile açılır.

sqlplus "/ as sysdba"

create spfile from pfile;

startup mount;

alter database open resetlogs;

startup force;