Question Re: change SID in Technology Q&A

change SID

Former Member — Mon, 01 Oct 2007 10:13:44 GMT

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

Re: change SID

markus_doehr2 — Mon, 01 Oct 2007 10:53:23 GMT

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

http://service.sap.com/systemcopy

Markus

Re: change SID

Former Member — Mon, 01 Oct 2007 12:31:04 GMT

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

Re: change SID

markus_doehr2 — Mon, 01 Oct 2007 13:40:09 GMT

A system copy is not "manually"?

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

Markus

Re: change SID

Former Member — Tue, 02 Oct 2007 02:09:36 GMT

Hi Fitto,

If you want to change the SID of the database and you are using Oracle 9.2 and above, oracle provides NID (new database id) utility. If you have access to metalink, read note: 224266.1. Not sure if SAP supports this though, but this is the same procedure we perform during test refresh.

Cheers,

Nisch

Re: change SID

Former Member — Tue, 02 Oct 2007 08:16:04 GMT

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

Re: change SID

markus_doehr2 — Tue, 02 Oct 2007 08:43:12 GMT

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

Re: change SID

Former Member — Tue, 02 Oct 2007 09:55:13 GMT

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

Re: change SID

Former Member — Tue, 09 Oct 2007 11:35:05 GMT

hi everyone,

the managers of my company wan´t to do it because is´nt critical and they prefer wait.

regards for everyone and if we will doing in a future i post and comment....