Home » RDBMS Server » Server Administration » DBname changed from pfile (10g, 10.2.0.1, windowXP)
DBname changed from pfile [message #582387] Wed, 17 April 2013 23:34 Go to next message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member

Dear All,

I am having few confusion on dbname, sid & tnsname.

rman target sys/oracle@suman auxiliary /

In the above command, "suman" is SID or Tnsname or dbname?

Bimistake, in my test database, i tried to change the DBname to suman from sumandb in pfile. After changing, i tried to startup database in nomount pfile but oracle through error that, unable to locate control file. Then, i remove the control files and tried to start database with nomount. Oracle through error about the control file.

This database, i had installed through DBCA.
I want to know, where are all places where DBname reside?

Can i start database through pfile even if it is created through DBCA?

Eager to know this answer from you.

Regards,
Ishika
Re: DBname changed from pfile [message #582388 is a reply to message #582387] Wed, 17 April 2013 23:39 Go to previous messageGo to next message
BlackSwan
Messages: 22539
Registered: January 2009
Senior Member
>I am having few confusion on dbname, sid & tnsname.
>rman target sys/oracle@suman auxiliary /
>In the above command, "suman" is SID or Tnsname or dbname?
"suman" is tns_alias; which exist as leftmost entry in tnsnames.ora file
Re: DBname changed from pfile [message #582390 is a reply to message #582388] Thu, 18 April 2013 00:15 Go to previous messageGo to next message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Thank you Mr. BlackSwan.

Can I change Dbname once database is installed?
Can I start database with nomount pfile, after changing the DBname?

Regards,
Ishika
Re: DBname changed from pfile [message #582392 is a reply to message #582390] Thu, 18 April 2013 00:19 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, use dbnewid tool.
Yes.

Regards
Michel
Re: DBname changed from pfile [message #582396 is a reply to message #582392] Thu, 18 April 2013 01:32 Go to previous message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Thank you Mr. Michel,

I will check and revert.
Previous Topic: Arabic language problem
Next Topic: ORA-12547: TNS:lost contact while login as sysdba
Goto Forum:
  


Current Time: Wed Jul 30 21:39:12 CDT 2014

Total time taken to generate the page: 0.14238 seconds