While i was creating a database(10g Release 2) using CREATE DATABASE command, it error out saying
ORA-01501: CREATE DATABASE failed
ORA-00301: error in adding log file '/u03/oradata/redologs/redo3a.log' - file
cannot be created
This happened because i forgot to create the directory redologs before the command was issued. After i've created this directory , i tried to run the CREATE DATABASE script again.Then i got the error
ORA-01501: CREATE DATABASE failed
ORA-01100: database already mounted
Even though the first attempt was failed , CREATE DATABASE dbname part of the script was enough to create a database. This got created and mounted !
So i decided to DROP the database using DROP DATABASE command. But i was getting the below error
SQL> SHUTDOWN NORMAL;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup restrict mount;
ORACLE instance started.
Total System Global Area 5368709120 bytes
Fixed Size 2028456 bytes
Variable Size 2600471640 bytes
Database Buffers 2751463424 bytes
Redo Buffers 14745600 bytes
ORA-01079: ORACLE database was not properly created, operation aborted
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> select name from v$database;
select name from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
I tried to use DBCA to 'DELETE' the database. But the DELETE checkbox is not active.
I can see the background processes for this instance running.
$ ps -ef |grep ora
oracle 254196 1 0 13:29:42 - 0:00 ora_lgwr_testdb36
oracle 262318 1335414 0 04:52:04 pts/1 0:00 -ksh
oracle 266288 1478782 0 06:25:29 pts/1 0:00 -ksh
oracle 372870 1 0 13:29:42 - 0:00 ora_dbw0_testdb36
oracle 790778 905228 0 09:40:15 pts/2 0:00 -ksh
oracle 856298 1 0 13:29:42 - 0:00 ora_mman_testdb36
oracle 884850 1331442 0 04:08:32 pts/0 0:00 -ksh
oracle 913632 1 0 13:29:42 - 0:00 ora_ckpt_testdb36
oracle 917658 942100 0 07:05:57 pts/0 0:00 -ksh
oracle 1032192 1 0 13:29:42 - 0:00 ora_smon_testdb36
oracle 1183954 1 0 13:29:42 - 0:00 ora_cjq0_testdb36
oracle 1212638 1 0 13:29:42 - 0:00 ora_psp0_testdb36
oracle 1241214 266288 0 13:32:46 pts/1 0:00 grep ora
oracle 1339462 1 0 13:29:42 - 0:00 ora_reco_testdb36
oracle 1392862 1 0 13:29:42 - 0:00 ora_pmon_testdb36
oracle 1404994 1 0 13:29:42 - 0:00 ora_mmon_testdb36
oracle 1441884 1 0 13:29:42 - 0:00 ora_mmnl_testdb36
oracle 1458354 266288 1 13:32:46 pts/1 0:00 ps -ef
I somehow want to DROP this Database. But how can i do this?