ORACLE 23c免费版尝鲜 - 重庆思庄Oracle、Redhat认证学习论坛

preinstall.png (96.86 KB, 下载次数: 179)

2023-4-9 18:50 上传

3.2 安装 23c-free
[root@newserversetup]# yum localinstall oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm

23c-free.png (37.8 KB, 下载次数: 182)

2023-4-9 18:51 上传

3.3 配置数据库
      3.3.1 配置文件
               数据文件路径，可以提前配置文件 /etc/sysconfig/oracle-free-23c.conf，我这里没有配置，保持默认。
                     [root@newserver ~]# cat /etc/sysconfig/oracle-free-23c.conf

#This is a configuration file to setup theOracle Database.

#It is used when running'/etc/init.d/oracle-free-23c configure'.

# LISTENER PORT used Database listener,Leave empty for automatic port assignment

LISTENER_PORT=

# Character set of the database

CHARSET=AL32UTF8

# Database file directory

# If not specified, database files arestored under Oracle base/oradata

DBFILE_DEST=

# DB Domain name

DB_DOMAIN=

# SKIP Validations, memory, space

               SKIP_VALIDATIONS=false

      3.3.2 配置数据库

[root@newserver setup]#/etc/init.d/oracle-free-23c configure

为 SYS, SYSTEM and PDBADMIN accounts 设置密码，满足基本的口令复杂度：至少8个字符，1个大小，1个小写，一个数字。后面就等待安装吧，大概要安装30分钟，看个人的机器性能了，好好放松一下。

安装日志在：/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log.

Global Database Name:FREE

System Identifier(SID):FREE

Connect to Oracle Database using one of theconnect strings:

Pluggable database: newserver/FREEPDB1

Multitenant container database: newserver

config.png (45.94 KB, 下载次数: 174)

下载附件

2023-4-9 19:00 上传

4.检查安装情况
  4.1 配置域名解析
   如果不配，也可以用，只是你要有耐心等待
   # echo "192.168.133.121 newserver" >> /etc/hosts

      [root@newserver ~]# cat /etc/hosts
   127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
   ::1       localhost localhost.localdomain localhost6 localhost6.localdomain6
   192.168.133.121 newserver
   [root@newserver ~]#

  4.2 配置环境变量
      安装好后，没有环境变量，输入不方便，我这里配置一下：

[oracle@newserver ~]$ export ORACLE_BASE=/opt/oracle/
[oracle@newserver ~]$ export ORACLE_HOME=/opt/oracle/product/23c/dbhomeFree
[oracle@newserver ~]$ export ORACLE_SID=FREE
[oracle@newserver ~]$ export PATH=$ORACLE_HOME/bin:$PATH

4.3 检查一下监听
lsnrctl status

lsnrctl.png (35.39 KB, 下载次数: 161)

下载附件

2023-4-9 19:08 上传

4.4 检查一下数据库后台进程
ps -ef|grep ora

ora-process.png (66.15 KB, 下载次数: 183)

下载附件

2023-4-9 19:10 上传

   发现没有，进程不是以ORA_开头，而是以DB_,导致还找了一下。

5.本地登录访问
[oracle@newserver ~]$ sqlplus /nolog

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Sun Apr 9 18:47:51 2023
Version 23.2.0.0.0

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

SQL> conn / as sysdba
Connected.
SQL> show pdbs

CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 FREEPDB1                      READ WRITE NO

SQL> select name from v$tablespace;

NAME
------------------------------
SYSAUX
SYSTEM
UNDOTBS1
USERS
SYSAUX
SYSTEM
UNDOTBS1
TEMP
TEMP
SYSTEM
SYSAUX

NAME
------------------------------
UNDOTBS1
TEMP
USERS

14 rows selected.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/opt/oracle/oradata/FREE/system01.dbf
/opt/oracle/oradata/FREE/pdbseed/system01.dbf
/opt/oracle/oradata/FREE/sysaux01.dbf
/opt/oracle/oradata/FREE/pdbseed/sysaux01.dbf
/opt/oracle/oradata/FREE/users01.dbf
/opt/oracle/oradata/FREE/pdbseed/undotbs01.dbf
/opt/oracle/oradata/FREE/undotbs01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/system01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/sysaux01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/undotbs01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/users01.dbf

11 rows selected.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/opt/oracle/oradata/FREE/temp01.dbf
/opt/oracle/oradata/FREE/pdbseed/temp01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/temp01.dbf

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/opt/oracle/oradata/FREE/redo03.log
/opt/oracle/oradata/FREE/redo02.log
/opt/oracle/oradata/FREE/redo01.log

SQL> select group#,sequence#,thread#,status from v$log;

GROUP#  SEQUENCE# THREAD# STATUS
---------- ---------- ---------- ----------------
      1       1       1 CURRENT
      2       0       1 UNUSED
      3       0       1 UNUSED

SQL> select group#,sequence#,thread#,status,bytes/1024/1024 from v$log;

GROUP#  SEQUENCE# THREAD# STATUS          BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
      1       1       1 CURRENT                   200
      2       0       1 UNUSED                      200
      3       0       1 UNUSED                      200

par.png (27.16 KB, 下载次数: 172)

下载附件

2023-4-9 19:16 上传

user.png (49.04 KB, 下载次数: 182)

下载附件

2023-4-9 19:20 上传

6.配置数据库自动启动
  6.1 查找服务名
  [oracle@newserver ~]$ systemctl list-unit-files|grep oracle
oracle-database-preinstall-23c-firstboot.service generated
oracle-free-23c.service                         generated

  6.2 看状态
[oracle@newserver ~]$ systemctl status oracle-free-23c.service
● oracle-free-23c.service - SYSV: This script is responsible for taking care of configuring the RPM Oracle FREE Database and its associated services.
Loaded: loaded (/etc/rc.d/init.d/oracle-free-23c; generated)
Active: inactive (dead)
   Docs: man:systemd-sysv-generator(8)
[oracle@newserver ~]$

  6.3 开启随操作系统启动而启动
[oracle@newserver ~]$ systemctl is-enabled oracle-free-23c.service
oracle-free-23c.service is not a native service, redirecting to systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install is-enabled oracle-free-23c
disabled

[oracle@newserver ~]$ exit
logout
[root@newserver ~]# systemctl enable oracle-free-23c.service
oracle-free-23c.service is not a native service, redirecting to systemd-sysv-install.
Executing: /usr/lib/systemd/systemd-sysv-install enable oracle-free-23c
[root@newserver ~]#

  6.4 启动服务
[root@newserver ~]# systemctl start oracle-free-23c.service

  6.5 查看状态
[root@newserver ~]# systemctl status oracle-free-23c.service
● oracle-free-23c.service - SYSV: This script is responsible for taking care of configuring the RPM Oracle FREE Database and its associated services.
Loaded: loaded (/etc/rc.d/init.d/oracle-free-23c; generated)
Active: active (exited) since Sun 2023-04-09 19:23:20 CST; 1s ago
   Docs: man:systemd-sysv-generator(8)
  Process: 18131 ExecStart=/etc/rc.d/init.d/oracle-free-23c start (code=exited, status=0/SUCCESS)

Apr 09 19:23:20 newserver systemd[1]: Starting SYSV: This script is responsible for taking care of configuring the RPM Oracle FREE Database and its associated services....
Apr 09 19:23:20 newserver oracle-free-23c[18131]: The Oracle Database instance FREE is already started.
Apr 09 19:23:20 newserver systemd[1]: Started SYSV: This script is responsible for taking care of configuring the RPM Oracle FREE Database and its associated services..

当然，这个时候，你可以重启一下机器，看数据库是否会自动起来。此处自行测试。

7.远程连接数据库
7.1 关闭防火墙，或者开启端口
      如果简单，就直接关闭防火墙
         systemctl stop firewalld
      或者开启端口也可
      [root@newserver ~]# firewall-cmd --add-port=1521/tcp --permanent
      [root@newserver ~]# firewall-cmd --reload
      [root@newserver ~]# firewall-cmd --list-all
      public (active)
            target: default
      icmp-block-inversion: no
      interfaces: ens160
      sources:
      services: cockpit dhcpv6-client ssh
      ports: 1521/tcp
      protocols:
      forward: no
      masquerade: no
      forward-ports:
      source-ports:
      icmp-blocks:
      rich rules:
  7.2 测试从WINDOWS远程机器访问：