Listener problem ..Urgent

[vinit]

Hi,
I wanted to configure my listener.ora to facilitate 2 Oracle SIDs both running on the same server. How do I do that ?
At present when I am checking the status, I am getting 2 services :-

Services Summary...
MPLA has 1 service handler(s)
PLSExtProc has 1 service handler(s)

What is the second service handler and why is it used..It is not any of my Oracle SIDs.


Cheers,

[gpsingh]

Cut and paste (append) the SID_DESC section , change the ORACLE_SID and restart listener.

[vinit]

Thats fine..but what about extproc service . Why is this required..?

Cheers

[jmodic]

PLSExtProc is a special service for executing external procedures. Fom inside SQL or PL/SQL you can call an external procedure (the one that reside outside the database, that is at OS level), for example you can copy or delete a file or send an email etc. Those external procedures are usualy written in C and compiled into "object" code libraries (.so on UNIX, .dll on NT).

In the database you simply have to "register" this external library and create a PL/SQL function that calls the library.