DX Application Performance Management

I am trying to install oracle database schema for 9.7.1.16 cluster. I am getting following error and when I login to database using SQL developer I am not able see any objects, index, tables etc.

in schematools.log

ripts/apm-defaults-oracle-9.7.0.0.sql - delimiter being used: ;
10/25/17 11:55:34.445 AM EDT [INFO] [main] [com.wily.apm.dbutil.SqlExecutor] Successfully Executed sql file apm-defaults-oracle-9.7.0.0.sql
10/25/17 11:55:34.460 AM EDT [INFO] [main] [root] [CreateSchema] - Schema creation complete
10/25/17 11:55:35.141 AM EDT [INFO] [main] [root] [UpgradeSchema] - DBDetails:  hostName: prdexascan.corp.absc.local port: 1521 databaseName: PMON_WAS user: apm_sap_pm1

10/25/17 11:55:35.143 AM EDT [INFO] [main] [root] [UpgradeSchema] - DBType: oracle
10/25/17 11:55:35.144 AM EDT [INFO] [main] [root] [UpgradeSchema] - Desired Version: 9.7.1.0
10/25/17 11:55:35.144 AM EDT [INFO] [main] [root] [UpgradeSchema] - Scripts location: /opt/CA/APM/install/oracle/database-scripts
10/25/17 11:55:35.144 AM EDT [INFO] [main] [root] [UpgradeSchema] - Postgres installation directory: null
10/25/17 11:55:35.890 AM EDT [INFO] [main] [root] [UpgradeSchema] - Current release is: 9.7.1.0
10/25/17 11:55:35.890 AM EDT [INFO] [main] [root] [UpgradeSchema] - Current version is already at desired version
10/25/17 11:55:35.905 AM EDT [INFO] [main] [root] [UpgradeSchema] - Schema creation complete

But in following file I am getting error and still nothing un SQL Developer

Introscope_9.7.1.16_InstallLog.log

CreateTables Failed
                          Status: ERROR
                          Additional Notes: ERROR - Check /opt/CA/APM/install/schematools.log

any idea how to fix it or how I can increase log level to get more detail logs

Probably best to open a ticket on this since all of the logs will need to be analyzed and will likely need your DBA's assistance.

Hi Junaid,

So this is a new install and not an upgrade and you used the 9.7.1 EM installer?

Thanks

Lynn