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

Guido Vornholt

Delphi Developer

Sat, 24 Sep 2005 03:14:02 GMT

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

I am using dbExpress in a WebSnap application (Win 2000 german)
with an Oracle database. I am using the oracle dbExpress driver
that was delivered with Delphi 6 (Update 2).

Sometimes (twice a week) the following error occurs:
ORA-01041: internal error. hostdef extension doesn't exist

For which Oracle version can I use the Delphi 6 Oracle driver?
Are there newer drivers (if yes, for which Oracle version)?

Thanks a lot in advance!
Guido

Dony Cha

Delphi Developer

Sat, 24 Sep 2005 12:40:59 GMT

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

Normally this is some kind of connection problem to Oracle DB. Use SQL*plus
to
check if you can connect to a database.

Quote

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

Dmitry Arefie

Delphi Developer

Sat, 24 Sep 2005 13:30:07 GMT

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

Hello !

This error means connection to server process was terminated
dues to some reason. Tou can check your server log and trace
files - probably there are also process dumps at server side.

Some time ago i made experiments with Oracle DbExp driver
and threading. Under havy load after some time i got the same
error. So, i will expect either either:
- driver has a bug (but very complex to reproduce)
- Oracle client has a bug.

I was using:
- Delphi7 drivers
- Oracle 9.2 client and server

All that is just IMHO, and not going to be a Complete True.
Anyway, i will suggest to use 3d party direct Oracle access
libraries, which works well in threading environments.

Regards,
Dmitry

===========================================
Dmitry L. Arefiev, director of gs-soft.ru ltd.
Solutions for successful companies

Author of NCOCI8 - Freeware Delphi to Oracle8i direct access

ICQ: 50741007
EMail: daref...@gs-soft.ru
Company: http://www.gs-soft.ru
NCOCI8: http://www.da-soft.com

Guido Vornhol

Delphi Developer

Tue, 27 Sep 2005 16:54:44 GMT

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

Thanks!

TeamB,
for which Oracle-Version is your Delphi 6 dbExp driver,
for which Oracle-Version is your Delphi 7 dbExp driver?

Best regards,
Guido

Quote

>This error means connection to server process was terminated
>dues to some reason. Tou can check your server log and trace
>files - probably there are also process dumps at server side.

>Some time ago i made experiments with Oracle DbExp driver
>and threading. Under havy load after some time i got the same
>error. So, i will expect either either:
>- driver has a bug (but very complex to reproduce)
>- Oracle client has a bug.

>I was using:
>- Delphi7 drivers
>- Oracle 9.2 client and server

>All that is just IMHO, and not going to be a Complete True.
>Anyway, i will suggest to use 3d party direct Oracle access
>libraries, which works well in threading environments.

Team

Delphi Developer

Tue, 27 Sep 2005 18:59:32 GMT

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

Quote

"Guido Vornholt" wrote:
> for which Oracle-Version is your Delphi 6 dbExp driver,

8.1.6

Quote

> for which Oracle-Version is your Delphi 7 dbExp driver?

--
Dave Nottage (TeamB)

Dmitry Arefiev [gs-soft.ru

Delphi Developer

Wed, 28 Sep 2005 03:03:29 GMT

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

Just want to add - i have not submitted this bug to QC,
just because it is reproducable just in 10% of runs in
my case ... May be it is in my software ...

--
<IMHO and not 100% True>

===========================================
Dmitry L. Arefiev, director of gs-soft.ru ltd.
Solutions for successful companies

Author of NCOCI8 - Freeware Delphi to Oracle8i direct access

ICQ: 50741007
EMail: daref...@gs-soft.ru
Company: http://www.gs-soft.ru
NCOCI8: http://www.da-soft.com

Dan Mise

Delphi Developer

Sat, 15 Oct 2005 09:08:41 GMT

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

Just a quick note on the Oracle threading bug. I've seen problems when you
have multiple TSQLConnections (one per thread) and connect at the same time.
This is with D6 and Oracle 8.1.7.4. The cause is definitely in the Oracle
driver, and has been confirmed by Oracle (check MetaLink for references and
details - I don't have them handy here). One solution is to Synchronize the
connect call back in the primary thread. Others have claimed to have success
with a mutex to prevent concurrent connections.

To make matters worse, the error changes across versions of Oracle (ours is
an AV in orageneric8.dll). Oracle claims that 9.2 is supposed to fix this,
but since I haven't tested it directly, I don't know. Maybe the error just
changed even more in that version. :-/
--
Dan Miser
http://www.distribucon.com

Quote

"Dmitry Arefiev" <daref...@da-soft.com> wrote in message

news:3e925e34$1@newsgroups.borland.com...

Quote

> Some time ago i made experiments with Oracle DbExp driver
> and threading. Under havy load after some time i got the same
> error. So, i will expect either either:
> - driver has a bug (but very complex to reproduce)
> - Oracle client has a bug.

Dmitry Arefie

Delphi Developer

Sat, 15 Oct 2005 13:34:00 GMT

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

Hello Dan !

Quote

> To make matters worse, the error changes across versions of Oracle (ours
is
> an AV in orageneric8.dll). Oracle claims that 9.2 is supposed to fix this,

9.2 is also infected by this AV.

Quote

> The cause is definitely in the Oracle driver, and has been confirmed
> by Oracle

Do you mean Oracle client ? I got - yes.

Quote

> details - I don't have them handy here). One solution is to Synchronize
the
> connect call back in the primary thread. Others have claimed to have
success
> with a mutex to prevent concurrent connections.

I am using connection pooling, which creates connections in single
thread and others are using connections. I have not seen this AV.

Regards,
Dmitry

===========================================
Dmitry L. Arefiev, director of gs-soft.ru ltd.
Solutions for successful companies

Author of NCOCI8 - Freeware Delphi to Oracle8i direct access

ICQ: 50741007
EMail: daref...@gs-soft.ru
Company: http://www.gs-soft.ru
NCOCI8: http://www.da-soft.com

Other Threads

1. ORA-01041 Internal Error: extension hostdef doesn't exist or HowTo configure BDE with Oracle8i

2. Oracle 8i and BDE5.01: ORA-01041: internal error, hostdef extension doesn't exist

3. ORA-01041:Internal Error-Hostdef extension does not exist

4. Win 2k / BDE Oracle: ORA-01041 Error: Hosdef extension doesn't exists

5. ORA-01041 Hostdef extension not found

6. Ora-01041 Internal Error. hostdef extension doesen't exist

7. ORA-01041:internal Error. hostdef extension does not exist

8. Getting General SQL error ORA-01041: internal error

9. hostdef extension doesn't exist

10. ORA-01041: internal error. (Delphi 5)