I got ” ORA-24324: service handle not initialized ” error in Oracle database.
ORA-24324: service handle not initialized
Details of error are as follows.
ORA-24324: service handle not initialized Cause: An attempt was made to use an improper service context handle. Action: Verify that the service context handle has all the parameters initialized prior to this call.
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 doesn't exist
service handle not initialized
This ORA-24324 error is related to the attempt was made to use an improper service context handle.
Verify that the service context handle has all the parameters initialized prior to this call.
Some datafiles cannot be read because are offline or corrupted.
Check the OFFLINE files:
select file#, status, name from v$datafile where status not in ('SYSTEM', 'ONLINE');
heck if you have a good backup from which you can restore any problematic data file.
1) First restore the problematic datafiles
2) Mount the database and ONLINE those datafiles
SQL> startup mount; SQL> alter database datafile file1#, .. , filen# online;
3) Recover the database
SQL> recover database;
4) Open database
SQL > alter database open ;
Third case is as follows, read the following post.
127 views last month, 4 views today