ORA-01092: ORACLE instance terminated.

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,.:confused:

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


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

what does the alert log say?

This is the Alert logs msg..

i could not able to diagnose:confused: it.. if u have time please teach me how to do that



Errors in file c:\oracle\product\10.2.0\db_1\admin\ost\bdump\ost_psp0_4908.trc:
.
.
.
.
.

Tue Mar 02 16:55:12 2010
Errors in file c:\oracle\product\10.2.0\db_1\admin\ost\bdump\ost_psp0_1260.trc:
ORA-01519: error while processing file '' near line

Instance terminated by USER, pid = 5176
ORA-1092 signalled during: 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...

The alert log says you have errors in this trace file
c:\oracle\product\10.2.0\db_1\admin\ost\bdump\ost_psp0_4908.trc:

Post the contents of this file.

thank u very much for ur attention,,

actually that alert file is so long to post here., i dont know how to understand and read this alert log file,, could u please tell me how to read and understand it,..

i completed the database creation,. i found that i have done some wrong specification of UNDO tablespace name in init.ora file..

i thank u again,, and expecting ur reply about my new dought about alert files

Quote:

---

Originally Posted by 4iappsDBA

thank u very much for ur attention,,

actually that alert file is so long to post here., i dont know how to understand and read this alert log file,, could u please tell me how to read and understand it,..

i completed the database creation,. i found that i have done some wrong specification of UNDO tablespace name in init.ora file..

i thank u again,, and expecting ur reply about my new dought about alert files

---

i couldn't begin to guess without seeing the errors in the trace file.
Just post the tail end of the trace file (rather than the whole thing), from just before whenever the error occurred.

am so sorry brother,, i just created new database without any error.. so i deleted the old log files... any how in coming future if am getting some error i will post it here..

thank you for ur response.

i would like to discuss more about this alert log understanding in coming future..

take care,,

kindly check the parameter undo_tablespace in parameter file and ensure that undo tablespace name same in database or parameter file
aur post the contents of alert log file

thanks a lot,, i did it ,, now its working,, thank u for ur kind help