1、下载安装文件

下载地址:https://www.oracle.com/nz/database/technologies/oracle19c-linux-downloads.html

LINUX.X64_193000_client.zip  带图形界面

LINUX.X64_193000_client_home.zip  无图形界面静默安装

2、创建用户和组

groupadd -g 6001 oinstall
groupadd -g 6002 dba
groupadd -g 6003 oper
groupadd -g 6004 backupdba
groupadd -g 6005 dgdba
groupadd -g 6006 kmdba
groupadd -g 6007 racdba
useradd -u 6001 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,racdba oracle
passwd oracle

3、创建目录

mkdir -p /u01/app/oracle/product/19.0.0/client_1
mkdir -p /u01/soft
chown -R oracle:oinstall /u01/
chmod -R 775 /u01

4、安装依赖包

yum install libaio bc flex readline-devel libnsl -y
yum install ksh libaio-devel compat-libcap1 libstdc++-devel glibc-devel -y
rpm -ivh rlwrap-0.42-1.el7.x86_64.rpm

5、上传安装包

#上传LINUX.X64_193000_client.zip至/u01/soft目录
#修改用户及所属组并解压
chown -R oracle:oinstall LINUX.X64_193000_client.zip

#解压安装包
su - oracle
unzip LINUX.X64_193000_client.zip -d /u01/soft

6、编辑环境变量

su - oracle

cat >> ~/.bash_profile << EOF
umask 022
export HOST=`hostname | cut -f1 -d"."`
export LANG=en_US
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.3/client_1
export ORACLE_SID=ORCL1
export ORACLE_TERM=xterm;
export PATH=.:$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/bin
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export NLS_LANG=AMERICAN_CHINA.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
EOF

#使环境变量生效
source .bash_profile

7、图形化界面安装,安装过程略

cd /u01/soft/client
export DISPLAY=192.168.1.2:0.0
./runInstaller

8、创建 tnsnames.ora 文件并测试连接

vi /u01/app/oracle/product/19.3/client_1/network/admin/tnsnames.ora

ORCL1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = dbname)
      (SERVER = DEDICATED)
    )
  )

#测试客户端并连接到数据库
sqlplus username/password@ORCL1