APM 10.x - How to create the APM db in Oracle 11gR2
Article ID: 262597
Updated On:
Products
Issue/Introduction
Environment
APM 10.x
Resolution
1. Make sure the Oracle EM is up and running:
2. Connect to the Oracle EM Console UI
3. Select Server > Security > Users
4. Click “Create” button:
5. Enter name=<username>, password=<password> and set profile=DEFAULT
6. Select “Roles” tab,
7. Click “Edit list” button, make sure to select “Connect” and “Resources” Roles, click OK
8. Select “System Privileges” tab
9. Click “Edit List” button, make sure to select “Analyze Any”, “Create Any view”, “Unlimited tablespace” system privileges, then click OK
10. Click OK to create the user
11. Test connectivity using the newly created user, for example:
sqlplus <username>/<password>@<oracle_sid>
SQL*Plus: Release 11.2.0.1.0
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
12. For Oracle 11g r2 and above, the property deferred_segment_creation should be set to false, otherwise apm db creation will fail with the following error in the EM_HOME\install\schematools.log
[ERROR] [main] [com.wily.apm.dbutil.SqlExecutor] Sql error
java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint
violated - parent key not found
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
13, Launch the Introscope EM installer and when ask for the database select Oracle Database.
14. After the installation is completed, you can verify in the Oracle DB that the APM tables have been created as expected
You can use Oracle EM Console UI > Schema > Tables, then enter your schema or user name
Feedback
