官方英文文档
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/index.html
登陆官网注册并下载数据库
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)
安装这个RPM需要一个前置包oracle-database-preinstall
直接使用自动补全安装环境
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.rpmwarning: 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 configureConfiguring Oracle Database ORCLCDB.Prepare for db operation8% completeCopying database files31% completeCreating and starting Oracle instance32% complete36% complete40% complete43% complete46% completeCompleting Database Creation51% complete54% completeCreating Pluggable Databases58% complete77% completeExecuting Post Configuration Actions100% completeDatabase creation complete. For details check the logfiles at: /opt/oracle/cfgtoollogs/dbca/ORCLCDB.Database Information:Global Database Name:ORCLCDBSystem Identifier(SID):ORCLCDBLook 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.开放防火墙端口
firewall-cmd --add-port=1521/tcp --permanentsuccessfirewall-cmd --reloadsuccessfirewall-cmd --list-ports1521/tcp切换到oracle用户
su - oracle编辑环境变量
vi .bash_profileexport ORACLE_HOME=/opt/oracle/product/19c/dbhome_1export PATH=$PATH:/opt/oracle/product/19c/dbhome_1/binexport ORACLE_SID=ORCLCDB刷新当前用户环境变量
source ~/.bash_profile登录数据库
$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 2 13:54:47 2022Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0SQL> 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;远程登陆测试
我使用的是Navicat 15 for Oracle
0
| 留言与评论(共有 0 条评论) “” |