如何使用 TNS 连接到 Oracle 服务器?

来自Navicat Wiki
跳转至: 导航搜索

可应用操作系统:Mac

可应用 Navicat 产品:Navicat for Oracle、Navicat Premium

可应用 Navicat 版本编号:版本 11 或以上


请注意,环境选项卡已从 Appstore 版本的 Navicat 中移除。如要改变 DYLD_LIBRARY_PATH 和 TNS_ADMIN 文件路径,请通过终端启动应用程序并输入环境变量。

版本 命令
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


** 在运行命令之前,你需要将 tnsnames.ora 文件和 Instant Client 复制到:

版本 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