Change System Id

[Former Member]

Dear All,

In test system the system id is TST.

In case of oracle we need to recreate controlfile

How to change SAP System ID TST?

Thanks in advance,

Nirav

[Former Member]

.

[Former Member]

Hi Nirav,

You need to change the SID in the following files:

1. In Controlfile as CREATE CONTROLFILE REUSE DATABASE <SSID> NORESETLOGS ARCHIVELOG;u201D as u201CCREATE CONTROLFILE RESUE SET DATABASE <TSID> RESETLOGS ARCHIVELOG;

2. At filesystem mount points.

3. in init<SID>.ora (you can use VI command as "%s/<SSID>/<TSID>/g"

4. in init<SID>.sap

5. in SAP Startup profiles (Default,Instance,Start) in /usr/sap/<SID>/SYS/profile)

6. In oracle database users (See the table entries of DBA_USERS)

7. In SAP configuration as suggested by Fan Yu

Regards.

Rajesh Narkhede

[Former Member]

Hi my friend,

Replace old SID with the new one in all 3 profiles in /usr/sap/<SID>/SYS/profile, defaultinstancestart. Also need to convert logical system name in BDLS after system is started.

Regards,