Oracle Enterprise Manager Messages Manual

Library

Product

Contents

Index

Oracle TopSessions Messages

VMS-00000 to VMS-00999: Critical Errors
VMS-01000 to VMS-01999: Not So Critical Errors
VMS-02000 to VMS-02999: Informational Messages

VMS-00000 to VMS-00999: Critical Errors

VMS-00001 Failed to create empty document.

Cause Could not create a document.

Action Reinstall the Performance Pack.

VMS-00002 OLE initialization failed; check version of OLE libraries.

Cause The AfxOleInit system call failed.

Action Check your version of the OLE libraries.

VMS-00003 Unable to access public synonym name. Cannot proceed further. Press Retry to reconnect.

Cause A critical public synonym could not be accessed because it either does not exist or the user does not have permissions to access it.

Action Ask your system administrator to run the script CATALOG.SQL.

VMS-00004 Unable to access public synonyms. Cannot proceed further. Press Retry to reconnect.

Cause The v$session, v$sesstat, v$statname public synonyms could not be accessed. The synonyms either do not exist or the user does not have permissions to access them.

Action Ask your system administrator to run the script CATALOG.SQL.

VMS-01000 to VMS-01999: Not So Critical Errors

VMS-01000 Unable to access public synonym V$OPEN_CURSOR. Cannot show open cursors.

Cause Either v$open_cursor does not exist or the user does not have the necessary permissions to access it.

Action Ask your system administrator to run the script CATALOG.SQL.

VMS-01001 Unable to access public synonym V$SQLTEXT. Cannot show explain plan.

Cause Either v$sqltext does not exist or the user does not have the necessary permissions to access it.

Action Ask your system administrator to run the script CATALOG.SQL.

VMS-01002 Unable to access public synonym V$LOCK. Cannot show locks information.

Cause Either v$lock not exist or the user does not have the necessary permissions to access it.

Action Ask your system administrator to run the script CATALOG.SQL.

VMS-01003 Unable to access public synonym SYS.DBA_WAITERS. Cannot show blocked sessions.

Cause It either does not exist or the user does not have the necessary permissions to access it.

Action Ask your system administrator to run the script CATBLOCK.SQL and grant you SELECT privilege on all columns of the views DBA_WAITERS and DBA_LOCKS.

VMS-01004 Unable to access table SYS.PLAN_TABLE. Cannot show explain plan.

Cause Either sys.plan_table does not exist or the user does not have the necessary permissions to access it.

Action Ask your system administrator to run UTLXPLAN.SQL and grant you SELECT, INSERT and DELETE privileges on all columns of this table.

VMS-01005 Unable to access public synonym DBA_OBJECTS. Cannot show blocked sessions.

Cause Either dba_objects does not exist or the user does not have the necessary permissions to access it.

Action Ask your system administrator to run the script CATALOG.SQL.

VMS-01006 Cannot access DBA_WAITERS and SYS.PLAN_TABLE. Cannot show blocked sessions and explain plan.

Cause Either sys.plan_table does not exist or the user does not have the necessary permissions to access it.

Action Ask your system administrator to run the script CATALOG.SQL and UTLXPLAN.SQL; to grant you the SELECT privilege on all columns of DBA_WAITERS; and to grant you SELECT, INSERT and DELETE privileges on all columns of SYS.PLAN_TABLE.

VMS-01014 Cannot verify if SYS.DBA_WAITERS and SYS.PLAN_TABLE are accessible. Assuming they are accessible.

Cause Unable to verify whether SYS.DBA_WAITERS and SYS.PLAN_TABLE are accessible.

Action None.

VMS-01015 Unable to access public synonym V$ROLLNAME. Cannot show locks information.

Cause Unable to access v$rollname public synonym. It either does not exist or you do not have permissions to access it.

Action Ask your system administrator to run the script CATALOG.SQL.

VMS-01016 Unable to access public synonym AUDIT_ACTIONS. Cannot show session commands.

Cause Unable to access audit_actions public synonym. It either does not exist or you do not have permissions to access it.

Action Ask your system administrator to run the script CATALOG.SQL.

VMS-02000 to VMS-02999: Informational Messages

VMS-02000 Query returned no rows.

Cause No rows were returned when the query was executed.

Action None.

VMS-02001 No data available.

Cause The query did not return any data.

Action None.

VMS-02002 The Name field must be supplied.

Cause Name field validation failed.

Action Enter a name in the appropriate field.

VMS-02003 The Password field must be supplied.

Cause Password field validation failed.

Action Enter a password in the appropriate field.

VMS-02004 Cannot explain plan for non-DML commands

Cause Explain plans can be shown only for SELECT, UPDATE and DELETE commands.

Action None.

VMS-02005 Close Oracle TopSessions?

Cause Confirm if you really want to close TopSessions application.

Action Press YES to exit or NO to continue.

VMS-02006 Data will be lost if you disconnect this session. Disconnect from database?

Cause Confirm if you really want to change database connection.

Action Press YES to proceed.

VMS-02007 Kill this session?

Cause Confirm if you really want to kill this session.

Action Press YES to proceed.

VMS-02008 Please connect to the database and retry the operation.

Cause Not connected to the database.

Action Connect to the database and retry the operation.

VMS-02009 Increasing the session refresh interval to a more reasonable length.

Cause Automatic session refresh interval too small.

Action Choose a greater session refresh interval length.

Prev Next

Library

Product

Contents

Index