Changing the SID for existing SAP systems

[Former Member]

Hi All,

I need to change the SID of the development and quality system without making a system copy.

The requirement is on strict timeline basis so I need to find out an alternate way to do it. A system copy will need a lot more time to do the same which is the last option at this time.

Please suggest.

Relevant answers will be rewarded accordingly.

Regards,

Himansu Roy

[Former Member · Accepted solution]

If you migarate the oracle db by copy the datafiles from product system to dev system, you can change the sid by following :

-- Develop system sid: DSD

Product system sid: DSP

The hostname of develop server is: DSDSER

The hostname of product server is: DSPSER

--- After you migration the DSP db to DSD db

- OPS$DSDADM User Creation

SQL> create user ops$dsdadm default tablespace psapuserd temporary tablespace psaptemp

identified externally;

SQL> grant connect, resource to ops$dsdadm;

SQL> create table ops$dsdadm.sapuser

(userid varchar2(255), passwd varchar2(255));

SQL> insert into op$dsdadm.sapuser values ( 'SAPR3','newpasswd');

. check the initDSD.ora parameter

remote_os_authent = true

- Update Instvers table

UNIX> sqlplus sapr3/<psaaword>

SQL> update instvers set sapsid='DSD' where sapsid = 'DSP';

SQL> update instvers set hostname='DSDSER' where hostname='DSPSER';

SQL> update instvers set dbhostname ='DSDSER' where dbhostname ='DSPSER';

[markus_doehr2]

I need to change the SID of the development and quality system without making a system copy.

You can do the system copy using backup/restore. There is no other way supported way of doing it. Fiddling manually at dozen (undocumented) places won´t be faster.

Markus