VMware Workstation PRO版本

17.0.0

OS版本

Oracle Linux 8.6

内核版本

5.4.17-2136.307.3.1.el8uek.x86_64

主机名

OL86.e.cc

内存

8G

swap

16G

存储

100G+ (nvme)

IP地址

10.0.0.23

systemctl stop firewalld

systemctl disable firewalld

setenforce 0

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

vi /etc/hosts

#添加

10.0.0.23 OL86.e.cc

dnf install -y ./oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm

cat /etc/sysctl.conf |grep -v ^$|grep -v ^#

cat /etc/security/limits.d/oracle-database-preinstall-23c.conf |grep -v ^$|grep -v ^#

passwd oracle

dnf install -y ./oracle-database-free-23c-1.0-1.el8.x86_64.rpm

vi ~/.bash_profile

#添加

export ORACLE_SID=FREE

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=$ORACLE_BASE/product/23c/dbhomeFree

export NLS_LANG='AMERICAN_AMERICA.UTF8'

export PATH=$ORACLE_HOME/bin:$PATH

source ~/.bash_profile

select * from v$version;

select file_name from dba_data_files;

show pdbs

show con_name

试试新语法

select sysdate;

select length(file_name) filename_size,

         max(bytes) filesize

from dba_data_files

group by filename_size

having filesize>600000000;

不要思考这条语句有什么用,我只拿来试试新语法的(group by 和 having子句可以用别名了!)