Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: récuperer la liste des bases de données Oracle:::

Re: récuperer la liste des bases de données Oracle:::

From: herta <herta.vandeneynde_at_gmail.com>
Date: Thu, 14 Jun 2007 09:01:39 -0000
Message-ID: <1181811699.447452.84720@q19g2000prn.googlegroups.com>


On Jun 14, 10:18 am, sekraf..._at_gmail.com wrote:
> Je cherche à ecuperer la liste des bases de données existantes sur un
> serveur Oracle.
> C'est certainement en interrogeant les vues systèmes;
>
> Mais j'arrive pas à voir la solution.
>
> Alors merci pour vos aides.
> Merci
> Mustapha

If it has not been tampered with, you could look at oratab (usually in /etc/ or in var/opt/oracle/). The first column in the list should give you the names of all the database on the system.

Assuming you are on linux or unix, you can see which databases are active by running a command such as 'ps auxw | grep smon'. The string following 'ora_smon_' are your database instance names.

Kind regards,

Herta Received on Thu Jun 14 2007 - 04:01:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US