Re: KEY and SID? What's the difference?

kev a écrit :

> 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

SID **IS** the instance name and nothing else and you have better to remove it from the example you give. KEY is specific to the IPC protocol.

So try to start the listener without the line specifying the SID in your example. Received on Mon Apr 10 2000 - 00:00:00 CDT