Oracle 11g 安装

实验环境：

Operating System	Rocky Linux 9.4 (Blue Onyx)
Kernel	Linux 5.14.0-427.33.1.el9_4.x86_64
Hardware Vendor	QEMU
Oracle	Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

1. 安装依赖包

yum install -y bc
yum install -y compat-libcap1*
yum install -y compat-libcap*
yum install -y binutils 
yum install -y compat-libstdc++-33 
yum install -y elfutils-libelf 
yum install -y elfutils-libelf-devel 
yum install -y gcc 
yum install -y gcc-c++ 
yum install -y glibc-2.5 
yum install -y glibc-common 
yum install -y glibc-devel 
yum install -y glibc-headers 
yum install -y ksh libaio 
yum install -y libaio-devel 
yum install -y libgcc 
yum install -y libstdc++ 
yum install -y libstdc++-devel 
yum install -y make 
yum install -y sysstat 
yum install -y unixODBC 
yum install -y unixODBC-devel
yum install -y binutils*
yum install -y compat-libstdc*
yum install -y elfutils-libelf*
yum install -y gcc*
yum install -y glibc*
yum install -y ksh*
yum install -y libaio*
yum install -y libgcc*
yum install -y libstdc*
yum install -y make*
yum install -y sysstat*
yum install -y libXp*
yum install -y glibc-kernheaders
yum install -y net-tools-*
yum install gcc-c++*
yum install libnsl

2. 创建Oracle用户和组

sudo groupadd oinstall
sudo groupadd dba
sudo useradd -g oinstall -G dba oracle
sudo passwd oracle

mkdir -p /opt/oracle/{oraInventory,install,db_1,oradata}
chown -R oracle:oinstall /opt/oradata
chmod -R 777 /opt/oracle
passwd oracle

 3. 设置环境变量

echo "export ORACLE_BASE=/opt/oracle" >> /etc/profile
echo "export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/dbhome_1" >> /etc/profile
echo "export ORACLE_SID=ORCL" >> /etc/profile
echo "export PATH=\$PATH:\$ORACLE_HOME/bin" >> /etc/profile
source /etc/profile

4. 配置内核参数

# 编辑 /etc/sysctl.conf 文件，添加以下行：

echo "fs.file-max = 6815744" >> /etc/sysctl.conf
echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range = 1024 65000" >> /etc/sysctl.conf
echo "kernel.shmmax = 536870912" >> /etc/sysctl.conf

# 然后运行以下命令来应用更改：

sudo sysctl -p

5. 调整系统资源限制

# 编辑 /etc/security/limits.conf 文件，添加以下行：

echo "oracle soft nproc 2047" >> /etc/security/limits.conf
echo "oracle hard nproc 16384" >> /etc/security/limits.conf
echo "oracle soft nofile 1024" >> /etc/security/limits.conf
echo "oracle hard nofile 65536" >> /etc/security/limits.conf

6. 以Oracle用户登录并解压Oracle软件包

su - oracle
cd /home/soft
unzip -q p13390677_112040_Linux-x86-64_1of7.zip 
unzip -q p13390677_112040_Linux-x86-64_2of7.zip 
unzip -q p13390677_112040_Linux-x86-64_1of7.zip 

7. 运行安装脚本

cd /home/soft/database 
export DISPLAY=:0
export LANG=en_US
./runInstaller -jreLoc $JAVA_HOME/jre

# 查询DISPLAY echo "export DISPLAY=:2" >> /etc/profile
# 可以使用下述命令解决这个问题：
# 1.在root下执行 #xdpyinfo | grep name  记录下name of display：后的字符串，如 ：2 
#2. #xhost + 返回信息为： access control disabled,clients can connect from any host
#3.切换到Oracle用户： su - oracle
#4.在Oracle用户下执行命令： export DISPLAY=:2
#5.在Oracle下执行xdpyinfo命令，如果能正常显示，说明设置成功

8. 按界面提示一步一步的向下安装

9. 配置监听

在终端中使用netca命令启动创建监听器

[oracle@oracle]$ netca

10. 创建数据库实例

在终端中使用dbca命令启动创建数据库实例