Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Database name embedded in controlfile -- what for?

Database name embedded in controlfile -- what for?

From: <johnvue_at_gte.net>
Date: Mon, 25 May 1998 13:06:16 GMT
Message-ID: <6kbqe7$t1p$4@gte2.gte.net> 





What is the exact relationship between the database name in CREATE
DATABASE and the DB_NAME parameter in init.ora?



Is there ever a legitimate reason for not making them the same?



It seems that ORACLE_SID environment variable tells Oracle about which
init<SID>.ora to use.  It doesn't use the environment variable to
match up with the database name embedded within the controlfile.



What is the purpose of having the database name inside the
controlfile?  Redundancy?
Received on Mon May 25 1998 - 08:06:16 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US