Oracle database upgrade step takes long time to complete and no progress seen in the upgrade log
Product(s):
APM Implementation and Performance Management
Version(s):
7
Environment:
N/A
Area:
N/A
Subarea:
N/A
Problem Description
While upgrading an APM Oracle database, the user noticed…
Restore of blank 7.12.5 APM Database in Oracle 12 c fails with error code ORA-60019
Product(s):
APM Implementation and Performance Management
Version(s):
7
Environment:
N/A
Area:
N/A
Subarea:
N/A
Problem Description
User tried to restore a blank APM database (copied from APM…
APM application server errors due to insufficient disk space on database server
Product(s):
APM Implementation and Performance Management
Version(s):
all
Environment:
N/A
Area:
N/A
Subarea:
N/A
Problem Description
APM smart client application server stopped responding…
APM Database management and troubleshooting tips
Product(s):
APM Implementation and Performance Management
Version(s):
All
Environment:
N\A
Area:
Database performance
Subarea:
N\A
Procedure for when DB block is observed:
Run the stored…
Troubleshooting slow performance or hangs due to custom Indexes
Product(s):
APM Implementation and Performance Management
Version(s):
7
Environment:
N/A
Area:
N/A
Subarea:
N/A
Problem
APM Foundation's database contains several indexes out of the box. These…
Frequent odbc communication link failure
Product(s):
APM Implementation and Performance Management
Version(s):
7.x
Environment:
N\A
Area:
N/A
Subarea:
N\A
Problem
Frequent user disconnects and the following error in the server log…
Verifying conversion to UNICODE
Product(s):
APM Implementation and Performance Management
Version(s):
All
Problem
We just performed a conversion of our APM database from ANSI to UNICODE.
How can we verify that the conversion was successful?
Solution…
Changing the database password
APM uses a shared database login rather than Windows authentication to access the database. Consequently you may be required to change that password on a periodic basis. This is certainly a good practice from a security perspective and the process involved…