Oracle Database 12c installation on Oracle Linux 7 (OEL7.2)

Oracle Database 12c Release 1 (12.1) Installation on Oracle Linux 7 (OL7.2)

Note from Oracle Database 12c R1 Installation Guide:

  • Starting with Oracle Database 12c Release 1 (12.1.0.2), Oracle Linux 7 and Red Hat Enterprise Linux 7 are supported on Linux x86-64 systems.

Supported Oracle Linux 7 distributions:

  • Oracle Linux 7 with the Unbreakable Enterprise kernel: 3.8.13-33.el7uek.x86_64 or later
  • Oracle Linux 7 with the Red Hat Compatible kernel: 3.10.0-123.el7.x86_64 or later

This means that Oracle Linux 7 only supports 12.1.0.2 onwards. This installation guide should not be used for a real system when using 12c database versions prior to 12.1.0.2.

Table of Contents

  1. Download Software
  2. Check hosts file, selinux and firewall
  3. Oracle Installation Prerequisites
  4. Oracle software directories
  5. Bash_profile
  6. Check your oracle user details
  7. Connect as oracle account
  8. Unzip the files.
  9. Database folder
  10. Run the installer
  11. Security updates
  12. Warning message
  13. Software updates
  14. Create and configure a database
  15. Server type
  16. Single instance DB installation
  17. Typical install
  18. Typical Install Configuration
  19. oraInventory location
  20. Typical installation summary
  21. Advanced install
  22. Oracle edition
  23. Language
  24. ORACLE_BASE and ORACLE_HOME
  25. oraInventory location
  26. General Purpose/ OLTP
  27. Container and Pluggable Database
  28. Database details
  29. Character sets tab
  30. Sample Schemas tab
  31. Directory for database files
  32. Oracle Enterprise Manager
  33. Enable Recovery
  34. Password for sys accounts
  35. OS group for each oracle group
  36. Start Installation process
  37. 2 scripts as user root
  38. Installation progress
  39. Database Configuration Assistant
  40. Installation summary window
  41. Database Express 12C

In our previous document (Oracle Linux 7.2 Installation using VirtualBox) we covered operating system installation; it’s a prerequisite for this tutorial.

At this moment we have “fresh” installation of the Oracle Linux 7.2. System is up and running.

  1. Download Software

Download the Oracle software from OTN (Oracle Technology Network) or from edelivery

OTN: Oracle Database 12c Release 1 (12.1.0.2) Software (64-bit)

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

edelivery: Oracle Database 12c Release 1 (12.1.0.2) Software (64-bit)

https://edelivery.oracle.com/osdc/faces/Home.jspx

  1. Check the hosts file, selinux config, and the firewall

Hosts File

The “/etc/hosts” file must contain a fully qualified name for the server.

<IP-address>       <fully-qualified-machine-name>                 <machine-name>

01

SELinux

SELinux is an access control implementation for the Linux kernel.

 

02

 

Firewall

If the OS is to be used for an Oracle installation, it is easier if the firewall is disabled.

 

03 firewall

 

  1. Oracle Installation Prerequisites

You will need the oracle-rdbms-server-12cR1-preinstall-1.0-4.el7.x86_64 rpm to complete the basic prerequisites. You can find it on your OS installation “Package” folder or just use yum to install it (yum install oracle-rdbms-server-12cR1-preinstall -y).

 

04 prereq

 

You can install missing packages from dvd. Just mount it and install missing packages using rpm -Uvh command from directory <mount dvd>/Packages or by using yum install command. I’m using x86_64 version of packages

 

05 run prereqs

 

Manual Setup

If you don’t have the “oracle-rdbms-server-12cR1-preinstall” package to perform all prerequisites, you will need to manually perform the following setup tasks.

Add or amend the following lines in the “/etc/sysctl.conf” file.

# kernel parameters for 12gR1 installation
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

 

06 sysctl

 

Run the following command to change the current kernel parameters.

/sbin/sysctl -p

Add the following lines to set shell limits for user oracle in  “/etc/security/limits.conf” file.

# shell limits for oracle user 12gR1
oracle   soft   nofile   1024
oracle   hard   nofile   65536
oracle   soft   nproc    2047
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768

 

07 limits

 

Add following line in the /etc/pam.d/login file, if it does not already exist

session required pam_limits.so

 

08 login

 

OPTIONAL: Take a Snapshot of your Virtual Machine

This will be our checkpoint on our installation guides. You can restore your VM at this snapshot at any time.

Click “Machine” menu and select “Take Snapshot…”

 

09 snapshot

 

Choose your Snapshot Name and Description

 

10 snapshot name

 

Wait for its progress

11 progress

You now have a new Snapshot for your VM

 

12 snapshot

 

  1. Create the directories in which the Oracle software will be installed.
mkdir -p /u01/app/oracle/product/12.1.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01

 

13 mkdir

 

  1. Add the following lines at the end of the “/home/oracle/.bash_profile” file.
# Oracle Settings
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1
export ORACLE_SID=cdb1
export ORACLE_UNQNAME=cdb1
export ORACLE_HOSTNAME=ol7.localdomain
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export TMP=/tmp
export TMPDIR=$TMP

 

14 bash

 

  1. Check your oracle user details

Modify oracle user to be part of the vboxsf group so it can access our Shared folder

 

15 id oracle

 

  1. Connect as oracle account

 

16 oracle

 

  1. Unzip the files.

unzip linuxamd64_12102_database_1of2.zip

unzip linuxamd64_12102_database_2of2.zip

 

17 unzip

 

  1. Go to the Database folder and check its content

 

18 ll

 

  1. Run the installer (./runInstaller)

 

19 runinstall

 

  1. Uncheck checkbox “I wish to receive security updates via My Oracle Support” and then click “Next” button.

 

20 dbca

 

  1. Ignore following message and click “Yes” button.

 

21 address

 

  1. Skip software updates

 

22 software

 

  1. Select “Create and configure a database” then click “Next” button.

 

23 create db

 

  1. Select “Server class” and click “Next” button.

 

24 server class

 

  1. Accept default “Single instance database installation” and click “Next” button.

 

25 single

 

  1. We will look at the Typical and Advanced install option

NOTE: Let’s take a look at Typical install first

 

26 typical

 

  1. Fill the needed information on the Typical Install Configuration window

 

27 install

 

  1. Choose your oraInventory location or click Next and set it to default

 

28 orainventory

 

  1. You are now presented the Summary of the Installation for the Typical install, you can start by clicking Install.

 

29 summary

 

NOTE: We’ll go back to #17 this time and choose the Advanced install option.

  1. Select “Advanced install” to later select more options during database installation and click “Next” button.

 

30 advanced

 

  1. You can select the edition you want. Once it’s done click “Next” button.

 

31 EE

 

  1. You can select language here. Once it’s done click “Next” button.

 

32 language

 

  1. Here you should see directories for ORACLE_BASE and ORACLE_HOME for your binaries according to environmental settings. Click “Next” button.

 

33 install loc

 

  1. Accept default and click “Next” button.

 

34 inventory

 

  1. Accept default “General Purpose/ Transaction Processing” and click “Next” button.

 

35 general

  1. Here you define your database name. Check checkbox “Create as Container database” and enter “Pluggable database name” to add your first container CDB1 and pluggable PDB1 database and click “Next” button.

 

36 db id

 

  1. Specify more details about your database on 3 tabs where you can define memory settings, character set and if to install sample schema on your database. Once you are happy with your settings click “Next” button.

 

37 mem

 

  1. Character sets tab

 

38 character

 

  1. Sample Schemas tab

 

39 schema

 

  1. Specify directory where you want to install your database files then click “Next” button.

 

40 filesystem

 

  1. On this page you can register your database in Oracle Enterprise Manager”. Accept default settings and click “Next” button.

 

41 em

 

  1. Check checkbox “Enable Recovery” to specify directory for your recovery area “Recovery area location” and click “Next” button.

 

42 enable

 

  1. Specify password for each user or enter the same for all. Once it’s done click “Next” button.

 

43 pass

 

  1. Here you can specify OS group for each oracle group. Accept default settings and click “Next” button.

 

44 OS

 

  1. If everything is right click “Install” button. It’s the last moment to come back to each of previous point and make changes.

 

45 summary

  1. Once binaries are installed the last step is to run 2 scripts as user root.

 

46 root

 

 

47 root run

 

  1. Installation in progress

 

48 install

 

  1. Database Configuration Assistant will start automatically and create database for you.

 

49 progress

 

  1. You should see summary window. You can update “Password Management” here. Once it’s done click “OK” button to continue. Oracle 12C installation is completed. Click “Close” button.

 

50 success

  1. Try to login as SYS to Enterprise manager Database express 12C

 

51 em express

 

 

52 em express 2

 

Like Loading…

Measure

Measure

Read more

How to migrate Raspberry Pi 5 OS from micro SD to NVME m.2 SSD

首先我買了Raspberry Pi CM5後來買了Raspberry Pi CM5 I/O board來當個人電腦使用,系統是安裝在256GB SD卡上運行的很好。用久了在開啟較肥的程式像Web Browser或LiberOffice會有慢半拍的反應,而有了升級NVME m.2 SSD念頭。 因為Raspberry Pi 5支援的最快PCIe gen3 x 4就不去考慮快的Gen4 or Gen5 m.2 SSD。找了ADATA出的 LEGEND 710入門級的產品,會利用HMB(Host Memory Buffer)來加速I/O速度,因為是Raspberry Pi OS kernel會認不得而無法正常使用 事先在SD卡的/boot/firmware/cmdline.txt 加入 kernel command line參數如下,然後重開機m.

By Phillips Hsieh

How to document Home Lab and Network

運維機房和跨域的網路,會遇到各式需求與問題,用對工具才能分析問題,個人覺得最重要的是使用能處理問題的工具。 推薦目前想學和正在使用的平台與軟體,協助將公司/家用機房文件化 佈告欄任務管理 Focalboard 白板可管理任務指派 網路架構文件編寫 netbox 精細管理網路設備與連接線路 IP 資源管理 phpipam 專注網路IP分配 邏輯塊文件編寫 draw.io 視覺化概念圖 機房設備管理 ITDB 管理設備生命週期與使用者

By Phillips Hsieh

如何在Raspberry Pi4上安裝Proxmox for ARM64

第一步 準備好Raspberry Pi 4 / CM4 4GB RAM,這裡要留意CM4如果是買有內建eMMC storage會限制不能使用SD卡開機而限制本地空間容量,如果沒有NAS外接空間或使用USB開機的話,建議買CM4 Lite插上大容量SD卡 第二步 去Armbian官網下載最小化Debian bookworm image https://www.armbian.com/rpi4b/ Armbian 25.2.2 Bookworm Minimal / IOT 然後寫入SD/USB開機碟,寫入方法參考官方文件 https://github.com/raspberrypi/usbboot/blob/master/Readme.md Note: 官方提供的預先設定系統方法,可以在Armbian初次啟動自動化完成系統設定。連結在此 https://docs.armbian.com/User-Guide_Autoconfig/

By Phillips Hsieh

世界越快心越慢

在晚飯後的休息時間,我特別享受在客廳瀏灠youtube上各樣各式創作者的影音作品。很大不同於傳統媒體,節目多是針對大多數族群喜好挑選的,在youtube上我會依心情看無腦的動畫、一些旅拍記錄、新聞時事談論。 尤其在看了大量的Youtube的分享後,我真的感受到會限制我的是我的無知,特別是那些我想都沒想過的實際應用,在學習後大大幫助到我的生活和工作層面。 休息在家時,我喜歡想一些沒做過的菜,動手去設計生活和工作上的解決方案,自己是真的很難閒著沒事做。 如創作文章,陪養新的習慣都能感覺到成長的喜悅,是不同於吃喝玩樂的快樂的。 創作不去限制固定的形式,文字是創作、影像聲音也是創作,記錄生活也是創作,我想留下的就是創造—》實現—》回憶,這樣子的循環過程,在留下的足跡面看到自己一路上的成長、失敗、絕望、重新再來。 雖然大部份的時候去做這些創作也不明白有什麼特別的意義,但不去做也不會留下什麼,所以呀不如反事都去試試看,也許能有不一樣的水花也許有意想不到的結果,投資自己永遠不會是失敗的決定,不是嗎?先問問自己再開始計畫下一步,未來沒人說得準。 像最近看youtube仍大一群人在為DOS開

By Phillips Hsieh