DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: help DATABASE CAN'T OPEN

  1. #1
    Join Date
    Mar 2001
    Posts
    78

    Red face

    I just created a default database using configuration Assistant on AIX. I tried to open it but but I could not. So I went into server manager and did the following but it did not help. Any help will be appreciated. Below is what I did:

    $ sqlplus

    SQL*Plus: Release 8.1.7.0.0 - Production on Fri May 18 09:14:24 2001

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Enter user-name: internal

    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    SQL> select database_status, status from v$instance;

    DATABASE_STATUS STATUS
    ----------------- -------
    ACTIVE STARTED

    SQL> shutdown abort
    ORACLE instance shut down.
    SQL> exit
    Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    dailynews oracle NATIONAL /home/oracle
    $ svrmgrl

    Oracle Server Manager Release 3.1.7.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    SVRMGR> connect internal as sysdba
    Connected.
    SVRMGR> startup nomount
    ORACLE instance started.
    Total System Global Area 72712084 bytes
    Fixed Size 73620 bytes
    Variable Size 55689216 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 172032 bytes
    SVRMGR> select database_status, status from v$instance;
    DATABASE_STATUS STATUS
    ----------------- -------
    ACTIVE STARTED
    1 row selected.
    SVRMGR> alter database mount;
    alter database mount
    *
    ORA-00600: internal error code, arguments: [kccsbck_first], [1], [1959844878], [], [], [], [], []
    SVRMGR> exit
    Server Manager complete.

    I checked the log files and found this:

    more alert_NATIONAL.log | grep ORA-
    ORA-00313: open failed for members of log group 1 of thread 1
    ORA-00312: online log 1 thread 1: '/u07/ora01/oradata/NATIONAL/redo03.log'
    ORA-27037: unable to obtain file status
    ORA-00313: open failed for members of log group 2 of thread 1
    ORA-00312: online log 2 thread 1: '/u07/ora01/oradata/NATIONAL/redo02.log'
    ORA-27037: unable to obtain file status
    ORA-00313: open failed for members of log group 3 of thread 1
    ORA-00312: online log 3 thread 1: '/u07/ora01/oradata/NATIONAL/redo01.log'
    ORA-27037: unable to obtain file status
    ORA-00600: internal error code, arguments: [kccsbck_first], [1], [1959844878], [], [], [], [], []
    ORA-600 signalled during: alter database mount...
    ORA-00600: internal error code, arguments: [kccsbck_first], [1], [1959844878], [], [], [], [], []
    ORA-600 signalled during: alter database mount
    ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
    ORA-00600: internal error code, arguments: [kccsbck_first], [1], [1959844878], [], [], [], [], []
    ORA-600 signalled during: alter database mount...


    I thought about adding some log groups and files but since the database was not mounted I could not do it.

    NOTE: During the database creation, Ispecified only one disk to store the data files with the intention to make the files OFA after the database is up
    DATABASE NAME IS NATIONAL

  2. #2
    Join Date
    Feb 2001
    Posts
    163
    Check the logs created by dbassistant, they may have some errors in it.

    Since this is a new database and you dont have any data in it, I would recommend that you just drop it and recreate it. This time, just let the dbassistant create the scripts and run them manually one after the other and that way you can find what the error is.

    Hope that helps

    Uday


  3. #3
    Join Date
    Mar 2001
    Posts
    78
    Since all the datafiles are on one mount point (/u07/ora01), I'm sure that by deleting everything in that mount point, the database would being droped, right? Or there is something else that I have to do?

  4. #4
    Join Date
    Feb 2001
    Posts
    163
    That is correct, but I would suggest that you use the configuration assistant to delete it, if you are new to this

    Uday

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