Monday 28 January 2013

Changing SID of SAP system



First Stop SAP - stopsap R3
DB Changes:-
Step 1:- Backup Control File to trace.
>sqlplus /nolog
>conn / as sysdba;
>connected;
>Alter database backup controlfile to trace;
Control file trace will get created at the follwoing location:-
/oracle/ALD/saptrace/usertrace
Step 2:- Switch log files 4 times
     
 Alter system switch logfile;
Step 3a:- Shutdown database.
        shutdown immediate;
Step 3b :- Stop Listener - #lnsrctl stop
Step 4:- Copy the trace file to transfer location

Step 5:- Change the file system locations.
/oracle/ALD/sapdata1 to /oracle/ED1/sapdata1
/oracle/ALD/saptemp1 to /oracle/ED1/saptemp1
/oracle/ALD/oraarch to /oracle/ED1/oraarch
/oracle/ALD/origlogA to /oracle/ED1/origlogA
/oracle/ALD/origlogB to /oracle/ED1/origlogB
(Create ticket with linux only for the above file system mount point
& same ticket ask linux colleague to create 2 users oraed1 & ed1adm
same like oraald & aldadm with same group & permission)

As ALD is the directory inside mount point /oracle we do not need to change
mount point just change the directory to new SID name.
As /usr/sap/ALD is the directory inside mount point /usr/sap we do not need to change
mount point just change the directory to new SID name.
As ALD is the directory inside mount point /sapmnt we do not need to change
mount point just change the directory to new SID name.

Step 6a:- Make the changes in the trace file to create a new control file.
      change SID to New ED1 and save with .sql
step 6b : change the line "CREATE CONTROLFILE REUSE DATABASE "ED1" RESETLOGS  ARCHIVELOG" to "CREATE CONTROLFILE SET DATABASE "ED1" RESETLOGS  ARCHIVELOG" in the .sql file

Step 7:- Change the entries for listener.ora and tnsnames.ora with new SID.
/oracle/ALD/102_64/network/admin
Step 8:- Start listener.
listener start
Step 9:- Change init<SID>.ora file with new SID and make changes of SID and control file location in the init<SID> file.
Step 10 - check and change the env variable files sapenv_<hostname>.csh and dbenv_<hostname>.csh of ora<SID> and <SID>adm
   
Step 10:- login with oraed1.
>sqlplus /nolog
>conn / as sysdba;
>@/<New Control file location>/controlfile.sql
>ALTER DATABASE OPEN RESETLOGS;
R/3 Changes:-
Step 1: Login with  <SID>sdm and check R3trans -d and correct it, if ends withRC other than 0000.
Step 2:- Make the folder change
Step 2a - check the links for profile,global and exe directory , and correct it if needed
Step 3:- Profile changes
Change profile ALD_DVEBMGS00_keylabs to ED1_DVEBMGS00_keylabs Make SID changes inside all 3 profiles.
step 4 : Changes sapms<SID> sntries in etc/hosts and etc/services file
Step : Start SAP


Above steps are for Linux platform with Oracle
Source http://ilovebasis.blogspot.in/2012/01/procedure-for-changing-sid-of-sap.html

I am trying to do in Windows with SQL DBA lets see and will post all the steps later post.



No comments:

Post a Comment

Note: only a member of this blog may post a comment.