change sid name

Below test changed sid from old sid SPTR to new sid cloudapp

1. shutdown instance

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production


SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
SPTR

SQL> shutdown immediate;

2. export new sid

[oracle@sptr ~]$ export ORACLE_SID=cloudapp

3. modify /etc/oratab

[oracle@sptr ~]$ vi /etc/oratab
SPTR:/u01/sptrprd1/app/oracle/product/11.2.0.4/dbhome_1:N
=>
cloudapp:/u01/sptrprd1/app/oracle/product/11.2.0.4/dbhome_1:N

4. under $ORACLE_HOME/dbs, change all file names containing SPTR to cloudap

[oracle@sptr ~]$ cd $ORACLE_HOME/dbs

[oracle@sptr dbs]$ ls -ltr | grep -i sptr
-rw-r----- 1 oracle oinstall      24 Oct  5 11:30 lkSPTR
-rw-r--r-- 1 oracle oinstall    1641 Nov  5 00:36 initSPTR.ora
-rw-r----- 1 oracle oinstall    1536 Dec 14 00:28 orapwSPTR
-rw-r----- 1 oracle oinstall    3584 Dec 28 16:14 spfileSPTR.ora
-rw-r----- 1 oracle oinstall 9879552 Dec 28 21:03 snapcf_SPTR.f
-rw-rw---- 1 oracle oinstall    1544 Dec 28 21:09 hc_SPTR.dat
[oracle@sptr dbs]$ cp lkSPTR lkcloudapp
[oracle@sptr dbs]$ cp initSPTR.ora initcloudapp.ora
[oracle@sptr dbs]$ cp orapwSPTR orapwcloudapp
[oracle@sptr dbs]$ cp spfileSPTR.ora spfilecloudapp.ora
[oracle@sptr dbs]$ cp snapcf_SPTR.f snapcf_cloudapp.f
[oracle@sptr dbs]$ cp hc_SPTR.dat hc_cloudapp.dat

5. startup instance and verify result

[oracle@sptr dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Dec 28 21:15:45 2014

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size 2257840 bytes
Variable Size 541068368 bytes
Database Buffers          289406976 bytes
Redo Buffers                2371584 bytes
Database mounted.
Database opened.
SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
cloudapp