ORA-03113: End-of-File on Communication Channel at STARTUP After Creating SPFILE (Doc ID 166608.1)

Last updated on DECEMBER 26, 2023

Applies to:

Symptoms

symptom: Database startup fails.
symptom: Instance cannot be started with SPFILE parameters
symptom: ORA-24314: service handle not initialized
symptom: ORA-01041: internal error hostdef extension doesn't exist
symptom: ORA-03113: end-of-file on communication channel

Changes

Created a SPFILE from PFILE, followed by SHUTDOWN and STARTUP of database.

NOTE ROLE:

1. Start the database:

SQL> STARTUP PFILE=D:\ORACLE\ORA90\DATABASE\INITV901.ORA
ORACLE instance started.

2. Check if an SPFILE exists:

SQL> SHOW PARAMETERS SPFILE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string

3. Create an SPFILE:

SQL> CREATE SPFILE FROM PFILE;
File created.

4. Stop the database

SQL> SHUTDOWN IMMEDIATE
ORACLE instance shut down.

5. Restart the database:

SQL> STARTUP
ORA-03113: end-of-file on communication channel

SQL> STARTUP
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

Cause