Thanks all for the help and replies. Actually I had some settinngs wrong in the pfile itself. I copied the pfile from $ORACLE_HOME/dbs/init.ora, modified it, then startedup nomount using this pfile, then issued the create database command i had sent in the earlier message. Wow ... the database got created !!
Then i run the scripts catalog.sql catproc.sql and caths.sql.

sqlplus /nolog

conn sys as sysdba
password: <blank>

startup open pfile='pfile destination\pfile'
instance have started..
showing sga sizes etc..

alter user sys identified by *****
User Altered

Alter user system identified by *****
User Altered

I logged out n logged in again, it prompted me for a passwd for sys at the sqlplus prompt but i just pressed enter, it said "connected to an idle instance". I even restarted the database from the sql prompt.

But when i connect through "oemapp dbastudio" when i give the username/passwd/sysdba, it says ora-01031 Insufficient privileges error.

Where did i go wrong now ?????

a BIG THANKS to ALL !!

--SHIB

Oracle LazyDBA home page