官方英文文檔
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/index.html

登陸官網(wǎng)注冊(cè)并下載數(shù)據(jù)庫(kù)
https://www.oracle.com/cn/database/technologies/oracle-database-software-downloads.html#19c

我這里下載19.3 - Enterprise Edition (also includes Standard Edition 2) Linux x86-64 RPM (2.5 GB)

安裝這個(gè)RPM需要一個(gè)前置包oracle-database-preinstall
直接使用自動(dòng)補(bǔ)全安裝環(huán)境

yum localinstall https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm

安裝

rpm -ihv oracle-database-ee-19c-1.0-1.x86_64.rpm warning: oracle-database-ee-19c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEYVerifying... ? ? ? ? ? ? ? ? ? ? ? ? ?################################# [100%]Preparing... ? ? ? ? ? ? ? ? ? ? ? ? ?################################# [100%]Updating / installing... ? 1:oracle-database-ee-19c-1.0-1 ? ? ################################# [100%] [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

安裝完成后按提示初始化

/etc/init.d/oracledb_ORCLCDB-19c configure Configuring Oracle Database ORCLCDB. Prepare for db operation 8% complete Copying database files 31% complete Creating and starting Oracle instance 32% complete 36% complete 40% complete 43% complete 46% complete Completing Database Creation 51% complete 54% complete Creating Pluggable Databases 58% complete 77% 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.

開(kāi)放防火墻端口

firewall-cmd --add-port=1521/tcp --permanent success firewall-cmd --reload success firewall-cmd --list-ports 1521/tcp

切換到oracle用戶

su - oracle

編輯環(huán)境變量

vi .bash_profile export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1export PATH=$PATH:/opt/oracle/product/19c/dbhome_1/binexport ORACLE_SID=ORCLCDB

刷新當(dāng)前用戶環(huán)境變量

source ~/.bash_profile

登錄數(shù)據(jù)庫(kù)

$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 2 13:54:47 2022 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 ORCLPDB1 ? ? ? ? ? ? ? ? ? ? ? READ WRITE NO

修改密碼

SQL> alter user system identified by 123456;

遠(yuǎn)程登陸測(cè)試
我使用的是Navicat 15 for Oracle

0