KNOWLEDGE BASE

Error "ORA-12154 TNS could not resolve the connect id" When Refreshing an Oracle extract on Tableau Server for Linux


Published: 08 Jan 2018
Last Modified Date: 10 Mar 2018

Issue

When refreshing an Oracle extract on Tableau Server for Linux, the following error may occur:

"ORA-12154 TNS could not resolve the connect id"

Environment

  • Tableau Server for Linux
  • Oracle

Resolution

Update the path for the tabsvc service, manually restart the tabcsv server, and restart tsm:
  • Add the following to /etc/systemd/system/tabsvc_0.service:
[Service]
Environment=TNS_ADMIN=<client_root>/network/admin
  • Restart the service and TSM by executing these commands in a bash shell:
sudo systemctl daemon-reload
sudo systemctl restart tabsvc_0.service
tsm login -u <username> -p <password>
tsm restart --request-timeout <timeout>

Cause

The environment variables needed for an Oracle tsnames connection have not been set properly.
Did this article resolve the issue?