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
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! - Official partner of 2002 FIFA World Cup
> > http://fifaworldcup.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: bharat dighe
> > INET: bdighe_at_yahoo.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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.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).
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: bharat dighe
INET: bdighe_at_yahoo.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 - 05:08:26 CDT