QUESTION POSED ON: 23 May 2007 I am installing Oracle 10g on Red Hat Linux. During startup I am getting the following error: "ORA-01103: database name 'SEEDDATA' in control file is not 'ORADB.'" Is it possible to change the database name in the control file? Please suggest the method to start up the database in this case.
>
EXPERT RESPONSE
There are two phases to successfully creating an Oracle database: (1) install the database software and (2) create a database. It sounds as if you have already installed the software and created a database (at least partially), but you are having problems starting the database. This error generally occurs when the db_name in the init.ora (or spfile) does not match what is in the controlfiles created for the database. Either you are using an incorrect init.ora (or spfile) to start a database, or you have changed the db_name in the init.ora. You can change the db_name of a database but this involves recreating the controlfiles; you cannot simply change it in the init.ora and start up the database.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.