MarcyNunns

Tech Tips: Database Troubleshooting for LISA and DEVTEST

Discussion created by MarcyNunns Employee on Aug 11, 2015
Latest reply on Aug 11, 2015 by Josh_Hendrick

Troubleshoot Invalid Username and/or Password for the Database

 

Add these properties to logging.properties file:

log4j.logger.com.mchange.v2.c3p0=DEBUG

log4j.logger.com.mchange.v2.resourcepool=DEBUG

 

Once done, remove these properties.

 

 

Verify connection string

 

For Oracle 11 connection string is

jdbc:oracle:thin:@[HOST]:1521:[SID]

 

For Oracle 12c connection string is: (:[SID] is deprecated in 12c)

jdbc:oracle:thin:@[HOST]:1521/[SID]

 

Verify Schema

 

Enterprise Dashboard and Registry must each be on a different schema.  Follow the documentation as to supported databases and the recommended size for each.

 

Database Maintenance

 

Make sure your database has regular maintenance which includes checking for signs of corruption in the database, looking for problem areas, verifying it has all the required indexes (compare to DDL delivered with release), removing duplicate records, making sure database is not getting full and checking for any abnormalities in the database that might signal a problem.

Outcomes