-
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,.
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
-
what does the alert log say?
-
This is the Alert logs msg..
i could not able to diagnose 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
-
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|