I tried to create a database with CREATE DATABASE statement. However it couldn't accomplish the task due to the error ORA-03113: end-of-file on communication channel.
Now I want to drop the database. When I startup and mount the database (in order to drop) I receive error and the db cannot be mounted:
ORA-01079: ORACLE database was not properly created, operation aborted
And if I try with DROP, it fails, because I haven't mounted it:
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-01507: database not mounted
Now there are two control files created only on the file system (as I specified in the init file).
What has to be done in advance to "clear" after the failed CREATE DATABASE statement and to execute it again?
OS: Solaris 10, x86 64-bit
Oracle Version: 11.2.0
Edited by: user13080027 on May 10, 2011 8:06 AM