How to connect Oracle servers using TNS?

From Navicat Wiki
Jump to: navigation, search

Apply OS : Mac

Apply Navicat Product : Navicat for Oracle, Navicat Premium

Apply Navicat Version No. : Version 11 or above


Please note that Environments tab is removed in Appstore's Navicat version. To change the DYLD_LIBRARY_PATH and TNS_ADMIN file paths, please launch the application through Terminal and type the environment variables.

Version Command
Navicat Premium env TNS_ADMIN=~/Library/Containers/com.prect.NavicatPremium/Data/Library/Application\ Support/PremiumSoft\ CyberTech/ DYLD_LIBRARY_PATH=~/Library/Containers/com.prect.NavicatPremium/Data/Library/Application\ Support/PremiumSoft\ CyberTech/OCI arch -i386 /Applications/Navicat\ Premium.app/Contents/MacOS/Navicat\ Premium
Navicat Premium Essentials env TNS_ADMIN=~/Library/Containers/com.prect.NavicatPremiumEssentials/Data/Library/Application\ Support/PremiumSoft\ CyberTech/ DYLD_LIBRARY_PATH=~/Library/Containers/com.prect.NavicatPremiumEssentials/Data/Library/Application\ Support/PremiumSoft\ CyberTech/OCI arch -i386 /Applications/Navicat\ Premium\ Essentials.app/Contents/MacOS/Navicat\ Premium\ Essentials
Navicat for Oracle env TNS_ADMIN=~/Library/Containers/com.prect.NavicatORA/Data/Library/Application\ Support/PremiumSoft\ CyberTech/ DYLD_LIBRARY_PATH=~/Library/Containers/com.prect.NavicatORA/Data/Library/Application\ Support/PremiumSoft\ CyberTech/OCI arch -i386 /Applications/Navicat\ for\ Oracle.app/Contents/MacOS/Navicat\ for\ Oracle
Navicat Essentials for Oracle env TNS_ADMIN=~/Library/Containers/com.prect.NavicatEssentialsForOracle/Data/Library/Application\ Support/PremiumSoft\ CyberTech/ DYLD_LIBRARY_PATH=~/Library/Containers/com.prect.NavicatEssentialsForOracle/Data/Library/Application\ Support/PremiumSoft\ CyberTech/OCI arch -i386 /Applications/Navicat\ Essentials\ for\ Oracle.app/Contents/MacOS/Navicat\ Essentials\ for\ Oracle


** Before running the command, you need to copy the tnsnames.ora file and instant client to:

Version tnsnames.ora Instant Client
Navicat Premium ~/Library/Containers/com.prect.NavicatPremium/Data/Library/Application Support/PremiumSoft CyberTech/ ~/Library/Containers/com.prect.NavicatPremium/Data/Library/Application Support/PremiumSoft CyberTech/OCI
Navicat Premium Essentials ~/Library/Containers/com.prect.NavicatPremiumEssentials/Data/Library/Application Support/PremiumSoft CyberTech/ ~/Library/Containers/com.prect.NavicatPremiumEssentials/Data/Library/Application Support/PremiumSoft CyberTech/OCI
Navicat for Oracle ~/Library/Containers/com.prect.NavicatORA/Data/Library/Application Support/PremiumSoft CyberTech/ ~/Library/Containers/com.prect.NavicatORA/Data/Library/Application Support/PremiumSoft CyberTech/OCI
Navicat Essentials for Oracle ~/Library/Containers/com.prect.NavicatEssentialsForOracle/Data/Library/Application Support/PremiumSoft CyberTech/ ~/Library/Containers/com.prect.NavicatEssentialsForOracle/Data/Library/Application Support/PremiumSoft CyberTech/OCI