I'm not sure if I'd mentioned this before: We do use an external procedure to run external OS commands, but the procedure that is mapped to the C program is a private procedure in a package. The public interface to this procedure uses the PRODUCT_PROFILE (aka PRODUCT_USER_PROFILE) table to control who may execute what commands. The default is that no-one may execute any commands. We use the table to allow access much as SQL*Plus uses it to deny access to certain commands.
-----Original Message----- Sent: Friday, January 09, 2004 11:44 AM To: Multiple recipients of list ORACLE-L HUMM, I've taken a pretty tight stand against open ended external procedures and Java Stored Procedures. Thankfully the developers here agree. Basically I've told them that can't have an external or java procedure that executes a command send into it. That being the case rsh or sh command processors are verboten. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- Sent: Friday, January 09, 2004 5:29 AM To: Multiple recipients of list ORACLE-L Dick/John Thanks for all your input. I conclude from this discussion that it is not possible to have different, seperate external procedure listeners for different SIDs in the same instance at least not in 8.1.7. Incidentially, I have been having an issue with running an rsh command via an external procedure. The external procedure is a C .so which uses the C system command to run a Unix command. Sometimes the Unix command is an rsh. What I find is that sometimes the rsh command causes the "ORA-28576 lost RPC connection to external procedure agent". However if I make the external procedure listener seperate and start it off as follows from the root crontab or inittab /usr/bin/su - oracle -c /u01/app/oracle/product/8.1.7/bin/lsnrctl start listener_ext Then I never get the error. Just wondered if anyone had any thoughts as to why starting the external procedure listener in this way seems to resolve the ORA-28576 error with rsh commands. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).