hostnamectl set-hostname db01
vim /etc/hosts
192.168.1.101 db01
vim /etc/selinux/config
SELINUX=disabled
2.5 关闭防火墙配置
systemctl disable firewalld
systemctl stop firewalld
systemctl stop firewalld.service
systemctl disable firewalld.service
2.6 配置本地yum源
mount -o loop Kylin-Server-V10-SP3-General-Release-2303-X86_64.iso /media
[root@localhost yum.repos.d]# vim kylin.repo
[ks10-local-iso]
name = Kylin Linux Advanced Server 10 - local
baseurl = file:///media
gpgcheck = 1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-kylin
enabled = 1
2.67添加swap分区
# 创建swap文件为4GB
dd if=/dev/zero of=/swapfile bs=1G count=13
# 标记为swap空间
mkswap /swapfile
# 设置文件权限
chmod -R 0600 /swapfile
# 激活swap文件
swapon /swapfile
# 开机自动挂载swap
vim /etc/fstab
/swapfile swap swap defaults 0 0
mount -a
查看版本
cat /etc/.kyinfo
[dist]
name=Kylin
milestone=Server-V10-SP3-General-Release-2212
arch=x86_64
beta=False
time=2022-12-02 15:44:18
dist_id=Kylin-Server-V10-SP3-General-Release-2212-x86_64-2022-12-02 15:44:18
安装包
yum install binutils* -y
yum install compat* -y
yum install glibc* -y
yum install libgcc* -y
yum install libstdc* -y
yum install libaio* -y
yum install make* -y
yum install sysstat* -y
yum install gcc* -y
yum install ncurses* -y
yum install readline* -y
yum install unixODBC* -y
yum install lrzsz -y
yum install -y make gcc binutils glibc libaio libXext libXtst libX11 libXau libxcb libXi
yum -y install elfutils-*
yum -y install glibc-headers*
yum -y install libaio*
yum -y install libnsl*
rpm -vih compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm
rpm -vih pdksh-5.2.14-36.el5.x86_64.rpm
rpm -vih libnsl2-1.3.0-2.ky10.x86_64.rpm
rpm -vih elfutils-libelf-0.176-5.el7.x86_64.rpm --nodeps --force
rpm -vih elfutils-libelf-devel-0.176-5.el7.x86_64.rpm --nodeps --force
rpm -vih glibc-headers-2.17-317.el7.x86_64.rpm --nodeps --force
rpm -vih libaio-0.3.109-13.el7.x86_64.rpm --nodeps --force
rpm -vih libaio-devel-0.3.109-13.el7.x86_64.rpm --nodeps --force
(以上这些安装包,可以复制centos7.9的rpm包)
rpm -vih libnsl-2.28-127.el8.x86_64.rpm --nodeps --force (从centos8.3上找)
修改内核参数(根据实际情况来调节,这里只是参考)
vim /etc/sysctl.conf
vm.swappiness = 1
vm.dirty_background_ratio = 3
vm.dirty_ratio = 80
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 100
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.file-max = 6815744
fs.aio-max-nr = 1048576
fs.file-max = 65535600
fs.aio-max-nr = 3145728
#kernel.shmall为物理内存除以pagesize;
#kernel.shmmax为物理内存的一半(256G,137438953472);
# fs.file-max为512 乘以 processes (如128个process则为 65536);
sysctl -p
修改资源限制(一般用于大型的OLTP数据库)
vi /etc/security/limits.conf
oracle soft nproc 20470
oracle hard nproc 163840
oracle soft nofile 10240
oracle hard nofile 655360
oracle soft stack 10240
soft memlock 211608995
hard memlock 211608995
#memlock: 内存锁,一般是物理内存的80%,大型数据库需要调,小数据库不需要调
创建用户/组,以及修改密码
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba,oper oracle
passwd Oralce123
创建目录
mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01
chmod -R 775 /u01/app/oracle
修改环境变量
su - oracle
vim .bash_profile
unset TNS_ADMIN
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=db01
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
unset USERNAME
umask 022
alias sqlplus='/usr/local/bin/rlwrap sqlplus'
alias rman='/usr/local/bin/rlwrap rman'
#
cd /home/soft
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
chown -R oracle:oinstall database/
chmod -R +x database/
调用xmange上的Xmanager - Passive文件
$su - oracle
LANG=en_US.UTF-8
export DISPLAY=192.168.1.201:0.0
./runInstaller
1. Users With Same UID
出现具有root权限,非root用户的问题处理(一般是通过等保后安装数据库)
vim /etc/passwd
ttss:x:0:0:root:/root:/bin/bash
root:x:0:0:root:/root:/bin/bash
...
这时将root用户:组 改为没有使用的编号,比如‘111’即可
vim /etc/passwd
ttss:x:0:0:root:/root:/bin/bash
root:x:111:111:root:/root:/bin/bash
...
...
2. 解决图形化界面 安装报错zip问题
cp /usr/bin/unzip /home/soft/database/install
3. 问题'agent_nmhs'
vim $ORACLE_HOME/sysman/lib/ins_emagent.mk
##找到$(MK_EMAGENT_NMECTL),在后面添加-lnnz11后保存退出
$(MK_EMAGENT_NMECTL) -lnnz11
《如果再出现其他报错,应该补丁没打全,需要再打补丁》
安装完以后修改oracle环境变量
cd $ORACLE_HOME/sqlplus/admin
vim glogin.sql
define _editor=vi
set linesize 100
set pagesize 9999
set sqlprompt "_user'@'_connect_identifier>"
配置开机自启动
su - oracle
vim /etc/oratab
db01:/u01/app/oracle/product/11.2.0/dbhome_1:Y
su - root
vim /etc/rc.d/rc.local
touch /var/lock/subsys/local
su - oracle -lc "/u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start"
su - oracle -c "/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart"