| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: seperate external procedure listeners for different SIDs
That's a wrinkle I had not thought about. Here, being a PeopleSoft shop, they like to run SQR's and sure enough they want to run the same sqr's from web pages, forms applications, etc..... Well I took the stand that the external procedure could only be passed data. No you can't pass an sqr filename, no you can't pass username and password (I get them from elswhere). It works and damanagement supports the idea.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Friday, January 09, 2004 12:39 PM
To: Multiple recipients of list ORACLE-L
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: JohnF_at_smdi.com
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Fri Jan 09 2004 - 12:04:26 CST
 |
 |