AskDba.org Weblog » Entries tagged with "dbconsole"
11gR2: Monitoring Real Time SQL Plan Execution from Oracle Enterprise Manager
Ever since 11gR2 has been released, it has created a lot of buzz in Oracle Blogosphere with various posts on 11g Release 2 (11gR2 ) New Features primarily ASM New features. I would like to introduce you all to a feature which has been incorporated in 11gR2 Oracle Enterprise Manager to display Real-Time SQL Monitoring information . I would say that this was much awaited feature which had to be implemented in OEM and comes as a handy … Read entire article »
Filed under: Featured, performance
DBConsole Issue on RAC -Part II
Continuing with DBConsole issue, we were able to get the cluvfy return success for the nodes. Basically Oracle suggested us that when we use ssh we should not get any banner. E.g [oracle@PROD01 ~]$ ssh PROD02 date Fri Jun 13 02:00:41 IST 2008 But in our case it was displaying a banner which displayed a warning message when someone logged in Server. As we are using Linux, we renamed file /etc/issue.net to something else and tried running cluvfy again. It was successful this time [oracle@PROD01 ~]$ cluvfy comp nodecon -n all Verifying node connectivity Checking node connectivity... Node connectivity check passed for subnet "10.X.X.X" with node(s) PROD02,PROD01. Node connectivity check passed for subnet "192.X.X.X" with node(s) PROD02,PROD01 Interfaces found on subnet "192.X.X.X" that are likely candidates for VIP: PROD02 eth3:192.X.X.X PROD01 eth3:192.X.X.X Interfaces found on subnet "10.X.X.X" that are likely candidates for … Read entire article »
DBConsole Issue on RAC -Part I
Currently I am working on issue where DBConsole is not starting on our 2 Node RAC system. When I try to start, I get following errors [oracle@PROD01 ~]$ emctl status dbconsole TZ set to US/Pacific Exception in getting local host java.net.UnknownHostException: PROD01: PROD01 at java.net.InetAddress.getLocalHost(InetAddress.java:1191) at oracle.sysman.emSDK.conf.TargetInstaller.getLocalHost (TargetInstaller.java:5561) at oracle.sysman.emSDK.conf.TargetInstaller.main (TargetInstaller.java:4126) Exception in getting local host I tried recreating the DBConsole but that also failed and gave following error [oracle@PROD01 ~]$ emca -config dbcontrol db -cluster STARTED EMCA at Jun 12, 2008 3:29:40 AM EM Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Jun 12, 2008 3:29:40 AM oracle.sysman.emcp.util.ClusterUtil getHostName SEVERE: Error getting hostname for the cluster node PROD01. This node may not be configured … Read entire article »

Recent Comments