centos7.9单机版安装oracle19c与rockylinux安装单机版21c

oracle19C安装

     Database Software Downloads | Oraclehttps://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c

1、安装centos7.9  GUI安装

关闭selinux

sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

配置yum源

2、配置用户与组

groupadd  oinstall
groupadd  dba
groupadd oper
useradd -g oinstall -G dba,oper oracle
echo password | passwd --stdin oracle
mkdir -p /orcl/oracle19c/dbhome
chown -R oracle:oinstall /orcl

3、配置环境变量

su - oracle
vim .bash_profile

export ORACLE_SID=orcl
export ORACLE_BASE=/orcl/oracle19c
export ORACLE_HOME=$ORACLE_BASE/dbhome
export PATH=$PATH:$ORACLE_HOME/bin

4、安装

桌面登录oracle

unzip LINUX.X64_193000_db_home.zip  -d /orcl/oracle19c/dbhome
cd /orcl/oracle19c/dbhome
./runInstaller

 

 

 

 

 

 

 

 

 

 

 root用户执行

/tmp/InstallActions2022-09-14_10-49-28AM/CVU_19.0.0.0.0_oracle/runfixup.sh 

 安装软件包

yum install -y compat-libcap1 libstdc++-devel gcc-c++ ksh glibc-devel libaio-devel compat-libstdc++-33

 

 

/orcl/oraInventory/orainstRoot.sh 
/orcl/orclinstall/root.sh

 检查：

sqlplus / as sysdba

select status from v$instance;
select open_mode from v$database;

解决上下键乱码问题：

root执行

wget https://download-ib01.fedoraproject.org/pub/epel/7/x86_64/Packages/r/rlwrap-0.45.2-1.el7.x86_64.rpm
yum install -y rlwrap-0.45.2-1.el7.x86_64.rpm

oracle用户执行

cd
vim .bash_profile

alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias lsnrctl='rlwrap lsnrctl'

source .bash_profile

oracle 21C安装

Database Software Downloads | Oraclehttps://www.oracle.com/database/technologies/oracle-database-software-downloads.html#license-lightbox

安装rockylinux8.6  GUI     

 关闭selinux

sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

配置yum源

2、配置用户与组

groupadd  oinstall
groupadd  dba
groupadd oper
useradd -g oinstall -G dba,oper oracle
echo password | passwd --stdin oracle
mkdir -p /orcl/oracle21c/dbhome
chown -R oracle:oinstall /orcl

3、配置环境变量

su - oracle
vim .bash_profile

export ORACLE_SID=orcl
export ORACLE_BASE=/orcl/oracle21c
export ORACLE_HOME=$ORACLE_BASE/dbhome
export PATH=$PATH:$ORACLE_HOME/bin

4、安装

unzip LINUX.X64_213000_db_home.zip  -d /orcl/oracle21c/dbhome
cd /orcl/oracle21c/dbhome
./runInstaller

若报错

/orcl/oracle21c/dbhome/perl/bin/perl: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory

dnf install -y  libnsl

 

 

 

 

 

 

 

 

/tmp/InstallActions2022-09-14_03-24-16PM/CVU_21.0.0.0.0_oracle/runfixup.sh

 

安装软件包

dnf -y install sysstat ksh glibc-devel

 

install

 

状态检查

 

 解决sqlplus  上下退格键乱码问题https://download-ib01.fedoraproject.org/pub/epel/8/Everything/x86_64/Packages/r/rlwrap-0.45.2-1.el8.x86_64.rpmhttps://download-ib01.fedoraproject.org/pub/epel/8/Everything/x86_64/Packages/r/rlwrap-0.45.2-1.el8.x86_64.rpm

dnf -y install rlwrap-0.45.2-1.el8.x86_64.rpm

oracle用户执行

cd
vim .bash_profile

alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias lsnrctl='rlwrap lsnrctl'

source .bash_profile