ORA-1092.
hello all,I'm having trouble with my database that can no longer open.
on startup I get the following error:
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1268508 bytes
Variable Size 1124074724 bytes
Database Buffers 1006632960 bytes
Redo Buffers 15507456 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection Forced
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension does not exist.
the database is in NOARCHIVELOG mode without any backup.
here is the result of some queries:
SQL> select name, file #, status from v $ datafile Where status not in ('SYSTEM', 'ONLINE');
no rows selected
select * from V $ recover_file;
on startup I get the following error:
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1268508 bytes
Variable Size 1124074724 bytes
Database Buffers 1006632960 bytes
Redo Buffers 15507456 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection Forced
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension does not exist.
the database is in NOARCHIVELOG mode without any backup.
here is the result of some queries:
SQL> select name, file #, status from v $ datafile Where status not in ('SYSTEM', 'ONLINE');
no rows selected
select * from V $ recover_file;
0