Mac安装Oracle11g客户端

在如下网址下载Oracle Instant Client：

https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html

下载文件，需要登陆才能下载：

instantclient-basic-macos.x64-11.2.0.4.0.zip
instantclient-sqlplus-macos.x64-11.2.0.4.0.zip

解压文件到你的目录，如：~/oracle/instantclient_11_2

设置环境变量

cat << 'EOF' >> ~/.zprofile
# Oracle Client
export ORACLE_HOME=~/oracle/instantclient_11_2
export DYLD_LIBRARY_PATH=$ORACLE_HOME:$PATH
export SQLPATH=$ORACLE_HOME
export PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME:$SQLPATH:$PATH
EOF

. ~/.zprofile

建立tnsnames.ora文件

mkdir -p $ORACLE_HOME/network/admin/
vi $ORACLE_HOME/network/admin/tnsnames.ora

XE =
 (DESCRIPTION = 
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.01)(PORT = 1521))
   )
 (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = XE)
 )
)

Mac还有关闭Gatekeeper，否则会报错“macOS无法验证此App不包含恶意软件”。

sudo spctl --master-disable

执行链接，成功完成链接

% sqlplus system/oracle@127.0.0.1:1521/xe         

SQL*Plus: Release 11.2.0.4.0 Production on Sat Mar 13 22:05:21 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-28002: the password will expire within 7 days



Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> quit

首页 » Mac安装Oracle11g客户端

相关内容