This content has been marked as final. Show 9 replies
ORA-01041 : internal error. hostdef extension doesn't exist.
What does it actually mean?
What is the hostdef extension?
The hostdef extension referred to is a structure which was added to the control
structure for the client/server communication.
It is accessed via a pointer in the original structure.
When the communication between the client and the server goes awry, this can
result in ORA-1041 and ORA-3113 errors.
The ORA-1041 is flagged when the POINTER to the EXTENSION structure for the
HOST DEFinition (for the communication channel between the client and the
server) has been nulled. This can occur when the connection gets lost 'for some
reason' and hence the procedure to investigate is the same as for ORA-3113.
The hostdef extension refers to the structures used to maintain the
client/server communication channel.
This problem typically occurs when you don't have your environment set up correctly.
Try to drop the database with the DBCA and recreate it again. This will also set up your environment. See if that helps. If it doesn't, then you have to solve the ORA-3113 error. This is quite a lengthy topic, so I'll refer to your Oracle Support's discussion. Go to Metalink and look up Note 19790.1. It discusses how to solve ORA-3113 errors.
thx for ur reply but i m nt getting the point you want to make that.so, wht is the immediate step i need to take to remove this errror.
do i need to reinstall the oracle but the same error occurs
Specify which OS you are working with and check if you meet the install requirements for it.
i m working with Win xp Professional.
intel pentim 4 processor 2.93GHZ
Ram 512 mb.
Before proceeding with reinstall, verify your environment variables are properly set (PATH, ORACLE_HOME), and your user belongs to the ora_dba privileged group.
no the path was not set.
can u give me the details how to set the values in a environment variable for oracle.
my user id amit
Envrionment variables in a windows os are set through the System advanced properties.
Start -> Control Panel -> system -> Advanced Properties -> Environment Variables.
madrid this is satish
how we can set the environment variables in linux os
can we set by using export @ os level
Yes you can.