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

世界越快心越慢

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

By Phillips Hsieh

知識管理的三個步驟:一小時學會把知識運用到生活上

摘錄瓦基「閱讀前哨站」文章作為自己學習知識管理的內容 Part1「篩選資訊」 如何從海量資訊中篩選出啟發性、實用性和相關性的精華,讓你在學習過程中不再迷失方向。 1. 實用性 2. 啟發性 Part2「提高理解」 如何通過譬喻法和應用法,將抽象的知識與日常生活和工作緊密結合,建立更深刻的理解。 1. 應用法 2. 譬喻法 Part3「運用知識」 如何連結既有知識,跟自己感興趣的領域和專案產生關聯,讓你在運用知識的路途上游刃有餘。 1. 跟日常工作專案、人際活動產生連結 # 為什麼要寫日記? * 寫日記是為了忘記,忘卻瑣碎事情,保持專注力 * 寫日記就像在翻譯這個世界,訓練自己的解讀能力 * 不只是透過日記來記錄生活,而是透過日記來發展生活 #如何寫日記? * 不要寫流水帳式的日記,而是寫覆盤式的日記 當我們試著記錄活動和感受之間的關聯,有助於辦認出真正快樂的事 日記的記錄方式要以過程為主,而非結果 * 感恩日記的科學建議,每日感恩的案例

By Phillips Hsieh
2024年 3月30日 14屆美利達環彰化百K

2024年 3月30日 14屆美利達環彰化百K

這是場半小時就被秒報名額滿的經典賽事, 能順利出賽實屬隊友的功勞, 這次的準備工作想試試新買的外胎, 因為是無內胎用的外胎, 特別緊超級難安裝的, 問了其他朋友才知道, 要沾上肥皂水才容易滑入車框。 一早四點起床準備, 五點集合備好咖啡在車上飲用, 約了六點在彰化田尾鄉南鎮國小, 整好裝四人一起出發前往會場。 被排在最後一批出發, 這次的路線會繞行的員林148上139縣道, 其實在早上五點多天就開始有點飄雨, 大伙就開始擔心不會要雨戰吧! 果不其然才出發準備上148爬坡雨勢越來越大, 戴著防風眼鏡的我在身體的熱氣加上雨水冷凝效果下, 鏡面上滿是霧氣肉眼可視距離才剩不到五公尺, 只能緊依前前方的車友幫忙開路, 之後洪大跟上來我立馬請求他幫忙開路, 上了139停下車把防風眼鏡收起來, 反正下雨天又陰天完全用不到太陽眼鏡了。 雨是邊下邊打雷, 大伙都在這條139上一台一台單車好像避電針, 一時有點害怕不然想平時沒做什麼壞事, 真打到自己就是天意了。 下了139雨勢開始變小, 大伙的速度開始有所提昇, 開高鐵列車的時機己成熟, 物色好列車就跟好跟滿。 最後找了一隊似乎整團有固定在練

By Phillips Hsieh
2023 12月9號 美利達單車嘉年華

2023 12月9號 美利達單車嘉年華

第二次參加美利達環南投賽事, 還記得去年第一次參加這美利達環南投, 還特地提前一天跟車友在魚池住了一晚。 這回用上了剛在7月份剛安裝的車頂架, 安裝了二種不同的攜車架, 都樂這邊可以不用拆車輪直上車頂, YAKIMA這邊選了經濟的款式, 折掉前輪利用前叉固定在攜車架上。 約了唯一一位一起參加的朋友, 二人一早四點約見面, 幫朋友帶上了拿鐵咖啡, 開上日月潭在水社碼頭停好車, 騎往向山遊客中心, 路過美麗的日月潭簡直不要太美了拍一張。 抵達會場己是人山人海了, 跟著大伙排隊順便也看網紅也欣賞名車。 出發就先沿著日月潭順時針騎, 騎到玄裝寺很急停下來上一下廁所, 比賽時都會尿都特別的滿, 一方面是比較緊張,一方面是特別興奮。 這時己經跟車友失散了, 只能獨推沿路看有沒有車友可以一起組隊的, 很可惜在山區大家的實力不一只求平安順騎了, 原則就是有補給就停有食物就吃。 下到水里人群再次聚集起來, 光等紅綠燈就是一條車龍。 騎行了一大圈水里再回到131縣道, 這時背後傳來熟悉的聲音叫菲哥, 終於跟車友重新集合接下來就一路邊聊邊騎。 最後來幾張專業攝影師拍攝的照片 回到終點台上

By Phillips Hsieh