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"
Last Modified Date: 10 Mar 2018
"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
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>
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.Additional Information
Setting an Oracle Connection to Use TNSNames.ora or LDAP.oraThank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials