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.
View 2 Replies
ADVERTISEMENT
Jun 11, 2010
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.
View 1 Replies
View Related
Mar 3, 2008
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?
View 7 Replies
View Related
Feb 24, 2013
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.
View 2 Replies
View Related
Sep 25, 2012
query to get the name and size of all the databases associated to grid..
I need to find this to do capacity planning in our environment.
View 6 Replies
View Related
Feb 8, 2010
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.
View 4 Replies
View Related
Aug 15, 2010
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.
View 5 Replies
View Related
Jan 19, 2013
With just 1.95 GB RAM in windows xp, would it be recommendable to use Oracle 11g OEM Grid control? Will the performance be poor?
View 1 Replies
View Related
Nov 11, 2008
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.
View 1 Replies
View Related
Jul 11, 2012
I have plan to monitor RAC database (2 instance) through 12c grid control.
Do i need to install agent on both the nodes.?
Do i need to configure both the instance.?
View 6 Replies
View Related
Jan 20, 2012
I am able to login to the database as system user through putty session but I am unable to login using OEM grid control. I get the below error :
Database Error
ORA-01017: invalid username/password; logon denied
I know that we get this error if the user id or the password is invalid. But if the password is invalid, how come i am able to login through putty?
View 5 Replies
View Related
Aug 3, 2011
which i can install Grid Control For my 10g databases.
View 2 Replies
View Related
Mar 12, 2010
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
View 2 Replies
View Related
May 29, 2013
Now we have 11G grid control on linux x86_64 server and we are planning to upgrade this to 12c Cloud control,
What are the available options,
1) upgrade from 11g to 12c on the same server.
2) Build another linux server and install 12cloud.
which ever is easy to have 12c upgrade. oracle recommended url's to follow the installation.
View 4 Replies
View Related
Mar 5, 2011
I have primary database on RAC 10g and i have a standby, i want add this standby on Grid Control for monitoring this standby.
View 3 Replies
View Related
Jul 31, 2010
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)
View 1 Replies
View Related
Jan 7, 2010
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.
View 4 Replies
View Related
Jul 11, 2012
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]....
View 1 Replies
View Related
Jun 25, 2010
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".
View 2 Replies
View Related
Sep 15, 2011
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.
View 2 Replies
View Related
Jul 27, 2011
can I install/use Oracle 10g Enterprise Manager Grid Control if my organization has only Oracle 10g Standard Edition Licences.
View 2 Replies
View Related
Aug 2, 2010
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
View 1 Replies
View Related
May 19, 2011
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
View 16 Replies
View Related
Oct 15, 2013
I want to permanently de activate alerts from 12C grid control so i do not get email anymore.
View 4 Replies
View Related
Jan 20, 2010
I have oracle 10g R2 in my system with web based OEM.But i want to use Java based OEM console like in oracle 9i in my system with 10g....
View 8 Replies
View Related
Feb 22, 2012
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..
View 6 Replies
View Related
Aug 24, 2012
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?
View 1 Replies
View Related
Aug 21, 2010
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...
View 1 Replies
View Related
Dec 20, 2010
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.
View 1 Replies
View Related
Feb 2, 2010
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.
Don't know what is wrong
View 4 Replies
View Related
