AAI Upgrade fails with error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Products

• Automation Analytics & Intelligence

Issue/Introduction

AAI upgrade failed, the upgrade.log shows the error below:

ERROR [common.db.DatabaseConnection] Unable to connect: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
     [java] ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
     [java]  
     [java] 09:12:51.720 DEBUG [common.db.DatabaseConnection] Exception occured
     [java] java.sql.SQLRecoverableException: Listener refused the connection with the following error:
     [java] ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
     [java]  

Environment

Release : 6.4.4

Resolution

Check the config tool->Database tab and verify if the the Database connection is sucessful, by doing a Test connection.

 

If it fails, verify that your Oracle Database is up and running on the server specific, and also verify the hostname for the DB server is correct.

 

Make any necessary updates to the connection and apply the changes.

 

Once the test is successful, you can reattempt the upgrade.