Oracle8i on Linux + Context

[Radek_Sedmak na eurotel.cz]

Ahoj,

     predem sorry za offtopic (moc to s linuxem nesouvisi i kdyz ? ) ale uz
nevim kudy kam a tak se ptam i tady.

Situace:
Oracle8i na RH6.1 (glibc2.1) bezi bez problemu

Instaluji ConText vse Ok ale kdyz chci z SQLplus spustit ( overit funkcnost
ConTextu )

(pro ty co nevedi co je to kontext, at to ma taky nejakou inf. hodnotu je to
cartridge k Oracle DB ktera umoznuje ukladat do Oracle DB dokumenty treba
PDF,HTML,DOC a ostatni formaty a databaze si je sama indexuje. Klasickej
fulltext. no a potom se davaj dotazy typu select id,doc_name from mydocuments
where containts(doc_body,'rum lih vodka') > 0
exec ctx_output.start_log('log');

tak to hodi

CHYBA na řádku 1:
ORA-20000: ConText error:
DRG-50704: Net8 listener is not running or cannot start external procedures
ORA-28575: nelze otevřít spojení RPC k agentu externí procedury
ORA-06512: na "CTXSYS.DRUE", line 122
ORA-06512: na "CTXSYS.CTX_OUTPUT", line 39
ORA-06512: na line 1

pritom tnsping na databazi chodi a tnsnames a listener obsahuje teoreticky to co
by mel, nenarazil jste nekdo na ten samy problem ?

                                                                            Bye
Sam

PS: Prikladam listener a tnsnames

listenrer.ora
LISTENER =
  (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL= IPC)(KEY=orcl))
        (ADDRESS=(PROTOCOL= IPC)(KEY=PNPKEY))
        (ADDRESS=(PROTOCOL= TCP)(HOST=vulcan)(PORT=1521))
  )

SID_LIST_LISTENER =
  (SID_LIST=
    (SID_DESC=
      (GLOBAL_DBNAME=db1
      (ORACLE_HOME=/u01/app/oracle/product/8.1.5)
      (SID_NAME=orcl)
    )
    (SID_DESC =
      (SID_NAME = ep_agt1)
      (ORACLE_HOME = /u01/app/oracle/product/8.1.5)
      (ENVS = LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.5/ctx/lib)
      (PROGRAM = extproc)
    )
  )


tnsnames.ora
extproc_connection_data =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = orcl))
    (CONNECT_DATA = (SID = ep_agt1))
  )

CONTEXT.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
           (COMMUNITY = tcp.world)
           (PROTOCOL = TCP)
           (Host = vulcan )
           (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )