ORA-01092: ORACLE instance terminated.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-01092: ORACLE instance terminated.

  1. #1
    Join Date
    Mar 2010
    Posts
    35

    Post 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

  2. #2
    Join Date
    Oct 2008
    Posts
    69
    what does the alert log say?

  3. #3
    Join Date
    Mar 2010
    Posts
    35
    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...

  4. #4
    Join Date
    Oct 2008
    Posts
    69
    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.

  5. #5
    Join Date
    Mar 2010
    Posts
    35
    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

  6. #6
    Join Date
    Oct 2008
    Posts
    69
    Quote Originally Posted by 4iappsDBA View Post
    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.

  7. #7
    Join Date
    Jul 2009
    Posts
    6

    Smile

    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,,

  8. #8
    Join Date
    Mar 2010
    Posts
    7
    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

  9. #9
    Join Date
    Mar 2010
    Posts
    35
    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
  •  



Click Here to Expand Forum to Full Width