32
Oracle TopSessions 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-01007: System failed to allocate a timer.

Cause: A timer could not be obtained from the system.

Action: Try closing other applications which use timers.

VMS-01008: Failed to connect to database.

Cause: A database session could not be opened.

Action: Specify a different username, password, or connect string.

VMS-01009: File topsess.opt not found.

Cause: Could not find the options file topsess.opt.

Action: Specify default options and continue. Oracle TopSessions will recreate this file when it exists.

VMS-01010: Trouble reading topsess.opt file.

Cause: Unable to read the options file topsess.opt.

Action: Specify the default options and continue. Oracle TopSessions will recreate this file when it exists.

VMS-01011: Could not write to topsess.opt file.

Cause: Unable to write to the options file topsess.opt file.

Action: The file probably has read-only permissions, or you may be out of hard disk space.

VMS-01012: Could not serialize to topsess.opt file.

Cause: Unable to serialize to the options file topsess.opt.

Action: The file probably has read-only permissions, or you may be out of hard disk space.

VMS-01013: Cannot proceed further. Press Retry to reconnect.

Cause: Unable to connect to the database.

Action: Press the retry button to reconnect.

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.

---