Loadheap.sh Fails When Using Non Sysman Database User (Doc ID 1934475.1)

Last updated on MARCH 29, 2017

Applies to:

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

Symptoms

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


[oracle@oemdb-test loadheap]$ ./loadheap.sh
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? :
heapdump__DEVELOP_dev_dev_ms12-b_jvm_1404715645794.txt
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(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:998)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)
at oracle.sysman.e2e.loadheap.persistence.DBUtil.disableHeapobjIndexes(DBUtil.java:529)
at oracle.sysman.e2e.loadheap.HeapGraph.finalPass(HeapGraph.java:1786)
at oracle.sysman.e2e.loadheap.HeapGraph.run(HeapGraph.java:494)
at oracle.sysman.e2e.loadheap.loadHeap.main(loadHeap.java:138)
Error processing file heapdump__DEVELOP_dev_dev_ms12-b_jvm_1404715645794.txt

Cause

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 hundreds of Community platforms