-
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
-
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
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|