Can same db runs on different hosts. [message #567873] |
Mon, 08 October 2012 01:47 |
chintan.patel
Messages: 162 Registered: July 2008 Location: Ahmedabad
|
Senior Member |
|
|
Hi Friends,
I have one production server with oracle 11g R2 DB. I have to change Server Hardware and thats why I have to install oracle 11g R2 DB on New hardware and test it. I had installed DB with software only option and copied the cold backup of production server. The hostname and ip address of both the servers are different. I had change the "db_domain" parameter into init.ora with the hostname.
Now my question is that can the same db runs on the same network with different hosts. Change of "db_domain" parameter into the init.ora is enough or i have to follow some other procedure.
Please suggest me.
Regards
Chintan
|
|
|
|
|
|
Re: Can same db runs on different hosts. [message #567934 is a reply to message #567876] |
Mon, 08 October 2012 07:15 |
chintan.patel
Messages: 162 Registered: July 2008 Location: Ahmedabad
|
Senior Member |
|
|
Hi John
I can successfully change the dbid and dbname using nic (dbnewid tool).
@ John as u suggest i am trying to change the global_name but it gives me an error ORA-01729: database link name expected.
Regards
Chintan
|
|
|
Re: Can same db runs on different hosts. [message #567937 is a reply to message #567934] |
Mon, 08 October 2012 07:22 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Wirks for me:orcl> select * from global_name;
GLOBAL_NAME
---------------------------------------------------
ORCL
orcl> alter database rename global_name to george;
Database altered.
orcl> select * from global_name;
GLOBAL_NAME
---------------------------------------------------
GEORGE
orcl> alter database rename global_name to sammy;
Database altered.
orcl> select * from global_name;
GLOBAL_NAME
---------------------------------------------------
SAMMY
orcl> alter database rename global_name to henry;
Database altered.
orcl> alter database rename global_name to orcl;
Database altered.
orcl>
|
|
|
Re: Can same db runs on different hosts. [message #567944 is a reply to message #567937] |
Mon, 08 October 2012 07:42 |
chintan.patel
Messages: 162 Registered: July 2008 Location: Ahmedabad
|
Senior Member |
|
|
Thanks John
When i select the query.
Quote:
select * from global_name;
GLOBAL_NAME
---------------------------------
TEST_DB.VBLIVEDATA.VB.COM
In above result, dbname "TEST_DB" is my new db name.
but it shows older domain name "VBLIVEDATA.VB.COM".
How can i resolve it.
Regards
Chintan
|
|
|
|
Re: Can same db runs on different hosts. [message #567948 is a reply to message #567944] |
Mon, 08 October 2012 07:49 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
orcl> alter database rename global_name to orcl.example.za;
Database altered.
orcl> select * from global_name;
GLOBAL_NAME
-----------------------------------------------------------------
ORCL.EXAMPLE.ZA
orcl> alter database rename global_name to use.your.initiative;
Database altered.
orcl> select * from global_name;
GLOBAL_NAME
-----------------------------------------------------------------
USE.YOUR.INITIATIVE
orcl>
|
|
|
|
|
|
Re: Can same db runs on different hosts. [message #568335 is a reply to message #567954] |
Wed, 10 October 2012 23:57 |
chintan.patel
Messages: 162 Registered: July 2008 Location: Ahmedabad
|
Senior Member |
|
|
@ Michel & John
Sorry for the late reply, but because of some hardware related problem my test server was not available for some time.
as you suggest i follow the steps and my problem is solved. I had successfully changed the dbid, dbname using dbnewid utility and change the global_name using alter database command.
Thanks
Chintan
|
|
|