Home » SQL & PL/SQL » Client Tools » Error in connection (Erwin 7.1.0)
Error in connection (Erwin 7.1.0) [message #443748] Wed, 17 February 2010 03:12 Go to next message
babar82
Messages: 108
Registered: March 2009
Location: Karachi
Senior Member
Hi,

I am trying to connect to database using ERWIN Data Modeler (7.1.0)
but the following error occurs.

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

The connection to database through other tools (e.g PL/SQL Developer etc) are successfully established.

Kindly Reply..
Re: Error in connection (Erwin 7.1.0) [message #443751 is a reply to message #443748] Wed, 17 February 2010 03:23 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
You are using which version of Oracle ?
Are you able to connect to the database using sql* plus?

sriram Smile
Re: Error in connection (Erwin 7.1.0) [message #443779 is a reply to message #443751] Wed, 17 February 2010 05:09 Go to previous messageGo to next message
babar82
Messages: 108
Registered: March 2009
Location: Karachi
Senior Member
Yes I can connect to the database which is Oracle 10g.
Re: Error in connection (Erwin 7.1.0) [message #443986 is a reply to message #443779] Thu, 18 February 2010 04:10 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
10g?
Always post the version number with 4 digits.
And we don`t know how your tool is communicating with the server?
See this..Quote:
ORA-01041 : internal error. hostdef extension doesn't exist.

What does it actually mean?
What is the hostdef extension?

Solution Description:
=====================


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.


Explanation:
============


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.



Try to re coneect....
sriram Smile
Previous Topic: Intalling Toad on Ubuntu 8.04
Next Topic: ECHO ON/OFF
Goto Forum:
  


Current Time: Tue Dec 06 12:25:27 CST 2016

Total time taken to generate the page: 0.10110 seconds