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

Last updated on APRIL 18, 2018

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 -

[oracle@oemdb-test loadheap]$ ./
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 heapdump__DEVELOP_dev_dev_ms12-b_jvm_1404715645794.txt


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

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

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