ORA-01041 error with external procedures / Oracle8.04

From: <msouabni_at_my-dejanews.com>
Date: Fri, 30 Oct 1998 15:44:24 GMT
Message-ID: <71cmsn$qk5$1@nnrp1.dejanews.com>

Hi,

I tried to test the example given with the oracle package for using external procedures (the find_max C function) but I got the following error (from SQL Plus) (under Win95/Personal Oracle 8.04) : ERROR:
ORA-01041: internal error. hostdef extension doesn't exist

begin UseIt; end;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

SQL> /
Nothing in SQL buffer to run.
SQL>
SQL> I think that the problem is due to the TNSNAMES.ORA & LISTENER.ORA configuration files, does someone knows how to configure them, the Oracle developper guide indications (and the release notes) are useless, the error message is always the same :

                       ::TNSNAMES.ORA::

# C:\ORAWIN95\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\ORAWIN95\net80\admin\tnsnames.ora # Generated by Oracle Net8 Assistant

PO_FERMAT.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 = oracle80ORCL)(ARGS =
'(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')) (CONNECT_DATA = (SID = ORCL) ) ) CMEXAMPLE.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(PORT = 1610)(HOST = CM_SERVER))
(ADDRESS = (PROTOCOL = tcp)(PORT = 1521)(HOST = LSNR_SERVER))
    )
    (CONNECT_DATA =
(SID = ORCL)

    )
    (SOURCE_ROUTE = yes)
  )

TCPEXAMPLE.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(Host = Production1)(Port = 1521))     (CONNECT_DATA =
(SID = ORCL)

    )
  )

NMPEXAMPLE.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe = ORAPIPE))     (CONNECT_DATA =
(SID = ORCL)

    )
  )

EXTPROC_CONNECTION_DATA.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = extproc))     (CONNECT_DATA =
(SID = extproc)

    )
  )

BEQ-LOCAL.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 = oracle80ORCL)(ARGS =
'(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')) (CONNECT_DATA = (SID = ORCL) ) ) SPXEXAMPLE.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))     (CONNECT_DATA =
(SID = ORCL)

    )
  )

TCP-LOOPBACK.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))     (CONNECT_DATA =
(SID = ORCL)

    )
  )

                       ::LISTENER.ORA::

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
        (ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = graveur)
          (Port = 1521)
        )
        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )
#        (ADDRESS =
#          (PROTOCOL = SPX)
#          (Service = graveur_lsnr)
#        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = graveur)
(SID_NAME = ORCL)
(ORACLE_HOME = c:\orawin95)

    )
    (SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)
(ORACLE_HOME = c:\orawin95)

    )
  )

EXTERNAL_PROCEDURE_LISTENER =
  (ADDRESS = (PROTOCOL = IPC)(KEY = extproc))

SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
  (SID_LIST =
    (SID_DESC =
(PROGRAM = extproc)
(SID_NAME = extproc)
(ORACLE_HOME = c:\orawin95)

    )
    (SID_DESC =
(GLOBAL_DBNAME = graveur)
(SID_NAME = extproc)
(ORACLE_HOME = c:\orawin95)

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)
(ORACLE_HOME = c:\orawin95)

    )
  )

thank you.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 30 1998 - 09:44:24 CST