Oracle12c安装部署文档-工具盒子

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

下载安装包

访问官网地址：https://www.oracle.com/database/technologies/oracle-database-software-downloads.html，下载安装包并解压

[root@Node-1 ~]# su - oracle
[oracle@Node-1 ~]$ wget https://file.lolicp.com/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