Generate Grid Control 10g Reports In Portuguese
Aug 31, 2011I am able to generate (and email) built in database space usage report, I have a requirement where the report has to be in portuguese language and not in english.
View 1 Replies
ADVERTISEMENT
Generate Filesystem Usage Reports From Grid Control10g?
Aug 31, 2011I am oracle 10g grid control.
I have a requirement where I have to generate monthly filesystem usage report(graphical) in an automated fashion,I checked the built in reports from the grid control 10g but not able to find any thing....
Generate Report From OEM Grid
Feb 6, 2012Can we collect information(generate report) about user sessions connected, database hit ratios, memory usage and other system metrics of all target databases from OEM grid control repository database. Which tables/views in repository DB will be holding these information.
View 1 Replies View RelatedGenerate Report From OEM Grid 11 Or RMAN
May 17, 2013*How can we generate the report of backup status,tablesapce(usedf,free space) for all the databases from OEM or RMAN*
1.)we need generate the report of tablespace used,free, archive...
2.)we also need we generate the Backup status report also
OEM Grid Control 10g Reporting
Aug 19, 2011I am using OEM Grid control 10g for monitoring/reporting purposes and a bit new to OEM.I am able to generate database alerts sent via email say for DB_abc1 and also generate reports.I installed Oracle 10g agent on a another box and lets say with DB_abc2 running on it,and did not realise that there was a database control already installed on that box, so I
1.Uninstalled database control on DB_abc2 box.
2.Uninstalled Oracle 10g agent and re-installed it on DB_abc2 box.
2.Was able to configure the DB_abc2 database from OEM Grid control gui ie the dbsnmp user password and was able to connect to it.
But when I put in alert for things like ORA-XXXX errors I am not getting any emails, also when I put in database usage reports(to be sent via emails) the reports are not picking up any data, they are empty.
I checked the agent on the box in question and the heart beat is OK, and I manually uploaded using "emctl upload" and it is sucessful.The only alerts I am getting for DB_abc1 is the agent up/down thats it.
DB_abc1 is a 9208 database and DB_abc2 is 10201 database.
Installing Grid Control 12c?
Apr 19, 2012I need to install the new Oracle Grid on a new virtual machine. Currently the new Grid VM server has a different name and IP. After it is setup and tested it will eventually take the place of the old production server using its original IP and name. If I install the new Grid now on this new VM with different name and IP address would I have to reinstall the agents on each of the target database servers?
View 1 Replies View RelatedOEM Grid Control 11g Space Constraint
Jun 21, 2012We have some space constrain with the server and unfortunately the Specific Oracle file system is not extendible. Middleware/ gc_inst are also in the same mount point consist (28G). Would like to create a soft link to these directory to a newly mounted LUN and so to avoid this space issue which is currently 95%. if soft link works and releases 28G?
OEM grid control 11g
OS: Red Hat Enterprise Linux Server release 5.6 (Tikanga)
Linux corpoem.corp.idt.com 2.6.18-238.5.1.el5 #1 SMP Mon Feb 21 05:52:39 EST 2011 x86_64 x86_64 x86_64 GNU/Linux
Grid Control Could Not Started Up After Changing IP Address
Sep 13, 2012I've changed the ip address of the enterprise manager grid control server. But oms could not be started. I got the error below:
[oracle@YDFULGRID bin]$ ./emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright © 1996, 2010 Oracle Corporation. All rights reserved.
Starting WebTier...
WebTier Successfully Started
Starting Oracle Management Server...
Oracle Management Server Could Not Be Started
Oracle Management Server is not functioning because of the following reason:
Connection to the repository failed. Verify that the repository connection information provided is correct.
Please check /oracle/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log for error details
When i checked the log:
I am getting this error:
2012-09-13 16:23:56,602 [main] DEBUG oms.StatusOMSCmd processStatusOMS.155 - Using http port.
2012-09-13 16:23:56,602 [main] DEBUG oms.StatusOMSCmd processStatusOMS.195 - Attempting to connect to servername
2012-09-13 16:24:17,638 [main] DEBUG oms.StatusOMSCmd processStatusOMS.200 - page status code is 503
2012-09-13 16:24:17,638 [main] DEBUG oms.StatusOMSCmd processStatusOMS.202 - header is 3
2012-09-13 16:24:17,639 [main] INFO wls.OMSController statusOMS.950 - statusOMS finished with result: 3
Application Target Not Show In Grid Control 11g (11.1.0)
Feb 20, 2013i insall grid contrlol on r12(12.1.1) and it work very fine detect all target r12 database plus oracle application server all target...but my problem is when i connect it to another system r12(12.1.3) by installing agent silent installation...it detect oracle r12 database only but not detect any target related to oracle application server such as oracle ebusiness suit,http server or any target related to application server. os linux 5.4. acutally i want to configure plug in 4.0...i follow metalink doc 1224313.1 refer me any doc any blog or any thig by which i can detect oracle application target in grid control.
View 7 Replies View RelatedOracle11g R1 Grid Control Installation Error
Apr 18, 2011In Oracle 11g grid control installation error OMS configuration failed:
DB s/w: Oracle DataBase 11g R2
OS : Windows Xp sp2
Grid s/w: Oracle 11g Grid Control R1
Weblogic Server : wls 10.3.4.0
As i did follow the oracle 11g grid control basic installation guide. i got error in oms configuration stage ....
Apr 18, 2011 7:28:58 PM oracle.sysman.omsca.adapter.wls.OMSWLSAdapter adapterDeleteOMS
FINE: Done Executing the command...0
Apr 18, 2011 7:28:58 PM oracle.sysman.omsca.framework.OMSGenericAdapter deleteAddOnInventory
INFO: Invoking deleteAddOnInventory for oms null
Apr 18, 2011 7:28:58 PM oracle.sysman.omsca.adapter.wls.OMSWLSAdapter adapterDeleteOMS
FINE: Stopping WebTier
[code]....
Enterprise Manager :: RAC Monitoring Through 12c Grid Control?
Jul 11, 2012I 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.?
Enterprise Manager :: Grid Control Installation - 10g
Aug 3, 2011which i can install Grid Control For my 10g databases.
View 2 Replies View RelatedTo Permanently Deactivate Alerts From 12C Grid Control
Oct 15, 2013I want to permanently de activate alerts from 12C grid control so i do not get email anymore.
View 4 Replies View RelatedEnterprise Manager :: Upgrade 11g Grid Control To 12c Cloud?
May 29, 2013Now 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.
Enterprise Manager :: How To Add Standby Monitoring On Grid Control
Mar 5, 2011I 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 RelatedEnterprise Manager :: Install Error Grid Control 10.2.0.1 On Sun
Jan 7, 2010I 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.
Enterprise Manager :: Grid Control Database Instances Always Down
Jun 11, 2010Installed 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.
Enterprise Manager :: Grid Control 10.2.0.5 Metrics List?
Jun 25, 2010Any 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".
Add OEM Grid Control Server As Target To Be Monitored
Feb 21, 2013I've installed OEM grid control 11.1.0.1.0 on server "A" which has an Oracle Database version 11.2.0.1.The OS on Server "A" is OEL 5.5. The grid control installed on this server is working fine and I've deployed agents on remote hosts which I am able to monitor them successfully using this grid control.
Now I would like to add the server ("A") on which the grid control is installed to be monitored by the grid control. is the same way as we deploy agents on remote hosts, but here the agent is already installed at the time of installing Grid Control.
Real Application Clusters :: Grid Control Agent
May 7, 2013I have a 2 node 11.2.0.3 RAC database, OS version is RHEL 6.1
Our existing grid control server setup is 10gR2.Can i install 10.2.0.5 agent on my RAC servers and use the 10g grid to monitor my 11.2.0.3 database(RHEL 6.1) ?
Enterprise Manager :: 11gR2 Grid Control - SVG Or Flash?
Sep 15, 2011I'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.
Enterprise Manager :: Monitoring Standby Database Using Grid Control
Mar 3, 2008I'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 RelatedAutomatic Storage Management :: Can't Connect RAC ASM Instance Using Grid Control 12c
Nov 19, 2012when i configure monitor target in GC12C,1 find i can not add asm instance target, and i use scan ip in 11GR2 rac ( two nodes )the problem is plublic IP's 1521 port not accept connect request from remote IP
error from gc12c
Failed to connect to the ASM: IO Error: The Network Adapter could not establish the connection The Connect Descriptor was (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.101.78)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)(SERVER=DEDICATED)))
[code]....
how can i let GC12C see ASM instance on each node in cluster??
Install / Use Enterprise Manager Grid Control If Only Have Standard Edition Licenses?
Jul 27, 2011can I install/use Oracle 10g Enterprise Manager Grid Control if my organization has only Oracle 10g Standard Edition Licences.
View 2 Replies View RelatedRAC/ASM Clusterware Installation :: OEM Grid Control Files For Oracle Database 10gR2
Jan 22, 2013I am trying to setup my environment to prepare for hands on DBA exercises from an OCM handbook for 10g -OCM:Oracle Database 10g Administrator Certified Master Exam Guide
I need access to the following files
gc_10205_part1of2.zip, gc_10205_part2of2.zip for 32 bit linux
Apparently the above along with other Grid software was once attainable from the link below but sometime between this year and the last Oracle decided to remove this and other software from public access. URL.....
I doubt Oracle will hear my plea - educational purposes only - so given I want access to the software only.
Enterprise Manager :: Core.xxx Files Generated By Grid Control Agent?
Aug 2, 2010I 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
Enterprise Manager :: Querying Grid Control Tables To Find Size And Name Of Database?
Sep 25, 2012query 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.
Enterprise Manager :: Install Grid Control 11gR1 - SQLException Null Resultset
May 19, 2011I'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
Reports & Discoverer :: Using If Condition To Generate Reports
Nov 19, 2010I need to generate reports in oracle.I want to use if condition in the query. but I'm unable to use if condition in query. how can i use if condition? is there any other method to do this?
View 4 Replies View RelatedReplication :: Oracle Streams / Tried Schema Replication Through Enterprise Manager Grid Control
Feb 22, 2012Actually 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..