描述

Oracle 12c 提供了类似 MySQL 的分页语法,而且更强大。Oracle 12c 的Even better PL/SQL from SQL, 直接在 SQL 中嵌 入 PL/SQL 对象并运行,猜测可能优化了 SQL engine 和 PL/SQL engine 2 种的代码引擎之间的交互,以获得比之前传统的 SQL 调用函数更少的上下文切换。Adaptive  Execution Plans  自适应执行计划, 该特性可以谈得上神奇,最终的执行计划将基于执行 中获得的行,列倾斜造成的问题将被克服。

基础环境配置

创建用户并安装依赖
[root@Node-1 ~]# useradd oracle
[root@Node-1 ~]# yum -y install libXext-devel libXrender-devel libXtst-devel
切换用户并下载安装包及解压
[root@Node-1 ~]# su - oracle
[oracle@Node-1 ~]$ wget https://file.api.ym68.cc/oracle/linuxx64_12201_database.zip
[oracle@Node-1 ~]$ unzip linuxx64_12201_database.zip
[oracle@Node-1 ~]$ cd database/
[oracle@Node-1 database]$ export DISPLAY=192.168.230.1:0.0
配置远程窗口

基于xmanager进行安装,新建XDMCP会话

新建完成后点击连接

启动安装程序
[oracle@Node-1 database]$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 34824 MB    Passed
Checking swap space: 0 MB available, 150 MB required.    Failed <<<<
Checking monitor: must be configured to display at least 256 colors
    >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set.    Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) [n] y


>>> Ignoring required pre-requisite failures. Continuing...
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-05-16_11-49-31PM. Please wait ...[oracle@Node-1 database]$ You can find the log of this install session at:
 /home/oracle/app/oraInventory/logs/installActions2020-05-16_11-49-31PM.log

启动后会有提示,选择是允许即可

安装Oracle

取消更新并进行下一步

此处选择yes

选择只安装数据库

选择单实例数据库安装

根据需要选择需要安装的版本,此处选择企业版

选择忽视所有并进行下一步

等待安装完成

提示需要root用户执行下列脚本:

[root@Node-1 ~]# /home/oracle/app/oraInventory/orainstRoot.sh
[root@Node-1 ~]# /home/oracle/app/oracle/product/12.2.0/dbhome_1/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /home/oracle/app/oracle/product/12.2.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] : 
yes
Installing Oracle Trace File Analyzer (TFA).
Log File: /home/oracle/app/oracle/product/12.2.0/dbhome_1/install/root_Node-1_2020-05-17_00-09-38-411266293.log
Finished installing Oracle Trace File Analyzer (TFA)

执行完成后点击OK

安装完成

[oracle@Node-1 ~]$ vim ~/.bash_profile
export ORACLE_HOME=/home/oracle/app/oracle/product/12.2.0/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin
[oracle@Node-1 ~]$ source ~/.bash_profile

待持续更新中

分类: Oracle