Oracle Grid manager does not see database instances?!

[Database Administrator]

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

[Database Administrator]

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

[Database Administrator]

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

[Database Administrator]

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

[Database Administrator]

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

[weiliangjun]

hi

i have the same problem.

waitting for someone to resove this .

best regard.

[s.shukla]

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.

[Joslynfr]

Hi

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

regards

[billmclaughlin]

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