在RockyLinux 9.3环境中采用RPM模式部署Oracle 19C - 范振勇
source link: https://www.cnblogs.com/fanzhenyong/p/18141041
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
正文
在RockyLinux 9.3环境中采用RPM模式部署Oracle 19C
在开发数据库系统时,可以验证功能是否与Oracle的表现一致,验证正确性和兼容性
- 虚拟机安装,CPU 2*4 内存16G 磁盘100G
- 目标生产环境是RHEL 9.X,学习环境采用Rocky Linux 9.3
- 选择Oracle版本是长期支持版19C
- 只验证基础的功能,可以禁用CDB PDB
- 安装的Oracle只需要功能验证不用于生产环境,也不进行性能测试
bing上查找资料,一般找到的安装Oracle的资料是CentOS 7.x,8.x,而9.x的比较少,找到:
- 直接查找官方文档
- Oracle Database Installation Guide 19c for Linux
发现最新的19C没有要求安装补丁,并且支持RPM方式安装,过程非常简洁,尝试成功后总结,供大家参考。
- Oracle Database Installation Guide 19c for Linux
安装虚拟机的过程不再赘述,安装后需要做的准备工作如下:
- 关闭防火墙
#检查防火墙状态
systemctl status firewalld.service
#关闭防火墙
systemctl stop firewalld.service
#禁止开机启动防火墙
systemctl disable firewalld.service
- 关闭SELINUX
vi /etc/selinux/config
编辑内容:
#SELINUX=enforcing #注释掉
SELINUX=disabled #增加
存盘退出,下次重新启动后生效。如果想使配置立即生效,执行:
setenforce 0
- 配置域名
采用修改/etc/hostname的方式,重启后生效
vi /etc/hostname
oracle19c.learning.cn
- 配置域名解析
vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.154.19 oracle19c oracle19c.learning.cn
- 配置软件源
事先将rocky linux 9.3的ISO mount到/mnt/rocky9/
vi /etc/yum.repos.d/rocky.repo
[baseos]
name=Rocky Linux $releasever - BaseOS
baseurl=file:///mnt/rocky9/BaseOS/
gpgcheck=1
enabled=1
countme=1
metadata_expire=6h
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-9
[appstream]
name=Rocky Linux $releasever - AppStream
baseurl=file:///mnt/rocky9/AppStream/
gpgcheck=1
enabled=1
countme=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-Rocky-9
- 准备Oracle RPM
- 预安装RPM:
访问Oracle Linux 9的软件源,如x86对应的是: https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/,
找到对应Oracle 19c的预安装版本,如 oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm,下载该预安装rpm - Oracle 19C:
访问 Oracle下载页 找到最新的19C版本,如
oracle-database-ee-19c-1.0-1.x86_64.rpm,然后下载到本地
- Linux共享Windows目录
为了节省Linux的磁盘空间,直接在Linux中访问Windows下载的rpm
- 在Windows中共享保存rpm的文件夹,如名称为//192.168.154.1/Oracle
- 在Linux中链接Windows的共享
mkdir -p /mnt/oracle
mount -t cifs -o username=xxxx,password=yyyy //192.168.154.1/Oracle /mnt/oracle
请把"xxxx","yyyy"换成实际的用户名和密码
部署Oracle预安装RPM包
按官方文档,安装 Preinstallation RPM时会:
- 解析Oracle Grid Infrastructure和Oracle Database所需的依赖项,并自动下载和安装对应的RPM包
- 创建oracle用户,将其加入新创建的oraInventory (oinstall)和 OSDBA (dba)组中
- 按Oracle数据库预安装RPM程序的建议设置sysctl.conf、系统启动参数和驱动程序参数
- 设置硬和软资源限制 Linux进程资源访问限制
- 根据内核版本设置其他推荐参数
- 在Linux x86_64和Linux aarch64机器的内核中设置numa=off
dnf install -y /mnt/oracle/19c/oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm
Last metadata expiration check: 0:01:14 ago on Wed 17 Apr 2024 12:02:20 PM CST.
Dependencies resolved.
======================================================================================================
Package Architecture Version Repository Size
======================================================================================================
Installing:
oracle-database-preinstall-19c x86_64 1.0-1.el9 @commandline 33 k
Installing dependencies:
chkconfig x86_64 1.24-1.el9 baseos 161 k
gssproxy x86_64 0.8.4-6.el9 baseos 108 k
initscripts x86_64 10.11.5-1.el9 baseos 210 k
keyutils x86_64 1.6.3-1.el9 baseos 72 k
ksh x86_64 3:1.0.0~beta.1-3.el9 appstream 879 k
libXxf86dga x86_64 1.1.5-8.el9 appstream 20 k
libaio-devel x86_64 0.3.111-13.el9 appstream 10 k
libdmx x86_64 1.1.4-12.el9 appstream 16 k
libev x86_64 4.33-5.el9 baseos 52 k
libnfsidmap x86_64 1:2.5.4-20.el9 baseos 60 k
libnsl x86_64 2.34-83.el9.7 baseos 77 k
libverto-libev x86_64 0.3.2-3.el9 baseos 13 k
nfs-utils x86_64 1:2.5.4-20.el9 baseos 425 k
rpcbind x86_64 1.2.6-5.el9 baseos 56 k
sssd-nfs-idmap x86_64 2.9.1-4.el9_3 baseos 42 k
xorg-x11-utils x86_64 7.5-40.el9 appstream 106 k
xorg-x11-xauth x86_64 1:1.1-10.el9 appstream 36 k
Transaction Summary
======================================================================================================
Install 18 Packages
Total size: 2.3 M
Installed size: 7.5 M
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : libnfsidmap-1:2.5.4-20.el9.x86_64 1/18
Installing : ksh-3:1.0.0~beta.1-3.el9.x86_64 2/18
Running scriptlet: ksh-3:1.0.0~beta.1-3.el9.x86_64 2/18
Installing : libdmx-1.1.4-12.el9.x86_64 3/18
Installing : libXxf86dga-1.1.5-8.el9.x86_64 4/18
Installing : xorg-x11-utils-7.5-40.el9.x86_64 5/18
Installing : xorg-x11-xauth-1:1.1-10.el9.x86_64 6/18
Installing : libaio-devel-0.3.111-13.el9.x86_64 7/18
Installing : libnsl-2.34-83.el9.7.x86_64 8/18
Installing : keyutils-1.6.3-1.el9.x86_64 9/18
Installing : libev-4.33-5.el9.x86_64 10/18
Installing : libverto-libev-0.3.2-3.el9.x86_64 11/18
Installing : gssproxy-0.8.4-6.el9.x86_64 12/18
Running scriptlet: gssproxy-0.8.4-6.el9.x86_64 12/18
Running scriptlet: rpcbind-1.2.6-5.el9.x86_64 13/18
Installing : rpcbind-1.2.6-5.el9.x86_64 13/18
Running scriptlet: rpcbind-1.2.6-5.el9.x86_64 13/18
Created symlink /etc/systemd/system/multi-user.target.wants/rpcbind.service → /usr/lib/systemd/system/rpcbind.service.
Created symlink /etc/systemd/system/sockets.target.wants/rpcbind.socket → /usr/lib/systemd/system/rpcbind.socket.
Running scriptlet: nfs-utils-1:2.5.4-20.el9.x86_64 14/18
Installing : nfs-utils-1:2.5.4-20.el9.x86_64 14/18
Running scriptlet: nfs-utils-1:2.5.4-20.el9.x86_64 14/18
Installing : chkconfig-1.24-1.el9.x86_64 15/18
Installing : initscripts-10.11.5-1.el9.x86_64 16/18
Running scriptlet: initscripts-10.11.5-1.el9.x86_64 16/18
Created symlink /etc/systemd/system/sysinit.target.wants/import-state.service → /usr/lib/systemd/system/import-state.service.
Created symlink /etc/systemd/system/sysinit.target.wants/loadmodules.service → /usr/lib/systemd/system/loadmodules.service.
Running scriptlet: oracle-database-preinstall-19c-1.0-1.el9.x86_64 17/18
Installing : oracle-database-preinstall-19c-1.0-1.el9.x86_64 17/18
Installing : sssd-nfs-idmap-2.9.1-4.el9_3.x86_64 18/18
Running scriptlet: oracle-database-preinstall-19c-1.0-1.el9.x86_64 18/18
Running scriptlet: sssd-nfs-idmap-2.9.1-4.el9_3.x86_64 18/18
Verifying : chkconfig-1.24-1.el9.x86_64 1/18
Verifying : libverto-libev-0.3.2-3.el9.x86_64 2/18
Verifying : initscripts-10.11.5-1.el9.x86_64 3/18
Verifying : rpcbind-1.2.6-5.el9.x86_64 4/18
Verifying : libev-4.33-5.el9.x86_64 5/18
Verifying : sssd-nfs-idmap-2.9.1-4.el9_3.x86_64 6/18
Verifying : gssproxy-0.8.4-6.el9.x86_64 7/18
Verifying : nfs-utils-1:2.5.4-20.el9.x86_64 8/18
Verifying : libnfsidmap-1:2.5.4-20.el9.x86_64 9/18
Verifying : keyutils-1.6.3-1.el9.x86_64 10/18
Verifying : libnsl-2.34-83.el9.7.x86_64 11/18
Verifying : libaio-devel-0.3.111-13.el9.x86_64 12/18
Verifying : xorg-x11-xauth-1:1.1-10.el9.x86_64 13/18
Verifying : xorg-x11-utils-7.5-40.el9.x86_64 14/18
Verifying : libXxf86dga-1.1.5-8.el9.x86_64 15/18
Verifying : libdmx-1.1.4-12.el9.x86_64 16/18
Verifying : ksh-3:1.0.0~beta.1-3.el9.x86_64 17/18
Verifying : oracle-database-preinstall-19c-1.0-1.el9.x86_64 18/18
Installed:
chkconfig-1.24-1.el9.x86_64 gssproxy-0.8.4-6.el9.x86_64 initscripts-10.11.5-1.el9.x86_64
keyutils-1.6.3-1.el9.x86_64 ksh-3:1.0.0~beta.1-3.el9.x86_64 libXxf86dga-1.1.5-8.el9.x86_64
libaio-devel-0.3.111-13.el9.x86_64 libdmx-1.1.4-12.el9.x86_64 libev-4.33-5.el9.x86_64
libnfsidmap-1:2.5.4-20.el9.x86_64 libnsl-2.34-83.el9.7.x86_64 libverto-libev-0.3.2-3.el9.x86_64
nfs-utils-1:2.5.4-20.el9.x86_64 oracle-database-preinstall-19c-1.0-1.el9.x86_64
rpcbind-1.2.6-5.el9.x86_64 sssd-nfs-idmap-2.9.1-4.el9_3.x86_64
xorg-x11-utils-7.5-40.el9.x86_64 xorg-x11-xauth-1:1.1-10.el9.x86_64
Complete!
注意:安装完成后重新启动系统,确认所有的系统参数已经应用
验证预安装RPM的工作成果(不是强迫症无需关注这一部分)
- 检查依赖项,执行命令
dnf repoquery --requires oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm
/bin/sh
/etc/redhat-release
/usr/bin/bash
bc
bind-utils
binutils
ethtool
glibc
glibc-devel
initscripts
ksh
libaio
libaio-devel
libgcc
libnsl
libstdc++
libstdc++-devel
make
module-init-tools
net-tools
nfs-utils
openssh-clients
pam
policycoreutils
policycoreutils-python-utils
procps
psmisc
smartmontools
sysstat
tar
unzip
util-linux-ng
xorg-x11-utils
xorg-x11-xauth
显示所有的依赖项,说明在部署预安装RPM过程中,检查3个文件和31个rpm的依赖关系
- 检查系统配置/etc/sysctl.conf 增加了内容
cat /etc/sysctl.conf
# oracle-database-preinstall-19c setting for fs.file-max is 6815744
fs.file-max = 6815744
# oracle-database-preinstall-19c setting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128
# oracle-database-preinstall-19c setting for kernel.shmmni is 4096
kernel.shmmni = 4096
# oracle-database-preinstall-19c setting for kernel.shmall is 1073741824 on x86_64
kernel.shmall = 1073741824
# oracle-database-preinstall-19c setting for kernel.shmmax is 4398046511104 on x86_64
kernel.shmmax = 4398046511104
# oracle-database-preinstall-19c setting for kernel.panic_on_oops is 1 per Orabug 19212317
kernel.panic_on_oops = 1
# oracle-database-preinstall-19c setting for net.core.rmem_default is 262144
net.core.rmem_default = 262144
# oracle-database-preinstall-19c setting for net.core.rmem_max is 4194304
net.core.rmem_max = 4194304
# oracle-database-preinstall-19c setting for net.core.wmem_default is 262144
net.core.wmem_default = 262144
# oracle-database-preinstall-19c setting for net.core.wmem_max is 1048576
net.core.wmem_max = 1048576
# oracle-database-preinstall-19c setting for net.ipv4.conf.all.rp_filter is 2
net.ipv4.conf.all.rp_filter = 2
# oracle-database-preinstall-19c setting for net.ipv4.conf.default.rp_filter is 2
net.ipv4.conf.default.rp_filter = 2
# oracle-database-preinstall-19c setting for fs.aio-max-nr is 1048576
fs.aio-max-nr = 1048576
# oracle-database-preinstall-19c setting for net.ipv4.ip_local_port_range is 9000 65500
net.ipv4.ip_local_port_range = 9000 65500
注: 原文件备份在/etc/sysctl.d/99-initial-sysctl.conf
- 检查系统配置/etc/sysconfig/network 增加了内容
cat /etc/sysconfig/network
# Created by anaconda
# oracle-database-preinstall-19c : Add NOZEROCONF=yes
NOZEROCONF=yes
- 检查进程资源配置
cat /etc/security/limits.d/oracle-database-preinstall-19c.conf
# oracle-database-preinstall-19c setting for nofile soft limit is 1024
oracle soft nofile 1024
# oracle-database-preinstall-19c setting for nofile hard limit is 65536
oracle hard nofile 65536
# oracle-database-preinstall-19c setting for nproc soft limit is 16384
# refer orabug15971421 for more info.
oracle soft nproc 16384
# oracle-database-preinstall-19c setting for nproc hard limit is 16384
oracle hard nproc 16384
# oracle-database-preinstall-19c setting for stack soft limit is 10240KB
oracle soft stack 10240
# oracle-database-preinstall-19c setting for stack hard limit is 32768KB
oracle hard stack 32768
# oracle-database-preinstall-19c setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM
oracle hard memlock 134217728
# oracle-database-preinstall-19c setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
oracle soft memlock 134217728
# oracle-database-preinstall-19c setting for data soft limit is 'unlimited'
oracle soft data unlimited
# oracle-database-preinstall-19c setting for data hard limit is 'unlimited'
oracle hard data unlimited
- 检查进启动配置的变化
diff /boot/grub2/grub.cfg /boot/grub2/grub.cfg-oracle-database-preinstall-19c.orabackup
设置“numa=off transparent_hugepage=never”关闭了透明大页和numa
< set kernelopts="root=/dev/mapper/rl-root ro crashkernel=1G-4G:192M,4G-64G:256M,64G-:512M resume=/dev/mapper/rl-swap rd.lvm.lv=rl/root rd.lvm.lv=rl/swap rhgb quiet numa=off transparent_hugepage=never "
---
> set kernelopts="root=/dev/mapper/rl-root ro crashkernel=1G-4G:192M,4G-64G:256M,64G-:512M resume=/dev/mapper/rl-swap rd.lvm.lv=rl/root rd.lvm.lv=rl/swap rhgb quiet "
注意:修改了内核参数,需要重新启动
- 验证创建用户和用户组
groups oracle
oracle : oinstall dba oper backupdba dgdba kmdba racdba
id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)
从结果可见oracle属于7个组
- 验证透明大页是否关闭
cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise [never]
cat /sys/kernel/mm/transparent_hugepage/defrag
always defer defer+madvise [madvise] never
- 也可以查看安装日志
cat /var/log/oracle-database-preinstall-19c/results/orakernel.log
安装Oracle RPM
dnf install -y /mnt/oracle/19c/oracle-database-ee-19c-1.0-1.x86_64.rpm
Last metadata expiration check: 0:04:44 ago on Wed 17 Apr 2024 12:02:20 PM CST.
Dependencies resolved.
==========================================================================================================
Package Architecture Version Repository Size
==========================================================================================================
Installing:
oracle-database-ee-19c x86_64 1.0-1 @commandline 2.5 G
Transaction Summary
==========================================================================================================
Install 1 Package
Total size: 2.5 G
Installed size: 6.9 G
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: oracle-database-ee-19c-1.0-1.x86_64 1/1
Installing : oracle-database-ee-19c-1.0-1.x86_64 1/1
Running scriptlet: oracle-database-ee-19c-1.0-1.x86_64 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure
Verifying : oracle-database-ee-19c-1.0-1.x86_64 1/1
Installed:
oracle-database-ee-19c-1.0-1.x86_64
Complete!
禁用CDB
vi /etc/init.d/oracledb_ORCLCDB-19c
...
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export ORACLE_VERSION=19c
export ORACLE_SID=ORCLCDB
export TEMPLATE_NAME=General_Purpose.dbc
export CHARSET=AL32UTF8
export PDB_NAME=ORCLPDB1
export LISTENER_NAME=LISTENER
export NUMBER_OF_PDBS=1
export CREATE_AS_CDB=true
修改为
export CREATE_AS_CDB=false
初始化数据库
[root@oracle19c ansible]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
Prepare for db operation
10% complete
Copying database files
40% complete
Creating and starting Oracle instance
42% complete
46% complete
50% complete
54% complete
60% complete
Completing Database Creation
66% complete
70% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.
Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.
可以查看详细一点儿的日志(输出了时间)
cat /opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log
本次初始化耗时6分钟,对比没有禁用CDB的一次实验,初始化耗时15分钟
修改oracle用户的环境变量
su - oracle
vi .bashrc
# 在原文件最后增加
umask 022
export TMP=/tmp
export TMPDIR=$TMP
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19c/dbhome_1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_SID=ORCLCDB
export PATH=$ORACLE_HOME/bin:$PATH
小技巧:修改.bashrc 而不是.bash_profile的原因是可以支持非登录模式执行shell
验证基本功能
返回root重新以oracle用户执行
su - oracle
[oracle@oracle19c ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 18 17:23:03 2024
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> create table t1(a int primary key,b varchar(16));
Table created.
SQL> insert into t1 values(100,'beijing');
1 row created.
SQL> insert into t1 values(200,'天津');
1 row created.
SQL> select * from t1 order by a desc;
A B
---------- ----------------
200 天津
100 beijing
重新启动系统后,发现服务不会自动重启,设置自动重启
采用RPM安装并没有设置自动重新启动Oracle的服务,运行 sqlplus / as sysdba 执行简单SQL报错,信息如下:
[oracle@oracle19c ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 18 22:59:25 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> select * from t1 ;
select * from t1
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
所以要手工增加自动重启的服务,此处主要参考ORACLE 19C 在centos 7的本地rpm包安装及调试,个别地方稍作修正
- 设置公共环境变量文件
vi /etc/sysconfig/ORCLCDB.oracledb
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
ORACLE_SID=ORCLCDB
- 创建监听服务
vi /usr/lib/systemd/system/[email protected]
[Unit]
Description=Oracle Net Listener
After=syslog.target network.target
[Service]
Type=forking
EnvironmentFile=/etc/sysconfig/ORCLCDB.oracledb
ExecStart=/opt/oracle/product/19c/dbhome_1/bin/lsnrctl start
ExecStop=/opt/oracle/product/19c/dbhome_1/bin/lsnrctl stop
User=oracle
[Install]
WantedBy=multi-user.target
- 创建服务启动服务
vi /usr/lib/systemd/system/[email protected]
[Unit]
Description=Oracle Database service
After=syslog.target network.target lsnrctl.service
[Service]
Type=forking
EnvironmentFile=/etc/sysconfig/ORCLCDB.oracledb
ExecStart=/opt/oracle/product/19c/dbhome_1/bin/dbstart $ORACLE_HOME
ExecStop=/opt/oracle/product/19c/dbhome_1/bin/dbshut $ORACLE_HOME
User=oracle
[Install]
WantedBy=multi-user.target
vi /etc/oratab
...
#ORCLCDB:/opt/oracle/product/19c/dbhome_1:N
#将此处原来的N修改为Y
ORCLCDB:/opt/oracle/product/19c/dbhome_1:Y
-
激活服务
systemctl enable ORCLCDB@lsnrctl
systemctl enable ORCLCDB@oracledb -
小技巧,先不忙着启动系统,先手工启动服务进行验证
systemctl start ORCLCDB@lsnrctl
systemctl start ORCLCDB@oracledb
如果有错误信息,则通过 systemctl status ORCLCDB@lsnrctl 分析问题
- 重启后检验服务状态
[root@oracle19c ansible]# netstat -tunlp | grep -E '1521|5500'
tcp6 0 0 :::5500 :::* LISTEN 1090/tnslsnr
tcp6 0 0 :::1521 :::* LISTEN 1090/tnslsnr
[root@oracle19c ansible]# su - oracle
[oracle@oracle19c ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 18 23:21:52 2024
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 * from t2 ;
A B
---------- ----------------
100 beijing
200 天津
本文的内容主要来自网络,但是经过了本人多次的验证和整理,剔除了一些不必要的环节,也为大家跳过了一些坑。如果有不足之处,请不吝指正,我一定及时修改更新。
1、RPM安装的限制
- 仅用于安装 Oracle 数据库软件,RAC不能这样安装,并且扣除preinstallation,安装rpm的难度与静默安装相当。
- RPM 只能用于安装软件,而不能用于更新软件
- 无法控制软件安装的目录,即不一定能满足企业安装规范的目录约束
- 推荐仅用于实验环境,不要用于生产环境
2、一些坑(网上个别文档有些笔误)
- 19C 缺省在/etc/init.d/oracledb_ORCLCDB-19c 设置了字符集为AL32UTF8,无需在其他地方设置服务器字符集
- /etc/hosts 一定要设置正确,但是无需删除127.0.0.1,::1 那两行
- 预安装RPM准备的内容见“验证预安装RPM的工作成果”部分,这些工作都不需要手工执行
- 仅仅功能验证的话不要启动CDB,否则连创建一个普通用户都要好几步操作
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK