Oracle19c在OEL7.9下的单机静默安装手册

目录

一、环境介绍

软件工具 VMware Workstation 17 Pro
Hostname oracle
操作系统 Oracle Linux Server 7.9
内存 8G
硬盘 100G
IP地址 192.168.100.10
数据库版本 oracle 19.3.0
ORACLE_SID oracle19c

二、安装配置

1．配置本地yum源

##挂载镜像源
mount /dev/cdrom /mnt

##备份yum源
# cd /etc/yum.repos.d/
# mkdir bak
# mv *.repo ./bak/

##配置yum源
cat <<EOF>>/etc/yum.repos.d/local.repo
[local]
name=local
baseurl=file:///mnt
gpgcheck=0
enabled=1
EOF

##查看yum源
yum repolist all

##设置开机启动并验证设置是否正确
vim /etc/fstab
/dev/cdrom   /mnt   iso9660  defaults  0  0

##umount 
umount /mnt

##是否能挂载
mount -a

2．修改主机名

vim /etc/hostname
###或者
hostnamectl set-hostname oracle

3．关闭防火墙

systemctl stop firewalld
systemctl disable firewalld
systemctl status firewalld

4．禁用NetworkManager服务

systemctl stop NetworkManager
systemctl disable NetworkManager
systemctl status NetworkManager

5．禁用SELINUX

setenforce 0
sed -i "/^SELINUX=/s#enforcing#disabled#" /etc/selinux/config
###查看修改结果
cat /etc/selinux/config |grep SELINUX=

6．配置NOZEROCONFIG

cat <<EOF>> /etc/sysconfig/network 
NOZEROCONF=yes
EOF

7．配置HOSTS解析

cat <<EOF>> /etc/hosts 
192.168.100.10  oracle
EOF

8．配置SSH服务

##配置LoginGraceTime参数为0, 将timeout wait设置为无限制
cp /etc/ssh/sshd_config /etc/ssh/sshd_config_`date +"%Y%m%d_%H%M%S"`  
sed -i '/#LoginGraceTime 2m/ s/#LoginGraceTime 2m/LoginGraceTime 0/' /etc/ssh/sshd_config
grep LoginGraceTime /etc/ssh/sshd_config

##加快SSH登陆速度，禁用DNS
cp /etc/ssh/sshd_config /etc/ssh/sshd_config_`date +"%Y%m%d_%H%M%S"` 
sed -i '/#UseDNS yes/ s/#UseDNS yes/UseDNS no/' /etc/ssh/sshd_config 
grep UseDNS /etc/ssh/sshd_config

##重启ssh服务
systemctl restart sshd.service

9．关闭avahi-daemon服务

###必须关闭 avahi-daemon 服务（如果在系统中存在）
systemctl status avahi-daemon.socket avahi-daemon.service
systemctl stop avahi-daemon.socket avahi-daemon.service 
systemctl disable avahi-daemon.socket avahi-daemon.service

10．关闭THP

##Oracle官方：Oracle Linux team 在测试的过程中发现，如果linux开启透明巨页THP，则I/O读写性能降低30%；
##如果关闭透明巨页THP，I/O读写性能则恢复正常。因此建议在Oracle Database中不要使用透明巨页THP,具体的MOS文档：文档ID 1606759.1
# cat /sys/kernel/mm/transparent_hugepage/enabled
# cat /sys/kernel/mm/transparent_hugepage/defrag
[root@oracle ~]#  cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
[root@oracle ~]# cat /sys/kernel/mm/transparent_hugepage/defrag
always defer defer+madvise [madvise] never

vi /etc/rc.d/rc.local
if test -f /sys/kernel/mm/transparent_hugepage/enabled; 
then echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; 
then echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
# 赋予 rc.local 文件可执行权限：
# chmod +x /etc/rc.d/rc.local
# 重启操作系统，使配置生效，检查 THP 状态，应该是被禁用的
# reboot
# cat /sys/kernel/mm/transparent_hugepage/enabled
# cat /sys/kernel/mm/transparent_hugepage/defrag


OR


cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
cp /etc/default/grub /etc/default/grub_`date +%Y%m%d_%H%M%S` 
vi /etc/default/grub
##将transparent_hugepage=never添加到GRUB_CMDLINE_LINUX的最后
cat /etc/default/grub
GRUB_TIMEOUT=5
GRUB_DISTRIBUTOR="$(sed 's, release .*$,,g' /etc/system-release)"
GRUB_DEFAULT=saved
GRUB_DISABLE_SUBMENU=true
GRUB_TERMINAL_OUTPUT="console"
GRUB_CMDLINE_LINUX="rd.lvm.lv=rhel/root rhgb quiet transparent_hugepage=never intel_pstate=disable"
GRUB_DISABLE_RECOVERY="true"
##执行以下命令：
grub2-mkconfig -o /boot/grub2/grub.cfg

11．关闭NUMA

#查看default 的grub的entry
[root@oracle ~]# grubby --default-kernel
/boot/vmlinuz-5.4.17-2011.6.2.el7uek.x86_64

#查看default grub的具体信息
[root@oracle ~]# grubby --info /boot/vmlinuz-5.4.17-2011.6.2.el7uek.x86_64
index=0
kernel=/boot/vmlinuz-5.4.17-2011.6.2.el7uek.x86_64
args="ro rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet LANG=en_US.UTF-8"
root=/dev/mapper/ol-root
initrd=/boot/initramfs-5.4.17-2011.6.2.el7uek.x86_64.img
title=Oracle Linux Server (5.4.17-2011.6.2.el7uek.x86_64 with Unbreakable Enterprise Kernel) 7.9

#更新args，添加numa=off的参数
grubby --args=numa=off --update-kernel /boot/vmlinuz-5.4.17-2011.6.2.el7uek.x86_64

#重启服务器后查询关闭情况
reboot

[root@oracle ~]# grubby --info /boot/vmlinuz-5.4.17-2011.6.2.el7uek.x86_64
index=0
kernel=/boot/vmlinuz-5.4.17-2011.6.2.el7uek.x86_64
args="ro rd.lvm.lv=ol/root rd.lvm.lv=ol/swap rhgb quiet LANG=en_US.UTF-8 numa=off"
root=/dev/mapper/ol-root
initrd=/boot/initramfs-5.4.17-2011.6.2.el7uek.x86_64.img
title=Oracle Linux Server (5.4.17-2011.6.2.el7uek.x86_64 with Unbreakable Enterprise Kernel) 7.9

12．安装依赖包

yum install -y bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb gcc make smartmontools sysstat

##检查是否安装完毕所有的包：
rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb gcc make smartmontools sysstat

##输出如下：
[root@oracle ~]# rpm --query --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make smartmontools sysstat
bc-1.06.95.13.el7 (x86_64)
binutils-2.27.44.base.0.1.el7 (x86_64)
compat-libcap1-1.10.7.el7 (x86_64)
compat-libstdc++-33-3.2.3.72.el7 (x86_64)
elfutils-libelf-0.176.5.el7 (x86_64)
elfutils-libelf-devel-0.176.5.el7 (x86_64)
fontconfig-devel-2.13.0.4.3.el7 (x86_64)
glibc-2.17.317.0.1.el7 (x86_64)
glibc-devel-2.17.317.0.1.el7 (x86_64)
ksh-20120801.142.0.1.el7 (x86_64)
libaio-0.3.109.13.el7 (x86_64)
libaio-devel-0.3.109.13.el7 (x86_64)
libX11-1.6.7.2.el7 (x86_64)
libXau-1.0.8.2.1.el7 (x86_64)
libXi-1.7.9.1.el7 (x86_64)
libXtst-1.2.3.1.el7 (x86_64)
libXrender-0.9.10.1.el7 (x86_64)
libXrender-devel-0.9.10.1.el7 (x86_64)
libgcc-4.8.5.44.0.3.el7 (x86_64)
libstdc++-4.8.5.44.0.3.el7 (x86_64)
libstdc++-devel-4.8.5.44.0.3.el7 (x86_64)
libxcb-1.13.1.el7 (x86_64)
gcc-4.8.5.44.0.3.el7 (x86_64)
make-3.82.24.el7 (x86_64)
smartmontools-7.0.2.el7 (x86_64)
sysstat-10.1.5.19.el7 (x86_64)

13．安装rlwarp（非必须）

##安装依赖包
yum install -y readline*  
##上传安装包
rz -y
##解压缩
tar -zxvf rlwrap-0.42.tar.gz
##进入解压目录
cd rlwrap-0.42
##编译
./configure
make && make install

14．配置系统环境变量

vim /etc/profile
if [ \$USER = "oracle" ]; then 
  if [ \$SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi

15．配置内核参数

cat >> /etc/sysctl.conf <<EOF
 kernel.shmall = 1887436
 kernel.sem = 250 32000 100 128
 kernel.shmmni = 4096
 kernel.shmmax = 7730941131
 net.ipv4.ip_local_port_range = 9000 65500
 net.core.rmem_default = 1048576
 net.core.rmem_max = 4194304
 net.core.wmem_default = 262144
 net.core.wmem_max = 1048576
 fs.file-max = 6815744
 fs.aio-max-nr = 1048576
EOF

###参数生效
sysctl -p

参数说明：

shmmax=建议设置为物理内存*80%，单位是字节

kernel.shmmax：表示单个共享内存段的最大值，以字节为单位，本地测试设定的为7.2GB，即“7730941131/1024/1024/1024=7.2G”。

kernel.shmmin：表示单个共享内存段的最小值，默认为1byte

kernel.shmall：表示整个系统范围内可用共享内存页的总量，单位是页（page），通过命令getconf PAGESIZE查看。计算公式是：shmmax/PAGE_SIZE

kernel.shmmni：表示整个系统范围内内存段的最大数量，一般为4096.

ip_local_port_range ：表示端口的范围。在监听器帮助客户端进程和服务器进程建立连接时，会用到指定范围内的端口。

kernel.sem ：表示设置的信号量，这4个参数内容大小固定。

net.core.rmem_default ：表示接收套接字缓冲区大小的缺省值（以字节为单位）。

net.core.rmem_max ：表示接收套接字缓冲区大小的最大值（以字节为单位）

net.core.wmem_default ：表示发送套接字缓冲区大小的缺省值（以字节为单位）。

net.core.wmem_max ：表示发送套接字缓冲区大小的最大值（以字节为单位）。

16．配置LIMITS限制参数

cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

17．配置PAM验证

cat >> /etc/pam.d/login <<EOF
session  required   /lib64/security/pam_limits.so 
EOF

18．创建组和用户

##创建oinstall和dba组
groupadd oinstall
groupadd dba
##创建oracle用户并加入相应组
useradd -g oinstall -G dba oracle
##初始化oracle用户密码
echo "oracle" | passwd --stdin oracle

19．创建安装目录并赋权

mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
mkdir -p /u01/app/oraInventory

chown -R oracle:oinstall /u01/
chmod -R 775 /u01/

20．配置用户环境变量

su - oracle
vim  /home/oracle/.bash_profile

######################begin##########################
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1
export ORACLE_SID=oracle19c
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
#######################end###########################


#######参数生效
source ~/.bash_profile

21．上传安装包

##使用root上传安装包并授权
su - root

chown oracle:oinstall LINUX.X64_193000_db_home.zip

##解压到$ORACLE_HOME目录
su - oracle

unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME

三、安装阶段(静默)

1. 编辑配置文件

[oracle@oracle opt]$ cd /u01/app/oracle/product/19.3.0/dbhome_1/install/response
[oracle@oracle response]$ 
[oracle@oracle response]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1/install/response
[oracle@oracle response]$ cat db_install.rsp|grep -v '^#'|grep -v '^$';
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=
UNIX_GROUP_NAME=
INVENTORY_LOCATION=
ORACLE_HOME=
ORACLE_BASE=
oracle.install.db.InstallEdition=
oracle.install.db.OSDBA_GROUP=
oracle.install.db.OSOPER_GROUP=
oracle.install.db.OSBACKUPDBA_GROUP=
oracle.install.db.OSDGDBA_GROUP=
oracle.install.db.OSKMDBA_GROUP=
oracle.install.db.OSRACDBA_GROUP=
oracle.install.db.rootconfig.executeRootScript=
oracle.install.db.rootconfig.configMethod=
oracle.install.db.rootconfig.sudoPath=
oracle.install.db.rootconfig.sudoUserName=
oracle.install.db.CLUSTER_NODES=
oracle.install.db.config.starterdb.type=
oracle.install.db.config.starterdb.globalDBName=
oracle.install.db.config.starterdb.SID=
oracle.install.db.ConfigureAsContainerDB=
oracle.install.db.config.PDBName=
oracle.install.db.config.starterdb.characterSet=
oracle.install.db.config.starterdb.memoryOption=
oracle.install.db.config.starterdb.memoryLimit=
oracle.install.db.config.starterdb.installExampleSchemas=
oracle.install.db.config.starterdb.password.ALL=
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.password.PDBADMIN=
oracle.install.db.config.starterdb.managementOption=
oracle.install.db.config.starterdb.omsHost=
oracle.install.db.config.starterdb.omsPort=
oracle.install.db.config.starterdb.emAdminUser=
oracle.install.db.config.starterdb.emAdminPassword=
oracle.install.db.config.starterdb.enableRecovery=
oracle.install.db.config.starterdb.storageType=
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=

###复制db_install.rsp至Oracle家目录
[oracle@oracle response]$ cp db_install.rsp /home/oracle/ 
[oracle@oracle response]$ cd /home/oracle/
[oracle@oracle ~]$ ls
db_install.rsp 
[oracle@oracle ~]$ vim db_install.rsp 
[oracle@oracle ~]$ 

##修改后的参数
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=dba
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba
oracle.install.db.rootconfig.executeRootScript=false
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=oracle19c
oracle.install.db.config.starterdb.SID=oracle19c
oracle.install.db.ConfigureAsContainerDB=false
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.password.ALL=oracle
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u01/app/oracle/oradata
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/u01/app/oracle/fast_recovery_area

2. 安装数据库

###安装数据库
su - oracle
cd $ORACLE_HOME
./runInstaller -silent -responseFile /home/oracle/db_install.rsp

##执行静默安装
[oracle@oracle dbhome_1]$ ./runInstaller -silent  -responseFile /home/oracle/db_install.rsp
Launching Oracle Database Setup Wizard...

The response file for this session can be found at:
 /u01/app/oracle/product/19.3.0/dbhome_1/install/response/db_2025-06-27_11-49-45AM.rsp

You can find the log of this install session at:
 /tmp/InstallActions2025-06-27_11-49-45AM/installActions2025-06-27_11-49-45AM.log

As a root user, execute the following script(s):
        1. /u01/app/oraInventory/orainstRoot.sh
        2. /u01/app/oracle/product/19.3.0/dbhome_1/root.sh

Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: 
[oracle]
Execute /u01/app/oracle/product/19.3.0/dbhome_1/root.sh on the following nodes: 
[oracle]


Successfully Setup Software.
Moved the install session logs to:
 /u01/app/oraInventory/logs/InstallActions2025-06-27_11-49-45AM


####root执行脚本
[root@oracle ~]#  /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@oracle ~]#
[root@oracle ~]#
[root@oracle ~]#  /u01/app/oracle/product/19.3.0/dbhome_1/root.sh
Check /u01/app/oracle/product/19.3.0/dbhome_1/install/root_oracle_2025-06-27_12-13-23-787816347.log for the output of root script

3. 创建监听

[oracle@oracle dbhome_1]$ cd /u01/app/oracle/product/19.3.0/dbhome_1/assistants/netca
[oracle@oracle netca]$ ls
doc  images  jlib  netca_deinst.sbs  netca.rsp  netca.sbs
[oracle@oracle netca]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1/assistants/netca
[oracle@oracle netca]$  cat netca.rsp|grep -v '^#'|grep -v '^$';
[GENERAL]
RESPONSEFILE_VERSION="19.0"
CREATE_TYPE="CUSTOM"
[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}


###不需要修改响应文件，默认安装就好。
$ cp netca.rsp /home/oracle/
$ cd $ORACLE_HOME/bin
$ netca -silent -responseFile /home/oracle/netca.rsp


[oracle@oracle bin]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1/bin
[oracle@oracle bin]$ netca -silent -responseFile /home/oracle/netca.rsp

Parsing command line arguments:
    Parameter "silent" = true
    Parameter "responsefile" = /home/oracle/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
    Running Listener Control: 
      /u01/app/oracle/product/19.3.0/dbhome_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0

###安装完成后查看监听状态
[oracle@oracle dbhome_1]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 05-JUL-2025 23:48:49

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                05-JUL-2025 23:47:53
Uptime                    0 days 0 hr. 0 min. 56 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

启动监听：lsnrctl start

停止监听：lsnrctl stop

重启监听：lsnrctl reload

查看监听：lsnrctl status

4. 创建数据库

[oracle@oracle bin]$ cd /u01/app/oracle/product/19.3.0/dbhome_1/assistants/dbca
[oracle@oracle dbca]$ ls
dbca.rsp  doc  jlib  templates
[oracle@oracle dbca]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1/assistants/dbca
###备份响应文件
[oracle@oracle dbca]$cd $ORACLE_HOME/assistants/dbca
[oracle@oracle dbca]$cp dbca.rsp /home/oracle

[oracle@oracle dbca]$ cat dbca.rsp|grep -v '^#'|grep -v '^$';
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0
gdbName=
sid=
databaseConfigType=
RACOneNodeServiceName=
policyManaged=
createServerPool=
serverPoolName=
cardinality=
force=
pqPoolName=
pqCardinality=
createAsContainerDatabase=
numberOfPDBs=
pdbName=
useLocalUndoForPDBs=
pdbAdminPassword=
nodelist=
templateName=
sysPassword=
systemPassword= 
oracleHomeUserPassword=
emConfiguration=
emExpressPort=5500
runCVUChecks=
dbsnmpPassword=
omsHost=
omsPort=
emUser=
emPassword=
dvConfiguration=
dvUserName=
dvUserPassword=
dvAccountManagerName=
dvAccountManagerPassword=
olsConfiguration=
datafileJarLocation=
datafileDestination=
recoveryAreaDestination=
storageType=
diskGroupName=
asmsnmpPassword=
recoveryGroupName=
characterSet=
nationalCharacterSet=
registerWithDirService=
dirServiceUserName=
dirServicePassword=
walletPassword=
listeners=
variablesFile=
variables=
initParams=
sampleSchema=
memoryPercentage=
databaseType=
automaticMemoryManagement=
totalMemory=


[oracle@oracle dbca]$ cd /home/oracle
#####配置参数
vim dbca.rsp
###主要修改以下参数
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0
gdbName=oracle19c
sid=oracle19c
databaseConfigType=SI
templateName=General_Purpose.dbc
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=pdb1
pdbAdminPassword=oracle
sysPassword=oracle
systemPassword=oracle
characterSet=ZHS16GBK
nationalCharacterSet=AL16UTF16
databaseType=OLTP


###安装步骤
[oracle@oracle ~]$ dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp 
[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
   CAUSE: 
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
   ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
53% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/oracle19c.
Database Information:
Global Database Name:oracle19c
System Identifier(SID):oracle19c
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/oracle19c/oracle19c.log" for further details.

##安装过程的日志在"/u01/app/oracle/cfgtoollogs/dbca/oracle19c/oracle19c.log".

5. 验证数据库

[oracle@oracle oradata]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 27-JUN-2025 17:13:57

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                27-JUN-2025 12:38:42
Uptime                    0 days 4 hr. 35 min. 15 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "388ab1a8d2fe02bde0630a64a8c0260e" has 1 instance(s).
  Instance "oracle19c", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "oracle19c", status READY, has 1 handler(s) for this service...
Service "oracle19c" has 1 instance(s).
  Instance "oracle19c", status READY, has 1 handler(s) for this service...
Service "oracle19cXDB" has 1 instance(s).
  Instance "oracle19c", status READY, has 1 handler(s) for this service...
Service "pdb1" has 1 instance(s).
  Instance "oracle19c", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oracle oradata]$ 


[oracle@oracle ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 27 16:53:09 2025
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> 
SQL> show user;
USER is "SYS"
SQL> 
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
SQL> 
SQL> 
SQL> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cdb_cluster_name                     string
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      oracle19
db_unique_name                       string      oracle19c
global_names                         boolean     FALSE
instance_name                        string      oracle19c
lock_name_space                      string
log_file_name_convert                string
pdb_file_name_convert                string
processor_group_name                 string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      oracle19c

借鉴了其他老师的操作步骤，自己实验和总结出来的。
如有错误，欢迎指正。

posted @ 2025-08-22 23:30  把你打成猪  阅读(36)  评论(0)    收藏  举报