Dear All,

i am creating a new database manually. am facing this below error while i creating it : ORA-01092: ORACLE instance terminated.
Disconnection forced.

i would like to show u the method i have followed,, please anyone assist me to do it in correct way, and up my database.

i followed lot of blogs and sites they mentioning problem with pfile's undo tablespace, but i didnt made any wrong in my undo tablespace name in my pfile.

i couldnt able to identify my mistake,.

kindly help me to improve me as a junior DBA like u ppl.


C:\Users\Xi-Admin>set oracle_sid=OST

C:\Users\Xi-Admin>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 2 16:54:14 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup nomount pfile='C:\oracle\product\10.2.0\db_1\admin\OST\pfile\initOST.ora';
ORACLE instance started.

Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 92275368 bytes
Database Buffers 192937984 bytes
Redo Buffers 7139328 bytes


SQL> CREATE DATABASE OST
LOGFILE GROUP 1 ('C:/oracle/product/10.2.0/oradata/OST/redo01.log') SIZE 100M,
GROUP 2 ('C:/oracle/product/10.2.0/oradata/OST/redo02.log') SIZE 100M,
GROUP 3 ('C:/oracle/product/10.2.0/oradata/OST/redo03.log') SIZE 100M
DATAFILE 'C:/oracle/product/10.2.0/oradata/OST/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'C:/oracle/product/10.2.0/oradata/OST/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE 'C:/oracle/product/10.2.0/oradata/OST/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE 'C:/oracle/product/10.2.0/oradata/OST/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
CREATE DATABASE OST
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced