Kylin V10 SP3 安装 Oracle 19c 操作手册

原创 majysky 2023-12-28

3803

Kylin V10 SP3 安装 Oracle 19c 操作手册

安装环境

此操作过程在VirtualBox 7.0.12创建虚拟机进行测试，只适用于测试
操作系统版本：Kylin V10 SP3 
数据库版本: Oracle 19.3.0
虚拟机版本：VirtualBox 7.0.12
    VirtualBox 下载地址 https://www.virtualbox.org/wiki/Downloads
    VirtualBox 扩展包下载地址： https://download.virtualbox.org/virtualbox/7.0.12/Oracle_VM_VirtualBox_Extension_Pack-7.0.12.vbox-extpack
远程工具：MobaXterm

创建虚拟机及安装操作系统

创建虚拟机

打开安装的Oracle VM VirtualBox，新建一个虚拟机。

设置虚拟机内存与CPU个数。

设置虚拟机的磁盘大小。

点击“完成”。

虚拟机启动前挂载Kylin V10的iso文件。

安装Kylin V10

点击虚拟机的启动，打开虚拟机，进入Kylin操作系统安装。

选择操作系统的语言。

设置红色框的内容后，点击“开始安装”。

“安装目的地”：选择自动分区或根据情况手工分区后点“确定”。

“软件选择”：选默认带GUI。

“用户设置Root密码”：设置root密码。

点击“重启系统”。

配置许可信息，在弹出窗口，选中复选框，点击“接受"。

添加虚拟机网卡

关闭虚拟机，点击虚拟机设置，在网卡2标签页，打勾启用网络连接，连接方式选择”仅主机(Host-Only)网络“，名称：”VirtualBox Host-Only Ethernet Adapter"。然后启动虚拟机。

设置网卡启动

登录系统后，点击右键，打开一个终端，

#切换到网卡配置文件夹
cd /etc/sysconfig/network-scripts 

#查看网卡名称
ifconfig

#启动网卡enp0s3 是Nat转换网卡，enp0s8是Host-Only网卡
 
#激活enp0s3网卡
nmcli d c enp0s3

#激活enp0s8网卡
nmcli d c enp0s8

#启动enp0s3网卡
nmcli c up enp0s3

#启动enp0s8网卡
nmcli c up enp0s8

关闭防火墙，可以让MobaXTerm连接系统

# 停firewalld服务
systtemctl stop firewalld

# 设置selinux
setenforce 0

安装VirtualBox增强功能包

将VBoxGuestAdditions.iso文件上传到/root , 备注：VBoxGuestAdditions.iso文件在VirtualBox的安装目录。

#创建iso挂载目录
mkdir /mnt/vbox

#挂载iso
mount -t iso9660 -o loop /root/VBoxGuestAdditions.iso /mnt/vbox

#安装
[root@localhost ~]# cd /mnt/vbox
[root@localhost vbox]# ls
AUTORUN.INF  runasroot.sh                       VBoxSolarisAdditions.pkg
autorun.sh   TRANS.TBL                          VBoxWindowsAdditions-amd64.exe
cert         VBoxDarwinAdditions.pkg            VBoxWindowsAdditions.exe
NT3x         VBoxDarwinAdditionsUninstall.tool  VBoxWindowsAdditions-x86.exe
OS2          VBoxLinuxAdditions.run             windows11-bypass.reg
[root@localhost vbox]# ./VBoxLinuxAdditions.run
Verifying archive integrity...  100%   MD5 checksums are OK. All good.
Uncompressing VirtualBox 7.0.12 Guest Additions for Linux  100%
VirtualBox Guest Additions installer
Copying additional installer modules ...
Installing additional modules ...
VirtualBox Guest Additions: Starting.
VirtualBox Guest Additions: Setting up modules
VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel
modules.  This may take a while.
VirtualBox Guest Additions: To build modules for other installed kernels, run
VirtualBox Guest Additions:   /sbin/rcvboxadd quicksetup <version>
VirtualBox Guest Additions: or
VirtualBox Guest Additions:   /sbin/rcvboxadd quicksetup all
VirtualBox Guest Additions: Building the modules for kernel
4.19.90-52.22.v2207.ky10.x86_64.

VirtualBox Guest Additions: Look at /var/log/vboxadd-setup.log to find out what
went wrong
VirtualBox Guest Additions: reloading kernel modules and services
VirtualBox Guest Additions: unable to load vboxguest kernel module, see dmesg
VirtualBox Guest Additions: kernel modules and services were not reloaded
The log file /var/log/vboxadd-setup.log may contain further information.

安装扩展包出现错误，需要修改VBoxAdditions源代码解决

[root@localhost vbox]# cd /opt/VBoxGuestAdditions-7.0.12/src/vboxguest-7.0.12/vboxguest/r0drv/linux/
[root@localhost linux]# ll
总用量 324
-rw-r--r-- 1 root root  7780 10月 13 00:55 alloc-r0drv-linux.c
-rw-r--r-- 1 root root  2983 10月 13 00:55 assert-r0drv-linux.c
-rw-r--r-- 1 root root  4506 10月 13 00:55 initterm-r0drv-linux.c
-rw-r--r-- 1 root root 75398 10月 13 00:55 memobj-r0drv-linux.c
-rw-r--r-- 1 root root  6149 10月 13 00:55 memuserkernel-r0drv-linux.c
-rw-r--r-- 1 root root  7951 10月 13 00:55 mpnotification-r0drv-linux.c
-rw-r--r-- 1 root root 18274 10月 13 00:55 mp-r0drv-linux.c
-rw-r--r-- 1 root root  2207 10月 13 00:55 process-r0drv-linux.c
-rw-r--r-- 1 root root  2178 10月 13 00:55 RTLogWriteDebugger-r0drv-linux.c
-rw-r--r-- 1 root root 12630 10月 13 00:55 semeventmulti-r0drv-linux.c
-rw-r--r-- 1 root root  9847 10月 13 00:55 semevent-r0drv-linux.c
-rw-r--r-- 1 root root  5740 10月 13 00:55 semfastmutex-r0drv-linux.c
-rw-r--r-- 1 root root 13649 10月 13 00:55 semmutex-r0drv-linux.c
-rw-r--r-- 1 root root  6671 10月 13 00:55 spinlock-r0drv-linux.c
-rw-r--r-- 1 root root  2202 10月 13 00:55 string.h
-rw-r--r-- 1 root root 14839 10月 13 00:55 the-linux-kernel.h
-rw-r--r-- 1 root root  6998 10月 13 00:55 thread2-r0drv-linux.c
-rw-r--r-- 1 root root  9029 10月 13 00:55 thread-r0drv-linux.c
-rw-r--r-- 1 root root  6736 10月 13 00:55 time-r0drv-linux.c
-rw-r--r-- 1 root root 62603 10月 13 00:55 timer-r0drv-linux.c
-rw-r--r-- 1 root root  9368 10月 13 00:55 waitqueue-r0drv-linux.h

#先备份文件
cp memuserkernel-r0drv-linux.c memuserkernel-r0drv-linux.c.bak

#修改文件内容
vi memuserkernel-r0drv-linux.c
使用i进行编辑，将以下两处RTLNX_VER_MIN(5,0,0)改为RTLNX_VER_MIN(4,0,0)即可啦

#或使用sed 修改
sed -i 's/RTLNX_VER_MIN(5,0,0)/RTLNX_VER_MIN(4,0,0)/g' memuserkernel-r0drv-linux.c

#查看修改后的内容
cat memuserkernel-r0drv-linux.c |grep RTLNX
#if RTLNX_VER_MIN(4,0,0) || RTLNX_RHEL_MIN(8,1)
#if RTLNX_VER_MIN(4,0,0) || RTLNX_RHEL_MIN(8,1)

随后还有一个文件中需要更改该函数问题，继续执行命令：

cd ../../../vboxsf
cp regops.c regops.c.bak
vi regops.c
使用i进行编辑，将以下两处RTLNX_VER_MIN(5,0,0)改为RTLNX_VER_MIN(4,0,0)即可啦

#或使用sed 修改
sed -i 's/RTLNX_VER_MIN(5,0,0)/RTLNX_VER_MIN(4,0,0)/g' regops.c

#查看修改后的内容
cat regops.c |grep "RTLNX_VER_MIN(4,0,0)"
#if RTLNX_VER_MIN(4,0,0) || RTLNX_RHEL_MIN(8,1)

#再次安装VirtualBox扩展包
[root@localhost vboxsf]# /sbin/rcvboxadd setup
VirtualBox Guest Additions: Starting.
VirtualBox Guest Additions: Setting up modules
VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel
modules.  This may take a while.
VirtualBox Guest Additions: To build modules for other installed kernels, run
VirtualBox Guest Additions:   /sbin/rcvboxadd quicksetup <version>
VirtualBox Guest Additions: or
VirtualBox Guest Additions:   /sbin/rcvboxadd quicksetup all
VirtualBox Guest Additions: Building the modules for kernel
4.19.90-52.22.v2207.ky10.x86_64.
ValueError: File context for /opt/VBoxGuestAdditions-7.0.12/other/mount.vboxsf already defined
VirtualBox Guest Additions: reloading kernel modules and services
VirtualBox Guest Additions: kernel modules and services 7.0.12 r159484 reloaded
VirtualBox Guest Additions: NOTE: you may still consider to re-login if some
user session specific services (Shared Clipboard, Drag and Drop, Seamless or
Guest Screen Resize) were not restarted automatically

#重启虚拟机
[root@localhost vboxsf]# reboot

重启虚拟机可以全屏显示。

操作操作初化始Oracle安装环境

修改主机名

[root@localhost ~]# hostnamectl set-hostname kylin
[root@kylin ~]# su -

hosts文件

[root@kylin ~]# vi /etc/hosts
#添加
192.168.56.117 kylin

用户创建

#创建用户组
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54330 racdba

#设置oracle用户的密码为Oracle_123
ORA_PWD=`echo "Oracle_123" |openssl passwd -stdin`

#创建oracle用户，并赋相应组
useradd -g oinstall -G dba,oper,backupdba,dgdba,kmdba,racdba -u 54321 oracle -p "$ORA_PWD" -m

#查看创建的用户
id oracle

安装目录创建

使用root用户操作

# 创建Oracle安装目录
mkdir -p /u01/app/oraInventory
mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1

# 创建Oracle安装目录
chown -R oracle:oinstall /u01/app/oracle
chown -R oracle:oinstall /u01/app/oraInventory

# 查看创建目录结构
tree /u01

/u01
└── app
    ├── oracle
    │   └── product
    │       └── 19.3.0
    │           └── dbhome_1
    └── oraInventory

6 directories, 0 files

系统参数修改

在 ”/etc/sysctl.conf“ 文件添加如下内容，或将如下内容添加到 “/etc/sysctl.d/98-oracle.conf"

# 将内容添加到98-oracle.conf文件
cat > /etc/sysctl.d/98-oracle.conf <<EOF
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
EOF

执行如下命令对设置的内核参数进行生效

/sbin/sysctl -p
# Or
/sbin/sysctl -p /etc/sysctl.d/98-oracle.conf

[root@kylin ~]# /sbin/sysctl -p
kernel.sysrq = 0
net.ipv4.ip_forward = 0
net.ipv4.conf.all.send_redirects = 0
net.ipv4.conf.default.send_redirects = 0
net.ipv4.conf.all.accept_source_route = 0
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.conf.all.accept_redirects = 0
net.ipv4.conf.default.accept_redirects = 0
net.ipv4.conf.all.secure_redirects = 0
net.ipv4.conf.default.secure_redirects = 0
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.icmp_ignore_bogus_error_responses = 1
net.ipv4.conf.all.rp_filter = 1
net.ipv4.conf.default.rp_filter = 1
net.ipv4.tcp_syncookies = 1
kernel.dmesg_restrict = 1
net.ipv6.conf.all.accept_redirects = 0
net.ipv6.conf.default.accept_redirects = 0

用户资源限制

将如下内容添加到 ”/etc/security/limits.d/oracle-database-preinstall-19c.conf“ 文件

#使用cat直接生成文件内容
cat > /etc/security/limits.d/oracle-database-preinstall-19c.conf <<EOF
oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768
oracle   hard   memlock    134217728
oracle   soft   memlock    134217728
EOF

用户环境变量设置

创建存放oracle用户的脚本文件夹

mkdir /home/oracle/scripts

创建设置环境变量的shell文件”setEnv.sh", 文件内容的“\” 是转义符，如果直接在命令行中使用export 设置变量不需要带“\" 。

cat > /home/oracle/scripts/setEnv.sh <<EOF
# Oracle Settings
export TMP=/tmp
export TMPDIR=\$TMP

export ORACLE_UNQNAME=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/19.3.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=orcl
export PDB_NAME=pdb1

export PATH=/usr/sbin:/usr/local/bin:\$PATH
export PATH=\$ORACLE_HOME/bin:\$PATH

export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
EOF

将setEnv.sh 添加到 “/home/oracle/.bash_profile”。

echo ". /home/oracle/scripts/setEnv.sh" >> /home/oracle/.bash_profile

创建数据库启动（start_all.sh)和关闭(stop_all.sh)脚本

cat > /home/oracle/scripts/start_all.sh <<EOF
#!/bin/bash
. /home/oracle/scripts/setEnv.sh

export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES

dbstart \$ORACLE_HOME
EOF


cat > /home/oracle/scripts/stop_all.sh <<EOF
#!/bin/bash
. /home/oracle/scripts/setEnv.sh

export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES

dbshut \$ORACLE_HOME
EOF

#设置用户属性
chown -R oracle:oinstall /home/oracle/scripts

#给脚本赋执行权限
chmod u+x /home/oracle/scripts/*.sh

[root@kylin ~]# ll /home/oracle/scripts/
总用量 12
-rwxr--r-- 1 oracle oinstall 452 12月 27 16:15 setEnv.sh
-rwxr--r-- 1 oracle oinstall 120 12月 27 16:15 start_all.sh
-rwxr--r-- 1 oracle oinstall 119 12月 27 16:15 stop_all.sh

关闭防火墙

# 关闭firewalld服务
systemctl stop firewalld
systemctl disable firewalld

#临时配置selinux
setenforce permissive

#修改selinux配置
vi /etc/selinux/config
将 SELINUX=enforcing 内容修改为 SELINUX=disabled

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

安装软件包

配置本地yum源，虚拟机挂载操作系统iso文件

#创建目录
mkdir /mnt/cdrom

#将光驱挂载到/mnt/cdrom目录
mount /dev/cdrom /mnt/cdrom

#查看挂载目录内容
ls -l /mnt/cdrom
总用量 544
dr-xr-xr-x 3 root root   2048  3月 15  2023 EFI
dr-xr-xr-x 3 root root   2048  3月 15  2023 images
dr-xr-xr-x 2 root root   2048  3月 15  2023 isolinux
dr-xr-xr-x 5 root root   2048  3月 24  2023 kylin-sm-package
-r--r--r-- 1 root root    441  3月 31  2023 LICENSE
dr-xr-xr-x 2 root root   2048  3月 15  2023 manual
dr-xr-xr-x 2 root root 538624  3月 24  2023 Packages
dr-xr-xr-x 2 root root   4096  3月 24  2023 repodata
-r--r--r-- 1 root root   2883  3月 31  2023 TRANS.TBL


# 创建本地yum repo文件
cat > /etc/yum.repos.d/kylin-media.repo <<EOF
[kylin-media]
name=Kylin V10
baseurl=file:///mnt/cdrom
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
EOF

# yum清理cache
yum makecache

# 查看Kylin的内核版本
[root@kylin ~]# nkvers
############## Kylin Linux Version #################
Release:
Kylin Linux Advanced Server release V10 (Lance)

Kernel:
4.19.90-52.22.v2207.ky10.x86_64

Build:
Kylin Linux Advanced Server
release V10 (SP3) /(Lance)-x86_64-Build23/20230324
#################################################

4.19.90 的内核与Oracle Linux 8，或者 Red Hat Enterprise Linux 8对应，选择安装如下软件包。

Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Solaris and MS Windows Operating Systems Installation and Configuration Requirements Quick Reference (12.1/12.2/18c/19c) (文档 ID 1587357.1)

# 使用yum安装软件包
yum install -y bc  \
binutils \
elfutils-libelf \
elfutils-libelf-devel \
fontconfig-devel \
glibc \
glibc-devel \
ksh \
libaio \
libaio-devel \
libXrender \
libX11 \
libXau \
libXi \
libXtst \
libgcc \
libnsl \
librdmacm \
libstdc++ \
libstdc++-devel \
libxcb \
libibverbs \
make \
policycoreutils \
policycoreutils-python-utils \
smartmontools \
sysstat

安装cvu软件包

[root@kylin soft]# rpm -ivh /u01/app/oracle/product/19.3.0/dbhome_1/cv/rpm/cvuqdisk-1.0.10-1.rpm
Verifying...                          ################################# [100%]
准备中...                          ################################# [100%]
Using default group oinstall to install package
正在升级/安装...
   1:cvuqdisk-1.0.10-1                ################################# [100%]

安装oracle软件

上传安装文件

#创建/soft目录，用来存放oracle安装文件
[root@kylin ~] mkdir /soft
[root@kylin soft]# ll
总用量 2987996
-rw-r--r-- 1 root root 3059705302 12月 27 16:57 LINUX.X64_193000_db_home.zip

#赋权限给oracle用户
[root@kylin soft]# chown -R oracle:oinstall /soft
[root@kylin soft]# ll
总用量 2987996
-rw-r--r-- 1 oracle oinstall 3059705302 12月 27 16:57 LINUX.X64_193000_db_home.zip

解压缩数据库安装文件

#切换到oracle用户
[root@kylin soft]# su - oracle

#进到/u01/app/oracle/product/19.3.0/dbhome_1 目录
[oracle@kylin ~]$ cd $ORACLE_HOME
[oracle@kylin dbhome_1]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1

#解压缩到安装ORACLE_HOME目录
[oracle@kylin dbhome_1]$ unzip /soft/LINUX.X64_193000_db_home.zip

安装数据库软件

使用oracle用户登录，打开终端

[oracle@kylin ~]$ cd $ORACLE_HOME
[oracle@kylin dbhome_1]$ ./runInstaller

出现这个错误是由于Kylin没有Oracle认证操作中，检测不通过，需要修改$ORACLE_HOME/cv/admin/cvu_config 配置文件

修改cvu_config

在kylin v10 sp3上安装 Oracle 19

PRVG-0282 : failed to retrieve the operating system distribution ID

解决办法：

#在$ORACLE_HOME/cv/admin/cvu_config 中增加一条记录：
vi $ORACLE_HOME/cv/admin/cvu_config 
CV_ASSUME_DISTID=ky10
 
或者直接命令：
echo "CV_ASSUME_DISTID=ky10" >> $ORACLE_HOME/cv/admin/cvu_config

修改后继续使用runInstaller

[oracle@kylin dbhome_1]$ ./runInstaller

选择“是”

点击“安装”

使用root用户执行

[root@kylin ~]# /u01/app/oraInventory/orainstRoot.sh
更改权限/u01/app/oraInventory.
添加组的读取和写入权限。
删除全局的读取, 写入和执行权限。

更改组名/u01/app/oraInventory 到 oinstall.
脚本的执行已完成。
[root@kylin ~]# /u01/app/oracle/product/19.3.0/dbhome_1/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/19.3.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Oracle Trace File Analyzer (TFA - Standalone Mode) is available at :
    /u01/app/oracle/product/19.3.0/dbhome_1/bin/tfactl

Note :
1. tfactl will use TFA Service if that service is running and user has been granted access
2. tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed

[root@kylin ~]#

点击“关闭”。

使用dbca创建实例

选择"Create a database"创建数据库

选择"Advanced configuration"

点击Next

SID输入orcl，打勾"Create as Container database" 创建CDB容器数据库

点击Next

不开启归档，后面再开启。

![image-20231226105608445](./assets/image-20231226105608445.png

创建侦听，

输入密码: Oracle_4U

[oracle@kylin ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 26-DEC-2023 11:13:53

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kylin)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                26-DEC-2023 11:00:41
Uptime                    0 days 0 hr. 13 min. 12 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/kylin/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kylin)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=kylin)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "0d6209332ab634e1e0637438a8c0e5cc" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "pdb" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

[oracle@kylin ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 26 11:14:19 2023
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> select open_mode from v$database;

OPEN_MODE
----------------------------------------
READ WRITE

SQL>

参考文档

1、Oracle Database 19c Installation On Oracle Linux 8 (OL8) https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-8

2、Database Installation Guide for Linux https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/automatically-configuring-oracle-linux-with-oracle-preinstallation-rpm.html#GUID-22846194-58EF-4552-AAC3-6F6D0A1DF794

3、Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Solaris and MS Windows Operating Systems Installation and Configuration Requirements Quick Reference (12.1/12.2/18c/19c) (文档 ID 1587357.1)

墨力计划 oracle19c

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

Kylin V10 SP3 安装 Oracle 19c 操作手册

Kylin V10 SP3 安装 Oracle 19c 操作手册

安装环境

创建虚拟机及安装操作系统

创建虚拟机

安装Kylin V10

添加虚拟机网卡

设置网卡启动

关闭防火墙，可以让MobaXTerm连接系统

安装VirtualBox增强功能包

操作操作初化始Oracle安装环境

修改主机名

hosts文件

用户创建

安装目录创建

系统参数修改

用户资源限制

用户环境变量设置

关闭防火墙

安装软件包

安装oracle软件

上传安装文件

解压缩数据库安装文件

安装数据库软件

修改cvu_config

使用dbca创建实例

参考文档

评论