Home » RDBMS Server » Enterprise Manager » Problem in Oracle EM (Database Limits - Current Open Cursors) ( Oracle Enterprise Manager Database Control 10.2.0.0)
Problem in Oracle EM (Database Limits - Current Open Cursors) [message #502919] Mon, 11 April 2011 10:33 Go to next message
MarkusW
Messages: 20
Registered: June 2009
Location: Austria
Junior Member
Hi everyone,

I have a problem in Oracle Enterprise Manager in All Metrics.

When I select in All Metrics e.g. Health Check > Maintenance it work's fine and I see a chart.

If I select in All Metrics > Database Limits > Current Open Cursors Count I got following error:

Error
oracle.sysman.dbTarget.db.emSDKOverride.page.mtrx.GetDataException: ORA-06550: Zeile 79, Spalte 16: PL/SQL: ORA-00942: Tabelle oder View nicht vorhanden ORA-06550: Zeile 51, Spalte 7: PL/SQL: SQL Statement ignored


What's the problem?

In this database instance i drop these users (schemas): dbuser, mddata, ordplugins, ordsys, si_informtn_schema!!

Can this lack of user to cause an error?

Oracle Enterprise Manager Database Control 10.2.0.0
Database instance: myDB > All Metrics > Database Limits > Current Open Cursors Count

Thanks.
Mark
Re: Problem in Oracle EM (Database Limits - Current Open Cursors) [message #502920 is a reply to message #502919] Mon, 11 April 2011 10:40 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What are the privileges and roles of the account you are connected with?

Regards
Michel
Re: Problem in Oracle EM (Database Limits - Current Open Cursors) [message #502921 is a reply to message #502920] Mon, 11 April 2011 10:41 Go to previous messageGo to next message
Michel Cadot
Messages: 60018
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select privilege from dba_sys_privs where grantee='YOUR USER' order by 1;
select granted_role, default_role from dba_role_privs where grantee='YOUR USER' order by 1;

Regards
Michel

[Updated on: Mon, 11 April 2011 10:42]

Report message to a moderator

Re: Problem in Oracle EM (Database Limits - Current Open Cursors) [message #502922 is a reply to message #502921] Mon, 11 April 2011 10:53 Go to previous messageGo to next message
MarkusW
Messages: 20
Registered: June 2009
Location: Austria
Junior Member
Hi,

I connect with user 'SYS' and Connect as 'SYSDBA'.

select privilege from dba_sys_privs where grantee='SYS' order by 1;

PRIVILEGE                       
------------------------------  
ADMINISTER ANY SQL TUNING SET   
ADMINISTER DATABASE TRIGGER     
ADMINISTER RESOURCE MANAGER     
ADMINISTER SQL TUNING SET       
ADVISOR                         
ALTER ANY CLUSTER               
ALTER ANY DIMENSION             
ALTER ANY EVALUATION CONTEXT    
ALTER ANY INDEX                 
ALTER ANY INDEXTYPE             
ALTER ANY LIBRARY               
ALTER ANY MATERIALIZED VIEW     
ALTER ANY OUTLINE               
ALTER ANY PROCEDURE             
ALTER ANY ROLE                  
ALTER ANY RULE                  
ALTER ANY RULE SET              
ALTER ANY SEQUENCE              
ALTER ANY SQL PROFILE           
ALTER ANY TABLE                 
ALTER ANY TRIGGER               
ALTER ANY TYPE                  
ALTER DATABASE                  
ALTER PROFILE                   
ALTER RESOURCE COST             
ALTER ROLLBACK SEGMENT          
ALTER SESSION                   
ALTER SYSTEM                    
ALTER TABLESPACE                
ALTER USER                      
ANALYZE ANY                     
AUDIT ANY                       
AUDIT SYSTEM                    
BACKUP ANY TABLE                
BECOME USER                     
CHANGE NOTIFICATION             
COMMENT ANY TABLE               
CREATE ANY CLUSTER              
CREATE ANY CONTEXT              
CREATE ANY DIMENSION            
CREATE ANY DIRECTORY            
CREATE ANY EVALUATION CONTEXT   
CREATE ANY INDEX                
CREATE ANY INDEXTYPE            
CREATE ANY JOB                  
CREATE ANY LIBRARY              
CREATE ANY MATERIALIZED VIEW    
CREATE ANY OPERATOR             
CREATE ANY OUTLINE              
CREATE ANY PROCEDURE            
CREATE ANY RULE                 
CREATE ANY RULE SET             
CREATE ANY SEQUENCE             
CREATE ANY SQL PROFILE          
CREATE ANY SYNONYM              
CREATE ANY TABLE                
CREATE ANY TRIGGER              
CREATE ANY TYPE                 
CREATE ANY VIEW                 
CREATE CLUSTER                  
CREATE DATABASE LINK            
CREATE DIMENSION                
CREATE EVALUATION CONTEXT       
CREATE EXTERNAL JOB             
CREATE INDEXTYPE                
CREATE JOB                      
CREATE LIBRARY                  
CREATE MATERIALIZED VIEW        
CREATE OPERATOR                 
CREATE PROCEDURE                
CREATE PROFILE                  
CREATE PUBLIC DATABASE LINK     
CREATE PUBLIC SYNONYM           
CREATE ROLE                     
CREATE ROLLBACK SEGMENT         
CREATE RULE                     
CREATE RULE SET                 
CREATE SEQUENCE                 
CREATE SESSION                  
CREATE SYNONYM                  
CREATE TABLE                    
CREATE TABLESPACE               
CREATE TRIGGER                  
CREATE TYPE                     
CREATE USER                     
CREATE VIEW                     
DEBUG ANY PROCEDURE             
DEBUG CONNECT SESSION           
DELETE ANY TABLE                
DEQUEUE ANY QUEUE               
DROP ANY CLUSTER                
DROP ANY CONTEXT                
DROP ANY DIMENSION              
DROP ANY DIRECTORY              
DROP ANY EVALUATION CONTEXT     
DROP ANY INDEX                  
DROP ANY INDEXTYPE              
DROP ANY LIBRARY                
DROP ANY MATERIALIZED VIEW      
DROP ANY OPERATOR               
DROP ANY OUTLINE                
DROP ANY PROCEDURE              
DROP ANY ROLE                   
DROP ANY RULE                   
DROP ANY RULE SET               
DROP ANY SEQUENCE               
DROP ANY SQL PROFILE            
DROP ANY SYNONYM                
DROP ANY TABLE                  
DROP ANY TRIGGER                
DROP ANY TYPE                   
DROP ANY VIEW                   
DROP PROFILE                    
DROP PUBLIC DATABASE LINK       
DROP PUBLIC SYNONYM             
DROP ROLLBACK SEGMENT           
DROP TABLESPACE                 
DROP USER                       
ENQUEUE ANY QUEUE               
EXECUTE ANY CLASS               
EXECUTE ANY EVALUATION CONTEXT  
EXECUTE ANY INDEXTYPE           
EXECUTE ANY LIBRARY             
EXECUTE ANY OPERATOR            
EXECUTE ANY PROCEDURE           
EXECUTE ANY PROGRAM             
EXECUTE ANY RULE                
EXECUTE ANY RULE SET            
EXECUTE ANY TYPE                
EXPORT FULL DATABASE            
FLASHBACK ANY TABLE             
FORCE ANY TRANSACTION           
FORCE TRANSACTION               
GLOBAL QUERY REWRITE            
GRANT ANY OBJECT PRIVILEGE      
GRANT ANY PRIVILEGE             
GRANT ANY ROLE                  
IMPORT FULL DATABASE            
INSERT ANY TABLE                
LOCK ANY TABLE                  
MANAGE ANY FILE GROUP           
MANAGE ANY QUEUE                
MANAGE FILE GROUP               
MANAGE SCHEDULER                
MANAGE TABLESPACE               
MERGE ANY VIEW                  
ON COMMIT REFRESH               
QUERY REWRITE                   
READ ANY FILE GROUP             
RESTRICTED SESSION              
RESUMABLE                       
SELECT ANY SEQUENCE             
SELECT ANY TABLE                
SELECT ANY TRANSACTION          
UNDER ANY TABLE                 
UNDER ANY TYPE                  
UNDER ANY VIEW                  
UNLIMITED TABLESPACE            
UPDATE ANY TABLE                


select granted_role, default_role from dba_role_privs where grantee='SYS' order by 1;

GRANTED_ROLE              DEFAULT_ROLE  
------------------------  ------------  
AQ_ADMINISTRATOR_ROLE     YES           
AQ_USER_ROLE              YES           
AUTHENTICATEDUSER         YES           
CONNECT                   YES           
CTXAPP                    YES           
DBA                       YES           
DELETE_CATALOG_ROLE       YES           
EJBCLIENT                 YES           
EXECUTE_CATALOG_ROLE      YES           
EXP_FULL_DATABASE         YES           
GATHER_SYSTEM_STATISTICS  YES           
HS_ADMIN_ROLE             YES           
IMP_FULL_DATABASE         YES           
JAVA_ADMIN                YES           
JAVADEBUGPRIV             YES           
JAVA_DEPLOY               YES           
JAVAIDPRIV                YES           
JAVASYSPRIV               YES           
JAVAUSERPRIV              YES           
LOGSTDBY_ADMINISTRATOR    YES           
MGMT_USER                 YES           
OEM_ADVISOR               YES           
OEM_MONITOR               YES           
OLAP_DBA                  YES           
OLAP_USER                 YES           
RECOVERY_CATALOG_OWNER    YES           
RESOURCE                  YES           
SCHEDULER_ADMIN           YES           
SELECT_CATALOG_ROLE       YES           
XDBADMIN                  YES           
XDBWEBSERVICES            YES          



Regards
Mark
Re: Problem in Oracle EM (Database Limits - Current Open Cursors) [message #503144 is a reply to message #502922] Wed, 13 April 2011 04:04 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>ORA-00942: Tabelle oder View nicht vorhanden

Do you know which table is looking for ? Have you seen the logs?

What's the reason you dropped "ordsys" schema?

Babu
Re: Problem in Oracle EM (Database Limits - Current Open Cursors) [message #503169 is a reply to message #503144] Wed, 13 April 2011 05:58 Go to previous messageGo to next message
MarkusW
Messages: 20
Registered: June 2009
Location: Austria
Junior Member
Hi,

I've got some log files from the database server.


/oracle/oracle10g/product/10.2.0/Db_1/solv250_myDB/sysman/log/emagent.trc

2011-04-13 12:36:16 Thread-1 WARN command: Job Subsystem Timeout set at 600 seconds
2011-04-13 12:36:16 Thread-1 WARN upload: Upload manager has no Failure script: disabled
2011-04-13 12:36:16 Thread-1 WARN upload: Recovering left over xml files in upload directory
2011-04-13 12:36:16 Thread-1 WARN upload: Recovered 6 left over xml files in upload directory
2011-04-13 12:36:17 Thread-1 WARN metadata: Metric Disk_Path does not have any data columns
2011-04-13 12:36:17 Thread-1 WARN metadata: Metric osm_diskGroupPolicies does not have any data columns
2011-04-13 12:36:19 Thread-13 ERROR upload: Error in uploadXMLFiles. Trying again in 60,00 seconds.
2011-04-13 12:36:43 Thread-16 ERROR util.files: nmeufile_getLength: Error in lfilen. Error = 2 (Datei oder Verzeichnis nicht gefunden)
2011-04-13 12:38:19 Thread-48 WARN vpxoci: OCI Error -- ErrorCode(6550): ORA-06550: Zeile 79, Spalte 16:
PL/SQL: ORA-00942: Tabelle oder View nicht vorhanden
ORA-06550: Zeile 51, Spalte 7:
PL/SQL: SQL Statement ignored

SQL = "/* OracleOEM */
DECLARE
metric_category_var VARCHAR2(80);
m"...
LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sol100)(PORT=1522))(CONNECT_DATA=(SID=myDB)))
2011-04-13 12:38:19 Thread-48 ERROR fetchlets.sql: ORA-06550: Zeile 79, Spalte 16:
PL/SQL: ORA-00942: Tabelle oder View nicht vorhanden
ORA-06550: Zeile 51, Spalte 7:
PL/SQL: SQL Statement ignored
2011-04-13 12:38:19 Thread-48 ERROR engine: [oracle_database,myDB,summary_AWR] : nmeegd_GetMetricData failed : ORA-06550: Zeile 79, Spalte 16:
PL/SQL: ORA-00942: Tabelle oder View nicht vorhanden
ORA-06550: Zeile 51, Spalte 7:
PL/SQL: SQL Statement ignored

2011-04-13 12:38:19 Thread-48 WARN Dispatcher: [oracle_database,myDB,summary_AWR] Returning errcode 12 with error ORA-06550: Zeile 79, Spalte 16:
PL/SQL: ORA-00942: Tabelle oder View nicht vorhanden
ORA-06550: Zeile 51, Spalte 7:
PL/SQL: SQL Statement ignored
as internal error


/oracle/oracle10g/product/10.2.0/Db_1/solv250_myDB/sysman/log/emdb.nohup


----- Wed Apr 13 12:34:42 2011::DBConsole. Monitoring Agent+Console -----
----- Wed Apr 13 12:34:42 2011::Console Launched with PID 27018 at time Wed Apr 13 12:34:42 2011 -----
11/04/13 12:35:09 Oracle Application Server Containers for J2EE 10g (9.0.4.1.0) initialized
----- Wed Apr 13 12:36:15 2011::Agent Launched with PID 27303 at time Wed Apr 13 12:36:15 2011 -----
(pid=27303): starting emagent version 10.1.0.4.1
11/04/13 12:37:46 ## oracle.sysman.db.adm.inst.SitemapController: event="doLoad"
11/04/13 12:37:46 ## 1. newPage = /database/instance/sitemap/sitemap
11/04/13 12:37:46 ## 2. newPage = /database/instance/sitemap/sitemap
11/04/13 12:38:19 oracle.sysman.emSDK.emd.comm.MetricGetException: ORA-06550: Zeile 79, Spalte 16: PL/SQL: ORA-00942: Tabelle oder View nicht vorhande
n ORA-06550: Zeile 51, Spalte 7: PL/SQL: SQL Statement ignored
11/04/13 12:38:19 at oracle.sysman.emSDK.emd.comm.ResponseHandler.startElement(ResponseHandler.java:289)
11/04/13 12:38:19 at oracle.sysman.emSDK.xml.MultiHandler.startElement(MultiHandler.java:198)
11/04/13 12:38:19 at org.xml.sax.helpers.ParserAdapter.startElement(ParserAdapter.java:597)
...


/oracle/oracle10g/product/10.2.0/Db_1/solv250_myDB/sysman/log/emoms.log

2011-04-13 12:38:19,328 [EMUI_12_38_18_/console/database/monitoring/metricDetail$type=oracle*_database$target=myDB$pageType=byDay$metricColumn=opencu
rsors$metric=Database*_Resource*_Usage] ERROR metrics.MetricDetailDataObject getDetailData.1828 - ORA-06550: Zeile 79, Spalte 16: PL/SQL: ORA-00942: T
abelle oder View nicht vorhanden ORA-06550: Zeile 51, Spalte 7: PL/SQL: SQL Statement ignored
oracle.sysman.dbTarget.db.emSDKOverride.page.mtrx.GetDataException: ORA-06550: Zeile 79, Spalte 16: PL/SQL: ORA-00942: Tabelle oder View nicht vorhand
en ORA-06550: Zeile 51, Spalte 7: PL/SQL: SQL Statement ignored
at oracle.sysman.dbTarget.db.console.databeans.DetailAwrDB.populate(DetailAwrDB.java:168)
at oracle.sysman.dbTarget.db.emlOverride.mntr.metrics.MetricDetailDataObject.getDetailData(MetricDetailDataObject.java:1118)
...


Since I do not interMedia needed, I deleted this schema.


Regards
Markus
Re: Problem in Oracle EM (Database Limits - Current Open Cursors) [message #503184 is a reply to message #503169] Wed, 13 April 2011 07:14 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Ok. Then you may have to re-create OEM DB Console
Re: Problem in Oracle EM (Database Limits - Current Open Cursors) [message #503731 is a reply to message #503184] Tue, 19 April 2011 04:05 Go to previous message
MarkusW
Messages: 20
Registered: June 2009
Location: Austria
Junior Member
Hi,

I created the new OEM DB Console, but after a restart I got another different error messages.
So I export my DB schema and create a new database instance.

Thanks for any help.

Regards
Markus
Previous Topic: IOException in sending Request :: Connection refused: connect "
Next Topic: Enterprise Console Message Interperation
Goto Forum:
  


Current Time: Mon Dec 22 21:46:41 CST 2014

Total time taken to generate the page: 0.04837 seconds