How to rename global_name to NEW_DBSID after System Copy

[Former Member]

Hello,

I changed SID D22 to S11 during system copy.The System Copy guide recommends to rename global_name on Oracle.

I have some questions.

1) Is the following procedure correct?

SQL>alter database rename global_name to S11;

2) If I do not rename global_name, what happens?

---

I refer to the guide "Homogeneous and Heterogeneous

System Copy for SAP Systems Based

on SAP Web Application Server

ABAP 6.40 SR1".

---

6.2 Performing Follow-On Actions in the

Target System

---

Oracle: If you changed the <DBSID> during the system copy, it is recommended to adapt the global_name parameter with the following SQL command:

alter database rename global_name to <NEW_DBSID>;

If the parameter is not existing on your system, ignore this step.

thanks,

Keishi

[stefan_koehler · Accepted solution]

Hello Keishi,

just for information.. the official oracle documentation about that topic:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/ds_admin.htm

> 1) Is the following procedure correct?

Here is a test in my MDD test database:

SQL> SELECT * FROM GLOBAL_NAME;
GLOBAL_NAME
-------------------------
MDD.WORLD

SQL> ALTER DATABASE RENAME GLOBAL_NAME TO MDD2.WORLD;
Database altered.

SQL> SELECT * FROM GLOBAL_NAME;
GLOBAL_NAME
-------------------------
MDD2.WORLD

SQL> ALTER DATABASE RENAME GLOBAL_NAME TO MDD.WORLD;
Database altered.

SQL> SELECT * FROM GLOBAL_NAME;
GLOBAL_NAME
-------------------------
MDD.WORLD

> 2) If I do not rename global_name, what happens?

If you use a distributed database system, you need to identify each database by a unique identifier (the global name).

For more information, take a look at the oracle documentation:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/ds_concepts.htm#i1007500

Regards

Stefan

[Former Member · Accepted solution]

Hello Stefan,

Thank you for your reply.

I try to rename global_name referring to your information.

Regards,

Keishi