安装Oracle XE 18c

目录

前言

准备工作

安装步骤

参考

---

前言

本文介绍如何在vagrant的oracle linux虚拟机安装Oracle XE 18c

准备工作

vagrant 2.2.18

virtualbox 6.1.28

下载oracle linux最新box文件 （可能要翻墙） 

https://yum.oracle.com/boxes/oraclelinux/latest/ol7-latest.box

下载preinstall包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

下载Oracle安装包 oracle-database-xe-18c-1.0-1.x86_64.rpm （可能要翻墙）

Oracle Database Express Edition (XE) 18c Downloads

DBeaver 7.3.5 Archive Files | DBeaver Community 

安装步骤

创建Vagrantfile

VAGRANTFILE_API_VERSION = '2'

Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|
  config.ssh.insert_key = false
  config.vm.box = 'oraclelinux'
  config.vm.box_url = 'https://yum.oracle.com/boxes/oraclelinux/latest/ol7-latest.box'
  config.vm.network 'forwarded_port', guest: 1521, host: 1521
  config.vm.network 'forwarded_port', guest: 5500, host: 5500
end

添加box

D:\sandbox\code\vagrant-oracle-database-xe-18c>vagrant box add oraclelinux file:///d:/sandbox/code/vagrant-oracle-database-xe-18c/ol7-latest.box
==> box: Box file was not detected as metadata. Adding it directly...
==> box: Adding box 'oraclelinux' (v0) for provider:
    box: Unpacking necessary files from: file:///d:/sandbox/code/vagrant-oracle-database-xe-18c/ol7-latest.box
    box:
==> box: Successfully added box 'oraclelinux' (v0) for 'virtualbox'!

vagrant up启动vagrant虚拟机

D:\sandbox\code\vagrant-oracle-database-xe-18c>vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Resuming suspended VM...
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
    default: SSH address: 127.0.0.1:2222
    default: SSH username: vagrant
    default: SSH auth method: private key
==> default: Machine booted and ready!
==> default: Machine already provisioned. Run `vagrant provision` or use the `--provision`
==> default: flag to force provisioning. Provisioners marked to run always will still run.

 vagrant ssh登录虚拟机

D:\sandbox\code\vagrant-oracle-database-xe-18c>vagrant ssh

Welcome to Oracle Linux Server release 7.8 (GNU/Linux 4.14.35-1902.300.11.el7uek.x86_64)

The Oracle Linux End-User License Agreement can be viewed here:

  * /usr/share/eula/eula.en_US

For additional packages, updates, documentation and community help, see:

  * https://yum.oracle.com/

[vagrant@localhost ~]

[vagrant@localhost ~]$ cd /vagrant
[vagrant@localhost vagrant]$ ll
total 2979458
-rwxrwxrwx. 1 vagrant vagrant         23 Jan 10 14:33 dotenv.sample
-rwxrwxrwx. 1 vagrant vagrant       1073 Jan 10 14:33 LICENSE
-rwxrwxrwx. 1 vagrant vagrant      62778 Jan 10 14:33 localhost_5500_em_login.png
-rwxrwxrwx. 1 vagrant vagrant      84575 Jan 10 14:33 localhost_5500_em_shell.png
-rwxrwxrwx. 1 vagrant vagrant  529002950 Jan 10 14:40 ol7-latest.box
-rwxrwxrwx. 1 vagrant vagrant      18244 Jan 13 13:34 oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
-rwxrwxrwx. 1 vagrant vagrant 2521766408 Jan 10 14:31 oracle-database-xe-18c-1.0-1.x86_64.rpm
-rwxrwxrwx. 1 vagrant vagrant         31 Jan 10 14:33 provision.sh
-rwxrwxrwx. 1 vagrant vagrant       6397 Jan 10 14:33 README.md
-rwxrwxrwx. 1 vagrant vagrant       1404 Jan 13 13:37 setup.sh
-rwxrwxrwx. 1 vagrant vagrant        365 Jan 13 13:43 Vagrantfile

使用root用户 

[vagrant@localhost vagrant]$ sudo -s

安装preinstall包 

[root@localhost vagrant]# yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

安装18c安装包

[root@localhost vagrant]# yum -y localinstall oracle-database-xe-18c-1.0-1.x86_64.rpm

设置并启动oracle，提示设置admin密码

[root@localhost vagrant]# /etc/init.d/oracle-xe-18c configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:

 至此数据库安装完毕，可通过任意数据库工具连接数据库，以下截图是DBeaver

另外可通过以下命令启动、关闭、重启数据库

[root@localhost vagrant]# /etc/init.d/oracle-xe-18c start
[root@localhost vagrant]# /etc/init.d/oracle-xe-18c stop
[root@localhost vagrant]# /etc/init.d/oracle-xe-18c restart

Github源代码

本文代码已提交github https://github.com/bin9wei/vagrant-oracle-database-xe-18c，附有详细README，欢迎试玩！

参考

Installing Oracle Database XE Using RPM Packages

Starting and Stopping Oracle Database