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