OraFAQ Forum: Server Administration » DBname changed from pfile

Home » RDBMS Server » Server Administration » DBname changed from pfile (10g, 10.2.0.1, windowXP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBname changed from pfile [message #582387]

Wed, 17 April 2013 23:34

ishika_20
Messages: 339
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

Report message to a moderator

Re: DBname changed from pfile [message #582388 is a reply to message #582387]

Wed, 17 April 2013 23:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: DBname changed from pfile [message #582390 is a reply to message #582388]

Thu, 18 April 2013 00:15

ishika_20
Messages: 339
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

Report message to a moderator