how to change sid of QAS server

[Former Member]

Hi,

we are using sap ecc6 wih sun solaris as os and oracle as database .our QAS sever and PRD server has same sid.now we want to change sid of QAS server without reinstalling sap.kindly suggest me how to do it.

Regards

Pranav

[markus_doehr2 · Accepted solution]

Do a system copy (backup/restore) of the QAS system according to

http://service.sap.com/systemcopy

Markus

[Former Member]

Hi Pranav,

In your case, I will go for change of DB sid by recreating control file and reinstall Central instance with new SID which will take less time rather than system copy.

Thanks,

Kiran.

[Former Member]

Hi Kiran,

Can u provide me steps for change of DB sid by recreating control file and reinstall Central instance with new SID.

[Former Member]

Hi Pranav

why the SIDs of production and QAS are same, did you do refresh of QAS from PRD ?

If yes, then you should have done control file creation and change of SIDs, after the datbase restore...

however, if you want to create the new control file and change the SID then try to consider the following steps:

1. Login as orasid

2. connect to sqlplus

3. run query: alter database PRD backup controlfile to trace;

4. It will create a control file as a latest trace file (.trc) in the directory /oracle/PRD/saptrace/usertrace

note: logout of sqlplus

5. Rename that .trc file into ldQAS.sql

6. copy this file into /oracle/SID ie. /oracle/QAS directory

7. edit the .sql file as below

8. CREATE CONTROLFILE SET DATABASE u201CQASu201D RESETLOGS ARCHIVELOGS;

add above statement replacing the below:

CREATE CONTROLFILE REUSE DATABASE u201CQASu201D NORESETLOGS ARCHIVELOGS;

9. Replace all occurences of string <PRD_SAPsid> by <QAS_SAPsid> in each line where <source_SAPsid> appears

:g/PRD/s/PRD/QAS/g

10. login in sqlplus, stop database

11. as oraqas, delete old control files:

rm /oracle/SID/sapdata1/system_1/cntrl/*

rm /oracle/sid/saparch/cntrl/*

rm /oracle/SID/origlogA/cntrl/*

12. again login into sqlplus (as sysdba always)

13. run this .sql : @ldQAS.sql

note: it should give a message that control file creaated.

14. Open the database using: alter database open resetlogs;

15. alter database rename global_name to QAS.WORLD;

16. drop user OPS$PRDADM cascade;

17. drop user OPS$ORAPRD;

18. create user OPS$ORAQAS identified externally default tablespace <tablespacename>

temporary tablespace psaptemp;

19. grant connect, unlimited tablespace, SAPDBA to OPS$ORAQAS;

grant connect, unlimited tablespace, SAPDBA to OPS$QASADM;

*********

at SAP level:

1. you can run BDLS to convert logicalsystems from PRD to QAS SID

Bhudev

[Former Member]

Hi Bhudev,

Thnx for response,

Actually my Quality and Production system has same sid so i cannot include my Quality system into System Landscape so i need to change the sid of quality server now.can you kindly provide me the step by step procedure to do it.

Regards,

Pranav