centos7 安装 oracle 19C

àì夳堔傛蜴生んèń 2023-01-14 04:58 154阅读 0赞

### 开启防火墙 ###

firewall-cmd --zone=public --add-port=1521/tcp --permanent  
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

### 创建用户，组 ###

useradd oracle  
passwd oracle

groupadd oinstall  
groupadd dba

usermod oracle -g oinstall -G dba

### 创建目录 ###

mkdir -p /oracle/u01/app/oracle  
mkdir -p /oracle/u01/app/oraInventory

chown oracle:dba -R /oracle/u01/app/oracle  
chown oracle:oinstall -R /oracle/u01/app/oraInventory

### 传输文件解压 ###

使用xftp将oracle程序包“LINUX.X64\_193000\_db\_home.zip”上传到app目录下

mkdir -p /oracle/u01/app/oracle/product/19.3/dbhome\_1  
unzip LINUX.X64\_193000\_db\_home.zip -d /oracle/u01/app/oracle/product/19.3/dbhome\_1

chown -R oracle:dba /oracle/u01/app/oracle/

### 配置yum源 ###

下载依赖的安装包、  
yum -y install tigervnc-server tigervnc vnc vnc-server  
yum -y install compat-libcap\*  
yum -y install ksh  
yum -y install gcc\*  
yum -y install libaio\*  
yum -y install compat-libstdc\*

### 修改参数文件 ###

vi .bash\_profile 加入：

export ORACLE\_BASE=/oracle/u01/app/oracle  
export ORACLE\_HOME=/oracle/u01/app/oracle/product/19.3/dbhome\_1  
export ORACLE\_SID=oradb  
export ORACLE\_TERM=xterm  
export ORACLE\_OWNER=oracle  
export TNS\_ADMIN=$ORACLE\_HOME/network/admin  
export ORA\_NLS33=$ORACLE\_HOME/ocommon/nls/admin/data  
export NLS\_LANG="AMERICAN\_AMERICA.ZHS16GBK"  
export LD\_LIBRARY\_PATH=$ORACLE\_HOME/lib:$ORACLE\_HOME/network/lib:/lib:/usr/lib:/usr/local/lib  
export LIBPATH=$ORACLE\_HOME/lib:$ORACLE\_HOME/network/lib:/lib:/usr/lib:/usr/local/lib  
export PATH=$PATH:/sbin:/usr/lbin:/usr/sbin:$JAVA\_HOME/bin:$ORACLE\_HOME/bin:$ORACLE\_HOME/lib:$HOME/bin:$ORACLE\_HOME/OPatch:.  
umask 022

编辑/etc/security/limits.conf  
/etc/security/limits.conf中增加如下几行

oracle        soft    nproc   16384  
oracle        hard    nproc   16384  
oracle        soft    nofile  65536  
oracle        hard    nofile  65536

### 开启界面 ###

export DISPLAY=:0  
xhost +  
su - oracle  
export DISPLAY=:0.0  
export DISPLAY

### 安装 ###

/oracle/u01/app/oracle/product/19.3/dbhome\_1/runInstaller 只安装数据库软件

安装好后netca

dbca

listen.ora添加  
SID\_LIST\_LISTENER =    
(SID\_LIST =    
  (SID\_DESC =    
  (GLOBAL\_DBNAME = oradb)  
  (SID\_NAME = oradb)  
  )  
)