Listener problem ..Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Listener problem ..Urgent

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    467

    Red face

    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,
    Vinit

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    Cut and paste (append) the SID_DESC section , change the ORACLE_SID and restart listener.

  3. #3
    Join Date
    Oct 2000
    Posts
    467
    Thats fine..but what about extproc service . Why is this required..?

    Cheers
    Vinit

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width