KEY and SID? What's the difference?

From: kev <kevin.porter_at_fast.no>
Date: 2000/04/10
Message-ID: <38F1EA71.EABFF6B@fast.no>#1/1

Hi,

I'm having trouble configuring my tnslistener to be able to start external processes (so I can use InterMedia).

I added this to my tnsnames.ora file:

extproc_connection_data =

                (DESCRIPTION =


                   (ADDRESS =

                          (PROTOCOL = ipc)
                          (KEY = MEGSOC))
                          (CONNECT_DATA = (SID = MEGSOC) )
                    )
                 )

but no success. My question is: what is the difference between the 'KEY' and the 'SID' in the above example?

The docs give this example:

extproc_connection_data =

                (DESCRIPTION =


                   (ADDRESS = (PROTOCOL = ipc)

                              (KEY = DBSID))


                   (CONNECT_DATA = (SID = ep_agt1)))

with this explanation:

"DBSID is the database SID. ep_agt1 can be named anything."

What the hell does that mean? SID doesn't appear to be anything to do with the Oracle SID. Instead that seems to be covered by KEY. I don't understand. My head hurts. Please explain this to me, so I can avoid these errors:

SQL> create index myindex on docs(text) indextype is ctxsys.context; create index myindex on docs(text) indextype is ctxsys.context *
ERROR at line 1:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: ConText error:
DRG-50704: Net8 listener is not running or cannot start external

procedures

ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
ORA-06512: at line 1

thanks,

Received on Mon Apr 10 2000 - 00:00:00 CDT