change SID

[#1]

hi everyone,

We need a procedure to change SID of a CRM system. We want to known the steps to make it. We have a solaris system with an oracle database.

thanks in advance.

Fitto

[markus_doehr2]

You need to backup the system and reinstall - as homogeneous system copy.

http://service.sap.com/systemcopy

--

Markus

[Former Member]

hi Markus!

we need to make it manually,is there any procedure? what can i do it?

i know that i must rename the filesystems, touch the profiles,..

best regards

Fitto

[markus_doehr2]

A system copy is not "manually"?

You wanna change just the SID or also the database name?

--

Markus

[Former Member]

Hi Markus,

When i said manually i refer without system copy because we have no disk space to make it.

We want to change only the SAP SID.

Thanks in advance,

Fitto

[markus_doehr2]

What comes to my mind is:

- new user (adm) must be created

- owner of all files must be changed

- profile changes (instance- and startprofiles)

- OPS$-user must be adapted

- if you use logon groups you need to change the backend R/3 system too

I´d be though very careful, I suggest opening an OSS call asking if this is supported in a CRM system. We had pretty much trouble with qRFC since all the queues have the SID as name in them and they may stop processing.

--

Markus

[Former Member]

Hello,

First of all, you need to make a full offline backup of your system (DB + FS).

As oraSID, start sqlplus session

SQL> alter database backup controlfile to trace;

This command will generate a trace file (available in /oracle/SID/saptrace/usertrace) which will contain a script to recreate you database controlfile.

Edit this script, keep the part ARCHIVELOG or NOARCHIVELOG, replace every old-SID with new-SID.

Save the script as cntrlfileSID.sql

Shutdown SAP and oracle.

Umount all SID-name-related filesystems, change them and re-mount everything.

(You can also use soft-links to gain time)

Change user SIDadm and oraSID (user name, groups, limits, environment profile).

Change SAP profile files in /sapmnt/SID/profile.

Modify the soft links in /usr/sap/SID/SYS ...

You will need to relink all oracle software (as oraSID)

As oraSID recreate your controlfile with the script cntrlfileSID.sql

=>use the resetlogs option to open you DB

Check oracle is OK

Modify you OPS$ users

This should work for an ABAP standalone system.

Good luck

Message was edited by:

Alluin Antoine