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'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 RelatedI've checked ALL the parameters. It seems to be OK.The db is running and OK.But when I try to configure the EM I get the following error Says that the databse instance is not available.But, tnsping works ok, and I can connect as sys without problems. the DB is OK.
EMCA iniciado en 12-dic-2010 12:54:17
Asistente de Configuraci¾n EM, Versi¾n 11.2.0.0.2 Producci¾n
Copyright (c) 2003, 2005, Oracle. Todos los Derechos Reservados.
[code]....
When login i'm getting error : Details Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin).
I have checked DBCONSOLE & AGENT are running properly.
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_SID=infoddp
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOME=/opt/oracle/product/11.2.0
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOSTNAME=liteningv
litening:/opt/oracle/product/11.2.0/bin>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
[code].....
I'm have in Oracle version Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production:
while enter in a command
$emctl status dbconsole
output comes:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Oracle Enterprise Manager 10g is running.
----------------------------------------------------------------------------------
$emctl stop dbconsole
output comes:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
-----------------------------------------------------------------------------------
$emctl start dbconsole
output comes:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
- An instance of Oracle Enterprise Manager 10g Database Control is already running.
-----------------------------------------------------------------------------------
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.?
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 Relatedi 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.
how to create database instance using database template file(.dbt) while running DBCA?
View 1 Replies View RelatedI create an instance with oracle scripts,.. postDBCreation.sql :
-SERVICE_NAME cag1.crick.cagis.gov should be cag1.mycrof.cagis.gov .... ultraSearchCfg.sql SERVICE_NAME=cag1.crick.cagis.gov should be ca1.mycrof.cagis.gov .. Impact: All DBlinks show as LINKNAME.CRICK.CAGIS.GOV and this instance is labeled CAG1.CRICK.CAGIS.GOV in the Grid Control Console.
I have created a new instance with address
[URL].......
Now ideally I would like to change this so I can access this from another a machine. Is this possible? Or do I have start from scratch?
I've tried to configure Connection Manager but i fails on TNS-04012: Unable to start Oracle Connection Manager instanceThis is my configuration (
CMAN1=(CONFIGURATION=
(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1522))
(RULE_LIST=
(RULE=(SRC=*)(DST=<IP>)(SRV=*)(ACT=accept))))
[code]...
I attempt to log to the Enterprise Manager via --> [URL] but I only receive the 'Page not found' error
As this is on a windows server I attempt to restart the service to no avail Also I try to start emctl start dbconsole - whcih also does not work
The Listener is up and running
If I issue a emctl status oms - I receive error Oracle Enterprise Manager 10g Grid Control not installed. Request Ignored.
with --> emctl status dbconsole
output is Oracle Enterprise Manager 10g is not running.
Logfiles:
Logs are generated in directory D:\oracle\product\10.2.0\db_1/ukedgas71.pcroot.com_OEMREP/sysman/log
Logfiles:
Directory of D:\oracle\product\10.2.0\db_1\UKEDGAS71.pcroot.com _OEMREP\sysman\log
20/04/2011 15:06 10,297 emagent.log
05/06/2009 09:48 0 emagentfetchlet.log
05/06/2009 09:46 0 emdctl.log
20/04/2011 15:05 6,363,995 emoms.log
20/04/2011 15:14 29 OracleDBConsoleOEMREPexit.log
20/04/2011 15:14 188,284 OracleDBConsoleOEMREPsrvc.log
05/06/2009 09:46 4,383 secure.log
7 File(s) 6,566,988 bytes
Tracefiles:
Directory of D:\oracle\product\10.2.0\db_1\UKEDGAS71.pcroot.com _OEMREP\sysman\log
20/04/2011 15:14 1,418,777 emagent.trc
05/06/2009 09:48 0 emagentfetchlet.trc
28/11/2009 16:21 8,360 emagent_perl.trc
21/04/2011 11:12 2,060,670 emdctl.trc
20/04/2011 15:05 1,649,464 emoms.trc
5 File(s) 5,137,271 bytes
0 Dir(s) 3,274,207,232 bytes free
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 = ).
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
/u01/app/oracle/product/10.2.0/db_1/jhlinux.home.com_orcl/sysman/log/emoms.log
2010-06-04 23:33:59,809 [HttpRequestHandler-8546123] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://jhlinux.home.com:3938/emd/main)(ERROR = INTERNAL_ERROR)
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?
For one of the server, we are able to start the agent but the status showing is UNKNOWN. So all the targets (50+) in Unknown state.
In the grid its in Blocked agent. We tried to unblock and did the Agent Resynchronization for this. At the end getting below error message as
Thread-9668 ERROR ThreadPool: Could not create thread, ERROR=12:Not enough space
In the emagent.log seeing below error
2010-11-12 21:03:48,950 Thread-9966 <Scheduler> Error Creating Thread for Upload Manager, OS threads exhausted (00951)
OS - AIX
DB Version - 10g
Agent version - 10g
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>
===========================================================
logfile attached for your reference.
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 RelatedWe 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
I have an issue with restoring a RMAN backup that i have with me to a new database instance. What i have with me are: 1. Backup of SPFile.
(O1_MF_NCNNF_CTLFILE_BU_92DVGYO2_.BKP)2. Backup of Control file (O1_MF_NNSNF_SPFILE_BU_92DVGW9H_.BKP)3. Full database backup (O1_MF_NNSNF_FULLPROD_BU_92DVGW9H_.BKP)
I have received these files from a customer environment and I need to restore these to a new database instance in a local machine. I have given a attempt as follows (in Oracle 10g): 1, Created a new database instance (Test75) using Oracle Database Configuration Assistant2. SET ORACLE_SID = Test753. Connected to this instance using RMAN4. Tried to restore the SPFILE from the received BKP file.I am getting errors and cannot proceed. I am not sure whether I am executing the correct steps.
I will begin to install Oracle Clusterware (11gR2), but I need to know how much space should I apply for the ASM instance? What size should I apply the shared disk to the nodes?
View 5 Replies View RelatedI have intsalled oracle client 9i.I add my services into tnsnames.ora .I could connect in sqlplus but in Enterprise manager i receive error ora12154 tns could not resolve service name!
View 4 Replies View RelatedI have two differenct databases with nsame name. Database 1 named DBX is on server SERVERX used for dev Database 2 named DBX is on server SERVERY used for test
I want to install OEM Agent on both server and access from one single OEM 11g Grid control.
What I find is that, the OEM seems to get confused when I try to login to the A database from OEM.
How should I configure OEM or Agent so that OEM can be used to login to both DBs?
I have oracle9i installed on my system.. i have created a database using enterprise manger console..
Now i want to export this database for the purpose of backup.. so that i can import it later.
What database version is supported as a repository for 10g OMS?
View 5 Replies View RelatedI 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 RelatedI would like to export my whole database every evening. How can I do this using enterprise manager.
View 4 Replies View RelatedI 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.
I need to copy all the database objects from one database to another database.I have 32 bit windows environment I tried export and put it in a dump file but dump file size exceeds the limit, my database size is about 300 GB.
What would be efficient way to replicate all the database objects move to another box ..?