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

[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