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 file:


Once done, remove these properties.



Verify connection string


For Oracle 11 connection string is



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



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.