OraFAQ Forum: Enterprise Manager » List of servers and databases

Home » RDBMS Server » Enterprise Manager » List of servers and databases (Grid on Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

List of servers and databases [message #509736]

Tue, 31 May 2011 10:00

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

Report message to a moderator

Re: List of servers and databases [message #509741 is a reply to message #509736]

Tue, 31 May 2011 10:45

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Just click on the "Target" tab.

Regards
Michel

Report message to a moderator

Re: List of servers and databases [message #509743 is a reply to message #509741]

Tue, 31 May 2011 12:36

caprikar
Messages: 226
Registered: March 2007

Senior Member

I meant, how to get the data from the database not from Grid GUI
Thanks

Report message to a moderator

Re: List of servers and databases [message #509746 is a reply to message #509743]

Tue, 31 May 2011 13:19

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

[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

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.

Report message to a moderator

Re: List of servers and databases [message #509752 is a reply to message #509748]

Tue, 31 May 2011 13:50

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

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: List of servers and databases [message #520826 is a reply to message #509746]

Wed, 24 August 2011 22:42

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.

Report message to a moderator

Previous Topic:	Interpretation of Oracle Metrics
Next Topic:	Grid Contral 10.2.0.5 Metrics List

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 03 08:22:11 CST 2026