Which version was the 10.2.0.1 database before, and what were you doing in terms of upgrading to 10.2.0.1?

07-05-2010, 05:05 PM

PAVB

Agreed.

It looks like an incomplete upgrade scenario, this is consistent with having upgraded Oracle codeset but not having upgraded Oracle instance. Each individual instance has to be upgraded after upgrading Oracle codeset.

If this is the case double-check Oracle upgrade README file for proper procedure.

I did install the Oracle10g
and it showed successful installation but we have not done optional configuration settings.

Later we executed netca and
later we created the database but without creating the system01.dbf file.
and it was done successfully

I forgot to create the dbstart and pwd file previously so
I created the dbstart and pwd file but after creation of the database.

is it necessary to provide it with the system01.dbf file also?

07-06-2010, 05:43 AM

vnktummala

how did you created the database with out mandatory system table space? It seems you messed up. Better clean-up, read some oracle documentation then create the database again.

Thanks,

07-06-2010, 11:48 AM

PAVB

Quote:

Originally Posted by aryaanu

...later we created the database but without creating the system01.dbf file.
and it was done successfully

Hard to believe - Check log harder.

07-06-2010, 12:31 PM

BeefStu

Try these steps

Create a Database Manually

Step 1: Decide on Your Instance's System Identifier (SID) The first step in creating the database is to determine the System Identifier (SID).
This is what the environment will be set to when your database starts up
and shuts down, and what the instance processes will have in their names as unique identifiers.

My Instance name is called cat1020 you can use whatever you want. So
wherever you see cat1020 replace with your name. Of course, use file system
paths that are relavant to your machine.

Step 3: Connect to and Start the Instance
Connect to the instance as SYSDBA either using operating system authentication or the password file method of authentication and start up the instance using the STARTUP command.

>sqlplus '/ as sysdba'

NOTE: If your parameter file is not in the default location or is not named init.ora, you may need to specify the PFILE clause in the STARTUP command for the instance to start. Because you do not yet have a database attached to the instance, you need to start up the instance in NOMOUNT state:

SQL> startup nomount; The instance is now started and ready for the CREATE DATABASE command.

Step 6: Create a Server Parameter File
This step is optional, although highly recommended by Oracle. Your Oracle database was created by starting the instance with a parameter file, or PFILE. Because it is editable, you can migrate, easily, your new database to using a server parameter file. Creation of the server parameter file (or spfile) is accomplished by issuing the following statement:

Create spfile from pfile;

Good luck

07-07-2010, 09:42 AM

aryaanu

Thanks

Thank you BeefStu

your instructions was really helpful I am successfully able to create database and able to connect database.