Home » RDBMS Server » Backup & Recovery » change DBID (Oracle 10.2 OS AIX6)
change DBID [message #444852] Wed, 24 February 2010 08:57 Go to next message
ijsselg
Messages: 13
Registered: April 2005
Location: Netherlands
Junior Member
Hello,

I want to change DBID of my oracle database. DBID is 645238352, and it must be 635902611. Is this possible? How?

Gerard
Re: change DBID [message #444853 is a reply to message #444852] Wed, 24 February 2010 09:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.oracle.com/pls/db10g/db10g.show_toc?which=main&partno=b10825&maxlevel=2&section=&expand=44869
Re: change DBID [message #444856 is a reply to message #444852] Wed, 24 February 2010 09:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As far as I know you cannot choose your DBID.

Regards
Michel
Re: change DBID [message #445128 is a reply to message #444852] Fri, 26 February 2010 01:29 Go to previous messageGo to next message
ijsselg
Messages: 13
Registered: April 2005
Location: Netherlands
Junior Member
Thanks.
Re: change DBID [message #445129 is a reply to message #444852] Fri, 26 February 2010 01:55 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
ijsselg wrote on Wed, 24 February 2010 20:27
Hello,

I want to change DBID of my oracle database. DBID is 645238352, and it must be 635902611. Is this possible? How?

Gerard


BUT WHY?
Why it should that value?
Michel suggested it`s not possible.Actually its not documented so its not advisable here to post the link...

If you Google for it sure you will find one....
Keywords :-change dbid oracle 10g pythian the first one would be yours.
Hope you are playing with your testing database....
Goodluck

sriram Smile

[Updated on: Fri, 26 February 2010 01:56]

Report message to a moderator

Re: change DBID [message #449408 is a reply to message #445129] Mon, 29 March 2010 07:19 Go to previous messageGo to next message
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
Member
My be below link will help you out.

http://www.oracle-base.com/articles/9i/DBNEWID.php

Regards
Harpreet Singh
Re: change DBID [message #449454 is a reply to message #449408] Mon, 29 March 2010 11:38 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
harpreetsinghkup wrote on Mon, 29 March 2010 17:49
My be below link will help you out.

http://www.oracle-base.com/articles/9i/DBNEWID.php

Regards
Harpreet Singh



Michel Cadot wrote on Wed, 24 February 2010 21:12
As far as I know you cannot choose your DBID.

Regards
Michel



sriram Smile

[Updated on: Mon, 29 March 2010 11:38]

Report message to a moderator

Re: change DBID [message #449458 is a reply to message #449408] Mon, 29 March 2010 11:48 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
harpreetsinghkup wrote on Mon, 29 March 2010 14:19
My be below link will help you out.

http://www.oracle-base.com/articles/9i/DBNEWID.php

Regards
Harpreet Singh

This will not help as the question is how to choose the DBID when this point is not addressed in the link you provided.

Regards
Michel

Previous Topic: Recovering lost datafile using OEM
Next Topic: Standby Database Failed
Goto Forum:
  


Current Time: Thu Mar 28 09:58:05 CDT 2024