cancel
Showing results for 
Search instead for 
Did you mean: 

Have a question

Martin Ayala
Occasional Visitor

Have a question

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
Martin
7 REPLIES
Ken Hubnik_2
Honored Contributor

Re: Have a question

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

Re: Have a question

I think you need to get with your DBA and get them to check out the parameters in the listener file.
Steven E. Protter
Exalted Contributor

Re: Have a question

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Wodisch
Honored Contributor

Re: Have a question

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
Honored Contributor

Re: Have a question

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
twang
Honored Contributor

Re: Have a question

"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
Esteemed Contributor

Re: Have a question

Hello!

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

Caesar