dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Oracle Grid manager does not see database instances?! - Oracle Server

This is a discussion on Oracle Grid manager does not see database instances?! - Oracle Server ; I have two lan's seperated by a router. On lan1 i am running oracle EM-grid control. On lan2 there are several oracle databases (all using the grid-agent) The problem is that i see all targets in grid control (agents, listener ...


Home > Database Forum > Oracle Database > Oracle Server > Oracle Grid manager does not see database instances?!

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 07-23-2007, 12:38 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Oracle Grid manager does not see database instances?!

I have two lan's seperated by a router.
On lan1 i am running oracle EM-grid control. On lan2 there are
several
oracle databases (all using the grid-agent)
The problem is that i see all targets in grid control (agents,
listener and database instances)
Agents and listenrs are NO problem, but when i try to view in grid
control the database instance i always get the error:
"Io exception: The Network Adapter could not establish the
connection"
or more detailed:


2007-07-20 12:31:25,203 [MetricCollector:HOMETAB_THREAD600:60] ERROR
rt.DbMetricCollectorTarget _getAllData.326 -
oracle.sysman.emSDK.emd.comm.CommException: cis_amst2
oracle.sysman.emSDK.emd.comm.CommException: cis_amst2
at
oracle.sysman.emSDK.emd.comm.EMDClient.getResponse ForRequest(EMDClient.java*:
1543)
at
oracle.sysman.emSDK.emd.comm.EMDClient.getMetrics( EMDClient.java:
915)
at
oracle.sysman.emo.perf.metric.rt.DbHomeTab._getAll Data(DbHomeTab.java:
322)
at
oracle.sysman.emo.perf.metric.rt.DbHomeTab.getData (DbHomeTab.java:
143)
at
oracle.sysman.emo.perf.metric.eng.MetricCached.col lectCachedData(MetricCach*
ed.java:
404)
at
oracle.sysman.emo.perf.metric.eng.MetricCollectorT hread._collectCachedData(*
MetricCollectorThread.java:
596)
at
oracle.sysman.emo.perf.metric.eng.MetricCollectorT hread.run(MetricCollector*
Thread.java:
320)
at java.lang.Thread.run(Thread.java:534)


I Think is has something to do whith the router (blocking a port
which
is needed for the action) But i do not know which port to open. Can
someone help?


Regards,
Anneke

Reply With Quote
  #2  
Old 07-23-2007, 12:47 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Oracle Grid manager does not see database instances?!

On Jul 22, 10:38 pm, Kuwerti wrote:
> I have two lan's seperated by a router.
> On lan1 i am running oracle EM-grid control. On lan2 there are
> several
> oracle databases (all using the grid-agent)
> The problem is that i see all targets in grid control (agents,
> listener and database instances)
> Agents and listenrs are NO problem, but when i try to view in grid
> control the database instance i always get the error:
> "Io exception: The Network Adapter could not establish the
> connection"
> or more detailed:
>
> 2007-07-20 12:31:25,203 [MetricCollector:HOMETAB_THREAD600:60] ERROR
> rt.DbMetricCollectorTarget _getAllData.326 -
> oracle.sysman.emSDK.emd.comm.CommException: cis_amst2
> oracle.sysman.emSDK.emd.comm.CommException: cis_amst2
> at
> oracle.sysman.emSDK.emd.comm.EMDClient.getResponse ForRequest(EMDClient.java*:
> 1543)
> at
> oracle.sysman.emSDK.emd.comm.EMDClient.getMetrics( EMDClient.java:
> 915)
> at
> oracle.sysman.emo.perf.metric.rt.DbHomeTab._getAll Data(DbHomeTab.java:
> 322)
> at
> oracle.sysman.emo.perf.metric.rt.DbHomeTab.getData (DbHomeTab.java:
> 143)
> at
> oracle.sysman.emo.perf.metric.eng.MetricCached.col lectCachedData(MetricCach*
> ed.java:
> 404)
> at
> oracle.sysman.emo.perf.metric.eng.MetricCollectorT hread._collectCachedData(*
> MetricCollectorThread.java:
> 596)
> at
> oracle.sysman.emo.perf.metric.eng.MetricCollectorT hread.run(MetricCollector*
> Thread.java:
> 320)
> at java.lang.Thread.run(Thread.java:534)
>
> I Think is has something to do whith the router (blocking a port
> which
> is needed for the action) But i do not know which port to open. Can
> someone help?


WHen you installed the agents on the remote boxes, it asked you about
the agent port. Usually 4889. Is that open?

/Hans

Reply With Quote
  #3  
Old 07-23-2007, 01:11 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Oracle Grid manager does not see database instances?!

On 23 jul, 06:47, HansF wrote:
> On Jul 22, 10:38 pm, Kuwerti wrote:
>
>
>
>
>
> > I have two lan's seperated by a router.
> > On lan1 i am running oracle EM-grid control. On lan2 there are
> > several
> > oracle databases (all using the grid-agent)
> > The problem is that i see all targets in grid control (agents,
> > listener and database instances)
> > Agents and listenrs are NO problem, but when i try to view in grid
> > control the database instance i always get the error:
> > "Io exception: The Network Adapter could not establish the
> > connection"
> > or more detailed:

>
> > 2007-07-20 12:31:25,203 [MetricCollector:HOMETAB_THREAD600:60] ERROR
> > rt.DbMetricCollectorTarget _getAllData.326 -
> > oracle.sysman.emSDK.emd.comm.CommException: cis_amst2
> > oracle.sysman.emSDK.emd.comm.CommException: cis_amst2
> > at
> > oracle.sysman.emSDK.emd.comm.EMDClient.getResponse ForRequest(EMDClient.java**:
> > 1543)
> > at
> > oracle.sysman.emSDK.emd.comm.EMDClient.getMetrics( EMDClient.java:
> > 915)
> > at
> > oracle.sysman.emo.perf.metric.rt.DbHomeTab._getAll Data(DbHomeTab.java:
> > 322)
> > at
> > oracle.sysman.emo.perf.metric.rt.DbHomeTab.getData (DbHomeTab.java:
> > 143)
> > at
> > oracle.sysman.emo.perf.metric.eng.MetricCached.col lectCachedData(MetricCach**
> > ed.java:
> > 404)
> > at
> > oracle.sysman.emo.perf.metric.eng.MetricCollectorT hread._collectCachedData(**
> > MetricCollectorThread.java:
> > 596)
> > at
> > oracle.sysman.emo.perf.metric.eng.MetricCollectorT hread.run(MetricCollector**
> > Thread.java:
> > 320)
> > at java.lang.Thread.run(Thread.java:534)

>
> > I Think is has something to do whith the router (blocking a port
> > which
> > is needed for the action) But i do not know which port to open. Can
> > someone help?

>
> WHen you installed the agents on the remote boxes, it asked you about
> the agent port. Usually 4889. Is that open?
>
> /Hans- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -


Hi Hans,

Thanks for your reply!
Well, the agents can upload the information to the grid-host. So i
think that port must be open.
I also see all targets in the grid-host (listeners, database
instances, agents).
The only problem i have is when I want to view the details of the
database-instance i get the error.

any more suggestions?

Regards,
Anneke

Reply With Quote
  #4  
Old 07-23-2007, 01:39 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Oracle Grid manager does not see database instances?!

Kuwerti wrote:
> On 23 jul, 06:47, HansF wrote:
>> On Jul 22, 10:38 pm, Kuwerti wrote:
>>
>>
>>
>>
>>
>>> I have two lan's seperated by a router.
>>> On lan1 i am running oracle EM-grid control. On lan2 there are
>>> several
>>> oracle databases (all using the grid-agent)
>>> The problem is that i see all targets in grid control (agents,
>>> listener and database instances)
>>> Agents and listenrs are NO problem, but when i try to view in grid
>>> control the database instance i always get the error:
>>> "Io exception: The Network Adapter could not establish the
>>> connection"
>>> or more detailed:
>>> 2007-07-20 12:31:25,203 [MetricCollector:HOMETAB_THREAD600:60] ERROR
>>> rt.DbMetricCollectorTarget _getAllData.326 -
>>> oracle.sysman.emSDK.emd.comm.CommException: cis_amst2
>>> oracle.sysman.emSDK.emd.comm.CommException: cis_amst2
>>> at
>>> oracle.sysman.emSDK.emd.comm.EMDClient.getResponse ForRequest(EMDClient.java**:
>>> 1543)
>>> at
>>> oracle.sysman.emSDK.emd.comm.EMDClient.getMetrics( EMDClient.java:
>>> 915)
>>> at
>>> oracle.sysman.emo.perf.metric.rt.DbHomeTab._getAll Data(DbHomeTab.java:
>>> 322)
>>> at
>>> oracle.sysman.emo.perf.metric.rt.DbHomeTab.getData (DbHomeTab.java:
>>> 143)
>>> at
>>> oracle.sysman.emo.perf.metric.eng.MetricCached.col lectCachedData(MetricCach**
>>> ed.java:
>>> 404)
>>> at
>>> oracle.sysman.emo.perf.metric.eng.MetricCollectorT hread._collectCachedData(**
>>> MetricCollectorThread.java:
>>> 596)
>>> at
>>> oracle.sysman.emo.perf.metric.eng.MetricCollectorT hread.run(MetricCollector**
>>> Thread.java:
>>> 320)
>>> at java.lang.Thread.run(Thread.java:534)
>>> I Think is has something to do whith the router (blocking a port
>>> which
>>> is needed for the action) But i do not know which port to open. Can
>>> someone help?

>> WHen you installed the agents on the remote boxes, it asked you about
>> the agent port. Usually 4889. Is that open?
>>
>> /Hans- Tekst uit oorspronkelijk bericht niet weergeven -
>>
>> - Tekst uit oorspronkelijk bericht weergeven -

>
> Hi Hans,
>
> Thanks for your reply!
> Well, the agents can upload the information to the grid-host. So i
> think that port must be open.
> I also see all targets in the grid-host (listeners, database
> instances, agents).
> The only problem i have is when I want to view the details of the
> database-instance i get the error.
>
> any more suggestions?
>
> Regards,
> Anneke


Did you register the database credentials?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Reply With Quote
  #5  
Old 07-23-2007, 03:18 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Oracle Grid manager does not see database instances?!

I think you mean configuration of the DB?

What i do is the fololoweing:
1- I go To enterprise Manager Grid control
2- I log in using the sysman account
3- I select "Total Monitored Targets" overview (the number which is a
link)

I now see that all the database instance targets do have a "metric
collection error"
4- I select one database instance.

Now is see that the status is "metric collection error" AND the
message "This database is not configured"

5- I click the button "CONFIGURE"

I get the error "oracle.sysman.emSDK.emd.comm.CommException: DB1: DB1"
AND (when i click next step)
"Please correct the following error(s).
targetName - Name must be specified"

Anneke



Reply With Quote
  #6  
Old 01-13-2009, 05:17 AM
Database Newbie
 
Join Date: Jan 2009
Posts: 1
weiliangjun is on a distinguished road
Smile Re: Oracle Grid manager does not see database instances?!

hi

i have the same problem.

waitting for someone to resove this .

best regard.
Reply With Quote
  #7  
Old 09-08-2009, 11:29 AM
Database Newbie
 
Join Date: Sep 2009
Posts: 1
s.shukla is on a distinguished road
Default Re: Oracle Grid manager does not see database instances?!

Did someone get a solution to this issue?
I am getting exactly the same error for an instance on a remote location, EM 10.2.0.3 OS is Windows 2003.

I have been struggling for past few days, and not able to monitor the system properly, Listener, host and agent are fine, but instance gives the error:
oracle.sysman.emSDK.emd.comm.CommException: Connection timed out: connect

Any suggestions are welcome.
Thanks and regards,
Sonal.
Reply With Quote
  #8  
Old 09-20-2009, 11:43 PM
Database Newbie
 
Join Date: Sep 2009
Posts: 1
Joslynfr is on a distinguished road
Default Re: Oracle Grid manager does not see database instances?!

Hi

do you have an entry for database servers in /etc/hosts within oem box?

regards
Reply With Quote
  #9  
Old 11-11-2009, 02:21 PM
Database Newbie
 
Join Date: Nov 2009
Posts: 1
billmclaughlin is on a distinguished road
Default Re: Oracle Grid manager does not see database instances?!

Hello,

I am having the same issue. I do have the entry in the hosts file on the oem box.

thanks if you have solved this issue please let me know what you have done

I appreciate any information

Regards
Bill
Reply With Quote
  #10  
Old 04-08-2010, 01:48 PM
Database Newbie
 
Join Date: Apr 2010
Posts: 1
hjacks04 is on a distinguished road
Default Re: Oracle Grid manager does not see database instances?!

Has anyone solved this problem?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Shared Memory and Semaphores Database Administrator Oracle Server 4 04-10-2007 05:44 PM
Red Hat Oracle 10g R2 Installation Issues Database Administrator Oracle Server 1 01-24-2007 09:34 AM
case of hidden memory in 5.3 Database Administrator aix 4 12-05-2006 09:02 AM
Sybase FAQ: 1/19 - index Database Administrator sybase 17 01-16-2005 01:51 AM
Sybase FAQ: 1/19 - index Database Administrator sybase 13 07-20-2004 12:16 AM


All times are GMT -4. The time now is 08:35 AM.