Hi all,
yesterday evening I launched a somewhat complicated package I am writing, which spreads data received from an external system into a very big staging table, across serveral tables of my DB and takes some other actions based on the data received. When running, suddenly the Oracle instance died without a word. From that point on, the database isn't reachable anymore:
SQL*Plus: Release 12.1.0.1.0 Production on Fri May 30 11:03:46 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
Now I am trying to resume the instance, without any success. The last thing I tried is to manually start the database, but with no luck:
sqlplus sys as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Fri May 30 10:56:27 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1720328192 bytes
Fixed Size 2403496 bytes
Variable Size 1342178136 bytes
Database Buffers 369098752 bytes
Redo Buffers 6647808 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 1000
Session ID: 240 Serial number: 7
I am working directly at the server console. What can I do to recover my DB?
OS: Windows server 2008 R2 Standard, Service pack 1.
virtual machine running on a ESXi 5.0 host.
Database: 12.1.0.1.0
For any other info, just ask.
Thanks in advance,
Gianfranco