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

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>

Note: With Tableau Server 2018.1 (and later releases), the need for sudo privileges has been removed by making use of the systemd capability to run as a user service.
systemctl Commands should be run as the tableau user, and not as root. If you specified a different unprivileged system user during Tableau Server setup, then run the commands as that user.

sudo su -l tableau
systemctl --user daemon-reload
systemctl --user restart tabsvc_0.service
tsm login -u <username> -p <password>
tsm restart --request-timeout <timeout>