My Oracle Support Banner Fails When Using Non Sysman Database User (Doc ID 1934475.1)

Last updated on JULY 26, 2019

Applies to:

APM - Application Performance Management - Version and later
Information in this document applies to any platform.


After running to create the JVMDIAG schema in JVMD, when running the script to load the heap dumps in repository it fails with following errors -

Interactive Mode
TMPDIR and TMP are not set. Defaulting to /tmp
Please verify that there is enough space in /tmp. It usually requires a few GB of space to load a heap
Script for JVM_DIAGNOSTICS load heap

Enter Heap Dump File Name? :
Load heap data to repository after heap analysis(y,Y), or just generate heap reports(n)?: [y]

Writing objects
Disable Heapobj indexes
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(
at oracle.jdbc.driver.OracleStatement.executeUpdate(
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(
at oracle.sysman.e2e.loadheap.persistence.DBUtil.disableHeapobjIndexes(
at oracle.sysman.e2e.loadheap.HeapGraph.finalPass(
at oracle.sysman.e2e.loadheap.loadHeap.main(
Error processing file <FILENAME>




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.