change SID

[Former Member]

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

[Former Member]

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....

[Former Member]

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

[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