Oracle 11.2.0.1
Running in noarchive mode - so no backup. This is a new test database.
The database was working fine. I used SQL Developer "database copy" to bring down database objects from production to test. The program ran for hours and never completed. So I clicked the "cancel" button. And "database copy" program closed cleanly.
I was able to connect to the database, but when I tried to create a db link it hung. So i did a Shutdown Immediate and the database closed properly.
But when I tried to bring the database back up...that is when the problem started.
SQL> startup
ORACLE instance started.
Total System Global Area 1.3495E+10 bytes
Fixed Size 2218032 bytes
Variable Size 6845106128 bytes
Database Buffers 6576668672 bytes
Redo Buffers 71471104 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Process ID: 5555
Session ID: 191 Serial number: 3
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
Here is what is in the alert log:
<msg time='2014-11-07T07:30:05.326-08:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:3056:2780954927' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='dub-ImrORA2.americas.epicor.net'
host_addr='10.20.0.88' module='sqlplus@dub-ImrORA2.americas.epicor.net (TNS V1-' pid='5555'>
<txt>ORA-1092 signalled during: ALTER DATABASE OPEN...
</txt>
</msg>
<msg time='2014-11-07T07:30:05.343-08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='dub-ImrORA2.americas.epicor.net' host_addr='10.20.0.88' module='sqlplus@dub-ImrORA2.americas.epicor.net (TNS V1-'
pid='5555'>
<txt>opiodr aborting process unknown ospid (5555) as a result of ORA-1092
</txt>
</msg>
<msg time='2014-11-07T07:30:06.531-08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='dub-ImrORA2.americas.epicor.net'
host_addr='10.20.0.88' pid='5555'>
<txt>ORA-1092 : opitsk aborting process
</txt>
</msg>
Please tell me how to recover this database.