Article Discussion: Creating a Database in Oracle 9i

Creating a Database in Oracle 9i If you have any questions or comments about this article please post them here.

You can read the article here .

Hi


I just started working on Oracle.

I was trying to create a new instance in oracle 9 i database using cofiguration assistant. It successfully created the database.
But i can't mount the database, since it has problem with control files. Control files are not created corresponding to this database. So i copied control files which was there in an already existing database. But it shows error

Ora - 01103 Database name GSBONE in control file is not ONLINE2

where GSBONE is the database instance which is perfectly running. ONLINE 2 is the database i created with configruation assistant.

Any idea how can i create a control file for this new database to mount ?

Ora - 01103 error occurs when your actual database name doesn't match the database name stored in your control file. To solve this problem, you must ensure that you are using the correct control file or change the database name to be the same as that inside the control file.

The main thing is that the name with the control file MUST be the same as the database being mounted.

So if you copied the files over, you most likely copied the GSBONE files to the ONLINE2 database. So change the database name within the ONLINE2 database to ONLINE2 instead of, what I believe is correct, the existing GSBONE name.

I hope this helps you. Let me know how you go, ok?

well i was working out to create a database but i was facing a problem that can there be a table with a foreign key but no primary or composite key?
a line in reply will be deeply appreciated

regards
Manpreet