Look in using External Procedures. Oracle provides this mechanism as interface to the outer world. You will have to write the code that talks to the outer world, though. Subscribe to http://technet.oracle.com (free) and serach for code examples.
- Kirti -----Original Message----- Sent: Thursday, June 27, 2002 5:08 AM To: Multiple recipients of list ORACLE-L Rachel, I just wanted to know if the Oracle provides library API's for all these tasks. Of course providing API's is best way to provide interface to the outer world. It is quite easy for any application to open a library and get the required parameters using the API's. Regards - Bharat --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > why would you need APIs for that? > > 1) (on unix) ps -ef|grep smon will tell you the > instances running on > the machine > > 2) ps -ef|grep tnsl will tell you the listeners > > 3) look at listener.ora in either > $ORACLE_HOME/network/admin or > /var/opt/oracle and it iwll give you the listener > details as well as > ports. Listeners don't listen on IP addresses > > 4) env|grep ORACLE will give you the listing of the > current > ORACLE_HOME > > 5) database user -- in sqlplus from an account with > select any table: > > select username from dba_users will give you the > database users. If > you want currently connected users, check v$session > > > I suggest a short session reading the Concepts and > Reference manual > might be in order > > > --- bharat dighe <[EMAIL PROTECTED]> wrote: > > Hi Folks, > > > > Does oracle provides any API's which can help user > to > > discover the information related to oracle setup? > > These API's can be used for finding out > > 1. The oracle instances which are up on the > machine. > > 2. Listeners which are up and their details. > > 3. IP adress and port on which the Listener is > > listening. > > 4. ORACLE HOME > > 6. Database users. > > > > etc etc. > > > > Thanks, > > - Bharat > > > > > > __________________________________________________ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
