Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

DataWarehouse Refresh job failed with error “ORA-12505, TNS:listener does not currently know of SID given in connect descriptor”

  1. Last updated
  2. Save as PDF

DataWarehouse job failed with error “ORA-12505, TNS:listener does not currently know of SID given in connect descriptor”

1.       If you are unable to connect to database from sql developer installed on your machine, Open Command Prompt as an administrator and Type 'lsnrctl status' and press enter.
If there are any errors after this command, Please try starting the listener by typing 'lsnrctl start' and press enter. This should start the listener.
Once this is successful, Run the refresh job again.

If error still occurs, Restart the Oracle service, making sure the listener service is already running. The error typically can happen if the database is started before the listener.  This is the most likely scenario if no settings have been changed in the DW configuration. Run the refresh job to check if the error is cleared.

2.   If the issue still persists, Please route to ORACLE_HOME/network/admin and check if tnsnames.ora has the correct connection information.
Check the kettle.properties and shared.xml files to see if required DB connections are set in them. ( see https://success.mitratech.com/TeamConnect/TeamConnect_Module_Guides/Data_Warehouse/Using_Data_Warehouse/07_Installing_and_Configuring_Data_Warehouse)

3.   If you are connecting to the database through sql developer by using the          service name, please use service name and if SID is used to connect, use SID in shared.xml file and run the refresh job again. This should resolve the error.

Tags recommended by the template: article:https://success.mitratech.com/TeamCo...Data_Warehouse