Skip to content

Instantly share code, notes, and snippets.

@c-l-nguyen

c-l-nguyen/mac_oracle.md

Last active March 31, 2020 16:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save c-l-nguyen/355aa39230ebf6d39d0bbaacc60ba50b to your computer and use it in GitHub Desktop.
Save c-l-nguyen/355aa39230ebf6d39d0bbaacc60ba50b to your computer and use it in GitHub Desktop.
Download ZIP
Set up Oracle client on Mac
Raw
mac_oracle.md 
1. Download basic instant client (and maybe the SQL*Plus package) at
https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html#ic_osx_inst
2. Unzip downloads
3. Mostly follow this tutorial: https://www.talkapex.com/2013/03/oracle-instant-client-on-mac-os-x/
	a. But create an /oracle folder in /usr/local folder instead
	b. Move the unzipped folders to /usr/local/oracle
	c. Put lines in .zshrc file if on macOS Catalina and set zsh as default shell
4. Get the tnsnames.ora file (and maybe the sqlnet.ora file) and move to
/usr/local/oracle/instantclient_19_3/network/admin
5. Go into Datagrip and set up an Oracle connection
	a. Choose TNS as connection type
	b. Under TNSADMIN, search for and point to /usr/local/oracle/instantclient_19_3/network/admin folder
	because it contains the tnsnames.ora files in it
	c. Test connection to see if it works
6. For Tableau to Oracle database connection, need extra setup
	a. Download Oracle drivers at https://www.tableau.com/support/drivers
		i. Might need older version of driver
	b. Tableau's documentation on setting up Oracle connection is wrong. Use this forum post instead
		i. Basically, just add tnsnames.ora file to /etc folder too because this is automatically sourced
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment