Enterprise Manager :: Interpretation Of Oracle Metrics
Aug 23, 2011
When looking at some of the metrics available in OEM, I am puzzled by the interpretation:
1) Using the Host tab, and load metrics, I can get a metric for the Total I/O for the host .. I assume this is IOPS.
2) Using the Database tab, and the instance_throughput physreads_pc metric I can get a metric for the Physical Reads from the database instance per second.
3) We generally have several Oracle instances on the same server, and in all cases, the sum of the physical reads for each database is SIGNIFICANTLY higher that the total i/o for the host.
Am I interpreting the information incorrectly ? Does one of the metrics consider db_block_size ?
Any complete List iof possible Metrics from Grid Control after installarion? No User-Defined, only Standard Metrics. How can I find them, I just checked Documentation and Metalink - but no result.
Any list prepared before or can point to any "how to create".
I have created some views in one SCHEMA and made it invalid by dropping it's base table
1) Thru some queries, on SQL, I checked it shows there are invalid objects. 2) But even though , I refreshed DBCONSOLE Home Page it doesn't show the invalid objects. 3) How frequently ALERT METRICS are collected/refreshed.
We have the Oracle Enterprise Manager Grid Control 10.2.0.5. We recently upgraded our Databases from 10.2.0.3 to 10.2.0.4 and since then we are having this problem.
Whenever i click an Agent on the Grid Control it gives me this error: "Communication between the Oracle Management Service host to the Agent host is unavailable. Any functions or displayed information requiring this communication link will be unavailable. For example: deleting/configuring/adding targets, uploading metric data, or displaying Agent home page information such as Agent to Management Service Response Time (ms)."
I get the same error when i try to configure a host or a database.
My problem is i install Oracle 9i enterprise edition 9.0.1.1.1 in windows xp professional but at the time of oracle database confiuration assistent it show me following errors it show:
I am having a database running in my windows 2003 server and I want to configure Enterprise manager for that database to check the resource utilization during the peak hours and also the number of transactions...
i have already give the grant option cnnect,resource to scott but it is not connecting to enter prise manager console of Oracle database 11gR1. i am getting this error while connecting "The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information"
when i am giving scott the dba rights then it is connecting. but i cann't give dba rights to scott.so, how/what is the specific command to give permission scott for connecting to enter prise manager console.
I suddenly started getting this error message "Error
java.lang.Exception: IOException in sending Request :: Connection refused: connect ". on the dbconsole of my database. Any clue where to proceed or how to find whats causing this error.
I have installed Oracle 11g R2 on the RHEL 5 platform. Once the installtion is complete we need to run two scripts: 1: orainstRoot.sh 2: root.sh
As the root user.When we run the root.sh script is ask us to overwrite three variables yes/no? we did yes.After Running these scripts we opened the database, tried to run listner as well, everything is running fine but when we are trying to run the Emterprise Manager using command:
emctl start dbconsole
we are prompted with a path to check the logs /u01/app/oracle/product/11.2.0/db_1/localhost_orcl11g/sysman/log
I do not know which file I have to check.What could be the reason we are not able to run the EM.I need it urgently as we ahve to generate the AWR reports for the client.
i have installed oracle 10g. but not able to start the Enterprise Manager, i am getting the error when ever i enter the url in the browser (//home:5560/ isql plus) .
is Oracle Corporation provides Enterprise console for 11g, like oracle provides Enter prise console for 10g through which we can view/create/manage all the objects like tables,views,functions and procedures etc.
is there a way to export/download graphs that are shown on Oracle Enterprise Manager? I tried to find some buttons that make it possibile, but I'm unable to find them...
While connecting my oracle with My JDBC driver . i got an SQLException:
public class Orajdbc { public static void main(String args[]) { try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection [code]......
i am successfully connected by type 1 odbc driver but while i want to connect it with "ojdbc6.jar" file then i got this exception i already added that jar file to my Environment variable ClASSPATH ..
I have just downloaded Oracle 11g from the Oracle website.How do I start enterprise manager?
but once I get away from UNIX I don't have a clue what I am doing. What are the windows bits. I go to the oracle bin directory from a dos window and enter emctl commands, and I get "emctl" is not recognised as an ibternal or external command.
When i try to login into em it always give - [URL]... dba role is granted to the user and i have verified the passoword . I even tried with system user and it gave me same error.
Validation Error
Examine and correct the following errors, then retry the operation:Host Credentials - Connection to host as user system failed: ERROR: Wrong password for user
I am using Oracle 11g Rel1 on Window 2003 Server R2 Enterprise Edition x64 with SP2. I am trying to configure DB console using command throuth emca. But I am getting the below mentioned error. Even I tried after manually deleted the repository then tried to create using emca command.
========================================================== Mar 28, 2011 3:11:16 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Mar 28, 2011 3:16:16 PM oracle.sysman.emcp.EMConfig perform SEVERE: Error starting Database Control Refer to the log file at D:appAdministratorcfgtoollogsemcamonetaemca_2011_03_28_15_09_53.log for more details. Could not complete the configuration. Refer to the log file at D:appAdministratorcfgtoollogsemcamonetaemca_2011_03_28_15_09_ 53.log for more details.
C:Documents and SettingsAdministrator> ===========================================================
using Firefox 8.0 and found that I was "unable to connect". I found that although my OracleDBConsoleorcl service was set to automatic, it was not started. So, I attempted to start it from the Windows services menu, but received a message that Windows could not start it and it said to see the System Event Log. So, I checked the Windows System Event Log and found:
"The OracleDBConsoleorcl service terminated with service-specific error The system cannot find the file specified."but it does not tell me the name of the file or directory path. So, where do I go from here? I did not want to hijack the other thread, so I started a new one, especially since the original poster was able to start this service. Is there a different way to try to start the service that might provide more information?
I have been using this installation for a long time and seem to remember this working once upon a time, but I could be wrong. I don't usually use Enterprise Manager, so this is not something critical, just a curiosity, and something that I might like to explore. I have provided version and system info below.
-- Oracle version info: SCOTT@orcl_11gR2> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for 64-bit Windows: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production
5 rows selected.
-- partial systeminfo (some lines like product key removed): C:>systeminfo OS Name: Microsoft Windows 7 Professional OS Version: 6.1.7601 Service Pack 1 Build 7601
comparison of oracle and toad products.I know we have oracle enterprise manager for doing application and enterprise management.I am listing the tools from toad
Can list the tools from oracle which have or perform the same functionality.
Toad Toad Development Suite for Oracle Toad DBA Suite for Oracle Toad for SQL Server Professional Edition Toad for SQL Server Xpert Edition Toad Data Point Pro Edition Toad Data Point Pro Edition- with analytics
behaviour of oracle enterprise manager. i want to edit a table of a database. after i clicked on the table the oem crashes without any messages - simply disappearing.
i installed oracle9i release2 V9.2.0.1.0 windows client and want to access an oracle8i V8.1.7 server on linux.
When I am trying to enter to the enterprise manager of oracle 11g, but it is not working. In my services list the 'oracledbconsoleorcl' is assigned as automatically to start with windows. But it is not starting. When I tried to start it manually the following message is displayed repeatedly even after restarting the pc.
'Windows could not start the oracledbconsoleorcl on Local computer. For more information, view the system event log. If this is a non-Microsoft services, contact the service vendor, and refer to service-specific error code 2.' In the event log the following error messages are displayed:The OracleDBConsoleorcl service terminated with service-specific error 2 (0x2). and
The OracleCSService service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
we have 5 database servers in different locations,
1.main database 10g(production) ip-192.1.1.1 2.standby for production 10g ip- 192.1.1.2
both are linux
3.another database 10g windows 4. another database 9i windows
both are in same location
5.new database 10g in linux ip-192.1.1.3 some other location i m having a system windows xp installed i m monitoring, all 10g by oracle enterpric manager linux os monitor by Putty software
and i m monitoring below 10g database by sqlplus. now how could i monitor all the database by oracle enterprise manager grid control installed in my system that windows OS installed.
My application consists of Oracle RAC and Oracle Enterprise Manage (OEM) on same two nodes. I am exploring the idea of utilizing Oracle Clusterware (which is already installed with Oracle RAC) to support OEM in active passive mode.
Here is the scenario.
Node A running Solaris 10.9 on SPARC and Node B running Solaris 10.9 on SPARC. Node A and Node B are both Oracle RAC Nodes ( Active Active ) which use Shared Storage for Oracle using ASM.
Node A and Node B will run Oracle Enterprise Manager (OEM) Application in active passive scenario which will be using Oracle RAC for its database. So, both Oracle RAC and OEM are sharing same server A and B for its clusters.
Now, OEM application need a third party clusterware to fail it over. It needs clusterware to provide floating VIP and shared folder of the size of 20GB which will keep software libraries. If node A goes down, node B have access to same libraries and will come up as active.
Do you know if oracle clusterware which comes with Oracle RAC can support OEM for failing over i.e. it can provide floating VIP and shared file system?
