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 previous message
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Arabic language problem
Next Topic: ORA-12547: TNS:lost contact while login as sysdba
Goto Forum:
  


Current Time: Tue Apr 16 03:12:36 CDT 2024