| Problem in Oracle EM (Database Limits - Current Open Cursors) [message #502919] |
Mon, 11 April 2011 10:33  |
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 #502922 is a reply to message #502921] |
Mon, 11 April 2011 10:53  |
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 #503169 is a reply to message #503144] |
Wed, 13 April 2011 05:58 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
