Site icon IT Tutorial

ORA-01041: internal error. hostdef extension doesn’t exist

I got ” ORA-01041: internal error. hostdef extension doesn’t exist ”  error in Oracle database.

 

ORA-01041: internal error. hostdef extension doesn’t exist

 

Details of error are as follows.

ORA-01041: internal error. hostdef extension doesn"t exist

Cause: Pointer to hstdef extension in hstdef is null.

Action: Report as a bug


After some system changes, e.g. replacing the motherboard, in the server, trying to connect or startup the database fails.
The service is running, but you are unable to connect as sysdba using a domain account:

SQL> connect / as sysdba
ORA-01041: internal error. hostdef extension doesn't exist

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

A domain administrator account is used to connect.  If the local system account is used, the connection as sysdba works fine.

 

 

internal error. hostdef extension doesn’t exist

This ORA-01041 error is related with the Pointer to hstdef extension in hstdef is null.

Report as a bug.

The system time was set incorrectly.

The local system time did not match the time on the domain server causing the authentication to fail.

 

To implement the solution, please execute the following steps:

1. Set the local system time correctly. Consult your operating system documentation for instructions on setting the system time.

2. Reboot the server.

3. Verify that the database starts and that sysdba connections can be made.

 

OR

Second case’s solution is to set SQLNET.AUTHENTICATION_SERVICES = (NONE) in sqlnet.ora ( under $ORACLE_HOME/network/admin )


 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

Exit mobile version