Have a question

[Martin Ayala]

Hi,
I have the following question: I am trying to connect to an Oracle database via ODBC and I get the following error message:

"internal error hostdef extension doesn't exist"

What do I have to do?
Thanks

[Ken Hubnik_2]

I think you need to get with your DBA and get them to check out the parameters in the listener file.

[Ken Hubnik_2]

I think you need to get with your DBA and get them to check out the parameters in the listener file.

[Steven E. Protter]

I think what Ken is telling you(and I am as well) is that unless the Oracle dba takes step to allow external or odbc connections to the database you won't be allowed to connect.

Its actually not a default, out of the box configuration for oracle databases.

SEP

[Wodisch]

Hi,

in order to access an Oracle RDBMS instance using ODBC you will usually have to go through the following steps:
- install/configure "SQL*Net" ("Net8" / "Net9") on the server to grant access over the network (the config file is "$ORACLE_HOME/network/admin/listener.ora")
- install/configure "SQL*Net" ("Net8" / "Net9") on the client station (the one where you want to use it over ODBC) (the config file is "$ORACLE_HOME/network/admin/tnsnames.ora")
- test wether the connectivity really works - from the client (e.g. "tnsping CONNECTSTRING" or "sqlplus USER/PASSWORD@CONNECTSTRING" where CONNECTSTRING is what you have defined in "tnsnames.ora")
- configure your ODBC using the Control Panel->ODBC Admin. Go for "System DSN", select the "Oracle" driver, and fill in the CONNECTSTRING and such)
- test it with the Oracle-supplied tool "odbctest"

FWIW,
Wodisch

[Yogeeraj_1]

hi,

The hostdef extension refers to the structures used to maintain the client/server communication channel. The ORA-1401 is usually reported when a connection has broken for some reason. Check for any additional errors in the database alert log.

If you do not find a server-side error logged in the database alert log and/or no associated trace file in the user_dump_dest, this is most likely a network connectivity issue. In this case it would be best to check your network logs.

Post them if possible.

hope this helps!

regards
Yogeeraj

[twang]

"internal error hostdef extension doesn't exist" is usually generated after the termination of the communications connection between a client process and the
database which is usually preceeded by ORA-3113: End of file on communications channel. These errors are after effects of the original problem which terminated the connection. This is often caused by an unhandled exception (ORA-7445 - core dump) in the server process or by networking problems. There can be other causes, however which would be specific to the application.
Are there errors in the alert.log or trace files in the user_dump_dest directory? You should check the networking logs for any information.

[Caesar_3]

Hello!

Looks like some connection problem or some
permission, check with your DBA about maybe
he know the reason for this.

Caesar