Change Instance name

How to change instance_name;

　

1. Create PFILE from spfile

2. shutdown immediate

3. Copy PFILE to initNew_Instance_Name.ora

dbs]$ cp -R initHRISD.ora initTJTGHRP.ora

　

　

4. ORACLE_SID=New_Instance_Name export ORACLE_SID=HRIST; echo $ORACLE_SID

startup nomount pfile='/GSTDB/orahris/product/11.2.0/dbhome_1/dbs/initTJTGHRP.ora';

　

　

5. sqlplus / as sysdba

6. startup PFILE=/oracle/product/10.2/dbs/initNew_Instance_Name.ora

startup nomount pfile='/GSTDB/orahris/product/11.2.0/dbhome_1/dbs/initHRIST.ora';

　

　

7. select * from v$instance

8. create spfile from pfile

9. shutdown

10. startup

　

　

select instance_name from v$instance;