Daily am getting this mails from grid... for the time of 3 to 4 seconds, am getting upto 15 mails saying the message which i mentioned below... In that time period the OEM is not working properly... After 4 seconds then OEM console is working fine..
Agent is unable to communicate with the OMS. (REASON = Agent is Unreachable (REASON : Agent to OMS Communication is brokenError in request response, code = 400 , text = ).
I have a server with Red Hat EL 5.5 running an oracle database 10g R2 and an Oracle Agent 10.2.0.5The disk ran out of space and I realized that there are a lot of files stating with core.xxx such as :
-rw------- 1 gridagent oinstall 17M Aug 2 13:10 core.10348 -rw------- 1 gridagent oinstall 17M Aug 2 13:15 core.10827 -rw------- 1 gridagent oinstall 17M Aug 2 12:30 core.4129 -rw------- 1 gridagent oinstall 17M Aug 2 12:35 core.4772
What's that ?Why are those files generated at $AGENT_HOME/<HOST>_<SID>/sysman/log/ ?
There are more than 24 GB of those files
in nmc.log I can see lines such as: NMC-00000 2010-08-02 13:25:39 [11760, nmcdbg.c,0440]TRC: Debug context enabled. NMC-20020 2010-07-30 01:31:58 [23083, nmccole.c,0725]ERR: Could not collect using DSGA Collection method NMC-20014 2010-07-29 01:31:56 [11258, nmccole.c,0822]ERR: Could not attach to the SGA
I have been facing issues deplyong OEM 11g agent on Oracle 10g Target databases. I have installed OEM Agent 11g which is functioning perfectly. Now i am trying to deploy management agent 11g on Target databases which are a Oracle 10g RAC system of 4 node on Oracle enterprise linux 64 bit. Below is the error log..
----------------------------------------------------------------- BLUE1DB-> ./runInstaller -silent -responsefile /opt/Agent11g/sysman/agent_download/11.1.0.1.0/linux_x64/response/additional_agent.rsp Starting Oracle Universal Installer... Checking Temp space: must be greater than 150 MB. Actual 1463 MB Passed Checking swap space: must be greater than 150 MB. Actual 32767 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-08-24_09-42-37PM. Please wait ...BLUE1DB-> *** Check for updates ***
My problem is that when i sign in on Enterprise Manager page ( URL.... ), i don't see that green up arrow that status is UP (and also those charts), but status: Agent unreachable: URL....
I tried to do what is specified in the Metalink(also here: URL.....), but the problem persists. And that metalink note (317242.1) applies to EM Grid Control (maybe that solution works for EM dbconsole also). So i don't have a Grid Control.I tried to stop dbconsole, then start it and then start upload agent ( emctl upload agent), but i got:
C:Documents and SettingsSorin>emctl upload agent Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. --------------------------------------------------------------- EMD upload error: Upload was successful but collections currently disabled - disk full
The agent status is:
C:Documents and SettingsSorin>emctl status agent Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. --------------------------------------------------------------- Agent Version : 10.2.0.4.2 OMS Version : 10.2.0.4.2 Protocol Version : 10.2.0.4.2 [code].....
The EM documentation does not work in this situation (and i specify this because sybrand_b has a problem with users who don't read the documentation.. ) However, i read here: URL....
"The agent collections will stop when the space on the disk is used beyond the default. Solution is to release the space on the disk."how to release space on the disk? What exactly means this? I have enough space on my D partition, where the Oracle product is. What should i do now? I want to see the EM page like this: URL....
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 have a problem with my DB agent. it doesn't upload data correctly, so I can't see updated information in first page of EM ( it doesn't show cpu usage, Active Sessions, Listener properties,...). when I checked the logs, I found that emagent.trc shows this error: "exceed max amount of upload data: 77 files, 52M, disabling collections warn : collector : disable collector"
what is missing in this pfile that would cause enterprise manager not to appear ?
In the Oracle Database 10g: Administration Workshop II The chapter 8 excercise calls for the database to be started using the pfile init_sgalab.ora . The purpose of this I suppose is to simulate a memory error.
When I get to the part where I need to use OEM to fix the problem, OEM does not come up. The contents of init_sgalab.ora are : -------------------------------------------- background_dump_dest='/u01/app/oracle/admin/orcl/bdump' compatible='10.2.0.1.0' control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl /control03.ctl' core_dump_dest='/u01/app/oracle/admin/orcl/cdump' db_block_size=8192 [code].......
I am not sure what is missing in this file to be able to bring up OEM.
Also, I looked at the logs and this is the only error message I found that might be relevant in
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> ===========================================================
I have to apply monitoring template on my databases. Databases are already added and configured into OEM. They are visible under Databases tab and also under Groups where I have added them.
But when I try applying monitoring template and look for database in search window, it doesn't appear there.
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...
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:
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.
i have change my database name successful but after that when i open my enterprise manager i can open it but i cannot do anything in enterprise manager . i cannot show any tabs there.. i have attached my this enterprise manager login page here
I needed to create a page on my existing APEX application that would allow the user to upload a file, I followed an online tutorial where the user had created a dummy table and inserted CSV File inserted through APEX into the table. Following that simple example I am able to load the simple CSV file (from tutorial) into a dummy table (from tutorial) but when I attempt to insert actual/dummy data into my actual database (which has a lot more fields of different types), using the exact same process, I am unable to do so.
Ironically, I am unable to insert even dummy values despite the fact that I have been able to insert the same dummy values using SQL Developer. Icing on the cake is that APEX does not produce any error, this lack of debugging feature (especially line by line debugging) is such a pain. Just to add, I can load the values into an Array and can successfully print the delimited values off the array but am still unable to insert the same values into my table. Here is the table that I am attempting to insert into (actual names replaced by Dummyxx):
Note that all the the CSV does not contain all the fields, the CSV files that are expected to be entered into the system contain 65 Fields whereas the Table has 73 Fields. Also note that the process runs fine through SQL loader that is invoked through a different server which I need to release and hence the attempt to load the table this way. Also, the procedure on the SQL Loader server is quite complex and involved JAVA+Unix Shell Scripts etc. which I would prefer to avoid.
I'm trying to install OMS on AIX and one of the prerequisites is JDK 1.6.0 SR6 but I couldn't find it in the IBM site, can some one tell me where can I download JDK 1.6.0 SR6?
I am trying to start enterprise manager without success. i used to work after installation of db 10g but do day when i run the command below it fails. also i donot see any thing useful in the logs that am being directed to directory /oracle/Ora10R2/Orahome/localhost.localdomain_dse/sysman/log
I have two databases on the same oracle 11g install. The first (ORCL) database uses the default port for EM (1158). However, I don't know what the second one uses. I go to the portlist.ini file, but it only has the entry for the default (ORCL) database.
When i run EM ,in my explorer show these SID = ORCL
instance is open agent is up but ...listener is down .my listener is active and run.... however i can connect to DataBase and execute DDL or DML transactions.How i could resolve it ?
