Following the installation and correct configuration of Agile and SQL Server the following error was generated when attempting to connect to Agile Administrator: "Login Failed: Unable to connect to the database"
KM-Dim7: How to recover datafiles in the event of 1018-DBIO: connect failed , ora-01092: oracle instance terminated the disconnection forced. error: unable to connect to database
Please gather any applicable information from the list below and contact Dimensions Support for help with this error message. What you need to troubleshoot:
2013/02/11 08:53:58 UTC 1.052 T T885561088 DDeployService::connectToDb: Connecting to database < dbname@sid > on host ... as user <userid>... 2013/02/11 09:03:00 UTC 542.379 T T885561088 DDeployServiceLockImpl::acquire: Error: Unable connect to database < dbname@sid > on host ... in order to lock it.
Error appears when logging into Dimensions Inet 7.x. The message is normally triggered by Inet not being able to connect to Oracle due to an incorrect Oracle port setting in the Dimensions Inet configuration file.
If you are using another port other than 1521 for Oracle connections , check that your Dimensions.properties file is updated with the correct port information. If the connection port for Oracle is defined as something other than the Dimensions default of 1521 and not changed or updated in the Dimensions.properties file, this error is encountered.
