Home » RDBMS Server » Enterprise Manager » List of servers and databases (Grid on Unix)
List of servers and databases [message #509736] Tue, 31 May 2011 10:00 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have oracle grid control 10.2, I want to get the list of databases and servers that was configured within the Grid, is there any query that I can use to get it from Grid database?
Thanks
Re: List of servers and databases [message #509741 is a reply to message #509736] Tue, 31 May 2011 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just click on the "Target" tab.

Regards
Michel
Re: List of servers and databases [message #509743 is a reply to message #509741] Tue, 31 May 2011 12:36 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
I meant, how to get the data from the database not from Grid GUI
Thanks
Re: List of servers and databases [message #509746 is a reply to message #509743] Tue, 31 May 2011 13:19 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Login to the Grid repository and there are many views you can query.


[Updated on: Tue, 31 May 2011 13:56] by Moderator

Report message to a moderator

Re: List of servers and databases [message #509748 is a reply to message #509746] Tue, 31 May 2011 13:29 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Thats exactly is what I'm looking for, the table or view in which the database and server information is stored within the repository database.
Re: List of servers and databases [message #509752 is a reply to message #509748] Tue, 31 May 2011 13:50 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Easy to find, just look at tables/Views starting with "MGMT" under SYSMAN schema.

[Updated on: Tue, 31 May 2011 13:56] by Moderator

Report message to a moderator

Re: List of servers and databases [message #509754 is a reply to message #509748] Tue, 31 May 2011 13:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
caprikar wrote on Tue, 31 May 2011 20:29
Thats exactly is what I'm looking for, the table or view in which the database and server information is stored within the repository database.


So you want to login Grid Control but do not want to use it to get the information it gives you. Very Happy

Regards
Michel

Re: List of servers and databases [message #520826 is a reply to message #509746] Wed, 24 August 2011 22:42 Go to previous message
taylorf20850
Messages: 5
Registered: August 2011
Location: Rockville, Md
Junior Member
Look for OEM Extensibility Guide...

It details how to extend, and the MGMT views are in the appendix.
Previous Topic: Interpretation of Oracle Metrics
Next Topic: Grid Contral 10.2.0.5 Metrics List
Goto Forum:
  


Current Time: Thu Mar 28 13:27:25 CDT 2024