{"id":28001,"date":"2023-04-27T13:02:50","date_gmt":"2023-02-16T10:39:47","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/"},"modified":"2025-08-12T05:48:20","modified_gmt":"2025-08-11T21:48:20","slug":"%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/","title":{"rendered":"\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free"},"content":{"rendered":"

\u9996\u51482023\u5e744\u6708\uff0cOracle\u6570\u636e\u5e9323c Free\uff08\u4ee5\u4e0b\u7b80\u79f023cFree\uff09\u5f00\u59cb\u63d0\u4f9b\u3002\u867d\u7136\u4e0e\u4e4b\u524d\u7684XE\u7c7b\u4f3c\uff0c\u4f46XE\u662f\u5728\u6b63\u5f0f\u7248\u672c\u53d1\u5e03\u540e\u63d0\u4f9b\u7684\uff0c\u800c\u8fd9\u6b21\u5219\u662f\u5148\u63d0\u4f9b\u4e86Free\u7248\u3002<\/p>\n

Oracle\u6570\u636e\u5e9323c\u5c06\u6210\u4e3a19c\u540e\u7684\u9996\u4e2a\u957f\u671f\u652f\u6301\u7248\u672c\uff0c\u4e5f\u662f\u9996\u4e2a\u4e0d\u518d\u652f\u6301\u975e\u5bb9\u5668\u6570\u636e\u5e93\u7684\u7248\u672c\u3002<\/p>\n

\u5c3d\u7ba1\u5c1a\u672a\u786e\u5b9a\u6b63\u5f0f\u7248\u7684\u53d1\u5e03\u65f6\u95f4\uff0c23cFree\u548c\u6b63\u5f0f\u7248\u5728\u529f\u80fd\u4e0a\u4f3c\u4e4e\u5b58\u5728\u5dee\u5f02\u3002\u4e3a\u4e86\u4e86\u89e3\u5b83\u4eec\u7684\u7279\u70b9\uff0c\u6211\u4eec\u9996\u5148\u8fdb\u884c\u4e86\u9884\u5148\u8c03\u67e5\u5e76\u5c1d\u8bd5\u4e86\u5b89\u88c5\u3002<\/p>\n

\u4e4b\u524d\u6211\u4e00\u76f4\u8ba4\u4e3a\u6211\u4e0d\u80fd\u518d\u4f7f\u7528\u4ee5\u524d\u5e38\u7528\u7684CentOS\u4e86\uff0c\u4f46\u6700\u8fd1\u624d\u77e5\u9053\u539f\u6765\u53ef\u4ee5\u4f7f\u7528CentOS Stream 8\uff08\u4e5f\u67099\u7248\u672c\uff09\uff0c\u6240\u4ee5\u8fd9\u6b21\u6211\u6253\u7b97\u5728CentOS Stream 8\u4e0a\u5b89\u88c523cFree\u3002<\/p>\n

\u53e6\u5916\uff0c\u56e0\u4e3a\u673a\u7f18\u5de7\u5408\uff0c\u6211\u51b3\u5b9a\u91cd\u65b0\u6574\u7406\u4e00\u4e0b\u5728CentOS Stream 8\u73af\u5883\u4e2d\u5b89\u88c5Oracle\u6570\u636e\u5e93\u65f6\u5e94\u8fdb\u884c\u7684\u5fc5\u8981\u8bbe\u7f6e\u3002<\/p>\n

\u8bf7\u53c2\u9605\u4ee5\u4e0b\u6709\u517323cFree\u7684\u6587\u7ae0\u3002<\/p>\n

 <\/p>\n

\u5b89\u88c5 CentOS Stream 8\u5173\u4e8e\u4e0b\u8f7d\u548c\u5b89\u88c5ISO\u955c\u50cf\uff0c\u8bf7\u53c2\u8003\u4ee5\u4e0b\u6587\u7ae0\u3002
\n\u8fd9\u6b21\u6211\u4eec\u5728Oracle VM\u4e0a\u642d\u5efa\u4e86\u73af\u5883\u3002<\/p>\n

 <\/p>\n

CentOS Stream 8\u7684\u914d\u7f6e\u8bbe\u5b9a\u5728\u5b89\u88c523cFree\u4e4b\u524d\uff0c\u4e3a\u4e86\u4fdd\u9669\u8d77\u89c1\uff0c\u5148\u8fdb\u884c\u9884\u5b9a\u7684\u64cd\u4f5c\u7cfb\u7edf\u8bbe\u7f6e\u3002<\/p>\n

\u5728CentOS Stream 8\u4e2d\uff0c\u5982\u679c\u5728\u64cd\u4f5c\u7cfb\u7edf\u5b89\u88c5\u65f6\u521b\u5efa\u4e00\u4e2aOS\u8d26\u53f7\uff0c\u5b83\u4f1a\u81ea\u52a8\u6dfb\u52a0\u5230”wheel”\u7528\u6237\u7ec4\u4e2d\uff0c\u56e0\u6b64\u6839\u636e\u89c4\u8303\u5e94\u8be5\u4f7f\u7528sudo\u8fdb\u884c\u4ee5\u4e0b\u8bbe\u7f6e\uff0c\u4f46\u4e3a\u4e86\u65b9\u4fbf\u8d77\u89c1\uff0c\u6211\u4eec\u9009\u62e9\u4f7f\u7528root\u7528\u6237\u8fdb\u884c\u64cd\u4f5c\u3002<\/p>\n

\u7981\u7528SELinux\u3002\u7f16\u8f91\/etc\/selinux\/config\u6587\u4ef6\uff0c\u5e76\u5c06SELINUX\u7684\u503c\u66f4\u6539\u4e3adisabled\uff0c\u7136\u540e\u91cd\u65b0\u542f\u52a8\u64cd\u4f5c\u7cfb\u7edf\u3002<\/p>\n
[<\/span>root@centos8stream ~]# vim \/etc\/selinux\/config \r\n\r\n# This file controls the state of SELinux on the system.<\/span>\r\n# SELINUX= can take one of these three values:<\/span>\r\n#     enforcing - SELinux security policy is enforced.<\/span>\r\n#     permissive - SELinux prints warnings instead of enforcing.<\/span>\r\n#     disabled - No SELinux policy is loaded.<\/span>\r\n#SELINUX=enforcing<\/span>\r\nSELINUX<\/span>=<\/span>disabled\r\n# SELINUXTYPE= can take one of these three values:<\/span>\r\n#     targeted - Targeted processes are protected,<\/span>\r\n#     minimum - Modification of targeted policy. Only selected processes are protected. <\/span>\r\n#     mls - Multi Level Security protection.<\/span>\r\nSELINUXTYPE<\/span>=<\/span>targeted\r\n\r\n[<\/span>root@centos8stream ~]# \r\n[<\/span>root@centos8stream ~]# reboot\r\n<\/code><\/pre>\n
\u7981\u7528Firewalld\u505c\u6b62\u5e76\u7981\u7528Firewalld\u3002<\/p>\n
[<\/span>root@centos8stream etc]# systemctl stop firewalld\r\n[<\/span>root@centos8stream etc]# systemctl disable firewalld\r\n<\/code><\/pre>\n
\u4fee\u6539journald\u7684\u8bbe\u7f6e\u6211\u5011\u5c07\u66f4\u6539syslog\u7684\u8a2d\u5b9a\uff0c\u4f7f\u5176\u6c38\u4e45\u4fdd\u5b58\u5728\u78c1\u76e4\u4e2d\u3002<\/p>\n
[<\/span>root@centos8stream ~]# vim \/etc\/systemd\/journald.conf \r\n#  This file is part of systemd.<\/span>\r\n#<\/span>\r\n#  systemd is free software; you can redistribute it and\/or modify it<\/span>\r\n#  under the terms of the GNU Lesser General Public License as published by<\/span>\r\n#  the Free Software Foundation; either version 2.1 of the License, or<\/span>\r\n#  (at your option) any later version.<\/span>\r\n#<\/span>\r\n# Entries in this file show the compile time defaults.<\/span>\r\n# You can change settings by editing this file.<\/span>\r\n# Defaults can be restored by simply deleting this file.<\/span>\r\n#<\/span>\r\n# See journald.conf(5) for details.<\/span>\r\n\r\n[<\/span>Journal]\r\nStorage<\/span>=<\/span>persistent\r\n#Compress=yes<\/span>\r\n#Seal=yes<\/span>\r\n#SplitMode=uid<\/span>\r\n#SyncIntervalSec=5m<\/span>\r\nRateLimitIntervalSec<\/span>=<\/span>0\r\nRateLimitBurst<\/span>=<\/span>0\r\n#SystemMaxUse=<\/span>\r\n#SystemKeepFree=<\/span>\r\n#SystemMaxFileSize=<\/span>\r\n#SystemMaxFiles=100<\/span>\r\n#RuntimeMaxUse=<\/span>\r\n#RuntimeKeepFree=<\/span>\r\n#RuntimeMaxFileSize=<\/span>\r\n#RuntimeMaxFiles=100<\/span>\r\n#MaxRetentionSec=<\/span>\r\n#MaxFileSec=1month<\/span>\r\n#ForwardToSyslog=no<\/span>\r\n#ForwardToKMsg=no<\/span>\r\n#ForwardToConsole=no<\/span>\r\n#ForwardToWall=yes<\/span>\r\n#TTYPath=\/dev\/console<\/span>\r\n#MaxLevelStore=debug<\/span>\r\n#MaxLevelSyslog=debug<\/span>\r\n#MaxLevelKMsg=notice<\/span>\r\n#MaxLevelConsole=info<\/span>\r\n#MaxLevelWall=emerg<\/span>\r\n#LineMax=48K<\/span>\r\nSystemMaxUse<\/span>=<\/span>1G\r\n\r\n[<\/span>root@centos8stream ~]# systemctl restart systemd-journald\r\n<\/code><\/pre>\n
NTP\u670d\u52a1\u5668\u8bbe\u7f6e
\n\u6307\u5b9a\u4e00\u4e2aNTP\u670d\u52a1\u5668\uff0c\u5e76\u5c06\u65f6\u95f4\u540c\u6b65\u8bbe\u7f6e\u4e3a\u6162\u901f\u6a21\u5f0f\u3002\u672c\u6b21\u9009\u62e9\u4e86jp.pool.ntp.org\u4f5c\u4e3aNTP\u670d\u52a1\u5668\u3002<\/p>\n
[<\/span>root@centos8stream ~]# vim \/etc\/chrony.conf \r\n# Use public servers from the pool.ntp.org project.<\/span>\r\n# Please consider joining the pool (http:\/\/www.pool.ntp.org\/join.html).<\/span>\r\n#pool 2.centos.pool.ntp.org iburst<\/span>\r\nserver jp.pool.ntp.org prefer iburst\r\n\r\n# Record the rate at which the system clock gains\/losses time.<\/span>\r\ndriftfile \/var\/lib\/chrony\/drift\r\n\r\n# Allow the system clock to be stepped in the first three updates<\/span>\r\n# if its offset is larger than 1 second.<\/span>\r\nmakestep 1.0 3\r\n\r\n# Enable kernel synchronization of the real-time clock (RTC).<\/span>\r\nrtcsync\r\n\r\n# Enable hardware timestamping on all interfaces that support it.<\/span>\r\n#hwtimestamp *<\/span>\r\n\r\n# Increase the minimum number of selectable sources required to adjust<\/span>\r\n# the system clock.<\/span>\r\n#minsources 2<\/span>\r\n\r\n# Allow NTP client access from local network.<\/span>\r\n#allow 192.168.0.0\/16<\/span>\r\n\r\n# Serve time even if not synchronized to a time source.<\/span>\r\n#local stratum 10<\/span>\r\n\r\n# Specify file containing keys for NTP authentication.<\/span>\r\nkeyfile \/etc\/chrony.keys\r\n\r\n# Get TAI-UTC offset and leap seconds from the system tz database.<\/span>\r\nleapsectz right\/UTC\r\n\r\n# Specify directory for log files.<\/span>\r\nlogdir \/var\/log\/chrony\r\n\r\n# Select which information is logged.<\/span>\r\n#log measurements statistics tracking<\/span>\r\n\r\nleapsecmode slew\r\n\r\n[<\/span>root@centos8stream ~]# systemctl restart chronyd\r\n<\/code><\/pre>\n
\u8bf7\u786e\u8ba4\u548c\u5fc5\u8981\u65f6\u66f4\u6539\u64cd\u4f5c\u7cfb\u7edf\u7684\u65f6\u533a\u3002\u5728\u5b89\u88c5\u64cd\u4f5c\u7cfb\u7edf\u65f6\uff0c\u6211\u5728GUI\u754c\u9762\u4e0a\u5c06\u65f6\u533a\u8bbe\u7f6e\u4e3a\u201cAsia\/Tokyo\u201d\u3002\u4f46\u4e0d\u77e5\u4e3a\u4f55\uff0c\u5b9e\u9645\u4e0a\u5374\u53d8\u6210\u4e86\u201cAmerica\/New_York (EDT)\u201d\u3002\u56e0\u6b64\uff0c\u6211\u9700\u8981\u66f4\u6539\u64cd\u4f5c\u7cfb\u7edf\u7684\u65f6\u533a\u8bbe\u7f6e\u3002<\/p>\n
[<\/span>root@centos8stream ~]# timedatectl status\r\n               Local time<\/span>: \u706b 2023-05-16 07:38:20 EDT\r\n           Universal time<\/span>: \u706b 2023-05-16 11:38:20 UTC\r\n                 RTC time<\/span>: \u706b 2023-05-16 11:38:21\r\n                Time zone: America\/New_York (<\/span>EDT, -0400<\/span>)<\/span>\r\nSystem clock synchronized: yes\r\n              <\/span>NTP service: active\r\n          RTC in <\/span>local <\/span>TZ: no\r\n[<\/span>root@centos8stream ~]# \r\n[<\/span>root@centos8stream ~]# timedatectl set-timezone Asia\/Tokyo\r\n[<\/span>root@centos8stream ~]# \r\n[<\/span>root@centos8stream ~]# timedatectl status\r\n               Local time<\/span>: \u706b 2023-05-16 20:39:19 JST\r\n           Universal time<\/span>: \u706b 2023-05-16 11:39:19 UTC\r\n                 RTC time<\/span>: \u706b 2023-05-16 11:39:20\r\n                Time zone: Asia\/Tokyo (<\/span>JST, +0900)<\/span>\r\nSystem clock synchronized: yes\r\n              <\/span>NTP service: active\r\n          RTC in <\/span>local <\/span>TZ: no\r\n[<\/span>root@centos8stream ~]# \r\n<\/code><\/pre>\n
\u4e3b\u673a\u8bbe\u7f6e\u6211\u4f1a\u8fdb\u884c\/etc\/hosts\u6587\u4ef6\u7684\u8bbe\u7f6e\u3002<\/p>\n
[<\/span>root@centos8stream etc]# vim \/etc\/hosts\r\n192.168.XXX.XXX  centos8stream\r\n127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4\r\n::1         localhost localhost.localdomain localhost6 localhost6.localdomain6\r\n<\/code><\/pre>\n
\u5b89\u88c523cFree\u5982\u679c\u8981\u5728Linux\u4e0a\u5b89\u88c5\u6b63\u5f0f\u7248\u7684Oracle\uff0c\u9700\u8981\u4e8b\u5148\u8fdb\u884c\u4e00\u4e9b\u51c6\u5907\u5de5\u4f5c\uff0c\u4f8b\u5982\u521b\u5efaoracle\u7528\u6237\u3001oinstall\u7b49\u7ec4\uff0c\u8bbe\u7f6e\u5185\u6838\u53c2\u6570\u7b49\u7b49\u3002\u4f46\u662f\uff0c\u5bf9\u4e8e23cFree\u6765\u8bf4\uff0c\u53ea\u9700\u5b89\u88c5\u4e24\u4e2arpm\u8f6f\u4ef6\u5305\uff0c\u57fa\u672c\u4e0a\u5c31\u53ef\u4ee5\u653e\u5fc3\u5730\u5b8c\u6210\u5b89\u88c5\u3002<\/p>\n
\u53ef\u4ece\u4ee5\u4e0b\u7f51\u7ad9\u4e0b\u8f7d\u7528\u4e8e\u5b89\u88c5\u7684RPM\u3002<\/p>\n
 <\/p>\n
\u4ece\u4e0a\u8ff0\u7f51\u7ad9\u4e0b\u8f7d\u4ee5\u4e0b\u4e24\u4e2aRPM\uff0c\u5e76\u5c06\u5176\u653e\u7f6e\u5728\u670d\u52a1\u5668\u4e0a\u3002
\n\u3010RHEL\u548cCentOS\u7684\u9884\u5b89\u88c5RPM\u3011
\noracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm<\/p>\n
\u3010\u9002\u7528\u4e8eLinux x64\u7684Oracle Database 23c \u514d\u8d39\u7684\u5f00\u53d1\u8005\u9884\u89c8\u7248\uff08OL8\u6216RHEL8\uff09\u3011
\noracle-database-free-23c-1.0-1.el8.x86_64.rpm<\/p>\n
\u6211\u5df2\u7ecf\u6309\u7167\u4ee5\u4e0b\u6b65\u9aa4\u5b89\u88c5\u4e8623cFree\u548c\u521b\u5efa\u4e86\u6570\u636e\u5e93\u3002<\/p>\n
 <\/p>\n
\u5b89\u88c5oracle-database-preinstall-23c\u3002
\n\u5b83\u4f1a\u81ea\u52a8\u5b89\u88c5\u6216\u66f4\u65b0\u6240\u9700\u7684Oracle\u8f6f\u4ef6\u5305\u3002<\/p>\n
[<\/span>root@centos8stream ~]# dnf localinstall oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm \r\n\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u671f\u9650\u5207\u308c\u306e\u6700\u7d42\u78ba\u8a8d: 0:22:46 \u6642\u9593\u524d\u306e 2023\u5e7405\u670815\u65e5 04\u664241\u520612\u79d2 \u306b\u5b9f\u65bd\u3057\u307e\u3057\u305f\u3002\r\n\u4f9d\u5b58\u95a2\u4fc2\u304c\u89e3\u6c7a\u3057\u307e\u3057\u305f\u3002\r\n======================================================================================================================================================================================<\/span>\r\n \u30d1\u30c3\u30b1\u30fc\u30b8                                            \u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc              \u30d0\u30fc\u30b8\u30e7\u30f3                                             \u30ea\u30dd\u30b8\u30c8\u30ea\u30fc                        \u30b5\u30a4\u30ba\r\n======================================================================================================================================================================================<\/span>\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb:\r\n oracle-database-preinstall-23c                        x86_64                        1.0-0.5.el8                                            @commandline                         30 k\r\n\u4f9d\u5b58\u95a2\u4fc2\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb:\r\n compat-openssl10                                      x86_64                        1:1.0.2o-4.el8                                         appstream                           1.1 M\r\n glibc-devel                                           x86_64                        2.28-225.el8                                           baseos                               83 k\r\n glibc-headers                                         x86_64                        2.28-225.el8                                           baseos                              488 k\r\n kernel-headers                                        x86_64                        4.18.0-490.el8                                         baseos                               11 M\r\n ksh                                                   x86_64                        20120801-257.el8                                       appstream                           929 k\r\n libnsl                                                x86_64                        2.28-225.el8                                           baseos                              105 k\r\n libxcrypt-devel                                       x86_64                        4.1.1-6.el8                                            baseos                               25 k\r\n lm_sensors-libs                                       x86_64                        3.4.0-23.20180522git70f7e08.el8                        baseos                               59 k\r\n make                                                  x86_64                        1:4.2.1-11.el8                                         baseos                              498 k\r\n sysstat                                               x86_64                        11.7.3-9.el8                                           appstream                           426 k\r\n\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u6982\u8981\r\n======================================================================================================================================================================================<\/span>\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb  11 \u30d1\u30c3\u30b1\u30fc\u30b8\r\n\r\n\u5408\u8a08\u30b5\u30a4\u30ba: 15 M\r\n\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30b5\u30a4\u30ba\u306e\u5408\u8a08: 15 M\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5f8c\u306e\u30b5\u30a4\u30ba: 17 M\r\n\u3053\u308c\u3067\u3088\u308d\u3057\u3044\u3067\u3059\u304b? [<\/span>y\/N]: y\r\n\u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9:\r\n(<\/span>1\/10)<\/span>: sysstat-11.7.3-9.el8.x86_64.rpm                                                                                                               485 kB\/s | 426 kB     00:00    \r\n(<\/span>2\/10)<\/span>: ksh-20120801-257.el8.x86_64.rpm                                                                                                               902 kB\/s | 929 kB     00:01    \r\n(<\/span>3\/10)<\/span>: compat-openssl10-1.0.2o-4.el8.x86_64.rpm                                                                                                      1.1 MB\/s | 1.1 MB     00:01    \r\n(<\/span>4\/10)<\/span>: glibc-devel-2.28-225.el8.x86_64.rpm                                                                                                           228 kB\/s |  83 kB     00:00    \r\n(<\/span>5\/10)<\/span>: libnsl-2.28-225.el8.x86_64.rpm                                                                                                                1.2 MB\/s | 105 kB     00:00    \r\n(<\/span>6\/10)<\/span>: libxcrypt-devel-4.1.1-6.el8.x86_64.rpm                                                                                                        492 kB\/s |  25 kB     00:00    \r\n(<\/span>7\/10)<\/span>: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64.rpm                                                                                    1.1 MB\/s |  59 kB     00:00    \r\n(<\/span>8\/10)<\/span>: glibc-headers-2.28-225.el8.x86_64.rpm                                                                                                         721 kB\/s | 488 kB     00:00    \r\n(<\/span>9\/10)<\/span>: make-4.2.1-11.el8.x86_64.rpm                                                                                                                  1.1 MB\/s | 498 kB     00:00    \r\n(<\/span>10\/10)<\/span>: kernel-headers-4.18.0-490.el8.x86_64.rpm                                                                                                     8.4 MB\/s |  11 MB     00:01    \r\n--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>\r\n\u5408\u8a08                                                                                                                                                  2.5 MB\/s |  15 MB     00:05     \r\nCentOS Stream 8 - AppStream                                                                                                                           1.5 MB\/s | 1.6 kB     00:00    \r\nGPG \u9375 XXXXXXXXXX \u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u4e2d:\r\n Userid     : \"CentOS (CentOS Official Signing Key) <security@centos.org>\"<\/span>\r\n Fingerprint: XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX\r\n From       : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-centosofficial\r\n\u3053\u308c\u3067\u3088\u308d\u3057\u3044\u3067\u3059\u304b? [<\/span>y\/N]: y\r\n\u9375\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306b\u6210\u529f\u3057\u307e\u3057\u305f\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u3092\u5b9f\u884c\u4e2d\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u306b\u6210\u529f\u3057\u307e\u3057\u305f\u3002\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u30c6\u30b9\u30c8\u3092\u5b9f\u884c\u4e2d\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u30c6\u30b9\u30c8\u306b\u6210\u529f\u3057\u307e\u3057\u305f\u3002\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u4e2d\r\n  \u6e96\u5099             :                                                                                                                                                              1\/1 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : make-1:4.2.1-11.el8.x86_64                                                                                                                                  1\/11 \r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: make-1:4.2.1-11.el8.x86_64                                                                                                                                  1\/11 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : compat-openssl10-1:1.0.2o-4.el8.x86_64                                                                                                                      2\/11 \r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: compat-openssl10-1:1.0.2o-4.el8.x86_64                                                                                                                      2\/11 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                                                      3\/11 \r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                                                      3\/11 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : sysstat-11.7.3-9.el8.x86_64                                                                                                                                 4\/11 \r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: sysstat-11.7.3-9.el8.x86_64                                                                                                                                 4\/11 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : libnsl-2.28-225.el8.x86_64                                                                                                                                  5\/11 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : kernel-headers-4.18.0-490.el8.x86_64                                                                                                                        6\/11 \r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: glibc-headers-2.28-225.el8.x86_64                                                                                                                           7\/11 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : glibc-headers-2.28-225.el8.x86_64                                                                                                                           7\/11 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : libxcrypt-devel-4.1.1-6.el8.x86_64                                                                                                                          8\/11 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : glibc-devel-2.28-225.el8.x86_64                                                                                                                             9\/11 \r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: glibc-devel-2.28-225.el8.x86_64                                                                                                                             9\/11 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : ksh-20120801-257.el8.x86_64                                                                                                                                10\/11 \r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: ksh-20120801-257.el8.x86_64                                                                                                                                10\/11 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64                                                                                                          11\/11 \r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: oracle-database-preinstall-23c-1.0-0.5.el8.x86_64                                                                                                          11\/11 \r\n  \u691c\u8a3c             : compat-openssl10-1:1.0.2o-4.el8.x86_64                                                                                                                      1\/11 \r\n  \u691c\u8a3c             : ksh-20120801-257.el8.x86_64                                                                                                                                 2\/11 \r\n  \u691c\u8a3c             : sysstat-11.7.3-9.el8.x86_64                                                                                                                                 3\/11 \r\n  \u691c\u8a3c             : glibc-devel-2.28-225.el8.x86_64                                                                                                                             4\/11 \r\n  \u691c\u8a3c             : glibc-headers-2.28-225.el8.x86_64                                                                                                                           5\/11 \r\n  \u691c\u8a3c             : kernel-headers-4.18.0-490.el8.x86_64                                                                                                                        6\/11 \r\n  \u691c\u8a3c             : libnsl-2.28-225.el8.x86_64                                                                                                                                  7\/11 \r\n  \u691c\u8a3c             : libxcrypt-devel-4.1.1-6.el8.x86_64                                                                                                                          8\/11 \r\n  \u691c\u8a3c             : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                                                      9\/11 \r\n  \u691c\u8a3c             : make-1:4.2.1-11.el8.x86_64                                                                                                                                 10\/11 \r\n  \u691c\u8a3c             : oracle-database-preinstall-23c-1.0-0.5.el8.x86_64                                                                                                          11\/11 \r\n\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e08\u307f:\r\n  compat-openssl10-1:1.0.2o-4.el8.x86_64 glibc-devel-2.28-225.el8.x86_64                   glibc-headers-2.28-225.el8.x86_64  kernel-headers-4.18.0-490.el8.x86_64                  \r\n  ksh-20120801-257.el8.x86_64            libnsl-2.28-225.el8.x86_64                        libxcrypt-devel-4.1.1-6.el8.x86_64 lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64\r\n  make-1:4.2.1-11.el8.x86_64             oracle-database-preinstall-23c-1.0-0.5.el8.x86_64 sysstat-11.7.3-9.el8.x86_64       \r\n\r\n\u5b8c\u4e86\u3057\u307e\u3057\u305f!\r\n<\/code><\/pre>\n
Oracle Database Free 23c\u5b89\u88c5
\n23cFree\u7684\u5b89\u88c5\u975e\u5e38\u7b80\u5355\uff0c\u53ea\u9700\u8981\u5b89\u88c5\u8f6f\u4ef6\u5305\u5373\u53ef\u3002<\/p>\n
[<\/span>root@centos8stream ~]# dnf localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm \r\n\u30e1\u30bf\u30c7\u30fc\u30bf\u306e\u671f\u9650\u5207\u308c\u306e\u6700\u7d42\u78ba\u8a8d: 0:24:11 \u6642\u9593\u524d\u306e 2023\u5e7405\u670815\u65e5 04\u664241\u520612\u79d2 \u306b\u5b9f\u65bd\u3057\u307e\u3057\u305f\u3002\r\n\u4f9d\u5b58\u95a2\u4fc2\u304c\u89e3\u6c7a\u3057\u307e\u3057\u305f\u3002\r\n======================================================================================================================================================================================<\/span>\r\n \u30d1\u30c3\u30b1\u30fc\u30b8                                              \u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc                      \u30d0\u30fc\u30b8\u30e7\u30f3                           \u30ea\u30dd\u30b8\u30c8\u30ea\u30fc                                \u30b5\u30a4\u30ba\r\n======================================================================================================================================================================================<\/span>\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb:\r\n oracle-database-free-23c                                x86_64                                1.0-1                                @commandline                                1.6 G\r\n\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u6982\u8981\r\n======================================================================================================================================================================================<\/span>\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb  1 \u30d1\u30c3\u30b1\u30fc\u30b8\r\n\r\n\u5408\u8a08\u30b5\u30a4\u30ba: 1.6 G\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5f8c\u306e\u30b5\u30a4\u30ba: 5.2 G\r\n\u3053\u308c\u3067\u3088\u308d\u3057\u3044\u3067\u3059\u304b? [<\/span>y\/N]: y\r\n\u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9:\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u3092\u5b9f\u884c\u4e2d\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u306b\u6210\u529f\u3057\u307e\u3057\u305f\u3002\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u30c6\u30b9\u30c8\u3092\u5b9f\u884c\u4e2d\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u30c6\u30b9\u30c8\u306b\u6210\u529f\u3057\u307e\u3057\u305f\u3002\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u4e2d\r\n  \u6e96\u5099             :                                                                                                                                                              1\/1 \r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: oracle-database-free-23c-1.0-1.x86_64                                                                                                                        1\/1 \r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d   : oracle-database-free-23c-1.0-1.x86_64                                                                                                                        1\/1 \r\n  scriptlet\u306e\u5b9f\u884c\u4e2d: oracle-database-free-23c-1.0-1.x86_64                                                                                                                        1\/1 \r\n[<\/span>INFO] Executing post installation scripts...\r\n[<\/span>INFO] Oracle home installed successfully and ready to be configured.\r\nTo configure Oracle Database Free, optionally modify the parameters in<\/span> '\/etc\/sysconfig\/oracle-free-23c.conf'<\/span> and then <\/span>run '\/etc\/init.d\/oracle-free-23c configure'<\/span> as root.\r\n\r\n  \u691c\u8a3c             : oracle-database-free-23c-1.0-1.x86_64                                                                                                                        1\/1 \r\n\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e08\u307f:\r\n  oracle-database-free-23c-1.0-1.x86_64                                                                                                                                               \r\n\r\n\u5b8c\u4e86\u3057\u307e\u3057\u305f!\r\n<\/code><\/pre>\n
\u6211\u5011\u4f86\u6aa2\u67e5\u5b89\u88dd\u5f8c\u7684\u72c0\u614b\u3002<\/p>\n
\u786e\u8ba4Oracle\u7528\u6237\u7ec4\u3002\u201dOracle\u7528\u6237\u548c\u7528\u6237\u7ec4\u5df2\u7ecf\u88ab\u521b\u5efa\u597d\u4e86\u3002<\/p>\n
[<\/span>root@centos8stream etc]# id <\/span>oracle\r\nuid<\/span>=<\/span>54321(<\/span>oracle)<\/span> gid<\/span>=<\/span>54321(<\/span>oinstall)<\/span> groups<\/span>=<\/span>54321(<\/span>oinstall)<\/span>,54322(<\/span>dba)<\/span>,54323(<\/span>oper)<\/span>,54324(<\/span>backupdba)<\/span>,54325(<\/span>dgdba)<\/span>,54326(<\/span>kmdba)<\/span>,54330(<\/span>racdba)<\/span>\r\n<\/code><\/pre>\n
\u6838\u5fc3\u53c2\u6570\u7684\u786e\u8ba4
\n\u9664\u4e86HugePage\u7684\u8bbe\u7f6e\u5916\uff0c\u5176\u4ed6\u8bbe\u7f6e\u5df2\u7ecf\u88ab\u9002\u5f53\u5730\u8bbe\u7f6e\u597d\u4e86\u3002<\/p>\n
[<\/span>root@centos8stream etc]# cat <\/span>sysctl.conf\r\n# sysctl settings are defined through files in<\/span>\r\n# \/usr\/lib\/sysctl.d\/, \/run\/sysctl.d\/, and \/etc\/sysctl.d\/.<\/span>\r\n#<\/span>\r\n# Vendors settings live in \/usr\/lib\/sysctl.d\/.<\/span>\r\n# To override a whole file, create a new file with the same in<\/span>\r\n# \/etc\/sysctl.d\/ and put new settings there. To override<\/span>\r\n# only specific settings, add a file with a lexically later<\/span>\r\n# name in \/etc\/sysctl.d\/ and put new settings there.<\/span>\r\n#<\/span>\r\n# For more information, see sysctl.conf(5) and sysctl.d(5).<\/span>\r\n\r\n# oracle-database-preinstall-23c setting for fs.file-max is 6815744<\/span>\r\nfs.file-max =<\/span> 6815744\r\n\r\n# oracle-database-preinstall-23c setting for kernel.sem is '250 32000 100 128'<\/span>\r\nkernel.sem =<\/span> 250 32000 100 128\r\n\r\n# oracle-database-preinstall-23c setting for kernel.shmmni is 4096<\/span>\r\nkernel.shmmni =<\/span> 4096\r\n\r\n# oracle-database-preinstall-23c setting for kernel.shmall is 1073741824 on x86_64<\/span>\r\nkernel.shmall =<\/span> 1073741824\r\n\r\n# oracle-database-preinstall-23c setting for kernel.shmmax is 4398046511104 on x86_64<\/span>\r\nkernel.shmmax =<\/span> 4398046511104\r\n\r\n# oracle-database-preinstall-23c setting for kernel.panic_on_oops is 1 per Orabug 19212317<\/span>\r\nkernel.panic_on_oops =<\/span> 1\r\n\r\n# oracle-database-preinstall-23c setting for net.core.rmem_default is 262144<\/span>\r\nnet.core.rmem_default =<\/span> 262144\r\n\r\n# oracle-database-preinstall-23c setting for net.core.rmem_max is 4194304<\/span>\r\nnet.core.rmem_max =<\/span> 4194304\r\n\r\n# oracle-database-preinstall-23c setting for net.core.wmem_default is 262144<\/span>\r\nnet.core.wmem_default =<\/span> 262144\r\n\r\n# oracle-database-preinstall-23c setting for net.core.wmem_max is 1048576<\/span>\r\nnet.core.wmem_max =<\/span> 1048576\r\n\r\n# oracle-database-preinstall-23c setting for net.ipv4.conf.all.rp_filter is 2<\/span>\r\nnet.ipv4.conf.all.rp_filter =<\/span> 2\r\n\r\n# oracle-database-preinstall-23c setting for fs.aio-max-nr is 1048576<\/span>\r\nfs.aio-max-nr =<\/span> 1048576\r\n\r\n# oracle-database-preinstall-23c setting for net.ipv4.ip_local_port_range is 9000 65500<\/span>\r\nnet.ipv4.ip_local_port_range =<\/span> 9000 65500\r\n\r\n[<\/span>root@centos8stream etc]#\r\n<\/code><\/pre>\n
\u572823cFree\u4e2d\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u4f1a\u8fdb\u884cSGA_TARGET\u548cPGA_AGGREGATE_TARGET\u7684\u5185\u5b58\u8bbe\u7f6e\uff0c\u56e0\u6b64\u5728\u521b\u5efa\u6570\u636e\u5e93\u4e4b\u540e\uff0c\u6839\u636e\u9700\u8981\u53ef\u4ee5\u8fdb\u884cHugePages\u7684\u8bbe\u7f6e\uff08\u975e\u5fc5\u9700\uff09\u3002<\/p>\n
\u5982\u679c\u8981\u6307\u5b9aHugePages\uff0c\u9700\u8981\u5728\/etc\/sysctl.conf\u4e2d\u6307\u5b9a”vm.nr_hugepages”\u7684\u503c\u5e76\u6dfb\u52a0\u3002\u6307\u5b9a\u7684\u503c\u4f1a\u6839\u636eSGA_TARGET\u7684\u503c\u800c\u53d8\u5316\u3002
\n(\u8ba1\u7b97\u516c\u5f0f)
\nvm.nr_hugepages = (SGA_TARGET\u7684\u503c(MB) + 50MB) \/ hugepagesize = (SGA_TARGET\u7684\u503c(MB) + 50MB) \/ 2
\n\u572823cFree\u4e2d\uff0cSGA_TARGET\u6307\u5b9a\u4e3a536M\uff0c\u6240\u4ee5\u5982\u679c\u8981\u8fdb\u884cHugePages\u8bbe\u7f6e\uff0c\u9700\u8981\u5728vm.nr_hugepages\u4e2d\u6307\u5b9a293\u3002
\nvm.nr_hugepages = 293\u53e6\u5916\uff0c\u8fd8\u9700\u8981\u5728\/etc\/security\/limits.conf\u4e2d\u6307\u5b9amemlock\uff08\u5305\u62ecsoft\u548chard\u4e24\u79cd\u503c\uff09\u5e76\u6dfb\u52a0\u3002\u6307\u5b9a\u7684\u503c\u4f1a\u6839\u636eSGA_TARGET\u7684\u503c\u800c\u53d8\u5316\u3002
\n(\u8ba1\u7b97\u516c\u5f0f)
\nmemlock = (SGA_TARGET\u7684\u503c(MB) + 50MB + 10MB) * 1024 (KB)
\n\u572823cFree\u4e2d\uff0cmemlock\u9700\u8981\u6307\u5b9a\u4e3a(536+50+10)*1024=610304\u3002
\noracle soft memlock 610304
\noracle hard memlock 610304<\/p>\n
\u8bf7\u63d0\u4f9b\u4ee5\u4e0b\u6587\u672c\u7684\u4e2d\u6587\u8bd1\u6587\uff1a\/etc\/security\/limits.conf\u7684\u914d\u7f6e\u3002<\/p>\n
\u572819c\u4e2d\uff0c\u9664\u4e86HugePages\u76f8\u5173\u7684\u8bbe\u7f6e\u5916\uff0c\u8fd8\u9700\u8981\u4ee5\u4e0b\u8bbe\u7f6e\uff0c\u4f46\u5728\u5b89\u88c523cFree\u540e\uff0c\u8fd9\u4e9b\u8bbe\u7f6e\u4ecd\u672a\u88ab\u6dfb\u52a0\u3002<\/p>\n
oracle           soft    nproc           <\/span>2047\r\noracle           hard    nproc           <\/span>16384\r\noracle           soft    nofile          1024\r\noracle           hard    nofile          65536\r\noracle           soft    stack           10240\r\noracle           hard    stack           32768\r\n<\/code><\/pre>\n
\u767b\u5f55\u7684\/etc\/pam.d\/login\u914d\u7f6e\u572819c\u7248\u672c\u4e2d\uff0c\u5df2\u7ecf\u6dfb\u52a0\u4e86\u4ee5\u4e0b\u8bbe\u7f6e\uff0c\u4f46\u5728\u5b89\u88c523c Free\u4e4b\u540e\uff0c\u5e76\u6ca1\u6709\u6dfb\u52a0\u8fd9\u4e9b\u8bbe\u7f6e\u3002<\/p>\n
session    required     pam_limits.so\r\n<\/code><\/pre>\n
\/etc\/profile\u7684\u914d\u7f6e
\n\u6211\u572819c\u4e2d\u6dfb\u52a0\u4e86\u4ee5\u4e0b\u914d\u7f6e\uff0c\u4f46\u5728\u5b89\u88c523cFree\u540e\uff0c\u914d\u7f6e\u5e76\u6ca1\u6709\u88ab\u6dfb\u52a0\u8fdb\u6765\u3002<\/p>\n
if<\/span> [<\/span> $USER<\/span> =<\/span> \"oracle\"<\/span> ]<\/span>;<\/span> then\r\n    if<\/span> [<\/span> $SHELL<\/span> =<\/span> \"\/bin\/ksh\"<\/span> ]<\/span>;<\/span> then\r\n        <\/span>ulimit<\/span> -p<\/span> 16384\r\n        ulimit<\/span> -n<\/span> 65536\r\n    else\r\n        <\/span>ulimit<\/span> -u<\/span> 16384 -n<\/span> 65536\r\n    fi\r\n    <\/span>umask <\/span>022\r\nfi<\/span>\r\n<\/code><\/pre>\n
\u900f\u660e\u5927\u9875\u8bbe\u7f6e\u900f\u660e\u5de8\u9875\u5df2\u7ecf\u914d\u7f6e\u597d\u4e86\u3002<\/p>\n
[<\/span>root@centos8stream etc]# cat<\/span> \/sys\/kernel\/mm\/transparent_hugepage\/enabled \r\nalways madvise [<\/span>never]\r\n[<\/span>root@centos8stream etc]# \r\n[<\/span>root@centos8stream etc]# cat<\/span> \/sys\/kernel\/mm\/transparent_hugepage\/defrag \r\nalways defer defer+madvise madvise [<\/span>never]\r\n<\/code><\/pre>\n
\u5728RHEL\u7684\u60c5\u51b5\u4e0b\uff0c\u9700\u8981\u6ce8\u610f\u900f\u660e\u5927\u9875\u9762\u8bbe\u7f6e\u65f6\u7684\u8def\u5f84\u662f\u4e0d\u540c\u7684\u3002
\n(RHEL\u7684\u60c5\u51b5\u4e0b)
\n\/sys\/kernel\/mm\/redhat_transparent_hugepage\/enabled
\n\/sys\/kernel\/mm\/redhat_transparent_hugepage\/defrag\u6211\u60f3\u5728\u6b63\u5f0f\u7248\u672c\u53d1\u5e03\u540e\u91cd\u65b0\u786e\u8ba4\u4e0a\u8ff0\u64cd\u4f5c\u7cfb\u7edf\u8bbe\u7f6e\u5468\u8fb9\u7684\u60c5\u51b5\u3002<\/p>\n
\u521b\u5efa\u6570\u636e\u5e93\u5b89\u88c523cFree\u540e\uff0c\u4ee5root\u7528\u6237\u6267\u884c\/etc\/init.d\/oracle-free-23c configure\u547d\u4ee4\uff0c\u5c06\u521b\u5efa\u6570\u636e\u5e93\u3002<\/p>\n
\u6211\u8ba4\u4e3a\u57fa\u672c\u9ed8\u8ba4\u8bbe\u7f6e\u5c31\u53ef\u4ee5\u4e86\uff0c\u4f46\u5982\u679c\u4f60\u60f3\u66f4\u6539\u4fa6\u542c\u5668\u7aef\u53e3\u6216\u6570\u636e\u5e93\u5b57\u7b26\u96c6\u4e4b\u7c7b\u7684\u5185\u5bb9\uff0c\u4f60\u53ef\u4ee5\u5148\u7f16\u8f91\/etc\/sysconfig\/oracle-free-23c.conf\u6587\u4ef6\uff0c\u7136\u540e\u6267\u884c\/etc\/init.d\/oracle-free-23c configure\u547d\u4ee4\u3002<\/p>\n
[<\/span>root@centos8stream etc]# cat<\/span> \/etc\/sysconfig\/oracle-free-23c.conf\r\n#This is a configuration file to setup the Oracle Database. <\/span>\r\n#It is used when running '\/etc\/init.d\/oracle-free-23c configure'.<\/span>\r\n\r\n# LISTENER PORT used Database listener, Leave empty for automatic port assignment<\/span>\r\nLISTENER_PORT<\/span>=<\/span>\r\n\r\n# Character set of the database<\/span>\r\nCHARSET<\/span>=<\/span>AL32UTF8\r\n\r\n# Database file directory<\/span>\r\n# If not specified, database files are stored under Oracle base\/oradata<\/span>\r\nDBFILE_DEST<\/span>=<\/span>\r\n\r\n# DB Domain name<\/span>\r\nDB_DOMAIN<\/span>=<\/span>\r\n\r\n# SKIP Validations, memory, space<\/span>\r\nSKIP_VALIDATIONS<\/span>=<\/span>false<\/span>\r\n<\/code><\/pre>\n
\u521b\u5efa\u6570\u636e\u5e93\u4f7f\u7528\u6839\u7528\u6237\u6267\u884c\/etc\/init.d\/oracle-free-23c configure\u547d\u4ee4\u65f6\uff0c\u4f1a\u8be2\u95eeSYS\u3001SYSTEM\u3001PDBADMIN\u7528\u6237\u7684\u5bc6\u7801\uff0c\u8bbe\u7f6e\u540e\u5c06\u5f00\u59cb\u521b\u5efaCDB\u548cPDB\uff08\u4e00\u4e2a\uff09\u3002<\/p>\n
[<\/span>root@centos8stream ~]# \/etc\/init.d\/oracle-free-23c configure\r\nSpecify a password to be used for <\/span>database accounts. Oracle recommends that the password entered should be at least 8 characters in <\/span>length, contain at least 1 uppercase character, 1 lower case<\/span> character and 1 digit [<\/span>0-9]. Note that the same password will be used for <\/span>SYS, SYSTEM and PDBADMIN accounts:\r\nConfirm the password:\r\nConfiguring Oracle Listener.\r\nListener configuration succeeded.\r\nConfiguring Oracle Database FREE.\r\nSYS\u30e6\u30fc\u30b6\u30fc\u30fb\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044: \r\n************<\/span>\r\nSYSTEM\u30e6\u30fc\u30b6\u30fc\u30fb\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044: \r\n************<\/span>\r\nPDBADMIN\u30e6\u30fc\u30b6\u30fc\u30fb\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044: \r\n***************<\/span>\r\nDB\u64cd\u4f5c\u306e\u6e96\u5099\r\n7%\u5b8c\u4e86\r\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30fb\u30d5\u30a1\u30a4\u30eb\u306e\u30b3\u30d4\u30fc\u4e2d\r\n29%\u5b8c\u4e86\r\nOracle\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210\u304a\u3088\u3073\u8d77\u52d5\u4e2d\r\n30%\u5b8c\u4e86\r\n33%\u5b8c\u4e86\r\n36%\u5b8c\u4e86\r\n39%\u5b8c\u4e86\r\n43%\u5b8c\u4e86\r\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210\u306e\u5b8c\u4e86\r\n47%\u5b8c\u4e86\r\n49%\u5b8c\u4e86\r\n50%\u5b8c\u4e86\r\n\u30d7\u30e9\u30ac\u30d6\u30eb\u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\r\n54%\u5b8c\u4e86\r\n71%\u5b8c\u4e86\r\n\u69cb\u6210\u5f8c\u30a2\u30af\u30b7\u30e7\u30f3\u306e\u5b9f\u884c\r\n93%\u5b8c\u4e86\r\n\u30ab\u30b9\u30bf\u30e0\u30fb\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u4e2d\r\n100%\u5b8c\u4e86\r\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002\u8a73\u7d30\u306f\u3001\u6b21\u306e\u5834\u6240\u306b\u3042\u308b\u30ed\u30b0\u30fb\u30d5\u30a1\u30a4\u30eb\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044:\r\n\/opt\/oracle\/cfgtoollogs\/dbca\/FREE\r\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u60c5\u5831:\r\n\u30b0\u30ed\u30fc\u30d0\u30eb\u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d:FREE\r\n\u30b7\u30b9\u30c6\u30e0\u8b58\u5225\u5b50(<\/span>SID)<\/span>:FREE\r\n\u8a73\u7d30\u306f\u30ed\u30b0\u30fb\u30d5\u30a1\u30a4\u30eb\"\/opt\/oracle\/cfgtoollogs\/dbca\/FREE\/FREE.log\"<\/span>\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\r\n\r\nConnect to Oracle Database using one of the connect strings:\r\n     Pluggable database: centos8stream\/FREEPDB1\r\n     Multitenant container database: centos8stream\r\n[<\/span>root@centos8stream ~]#\r\n<\/code><\/pre>\n
\u5f53\u5b8c\u6210\u540e\uff0cSID(CDB)\uff1aFREE\uff0cPDB\uff1aFREEPDB1\u5c06\u4f1a\u88ab\u521b\u5efa\u3002<\/p>\n
\u5b89\u88c5rlwrap\u4e3a\u4e86\u5728SQL*Plus\u4e2d\u4f7f\u7528\u5386\u53f2\u529f\u80fd\uff0c\u9700\u8981\u5b89\u88c5rlwrap\u3002\u4e3a\u4e86\u5b89\u88c5rlwrap\uff0c\u9700\u8981\u5148\u5b89\u88c5EPEL\u4ed3\u5e93\u3002<\/p>\n
# dnf install https:\/\/dl.fedoraproject.org\/pub\/epel\/epel-release-latest-8.noarch.rpm<\/span>\r\n<\/code><\/pre>\n
\u63a5\u4e0b\u6765\u5b89\u88c5rlwrap\u3002<\/p>\n
# dnf install rlwrap<\/span>\r\n<\/code><\/pre>\n
\u8bbe\u5b9a\u73af\u5883\u53d8\u91cf
\n\u5207\u6362\u5230Oracle\u7528\u6237\u5e76\u5c06\u73af\u5883\u53d8\u91cf\u8bbe\u7f6e\u5982\u4e0b\u3002<\/p>\n
# .bash_profile<\/span>\r\n# Get the aliases and functions<\/span>\r\nif<\/span> [<\/span> -f<\/span> ~\/.bashrc ]<\/span>;<\/span> then<\/span>\r\n        .<\/span> ~\/.bashrc\r\nfi<\/span>\r\n\r\n# User specific environment and startup programs<\/span>\r\nexport <\/span>ORACLE_BASE<\/span>=<\/span>\/opt\/oracle\r\nexport <\/span>ORACLE_HOME<\/span>=<\/span>$ORACLE_BASE<\/span>\/product\/23c\/dbhomeFree\r\nexport <\/span>PATH<\/span>=<\/span>$PATH<\/span>:$ORACLE_HOME<\/span>\/bin\r\nexport <\/span>ORACLE_SID<\/span>=<\/span>FREE\r\nexport <\/span>NLS_LANG<\/span>=<\/span>Japanese_Japan.AL32UTF8\r\n#export ORAENV_ASK=NO<\/span>\r\nalias <\/span>sqlplus<\/span>=<\/span>'rlwrap sqlplus'<\/span>\r\n<\/code><\/pre>\n
\u4ee5SYS\u7528\u6237\u767b\u5f55\u5230CDB\u5e76\u8fdb\u884c\u521d\u59cb\u8bbe\u7f6e\u3002
\n\u8fde\u63a5\u5230CDB\u548cPDB\uff0c\u5e76\u4fee\u6539\u5ba1\u8ba1\u8bbe\u7f6e\u548c\u9ed8\u8ba4\u6982\u8981\u6587\u4ef6\u3002\u53e6\u5916\uff0c\u8bbe\u7f6ePDB\u81ea\u52a8\u542f\u52a8\uff08\u4fdd\u5b58\u72b6\u6001\uff09\u3002<\/p>\n
[<\/span>oracle<\/span>@<\/span>centos8stream<\/span> ~<\/span>]<\/span>$<\/span> sqlplus<\/span> \/<\/span> as<\/span> sysdba<\/span>\r\nSQL<\/span>*<\/span>Plus<\/span>:<\/span> Release<\/span> 23<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span> -<\/span> Developer<\/span>-<\/span>Release<\/span> on<\/span> \u6708<\/span> 5<\/span>\u6708<\/span> 15<\/span> 05<\/span>:<\/span>47<\/span>:<\/span>18<\/span> 2023<\/span>\r\nVersion<\/span> 23<\/span>.<\/span>2<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span>\r\nCopyright<\/span> (<\/span>c<\/span>)<\/span> 1982<\/span>,<\/span> 2023<\/span>,<\/span> Oracle<\/span>.<\/span>  All<\/span> rights<\/span> reserved<\/span>.<\/span>\r\n\r\nOracle<\/span> Database<\/span> 23<\/span>c<\/span> Free<\/span>,<\/span> Release<\/span> 23<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span> -<\/span> Developer<\/span>-<\/span>Release<\/span>\r\nVersion<\/span> 23<\/span>.<\/span>2<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span>\r\n\u306b\u63a5\u7d9a\u3055\u308c\u307e\u3057\u305f\u3002<\/span>\r\nSQL<\/span>><\/span> \r\nSQL<\/span>><\/span> noaudit<\/span> all<\/span>;<\/span>\r\nnoaudit<\/span> all<\/span> privileges<\/span>;<\/span>\r\nnoaudit<\/span> exempt<\/span> access<\/span> policy<\/span>;<\/span>\r\n\r\nALTER<\/span> PROFILE<\/span> DEFAULT<\/span> LIMIT<\/span>\r\nFAILED_LOGIN_ATTEMPTS<\/span> 10<\/span>\r\nPASSWORD_LIFE_TIME<\/span> UNLIMITED<\/span>\r\nPASSWORD_GRACE_TIME<\/span> UNLIMITED<\/span>\r\nPASSWORD_LOCK_TIME<\/span> UNLIMITED<\/span>\r\nPASSWORD_REUSE_TIME<\/span> UNLIMITED<\/span>\r\nPASSWORD_REUSE_MAX<\/span> UNLIMITED<\/span>;<\/span>\r\n\r\n\u76e3\u67fb\u53d6\u6d88\u3057\u304c\u6210\u529f\u3057\u307e\u3057\u305f\u3002<\/span>\r\n\r\nSQL<\/span>><\/span>\r\nSQL<\/span>><\/span> sho<\/span> pdbs<\/span>\r\n\r\n    CON_ID<\/span> CON_NAME<\/span>                       OPEN<\/span> MODE<\/span>  RESTRICTED<\/span>\r\n---------- ------------------------------ ---------- ----------<\/span>\r\n         2<\/span> PDB<\/span>$<\/span>SEED<\/span>                       READ<\/span> ONLY<\/span>  NO<\/span>\r\n         3<\/span> FREEPDB1<\/span>                       READ<\/span> WRITE<\/span> NO<\/span>\r\nSQL<\/span>><\/span> \r\nSQL<\/span>><\/span> alter<\/span> session<\/span> set<\/span> container<\/span>=<\/span>FREEPDB1<\/span>;<\/span>\r\n\r\n\u30bb\u30c3\u30b7\u30e7\u30f3\u304c\u5909\u66f4\u3055\u308c\u307e\u3057\u305f\u3002<\/span>\r\n\r\nSQL<\/span>><\/span> \r\nSQL<\/span>><\/span> show<\/span> con_name<\/span>\r\n\r\nCON_NAME<\/span>\r\n------------------------------<\/span>\r\nFREEPDB1<\/span>\r\nSQL<\/span>><\/span> \r\n\r\nSQL<\/span>><\/span> alter<\/span> pluggable<\/span> database<\/span> FREEPDB1<\/span> save<\/span> state<\/span>;<\/span>\r\n\r\n\u30d7\u30e9\u30ac\u30d6\u30eb\u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u5909\u66f4\u3055\u308c\u307e\u3057\u305f\u3002<\/span>\r\n\r\nSQL<\/span>><\/span> \r\nSQL<\/span>><\/span> noaudit<\/span> all<\/span>;<\/span>\r\nnoaudit<\/span> all<\/span> privileges<\/span>;<\/span>\r\nnoaudit<\/span> exempt<\/span> access<\/span> policy<\/span>;<\/span>\r\n\r\nALTER<\/span> PROFILE<\/span> DEFAULT<\/span> LIMIT<\/span>\r\nFAILED_LOGIN_ATTEMPTS<\/span> 10<\/span>\r\nPASSWORD_LIFE_TIME<\/span> UNLIMITED<\/span>\r\nPASSWORD_GRACE_TIME<\/span> UNLIMITED<\/span>\r\nPASSWORD_LOCK_TIME<\/span> UNLIMITED<\/span>\r\nPASSWORD_REUSE_TIME<\/span> UNLIMITED<\/span>\r\nPASSWORD_REUSE_MAX<\/span> UNLIMITED<\/span>;<\/span>\r\n\r\n\u76e3\u67fb\u53d6\u6d88\u3057\u304c\u6210\u529f\u3057\u307e\u3057\u305f\u3002<\/span>\r\n<\/code><\/pre>\n
\u542c\u4f17\u72b6\u6001\u786e\u8ba4<\/p>\n
[<\/span>oracle@centos8stream ~]$ <\/span>lsnrctl status\r\n\r\nLSNRCTL for <\/span>Linux: Version 23.0.0.0.0 - Developer-Release on 15-5\u6708 -2023<\/span> 06:57:30\r\n\r\nCopyright (<\/span>c)<\/span> 1991, 2023, Oracle.  All rights reserved.\r\n\r\n(<\/span>DESCRIPTION<\/span>=(<\/span>ADDRESS<\/span>=(<\/span>PROTOCOL<\/span>=<\/span>TCP)(<\/span>HOST<\/span>=<\/span>centos8stream)(<\/span>PORT<\/span>=<\/span>1521)))<\/span>\u306b\u63a5\u7d9a\u4e2d\r\n\u30ea\u30b9\u30ca\u30fc\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\r\n------------------------<\/span>\r\n\u5225\u540d                      LISTENER\r\n\u30d0\u30fc\u30b8\u30e7\u30f3                TNSLSNR for <\/span>Linux: Version 23.0.0.0.0 - Developer-Release\r\n\u958b\u59cb\u65e5                    15-5\u6708 -2023<\/span> 05:19:22\r\n\u7a3c\u50cd\u6642\u9593                  0 \u65e5 1 \u6642\u9593 38 \u5206 8 \u79d2\r\n\u30c8\u30ec\u30fc\u30b9\u30fb\u30ec\u30d9\u30eb          off\r\n\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3              ON: Local OS Authentication\r\nSNMP                      OFF\r\n\u30c7\u30d5\u30a9\u30eb\u30c8\u30fb\u30b5\u30fc\u30d3\u30b9           FREE\r\n\u30d1\u30e9\u30e1\u30fc\u30bf\u30fb\u30d5\u30a1\u30a4\u30eb      \/opt\/oracle\/product\/23c\/dbhomeFree\/network\/admin\/listener.ora\r\n\u30ed\u30b0\u30fb\u30d5\u30a1\u30a4\u30eb            \/opt\/oracle\/diag\/tnslsnr\/centos8stream\/listener\/alert\/log.xml\r\n\u30ea\u30b9\u30cb\u30f3\u30b0\u30fb\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306e\u30b5\u30de\u30ea\u30fc...\r\n  (<\/span>DESCRIPTION<\/span>=(<\/span>ADDRESS<\/span>=(<\/span>PROTOCOL<\/span>=<\/span>tcp)(<\/span>HOST<\/span>=<\/span>centos8stream)(<\/span>PORT<\/span>=<\/span>1521)))<\/span>\r\n  (<\/span>DESCRIPTION<\/span>=(<\/span>ADDRESS<\/span>=(<\/span>PROTOCOL<\/span>=<\/span>ipc)(<\/span>KEY<\/span>=<\/span>EXTPROC1521)))<\/span>\r\n\u30b5\u30fc\u30d3\u30b9\u306e\u30b5\u30de\u30ea\u30fc...\r\n\u30b5\u30fc\u30d3\u30b9\"FREE\"<\/span>\u306b\u306f\u30011\u4ef6\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u3042\u308a\u307e\u3059\u3002\r\n  \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\"FREE\"<\/span>\u3001\u72b6\u614bREADY\u306b\u306f\u3001\u3053\u306e\u30b5\u30fc\u30d3\u30b9\u306b\u5bfe\u3059\u308b1\u4ef6\u306e\u30cf\u30f3\u30c9\u30e9\u304c\u3042\u308a\u307e\u3059...\r\n\u30b5\u30fc\u30d3\u30b9\"FREEXDB\"<\/span>\u306b\u306f\u30011\u4ef6\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u3042\u308a\u307e\u3059\u3002\r\n  \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\"FREE\"<\/span>\u3001\u72b6\u614bREADY\u306b\u306f\u3001\u3053\u306e\u30b5\u30fc\u30d3\u30b9\u306b\u5bfe\u3059\u308b1\u4ef6\u306e\u30cf\u30f3\u30c9\u30e9\u304c\u3042\u308a\u307e\u3059...\r\n\u30b5\u30fc\u30d3\u30b9\"fbb91781d7412d32e053750aa8c0ea4a\"<\/span>\u306b\u306f\u30011\u4ef6\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u3042\u308a\u307e\u3059\u3002\r\n  \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\"FREE\"<\/span>\u3001\u72b6\u614bREADY\u306b\u306f\u3001\u3053\u306e\u30b5\u30fc\u30d3\u30b9\u306b\u5bfe\u3059\u308b1\u4ef6\u306e\u30cf\u30f3\u30c9\u30e9\u304c\u3042\u308a\u307e\u3059...\r\n\u30b5\u30fc\u30d3\u30b9\"freepdb1\"<\/span>\u306b\u306f\u30011\u4ef6\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u3042\u308a\u307e\u3059\u3002\r\n  \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\"FREE\"<\/span>\u3001\u72b6\u614bREADY\u306b\u306f\u3001\u3053\u306e\u30b5\u30fc\u30d3\u30b9\u306b\u5bfe\u3059\u308b1\u4ef6\u306e\u30cf\u30f3\u30c9\u30e9\u304c\u3042\u308a\u307e\u3059...\r\n\u30b3\u30de\u30f3\u30c9\u306f\u6b63\u5e38\u306b\u7d42\u4e86\u3057\u307e\u3057\u305f\u3002\r\n<\/code><\/pre>\n
\u5728\u4e2d\u56fd\uff0c\u53ea\u9700\u8981\u4e00\u79cd\u9009\u62e9\u6765\u7528\u4e2d\u6587\u91ca\u4e49\u4ee5\u4e0b\u5185\u5bb9\uff1a
\nSQL*Plus\u7684\u8bbe\u7f6e\u4ee5\u4e0b\u662fSQL*Plus\u4e2d\u7528\u4e8e\u8bbe\u7f6e\u7f16\u8f91\u5668\u7b49\u7684\u914d\u7f6e\u793a\u4f8b\u3002<\/p>\n
[<\/span>oracle@centos8stream ~]$ <\/span>cat<\/span> $ORACLE_HOME<\/span>\/sqlplus\/admin\/glogin.sql\r\n--<\/span>\r\n--<\/span> Copyright (<\/span>c)<\/span> 1988, 2005, Oracle.  All Rights Reserved.\r\n--<\/span>\r\n--<\/span> NAME\r\n--<\/span>   glogin.sql\r\n--<\/span>\r\n--<\/span> DESCRIPTION\r\n--<\/span>   SQL*<\/span>Plus global login \"site profile\"<\/span> file\r\n--<\/span>\r\n--<\/span>   Add any SQL*<\/span>Plus commands here that are to be executed when a\r\n--<\/span>   user starts SQL*<\/span>Plus, or uses the SQL*<\/span>Plus CONNECT command.\r\n--<\/span>\r\n--<\/span> USAGE\r\n--<\/span>   This script is automatically run\r\n--<\/span>\r\nshow con_name\r\nset <\/span>pages 100\r\nset <\/span>lines 200\r\n\r\ndefine _EDITOR =<\/span> vim\r\n<\/code><\/pre>\n
\u914d\u7f6etnsnames.ora\u6587\u4ef6
\n\u6211\u5c06\u6dfb\u52a0PDB\u7684\u8bbe\u7f6e\u3002\u4ee5\u4e0b\u662f\u8bbe\u7f6e\u793a\u4f8b\u3002<\/p>\n
# tnsnames.ora Network Configuration File: \/opt\/oracle\/product\/23c\/dbhomeFree\/network\/admin\/tnsnames.ora<\/span>\r\n# Generated by Oracle configuration tools.<\/span>\r\n\r\nFREE =<\/span>\r\n  (<\/span>DESCRIPTION =<\/span>\r\n    (<\/span>ADDRESS =<\/span> (<\/span>PROTOCOL =<\/span> TCP)(<\/span>HOST =<\/span> centos8stream)(<\/span>PORT =<\/span> 1521))<\/span>\r\n    (<\/span>CONNECT_DATA =<\/span>\r\n      (<\/span>SERVER =<\/span> DEDICATED)<\/span>\r\n      (<\/span>SERVICE_NAME =<\/span> FREE)<\/span>\r\n    )<\/span>\r\n  )<\/span>\r\n\r\nLISTENER_FREE =<\/span>\r\n  (<\/span>ADDRESS =<\/span> (<\/span>PROTOCOL =<\/span> TCP)(<\/span>HOST =<\/span> centos8stream)(<\/span>PORT =<\/span> 1521))<\/span>\r\n\r\n\r\nFREEPDB1 =<\/span>\r\n  (<\/span>DESCRIPTION =<\/span>\r\n    (<\/span>ADDRESS =<\/span> (<\/span>PROTOCOL =<\/span> TCP)(<\/span>HOST =<\/span> centos8stream)(<\/span>PORT =<\/span> 1521))<\/span>\r\n    (<\/span>CONNECT_DATA =<\/span>\r\n      (<\/span>SERVER =<\/span> DEDICATED)<\/span>\r\n      (<\/span>SERVICE_NAME =<\/span> FREEPDB1)<\/span>\r\n    )<\/span>\r\n  )<\/span>\r\n<\/code><\/pre>\n
\u53ea\u8981\u5728tnsnames.ora\u8fdb\u884c\u8bbe\u7f6e\u540e\uff0c\u80fd\u591f\u6210\u529f\u8fde\u63a5\u5230PDB\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n
[<\/span>oracle<\/span>@<\/span>centos8stream<\/span> ~<\/span>]<\/span>$<\/span> sqlplus<\/span> sys<\/span>@<\/span>freepdb1<\/span> as<\/span> sysdba<\/span>\r\n\r\nSQL<\/span>*<\/span>Plus<\/span>:<\/span> Release<\/span> 23<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span> -<\/span> Developer<\/span>-<\/span>Release<\/span> on<\/span> \u706b<\/span> 5<\/span>\u6708<\/span> 16<\/span> 07<\/span>:<\/span>18<\/span>:<\/span>30<\/span> 2023<\/span>\r\nVersion<\/span> 23<\/span>.<\/span>2<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span>\r\n\r\nCopyright<\/span> (<\/span>c<\/span>)<\/span> 1982<\/span>,<\/span> 2023<\/span>,<\/span> Oracle<\/span>.<\/span>  All<\/span> rights<\/span> reserved<\/span>.<\/span>\r\n\r\n\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044<\/span>:<\/span> \r\n\r\n\r\nOracle<\/span> Database<\/span> 23<\/span>c<\/span> Free<\/span>,<\/span> Release<\/span> 23<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span> -<\/span> Developer<\/span>-<\/span>Release<\/span>\r\nVersion<\/span> 23<\/span>.<\/span>2<\/span>.<\/span>0<\/span>.<\/span>0<\/span>.<\/span>0<\/span>\r\n\u306b\u63a5\u7d9a\u3055\u308c\u307e\u3057\u305f\u3002<\/span>\r\n\r\nCON_NAME<\/span>\r\n------------------------------<\/span>\r\nFREEPDB1<\/span>\r\nSQL<\/span>><\/span>\r\n<\/code><\/pre>\n
\u81ea\u52a8\u542f\u52a8\u548c\u505c\u6b62\u8bbe\u7f6e
\n\u4f7f\u7528root\u7528\u6237\u7f16\u8f91\/etc\/oratab\u6587\u4ef6\uff0c\u5e76\u5c06\u672b\u5c3e\u4e3a”N”\u7684\u90e8\u5206\u66f4\u6539\u4e3a”Y”\u3002<\/p>\n
[<\/span>root@centos8stream etc]# vim \/etc\/oratab\r\n#<\/span>\r\n# This file is used by ORACLE utilities.  It is created by root.sh<\/span>\r\n# and updated by either Database Configuration Assistant while creating<\/span>\r\n# a database or ASM Configuration Assistant while creating ASM instance.<\/span>\r\n\r\n# A colon, ':', is used as the field terminator.  A new line terminates<\/span>\r\n# the entry.  Lines beginning with a pound sign, '#', are comments.<\/span>\r\n#<\/span>\r\n# Entries are of the form:<\/span>\r\n#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:<\/span>\r\n#<\/span>\r\n# The first and second fields are the system identifier and home<\/span>\r\n# directory of the database respectively.  The third field indicates<\/span>\r\n# to the dbstart utility that the database should , \"Y\", or should not,<\/span>\r\n# \"N\", be brought up at system boot time.<\/span>\r\n#<\/span>\r\n# Multiple entries with the same $ORACLE_SID are not allowed.<\/span>\r\n#<\/span>\r\n#<\/span>\r\nFREE:\/opt\/oracle\/product\/23c\/dbhomeFree:Y \u2190\u3053\u3053\u3092N\u304b\u3089Y\u306b\u5909\u66f4\r\n<\/code><\/pre>\n
\u63a5\u4e0b\u6765\uff0c\u521b\u5efa\u4ee5\u4e0bUnit\u6587\u4ef6\uff0c\u5e76\u5c06\u5176\u653e\u7f6e\u5728\/etc\/systemd\/system\u76ee\u5f55\u4e2d\u3002<\/p>\n
[<\/span>root@centos8stream system]# cat <\/span>oracle.service \r\n[<\/span>Unit]\r\nDescription<\/span>=<\/span>Oracle Database Server\r\nAfter<\/span>=<\/span>syslog.target network.target\r\n\r\n[<\/span>Service]\r\nType<\/span>=<\/span>forking\r\nExecStart<\/span>=<\/span>\/opt\/oracle\/product\/23c\/dbhomeFree\/bin\/dbstart \/opt\/oracle\/product\/23c\/dbhomeFree\r\nExecStop<\/span>=<\/span>\/opt\/oracle\/product\/23c\/dbhomeFree\/bin\/dbshut \/opt\/oracle\/product\/23c\/dbhomeFree\r\nUser<\/span>=<\/span>oracle\r\nGroup<\/span>=<\/span>oinstall\r\n\r\n[<\/span>Install]\r\nWantedBy<\/span>=<\/span>multi-user.target\r\n<\/code><\/pre>\n
\u968f\u540e\uff0c\u6211\u4eec\u5c06\u542f\u7528oracle.service\u3002<\/p>\n
[<\/span>root@centos8stream system]# systemctl enable <\/span>oracle\r\nCreated symlink \/etc\/systemd\/system\/multi-user.target.wants\/oracle.service \u2192 \/etc\/systemd\/system\/oracle.service.\r\n[<\/span>root@centos8stream system]#\r\n[<\/span>root@centos8stream system]# systemctl is-enabled oracle\r\nenabled\r\n<\/code><\/pre>\n
\u8b66\u62a5\u65e5\u5fd7\u3001\u76d1\u542c\u5668\u65e5\u5fd7\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u8f93\u51fa\u5982\u4e0b\u6240\u793a\u3002<\/p>\n
\u30a2\u30e9\u30fc\u30c8\u30ed\u30b0\uff1a\/opt\/oracle\/diag\/rdbms\/free\/FREE\/trace\/alert_FREE.log\r\n\u30ea\u30b9\u30ca\u30fc\u30ed\u30b0\uff1a\/opt\/oracle\/diag\/tnslsnr\/(host\u540d)\/listener\/trace\/listener.log\r\n<\/code><\/pre>\n
\u6570\u636e\u6587\u4ef6\u521b\u5efa\u7684\u4f4d\u7f6e\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u662f\u5728\u4e0b\u9762\u521b\u5efa\u7684\u3002<\/p>\n
\u4e2d\u56fd\u53d1\u5c55\u94f6\u884c\u7684\u6570\u636e\u5e93\u6587\u4ef6<\/p>\n
[<\/span>oracle@centos8stream FREE]$ <\/span>pwd<\/span>\r\n\/opt\/oracle\/oradata\/FREE\r\n[<\/span>oracle@centos8stream FREE]$ <\/span>ll\r\n\u5408\u8a08 2486340\r\ndrwxr-x--- 2 oracle oinstall        104  5\u6708 15 18:30 FREEPDB1\r\n-rw-r-----<\/span> 1 oracle oinstall   18759680  5\u6708 17 16:21 control01.ctl\r\n-rw-r-----<\/span> 1 oracle oinstall   18759680  5\u6708 17 16:21 control02.ctl\r\ndrwxr-x--- 2 oracle oinstall         85  5\u6708 15 18:22 pdbseed\r\n-rw-r-----<\/span> 1 oracle oinstall  209715712  5\u6708 17 10:59 redo01.log\r\n-rw-r-----<\/span> 1 oracle oinstall  209715712  5\u6708 17 16:20 redo02.log\r\n-rw-r-----<\/span> 1 oracle oinstall  209715712  5\u6708 17 10:59 redo03.log\r\n-rw-r-----<\/span> 1 oracle oinstall  618668032  5\u6708 17 16:19 sysaux01.dbf\r\n-rw-r-----<\/span> 1 oracle oinstall 1216356352  5\u6708 17 16:19 system01.dbf\r\n-rw-r-----<\/span> 1 oracle oinstall   20979712  5\u6708 17 11:02 temp01.dbf\r\n-rw-r-----<\/span> 1 oracle oinstall   36708352  5\u6708 17 16:19 undotbs01.dbf\r\n-rw-r-----<\/span> 1 oracle oinstall    5251072  5\u6708 17 10:59 users01.dbf\r\n[<\/span>oracle@centos8stream FREE]$<\/span>\r\n<\/code><\/pre>\n
PDB\u6570\u636e\u5e93\u6587\u4ef6<\/p>\n
[<\/span>oracle@centos8stream FREEPDB1]$ <\/span>pwd<\/span>\r\n\/opt\/oracle\/oradata\/FREE\/FREEPDB1\r\n[<\/span>oracle@centos8stream FREEPDB1]$ <\/span>ll\r\n\u5408\u8a08 744728\r\n-rw-r-----<\/span> 1 oracle oinstall 346038272  5\u6708 17 16:19 sysaux01.dbf\r\n-rw-r-----<\/span> 1 oracle oinstall 304095232  5\u6708 17 16:19 system01.dbf\r\n-rw-r-----<\/span> 1 oracle oinstall  20979712  5\u6708 17 11:00 temp01.dbf\r\n-rw-r-----<\/span> 1 oracle oinstall 104865792  5\u6708 17 16:19 undotbs01.dbf\r\n-rw-r-----<\/span> 1 oracle oinstall   5251072  5\u6708 17 10:59 users01.dbf\r\n[<\/span>oracle@centos8stream FREEPDB1]$<\/span>\r\n<\/code><\/pre>\n
\u5176\u4ed6\u636e23c\u7684\u65b0\u529f\u80fd\uff0c\u4f3c\u4e4e\u53ef\u4ee5\u901a\u8fc7\u6307\u5b9adual\u7684SQL\u8bed\u53e5\u6765\u6267\u884cselect\u8bed\u53e5\uff0c\u800c\u65e0\u9700\u7f16\u5199from\u5b50\u53e5\u3002<\/p>\n
SQL<\/span>><\/span> select<\/span> dbtimezone<\/span>;<\/span>\r\n\r\nDBTIME<\/span>\r\n------<\/span>\r\n+<\/span>00<\/span>:<\/span>00<\/span>\r\n\r\nSQL<\/span>><\/span> select<\/span> to_char<\/span>(<\/span>sysdate<\/span>,<\/span>'YYYY\/MM\/DD HH24:MI:SS'<\/span>);<\/span>\r\n\r\nTO_CHAR<\/span>(<\/span>SYSDATE<\/span>,<\/span>'YY\r\n-------------------\r\n2023\/05\/17 16:28:15\r\n\r\nSQL>\r\n<\/span><\/code><\/pre>\n
\u6211\u60f3\u5728\u6b63\u5f0f\u7248\u53d1\u5e03\u540e\u6216\u5176\u4ed6\u65f6\u5019\uff0c\u989d\u5916\u786e\u8ba4\u4e00\u4e0b\u6709\u517323c\u529f\u80fd\u53d8\u66f4\u548c\u521d\u59cb\u53c2\u6570\u53d8\u66f4\u7b49\u65b9\u9762\u7684\u5185\u5bb9\u3002<\/p>\n
\u6700\u540e\u6211\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free\uff0c\u5e76\u5927\u81f4\u786e\u8ba4\u4e86\u64cd\u4f5c\u7cfb\u7edf\u8bbe\u7f6e\u7b49\u65b9\u9762\u7684\u5dee\u5f02\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9996\u51482023\u5e744\u6708\uff0cOracle\u6570\u636e\u5e9323c Free\uff08\u4ee5\u4e0b\u7b80\u79f023cFree\uff09\u5f00\u59cb\u63d0\u4f9b\u3002\u867d\u7136\u4e0e\u4e4b\u524d\u7684XE\u7c7b\u4f3c […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[227],"class_list":["post-28001","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-227"],"yoast_head":"\n\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5173\u4e8e\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u5728centos-stream-8\u4e0a\u5b89\u88c5oracle-database-23c-free\u3002-2\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8e\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u5728centos-stream-8\u4e0a\u5b89\u88c5oracle-database-23c-free\u3002-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-16T10:39:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-11T21:48:20+00:00\" \/>\n<meta name=\"author\" content=\"\u97f5, \u79d1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u97f5, \u79d1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/\",\"name\":\"\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-02-16T10:39:47+00:00\",\"dateModified\":\"2025-08-11T21:48:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\"},\"description\":\"\u5173\u4e8e\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free\u7684\u6280\u672f\u6587\u7ae0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\",\"name\":\"\u97f5, \u79d1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"caption\":\"\u97f5, \u79d1\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free - Blog - Silicon Cloud","description":"\u5173\u4e8e\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free\u7684\u6280\u672f\u6587\u7ae0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u5728centos-stream-8\u4e0a\u5b89\u88c5oracle-database-23c-free\u3002-2\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free","og_description":"\u5173\u4e8e\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free\u7684\u6280\u672f\u6587\u7ae0","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5c1d\u8bd5\u5728centos-stream-8\u4e0a\u5b89\u88c5oracle-database-23c-free\u3002-2\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-02-16T10:39:47+00:00","article_modified_time":"2025-08-11T21:48:20+00:00","author":"\u97f5, \u79d1","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u97f5, \u79d1","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/","name":"\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-02-16T10:39:47+00:00","dateModified":"2025-08-11T21:48:20+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e"},"description":"\u5173\u4e8e\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free\u7684\u6280\u672f\u6587\u7ae0","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5c1d\u8bd5\u5728CentOS Stream 8\u4e0a\u5b89\u88c5Oracle Database 23c Free"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e","name":"\u97f5, \u79d1","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","caption":"\u97f5, \u79d1"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%b0%9d%e8%af%95%e5%9c%a8centos-stream-8%e4%b8%8a%e5%ae%89%e8%a3%85oracle-database-23c-free%e3%80%82-2\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=28001"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28001\/revisions"}],"predecessor-version":[{"id":111246,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28001\/revisions\/111246"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=28001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=28001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=28001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}