Tableau error ORA-21561 and solution

[bizzaredm]

Hey there! 

If your users run into this issue 
https://kb.tableau.com/articles/issue/error-ora-21561-oid-generation-failed-connecting-to-oracle-fro...
"Error "ORA-21561: OID generation failed" Connecting to Oracle with a Mac"

Tableau has a solution, edit the hosts file to include local computer name by adding the computer name to the end of the 127.0.0.1 line

Which is wonderful! and helped us out. But we did not want users to have to edit this manually. So we made a script and deployed it to Tableau users via self service.  

This script will add the entry, or remove it if the entry is already there. It uses jamf helper to show the user a nice notification window

#!/bin/bash

# Developed by bizzaredm - 2020
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # 
# SYSTEM VARIABLES
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # 

jamfHelper="/Library/Application Support/JAMF/bin/jamfHelper.app/Contents/MacOS/jamfhelper"
networkConnectIcon="/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/ConnectToIcon.icns"
alertIcon="/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/AlertCautionIcon.icns"
whatsMyHostName=$(hostname)

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # 
# APPLICATION
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # 
 	if grep -q "#This next line is for Tableau." /etc/hosts; then
		#Check for exit code, TODO remove after debug
		echo $?
		echo "Redirect exists for Tableau, removing..."
  	 	# Remove line
		awk '/Tableau/ {while (/Tableau/ && getline>0) ; next} 1' /etc/hosts > /etc/hostscleaned
		mv /etc/hosts /etc/host.bak
		mv /etc/hostscleaned /etc/hosts
 		# Reset DNS
 	   	#/usr/bin/killall -HUP mDNSResponder
  		windowType="hud"     #   [hud | utility | fs]
		windowPosition="" #   [ul | ll | ur | lr]
		title="Host Updater"          #   "string"
		heading=""            #   "string"
		description="Host Tableau Entry Removed"        #   "string"
		icon="$networkConnectIcon"               #   path
		iconSize="125"           #   pixels
		timeout=""            #   seconds
    
		"$jamfHelper" -windowType "$windowType" -windowPosition "$windowPosition" -title "$title" -heading "$heading" -description "$description"  -icon "$icon" -iconSize "$iconSize" -button1 Okay -defaultButton 1 -cancelButton "0" -countdown "$timeout" -timeout "$timeout"

	else
	
    	echo "Redirect does not exist for Tableau, adding it now..."
    	# Add redirect
		echo "#This next line is for Tableau." >> /etc/hosts
    	echo "127.0.0.1 localhost" "$whatsMyHostName" >> /etc/hosts
    	# Reset DNS
  		#/usr/bin/killall -HUP mDNSResponder
   		windowType="hud"     #   [hud | utility | fs]
		windowPosition="" #   [ul | ll | ur | lr]
		title="Host Updater"          #   "string"
		heading=""            #   "string"
		description="Host Tableau Entry Added"        #   "string"
		icon="$networkConnectIcon"               #   path
		iconSize="125"           #   pixels
		timeout=""            #   seconds
		"$jamfHelper" -windowType "$windowType" -windowPosition "$windowPosition" -title "$title" -heading "$heading" -description "$description"  -icon "$icon" -iconSize "$iconSize" -button1 Okay -defaultButton 1 -cancelButton "0" -countdown "$timeout" -timeout "$timeout"
	fi