RE: ORACLE API's

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Thu, 27 Jun 2002 06:38:38 -0800
Message-ID: <F001.0048A512.20020627063838@fatcity.com>

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 <wisernet100_at_yahoo.com> 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 <bdighe_at_yahoo.com> 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: kirti.deshpande_at_verizon.com

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: 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 Thu Jun 27 2002 - 09:38:38 CDT