欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

Oracle12c for OEL5.8 Single instance database inst

程序员文章站 2024-01-19 08:51:28
...

check list: 操作系统版本支持 : Oracle Linux 5 Supported distributions: Oracle Linux 5 Update 6 with the Unbreakable Enterprise kernel: 2.6.32-100.0.19 or later Oracle Linux 5 Update 6 with the Red Hat compatible kernel: 2.6.18-238.0.0.0.1

check list:

操作系统版本支持

Oracle Linux 5 Supported distributions:

Oracle Linux 5 Update 6 with the Unbreakable Enterprise kernel: 2.6.32-100.0.19 or later
Oracle Linux 5 Update 6 with the Red Hat compatible kernel: 2.6.18-238.0.0.0.1.el5 or later

安装最小需求:

软件目录  :  6.4 GB
/TMP空间   :  1GB
物理内存  :  1GB
SWAP空间 :  1 GB 16G,16G

系统包支持:

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

参数文件设置

/etc/sysctl.conf

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

/etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 10240

创建用户和组和文件目录:

#groupadd oinstall
#groupadd dba
#useradd -g oinstall -G dba oracle
#mkdir -p /u01/app/oracle/
#chown -R oracle:oinstall /u01/app/oracle/
#chmod -R 775 /u01/app/oracle/

环境变量和/etc/hosts,此处省略 , HOHO~!~ 顺便说一下软件的下载地址:

http://download.oracle.com/otn/linux/oracle12c/121020/linuxamd64_12102_database_1of2.zip

http://download.oracle.com/otn/linux/oracle12c/121020/linuxamd64_12102_database_2of2.zip

好啦,开始安装了!

软件部分,没啥说的,直接上图:

1. Configure Security Updates

没啥说的,全都不选择,直接NEXT.

Oracle12c for OEL5.8 Single instance database inst

告警也不理你,直接YES.

Oracle12c for OEL5.8 Single instance database inst

2. Installation Option

只安装软件,好处就是快,NEXT.

Oracle12c for OEL5.8 Single instance database inst

3. Grid Installation Options

只安装单实例,本文的标题,NEXT .

Oracle12c for OEL5.8 Single instance database inst

4. Select Product Languages

支持下中文,NEXT.

Oracle12c for OEL5.8 Single instance database inst

5. Database Edition

还有人会选择“Enterprise Edition” 以外的选项吗? NEXT.

Oracle12c for OEL5.8 Single instance database inst

6. Installation Location

BASE和HOME,和以往差不多,NEXT.

Oracle12c for OEL5.8 Single instance database inst

7. Create Inventory

一样一样的,NEXT.

Oracle12c for OEL5.8 Single instance database inst

8. Operating System Groups

我“默认”了,NEXT.

Oracle12c for OEL5.8 Single instance database inst

9. Prerequisite Checks

准备工作要做好,不然折腾的是自己,这里没大问题,我这里选择了忽略,这是个坏习惯, NEXT。

Oracle12c for OEL5.8 Single instance database inst

10. Summary

不解释,Install.

Oracle12c for OEL5.8 Single instance database inst

11. Install Product

工程开始了,要咖啡么。。。。。。

Oracle12c for OEL5.8 Single instance database inst

12. Install Product

按照提示,一个一个节点轮流串行执行,执行完成后,返回来点”ok”

Oracle12c for OEL5.8 Single instance database inst

13. Finish

软件安装完成. Close.

Oracle12c for OEL5.8 Single instance database inst

数据库创建,没啥说的,继续上图:

1. Database Operation

创建数据库,走起NEXT.

Oracle12c for OEL5.8 Single instance database inst

2. Creation Mode

Advanced Mode,NEXT.

Oracle12c for OEL5.8 Single instance database inst

3. Database Template

按照自己习惯定制吧,NEXT。

Oracle12c for OEL5.8 Single instance database inst

4. Database Identification

填入实例名称,这里与以往版本有变化,可以PBD了。NEXT~

Oracle12c for OEL5.8 Single instance database inst

5. Management Options

我没有选择EM这两项,因为我平时基本用不到。 NEXT.

Oracle12c for OEL5.8 Single instance database inst

6. Database Credentials

我们只是虚拟机玩玩,所以统一密码,生产库记得安装好后改回去。 NEXT.

Oracle12c for OEL5.8 Single instance database inst

7. Network Configuration

监听配置, NEXT.

Oracle12c for OEL5.8 Single instance database inst

8. Storage Locations

存储的选择,和以往11g没多大区别. NEXT.

Oracle12c for OEL5.8 Single instance database inst

9. Database Options

这里都是灰色的,不知道是不是我打开的方式不对. 不管了,继续NEXT.

Oracle12c for OEL5.8 Single instance database inst

10. Database Vault & OLS

直接跳过了,NEXT.

Oracle12c for OEL5.8 Single instance database inst

11. Initialization Parameters

内存,块大小,字符集,服务器模式等配置.

Oracle12c for OEL5.8 Single instance database instOracle12c for OEL5.8 Single instance database instOracle12c for OEL5.8 Single instance database instOracle12c for OEL5.8 Single instance database inst

11. Createion Options

创建数据库,NEXT

Oracle12c for OEL5.8 Single instance database inst

12. Prerequisite Check

忽略了,我们要记住,任何检查都要搞定,不要给后面出问题的机会。

Oracle12c for OEL5.8 Single instance database inst

12. Summary

Finish ~

Oracle12c for OEL5.8 Single instance database inst

13. Progress Page

再来一杯咖啡吗?

Oracle12c for OEL5.8 Single instance database inst

OH ~ 中奖了!!

Oracle12c for OEL5.8 Single instance database inst

$oerr ora 00845
00845, 00000, “MEMORY_TARGET not supported on this system”
// *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux.
// *Action: Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.

根据提示,去增加了 /dev/shm

编辑/etc/fstab

tmpfs /dev/shm tmpfs defaults 0 0
改为
tmpfs /dev/shm tmpfs defaults,size=4g 0 0

重新MOUNT, 安装重新来过……. 欲哭无泪~

14. Finish

OK , 搞定~

Oracle12c for OEL5.8 Single instance database inst

总的来讲,安装还算顺利, 不过中间犯的错误都是可以避免的。在工作中一定要记住,安装预检查是必要的一部分,不然后面谁知道会有什么问题等着我们呢。本章就到这里, 非常感谢大家~~