Change SID and Servername from a TEST System without Systemcopy

[Former Member]

Hello,

i have here a Problem. I have a cloned TEST System. So i have to Change now the Servername and also the SID of the SAP System WITHOUT doing a Systemcopy.

I know this is NOT supportet by SAP: But this is an Testsystem. So it is no Problem for us to do it without the Support from SAP.

But i have no clue how to do this..

I always used Systemcopy to Change the SID and Servername.. But this time i have to do it without a systemcopy.

So please can you help me with this?

Oh and yes. We are running on Linux with Oracle 11.2

Kind Regards

[former_member192421]

Hi,

Checkout this document.

http://scn.sap.com/docs/DOC-32851

Cheers

Rajkumar

[Former Member]

I already checked this document.. and yeah it Looks like this is what i wanted..

[Former Member]

Thanks Orkun Gedik,

but what about this new tool: System Rename Tool ?

Looks like it do exactly what i need.... but in an easier way...

Regards

[Reagan]

Good Day

As you are changing the SID of the system you will need to do a lot of modifications at the OS level.

You will need to rename the file systems.

Modify the environment variables for the OS users.

Rename the OS users and create new home directories.

Recreate all symbolic links for Oracle and SAP.

Rename SAP profiles.

Modify the services files (eg message server service)

Modify Oracle Listener.

Cheers

RB

[Former Member]

Thanks and Kind Regards. This helpes me alot

[former_member206552]

have a look this might help

http://scn.sap.com/thread/1850270

[Former Member]

In a perfect world.. it would be really nice to Change both

But as i mentioned at the end of the thread... i found this tool

System Rename Tool. This Looks like a tool from SAP that do exactly what i Need

[former_member206552]

hi,

do you only want to change the SAP SID or the DB SID as well ?

Best regards

marius

[Former Member]

Hi,

we are running on Linux and Oracle 11.2

Thanks for your Posts. So i cannot do a Systemcopy. Because the System is already cloned. So ist here and ready to use. But first i have to Change the SID and the Servername.

Yes i know it would be better to do a Systemcopy. But as i mentioned. The System is already cloned.

So please can you guide me through the procedure with a up and running test System?

This would be great.

Kind Regards

[Former Member]

First of all you need to stop the test system, because the SID needs to be changed. But before of it, you should create the control file with the command, below;

SQL>alter database backup controlfile to trace resetlogs;

Find the trace file under usertrace directory. Then, copy the lines between  "STARTUP NOMOUNT" and "-- Commands to re-create incarnation table" strings.

Replace the first line as below;

CREATE CONTROLFILE SET DATABASE "<NEWSID>" NORESETLOGS NOARCHIVELOG

And save the sql statement named, control.sql file

Then, shutdown the database and delete all control files at the OS level.

After that, execute the sql statement at the sqlplus, as below;

SQL>STARTUP NOMOUNT

SQL>@<full path>\control.sql

SQL>SHUTDOWN

SQL>STARTUP MOUNT

SQL>ALTER DATABASE OPEN RESETLOGS;

SQL>SHUTDOWN

SQL>STARTUP

After you created control files with the steps above, set up the OPS$ mechanism if it is required.

Then, find and replace new hostname in the SAP profile parameters.

I hope that it is clear.

Best regards,

Orkun Gedik

[Former Member]

Just one question....

where i can find the control files on OS Level?

[Former Member]

Execute the statement, below;

SQL>show parameter control_files

This command will provide control files with full path.

Best regards,

Orkun Gedik

[Former Member]

Hi Bjoern,

It is recommended to follow SAP system copy procedure, by the test system refresh/installation operations.

Of course, the SAP system copy procedure make it easy the copy process, but it will not make a problem, if you are not planning to upgrade on newly copied J2EE based system.

In short, you can follow the procedure in my previous thread http://scn.sap.com/message/10320147#10320147

Best regards,

Orkun Gedik

[Former Member]

Hi,

     Please confirm what is your OS you are going to clone?

If it is windows environment, you can just change the server names in the instance and default profiles.. Then that should be fine.

If it is a Unix & Linux,  then in addition  to change in the instance parameter and default parameter, you also need to either change the .*.sh & .*.csh files to map the new server name.

Rest will be fine.

We just did a DB restore with a different name and cloned the system with a different servername .. Now the system is up and running. We changed as said before.

Thanks and Regards,

Vimal