ora-01092

[prav_saras]

Hi Friends
I am creating the database manually on Oracle 9i
I follow thr following steps:
1.Create the parameter file.
2.oradim utility
3.d: set oracle_sid=xyz (say)
4.connect as sys
5.sql>startup nomount pfile='d:\banti\initbanti.ora'
6.connected to idle instance
7.startup nomount pfile=d:\banti\initbanti.ora
8.databse started.
9.craete databse banti
maxlogfiles 32
maxdatafiles 100
max logmembers 3
logfile ''
datafile ''

Now after some time i got the error
ora-01092-oracle instance teminated disscnnection forced

can any boy tell me what i am doing wrong


regards

praveen

[akhadar]

Check in your parameter file that any obsolate parameters are mentioned.Also make sure that u included the undo_mangement parameter.check for the directories to which u are trying to write really exist and u have all the related permissions.
Try to attach the script through which u are trying to create the DB manually.

[davey23uk]

also provide exactly what you type, as what you put there is rubbish and full of typo's

What does the alert log say?

[JMac]

If its standard edition beware of multiple archive dests in your init.ora.

Just use LOG_ARCHIVE_DEST=

[julian]

Originally posted by prav_saras
Hi Friends
I am creating the database manually on Oracle 9i
I follow thr following steps:
1.Create the parameter file.
2.oradim utility
3.d: set oracle_sid=xyz (say)
4.connect as sys
5.sql>startup nomount pfile='d:\banti\initbanti.ora'
6.connected to idle instance
7.startup nomount pfile=d:\banti\initbanti.ora
8.databse started.
9.craete databse banti
maxlogfiles 32
maxdatafiles 100
max logmembers 3
logfile ''
datafile ''

Now after some time i got the error
ora-01092-oracle instance teminated disscnnection forced

can any boy tell me what i am doing wrong


regards

praveen

What does the alert.log say?

[jmodic]

Originally posted by davey23uk
What does the alert log say?