Home » RDBMS Server » Server Administration » Database Rename (Oracle 10g R2)
Database Rename [message #530381] Tue, 08 November 2011 00:03 Go to next message
sha_jit
Messages: 4
Registered: May 2011
Junior Member
Can any one provide automated shell script for renaming oracle DB 10gR2. Now it is a daily manual job for us. If anyone help on this automation it will b great.
Re: Database Rename [message #530385 is a reply to message #530381] Tue, 08 November 2011 00:10 Go to previous messageGo to next message
Littlefoot
Messages: 19648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No idea.

Why do you do that, anyway? I mean, what is the purpose of daily renaming a database?!?
Re: Database Rename [message #530387 is a reply to message #530385] Tue, 08 November 2011 00:12 Go to previous messageGo to next message
sha_jit
Messages: 4
Registered: May 2011
Junior Member
We have a daily production refresh to non-prod boxes using app bcv process. But the problem is that the production database name and non-prod database name r same. Client needs non-prod database should be renamed after clod-refresh. We can do it manually in dry run, but client want a automation in this without manual intervention.
Re: Database Rename [message #530400 is a reply to message #530387] Tue, 08 November 2011 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59275
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is a tool named "DBNEWID" (nid program in Unix) that you can run in your script.

Regards
Michel
Re: Database Rename [message #530403 is a reply to message #530387] Tue, 08 November 2011 01:14 Go to previous message
John Watson
Messages: 4610
Registered: January 2010
Location: Global Village
Senior Member
Hello -

Do you want to change the name of the instance, or the database, or the global_name, or the service name, or the TNS name people use to connect? Or all five?
There are different methods for each of these.

Rgds, John.



[Updated on: Tue, 08 November 2011 01:14]

Report message to a moderator

Previous Topic: Elapsed time in AWR report
Next Topic: DBMS_LOCK_ALLOCATED
Goto Forum:
  


Current Time: Tue Sep 30 09:15:25 CDT 2014

Total time taken to generate the page: 0.20614 seconds