RE: What OEM table stores the list of databases

  • From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 23 Jul 2004 09:43:10 -0400

OEM server does not have the tns entries for all of the databases.
>>> chris.grabowy@xxxxxxxx 7/23/04 9:35:39 AM >>>
Is parsing tnsnames.ora an option?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jeffrey Beckstrom
Sent: Friday, July 23, 2004 9:20 AM
To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxxxx;
oracledba@xxxxxxxxxxx; oracle-rdbms@xxxxxxxxxxxxxxx 
Subject: What OEM table stores the list of databases


I am looking at creating jobs to go against all of our databases. 
Since
they are all registered in OEM, I was hoping to query a OEM table to
get
all of the database names.  Anybody what OEM table this is stored in.



Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx 
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/ 
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html 
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx 
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/ 
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html 
-----------------------------------------------------------------



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: