[student@oel7 ~]$ yum info oracle-database-preinstall-19c Loaded plugins: langpacks, ulninfo Available Packages Name : oracle-database-preinstall-19c Arch : x86_64 Version : 1.0 Release : 3.el7 Size : 27 k Repo : ol7_latest/x86_64 Summary : Oracle Database Preinstallation RPM License : GPLv2 Description : The Oracle Database Preinstallation RPM automatically installs any additional : packages needed for installing Oracle Grid Infrastructure and Oracle Database : and configures your server operating system automatically, including setting : kernel parameters and other basic operating system requirements for install.
[student@oel7 ~]$ cat /etc/sysctl.d/99-oracle-database-preinstall-19c-sysctl.conf # sysctl settings are defined through files in # /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/. # # Vendors settings live in /usr/lib/sysctl.d/. # To override a whole file, create a new file with the same in # /etc/sysctl.d/ and put new settings there. To override # only specific settings, add a file with a lexically later # name in /etc/sysctl.d/ and put new settings there. # # For more information, see sysctl.conf(5) and sysctl.d(5).
# 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 = 25032000100128
# 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 = 900065500
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-JAN-202518:39:33
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel7)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 03-JAN-202518:38:53 Uptime 0 days 0 hr. 0min. 39 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.3.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/oel7/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel7)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully
创建数据库
使用 dbca 图形化方式创建数据库。 创建数据库步骤：
命令行安装
dbca 除了通过图形化方式创建数据库外还支持通过命令行方式创建数据库。
创建非容器数据库：
1
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname test -sid test -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 322:01:582025 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> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 READ WRITE NO SQL> conn sys/oracle@oel7:1521/pdb1 as sysdba Connected. SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 PDB1 READ WRITE NO
set termout off column propmt_c new_value propmt_c SELECT SYS_CONTEXT ('USERENV', 'CON_NAME') as propmt_c FROM DUAL; set sqlprompt "_user'@'_connect_identifier(&propmt_c)> "
使用 sqlplus 连接数据库后就有提示符：
1 2 3 4
SYS@orcl(CDB$ROOT)> @(CDB$ROOT)> conn sys/oracle@oel7:1521/pdb1 as sysdba Connected. SYS@oel7:1521/pdb1(PDB1)>
评论· · · · · ·