Enterprise Manager :: Config - Enter Price Manager Grid Control For All DB
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
ADVERTISEMENT
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
Aug 3, 2011
which i can install Grid Control For my 10g databases.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Aug 12, 2010
I have installed OUI( Oracle universal insaller) and the with DBCA(Database Configuration Assistant) i have installed the database. Before DBCA completion of Database it give error message like database control not running. When i press OK the DBCA completed and database installed but where it shows the database control url it shows database url is null. when i try to give this url http://sweetdba:1158/em it shows error. why the url is not working. 11g database is working and connected.
View 4 Replies
View Related
Jul 28, 2012
I installed Oracle database 11g enterprise edition. I can connect it through sql plus but Database control is not starting. I have checked dbconsole service which is running.
the address is [URL]...
but mozilla and chrome both are unable to start the application. after installation it started only once. but it is not starting now.
second thing is how can i confirm what is the port of my listener is it 1158 or something else.
View 2 Replies
View Related
Mar 11, 2012
I always thought that Database control and Enterprise manager was synonyms...But I am reading a mock about OCA exam and there it said:
QUOTE You just can apply the pacth binaries using the Database Control and with the oPatch utility, but not with the Enterprise Manager...
But to me Database Control and Enterprise Manager are the same thing...
Are there difference between them?
View 1 Replies
View Related
Aug 13, 2013
Is that possible to copy users without using EM DB-control?
View 1 Replies
View Related
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
View Related
Sep 8, 2010
I'm having a problem with performing backups from EM DB Control on two of my Oracle 10g 10.2.0.4 systems. When I configure and submit any backup job from EM (either online or offline), the following happens:
- When the job is due to run a Pre backup task has status of 'Scheduled'
- Prebackup task completes and status changes to 'Succeeded'
- Backup task appears with status of 'Scheduled' and value of started time within the next minute
- Status of backup task never changes from 'Scheduled', and the started time keeps updating to the current time
- This goes on indefinitely until I abort the job
At the moment I have scheduled tasks configured to run an RMAN job every night, but I need to get this working through Enterprise Manager Database control.
Something else which has happended on one of these systems is that after applying some Microsoft Critical updates the database control service would not start. The only way I could find to resolve this was to recreate the Enterprise Manager repository. Could there be a link here at all?
I've also posted this here: [URL] but with no response so far.
View 4 Replies
View Related
Sep 4, 2013
I have a problem when I install oracle 11g: I did an installation on a win2008 r2 server and everything works fine, I did another installation on another server in the same network as a test, but at the end of the installation I get an alert that says:
start database error control .....
Executing set oracle_unqname and then emctl start dbcontrol.
of course nothing happens.
dbcontrol_nome the service instance will not start. checking the file in your home directory I always acts everything is in place. I reinstalled windows to eliminate all the checks made, repeated installation and here appeared the same problem.
question: can exist 2 oracle installations on the same network with the same name db? I currently have two installations of the same name with oracle db 10
View 3 Replies
View Related
Oct 15, 2010
I am getting an error regarding Starting Database Control. I have multiple databases on the same server but every time I am trying to create a new database I am getting the same error again and again.
View 1 Replies
View Related
