Enterprise Manager :: Configuring Grid Alerts For Two Different Groups Based On Database Environment
Aug 12, 2010
i have implemeted grid control for monitoring database. we have different database environment like PROD , STAGE, TEST, BETA.
Now my requirement is, i need to configure PROD & STAGE alert for one group (group1@oracle.com) means, what ever alerts generated by grid should sent notification to group1@oracle.com and TEST AND BETA database alerts should to group2@oracle.com.
Now i am following the oracle manual to configure notifications. unfortunately i could not find to complete my requirement.
[URL]
did any one implemented alerts to send different groups.
Installed Grid Control 10.2.0.2.0 on Windows Server 2003R2 32-bit. Immediately upgraded to 10.2.0.5.0. Both install and upgrade went fine, Grid Control can see its own database in the list of targets, looks good.
I then installed Oracle 11gR2 11.2.0.1.0 64-bit on Windows Server 2008R2 64-bit and created a new database. I then installed the 10.2.0.5.0 agent manually on the server via OUI. Agent install went fine, secured and started properly.
The problems I'm having is Grid Control can't seem to see the database instance. If I go to "Targets", GC can see the host just fine, shows that its up and can see targets for the listener (Up), the agent at port 3872 (Up), and the database instance (Down). Drilling down to the database instance, it shows that the instance is not up (though it is as I can connect to it from a different machine and run queries against not) and the Agent Connection to Instance is down with the error: Failed to connect to database instance: (UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc...
Also, pulling up the "Alerts" tab for errors showed the following for Metrics "Access to Important Tables and Views", "DB Data Files Permissions", and "DB Control Files Permission":
Target: SR3 Type: Database Instance Metric: Access To Important Tables And Views Collection Timestamp: Jun 11, 2010 11:11:26 AM Error Type: Collection Failure Message: 1804 at c:oracleagent10g/sysman/admin/scripts/db/esaDbUtils.pl line 290. There are also several "Missing Properties : [AdrHome,ConvertFromCharset,needCharsetConvert]" errors listed too.
I've looked into the 1804 error and from what I could find, its a perl-related issue with not being able to get the ORACLE_HOME information.
- I verified that ORACLE_HOME was set in the environment variables and even rebooted to make sure it was being picked up properly. That didn't work. - I added "$ENV{ORACLE_HOME}='c:\oracle\product\11.2.0\dbhome';" to the esaDbUtils.pl file. That didn't work either. - I added the GC security certificate to the trusted certificates on the target box in case it was some kind of SSL issue. I don't get the annoying "invalid certificate" warning, but it didn't fix it.
I'm monitoring and all my databases using grid control. Recently I added a dataguard configuration but the standby database shows me a lot of error simple because it's in MOUNT state. how I should configure grid control or the standby database so the errors disappear?
I have Oracle 11g on Linux...and i have set up SMTP of my Enterprise Manager Database control. I click on Test and an email was sent successfully. What i don't know is how to add more emails as the recipient of the alerts.
I have setup metrics like number of sessions, cpu usage, buffer cache hits, swapping, tablespace usage, etc...Upon saving and waiting for transactions to come in, alerts were shown the the EM homepage..but i did not receive any emails.
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.
How to configure SMS alerts for mobiles from OEM. We have a very big setup managed by 10g grid and i want to configure Mobile SMS alerts from OEM Grid.
I am getting one error message while installing this OEM grid control in existing DB. this error come at last in configuration step. This is the error stack:
Getting temporary tablespace from database... Found temporary tablespace: TEMP Checking SYS Credentials ... OK. Checking DB Init Parameters ... OK. Checking for Repos User ... Does not Exist. Loading necessary DB objects ... Checking DB Object (DBMS_SHARED_POOL , PACKAGE) ... Exists. DBMS POOL package exists. Done Loading necessary DB objects Creating repos user ... Done. Creating EM Schema ... Failed. Repository Creation failed. Failed to create repository schema. Configuration assistant "Enterprise Manager Repository Creation Assistant" failed -------- I am using oracle 10.1.0.3.0 on Windows XP.
what this error means? or any way that complete without it and later create manually.
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
In one of our cluster environment host 1 has 30+ targets. We are trying to add the targets in the grid. But while doing Agent Synchronization targets are not getting populated in the host..
Checked the log file of the same. Getting error as below..Not sure how to fix this.
2010-07-30 22:15:42,777 Thread-4158 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/rac_database_db303pta.xml, Line=0, Msg=LPX-00229: input source is empty (01006) 2010-07-30 22:15:46,534 Thread-4675 target {dbb01pta, rac_database} is broken: Computation of a critical dynamic property failed. Retries Completed (00156) 2010-07-30 22:15:46,580 Thread-4675 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/oracle_database_d01pt1_d01pt.xml, Line=0, Msg=LPX-00229: input source is empty (01006) 2010-07-30 22:15:46,581 Thread-4675 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/rac_database_dpta.xml, Line=0, Msg=LPX-00229: input source is empty (01006) 2010-07-30 22:15:47,603 Thread-4166 target {tta, rac_database} is broken: Computation of a critical dynamic property failed. Retries Completed (00156) 2010-07-30 22:15:47,648 Thread-4166 ORAXML-229, File=file:/oracle/product/em/agent10g/magerdbspr08.corp.internal.com/sysman/emd/collection/oracle_database_dta_d22.xml, Line=0, Msg=LPX-00229: input source is empty (01006)
I try to install the Grid Control 10.2.0.5 on Solaris 10 in an existing (empty) Database Oracle 10.2.0.4. All steps work without problems except
-- OMS Configuration (in Configutaion Assistants)
emca_repos_create15_25_32.log :
Quote: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:647) [code].......
ORA_NLS10 is set to $ORACLE_HOME/nls/data of DB
Also tried to set to $ORACLE_HOME/nls/data of oms10g but get Problems to start opmn and later on it report also ORACLE_HOME and NLS Parameter set incorrectly. I checked MetaLink / Internet without success.
I configured EM grid control(11g) and install agent.when I configured standby database by data guard I got error messages.examine and correct the following error(s), then re-try the operation.
Remote Operation Error - install_driver(Oracle) failed: Can't load '/home/oracle/Oracle/Middleware/agent11g/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: /home/oracle/Oracle/Middleware/agent11g/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied at /home/oracle/Oracle/Middleware/agent11g/perl/lib/5.10.0/x86_64-linux-thread-multi/DynaLoader.pm line 203. at (eval 14) line 3 Compilation failed in require at (eval 14) line 3. Perhaps a required shared library or dll isn't installed where expected at [code]....
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'm trying to use 11gR2 Grid Control to manage several 10gR2 database targets. I'm unable to determine the correct mix of Adobe software plug-ins to use for displaying SQL execution plans in a more graphical style. My client OS is Windows 7 - I have tried to research plug-ins for Internet Explorer 8, I upgraded (and subsequently downgraded!) to IE 9; I installed Firefox 6.x, tried with Google Chrome and all with the same results.
I'm not seeing any relevant information from MyOracle support or on Google, but may not be asking the correct question. As far as I can determine, SVG 3.0 is needed, Adobe stopped development in 2009 and there is no variant available therefore for Windows 7.
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'm trying to install Enterprise Manager Grid Control 11gR1 - Windows2003 32. On the "Connect to Oracle Database" step 5 when installing a new Enterprise Manager System, I get an Error window that states:
"ERROR: SQLException null Resultset
Cause: Verifying whether database is valid for this install, using the given credentials has failed.
Possible Reasons: 1. Credentials provided may be incorrect 2. Listener may be down 3. Database may be down
Actually am trying to replicate two db servers from one in hong kong and another in china. when am trying to establish the replication, am getting error 'ORA-04052: error occurred when looking up remote object' like this...
but the same way i have tried in my local network, it is working fine.i have tried schema replication through enterprise manager grid control..
Here we have a dataguard environment with db1 as primary and db2 as physical standby database. We configured dataguard in 10g environments and we are not using grid control. What are the steps for configuring rman for incremental backups in this environment?
We want to schedule the backups to be taken in standby db, (that is applicable in case of switchover too). In the case of switchover to db2 what all do we need to do in rman manually to resume backups in db1?
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.
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.
