博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
CentOs5.8下安装Oracle12C
阅读量:5920 次
发布时间:2019-06-19

本文共 5395 字,大约阅读时间需要 17 分钟。

12C安装向导:

http://docs.oracle.com/database/121/LTDQI/toc.htm

12C下载地址:

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

 

1.安装Oracle依赖包

使用yum安装Oracle12C依赖,标注32 bit不需安装。没有yum环境的这些包可以在操作系统安装介质中查找。这些需要的安装依赖包可以在Oracle提供的12C在线安装文档中找到。操作系统版本不同,所需要的依赖包略有差别。

binutils-2.17.50.0.6compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (32 bit)gcc-4.1.2gcc-c++-4.1.2glibc-2.5-58glibc-2.5-58 (32 bit)glibc-devel-2.5-58glibc-devel-2.5-58 (32 bit)kshlibaio-0.3.106libaio-0.3.106 (32 bit)libaio-devel-0.3.106libaio-devel-0.3.106 (32 bit)libgcc-4.1.2libgcc-4.1.2 (32 bit)libstdc++-4.1.2libstdc++-4.1.2 (32 bit)libstdc++-devel 4.1.2libXext-1.0.1libXext-1.0.1 (32 bit)libXtst-1.0.1libXtst-1.0.1 (32 bit)libX11-1.0.3libX11-1.0.3 (32 bit)libXau-1.0.1libXau-1.0.1 (32 bit)libXi-1.0.1libXi-1.0.1 (32 bit) make-3.81sysstat-7.0.2

 

2. 创建用户及组

[root@edu ~]# groupadd oinstall[root@edu ~]# groupadd dba[root@edu ~]# useradd -g oinstall -G dba oracle[root@edu ~]# passwd oracleChanging password for user oracle.New UNIX password: BAD PASSWORD: it is based on a dictionary wordRetype new UNIX password: passwd: all authentication tokens updated successfully.

 

3.修改系统内核参数

使用vi命令修改配置文件/etc/sysctl.conf,使用/sbin/sysctl –p命令使内核配置生效。

fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586

 

4.修改用户资源限制

使用vi命令修改配置文件/etc/security/limits.conf

oracle soft nofile 65536oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 16384oracle stack nproc 16384

 

5.创建安装目录

 

[root@edu ~]# mkdir -p /u01/app[root@edu ~]# chown -R oracle:oinstall /u01[root@edu ~]# chmod -R 775 /u01[root@edu ~]# ls -ld /u01/app/drwxrwxr-x 2 oracle oinstall 4096 Jan 29 20:54 /u01/app/[root@edu ~]#

 

 

6.配置Oracle用户环境变量

 

修改Oracle下的.bash_profile文件,不同的shell名称会有区别。source .bash_profile使修改生效。

 

ORACLE_BASE=/u01/app;export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1     export ORACLE_HOMEORACLE_SID=ORCL;export ORACLE_SIDTMP=/tmp;export TMPTMPDIR=/tmp;export TMPDIRPATH=$PATH:$ORACLE_HOME/bin;export PATHDISPLAY=:0.0;export DISPLAY

 

 

7. 解压执行安装Oracle12C软件

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

按照提示以root身份执行以下脚本:

[root@edu /]# /u01/oraInventory/orainstRoot.sh Changing permissions of /u01/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /u01/oraInventory to oinstall.The execution of the script is complete.

 

[root@edu /]# /u01/app/product/12.1.0/dbhome_1/root.sh Performing root user operation for Oracle 12c The following environment variables are set as:    ORACLE_OWNER= oracle    ORACLE_HOME=  /u01/app/product/12.1.0/dbhome_1Enter 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 byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.

 

 

 

8.使用dbca创建数据库

 

在Oracle用户下直接执行dbca命令:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

9.使用netca创建监听

 

 

 

 

 

 

 

 

10.验证数据库及监听安装

 

[oracle@edu database]$ sqlplus '/as sysdba'SQL*Plus: Release 12.1.0.1.0 Production on Fri Jan 30 22:46:06 2015Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> select banner from v$version;BANNER----------------------------------------------------------------------------Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionPL/SQL Release 12.1.0.1.0 - ProductionCORE    12.1.0.1.0    ProductionTNS for Linux: Version 12.1.0.1.0 - ProductionNLSRTL Version 12.1.0.1.0 – Production

 

[oracle@edu database]$ lsnrctl statusLSNRCTL for Linux: Version 12.1.0.1.0 - Production on 30-JAN-2015 22:47:42Copyright (c) 1991, 2013, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edu.localdomain)(PORT=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 12.1.0.1.0 - ProductionStart Date                30-JAN-2015 22:40:00Uptime                    0 days 0 hr. 7 min. 42 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/product/12.1.0/dbhome_1/network/admin/listener.oraListener Log File         /u01/app/diag/tnslsnr/edu/listener/alert/log.xmlListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edu.localdomain)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=edu.localdomain)(PORT=5500))(Security=(my_wallet_directory=/u01/app/admin/ORCL/xdb_wallet))(Presentation=HTTP)(Session=RAW))Services Summary...Service "ORCL" has 1 instance(s).  Instance "ORCL", status READY, has 1 handler(s) for this service...Service "ORCLXDB" has 1 instance(s).  Instance "ORCL", status READY, has 1 handler(s) for this service...The command completed successfully

 

至此我们的Oracle12c数据库安装成功!

 

转载于:https://www.cnblogs.com/myrunning/p/4268573.html

你可能感兴趣的文章
500行 python 代码实现模板引擎
查看>>
空元素和可替换元素
查看>>
号称“更快更稳”的华为云全新云服务器S6性能大评测
查看>>
聊天室应用开发实践(二):实现基于 Web 的聊天室
查看>>
Python学习笔记 - 发送邮件
查看>>
29.Flutter与原生解耦式混合开发
查看>>
【Go学习笔记9】go语言中的工具包-json
查看>>
说说在 Python 中如何导入类
查看>>
Python爬取双色球,妈妈再也不会担心我不会中奖了
查看>>
初体验之开源Git服务Gogs
查看>>
react重要基础概念---06应用:Tabs组件
查看>>
UIButton的重复点击
查看>>
java学习日记—4.11
查看>>
VUE记录
查看>>
Flutter数据库Sqflite之增删改查
查看>>
vue拖拽插件
查看>>
Android的基本控件和Activity的应用总结
查看>>
java B2B2C 多租户电子商城系统-整合企业架构的技术点
查看>>
Service
查看>>
ssh 服务突然连接不了案例总结
查看>>