curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
rm -f oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

#默认安装到目录/opt/oracle/product/18c/dbhome_1
#自动创建一个CDB (ORCLCDB) 和一个PDB (ORCLPDB1) 和配置一个listener在默认端口1521
yum -y localinstall oracle-database-ee-18c-1.0-1.x86_64.rpm

cat /etc/sysconfig/oracledb_ORCLCDB-18c.conf
# 定义监听端口
# 定义数据存放位置
# 定义Enterprise Manager监听端口

创建数据库

/etc/init.d/oracledb_ORCLCDB-18c configure

du -sh /opt/

su - oracle
vi .bash_profile
添加
export ORACLE_SID=ORCLCDB
export ORACLE_BASE=/opt/oracle/oradata
export ORACLE_HOME=/opt/oracle/product/18c/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin
umask 022

执行source .bash_profile

配置数据库自启

vi /etc/oratab
ORCLCDB:/opt/oracle/product/18c/dbhome_1:Y

vi /etc/sysconfig/ORCLCDB.oracledb
添加
ORACLE_BASE=/opt/oracle/oradata
ORACLE_HOME=/opt/oracle/product/18c/dbhome_1
ORACLE_SID=ORCLCDB

创建监听服务

vi /usr/lib/systemd/system/ORCLCDB@lsnrctl.service
添加
[Unit]
Description=Oracle Net Listener
After=network.target

[Service]
Type=forking
EnvironmentFile=/etc/sysconfig/ORCLCDB.oracledb
ExecStart=/opt/oracle/product/18c/dbhome_1/bin/lsnrctl start
ExecStop=/opt/oracle/product/18c/dbhome_1/bin/lsnrctl stop
User=oracle

[Install]
WantedBy=multi-user.target

创建数据库服务

vi /usr/lib/systemd/system/ORCLCDB@oracledb.service
添加
[Unit]
Description=Oracle Database service
After=network.target lsnrctl.service

[Service]
Type=forking
EnvironmentFile=/etc/sysconfig/ORCLCDB.oracledb
ExecStart=/opt/oracle/product/18c/dbhome_1/bin/dbstart $ORACLE_HOME
ExecStop=/opt/oracle/product/18c/dbhome_1/bin/dbshut $ORACLE_HOME
User=oracle

[Install]
WantedBy=multi-user.target

设置服务自启

systemctl daemon-reload 
systemctl enable ORCLCDB@lsnrctl ORCLCDB@oracledb

测试

netstat -nultp  | grep -E '1521|5500'

su - oracle
lsnrctl start
sqlplus / as sysdba
select banner from sys.v_$version;
select * from v$version;

登录EM管理器

su - oracle
sqlplus / as sysdba
connect / as sysdba
alter user system identified by oracle;
alter user sys identified by oracle;

浏览器登录地址 https://IP:5500/em/login   用户名sys 密码刚修改的oracle