ORACLE数据库自带的opath,oracle11.2.0.4.0 数据库安装

-rw-r--r--. 1 oracle oinstall 1395582860 Jun 24 18:02 p13390677_112040_Linux-x86-64_1of7.zip

-rw-r--r--. 1 oracle oinstall 1151304589 Jun 24 18:02 p13390677_112040_Linux-x86-64_2of7.zip

oracle11.2.0.4.0数据库安装

一、修改内核

1.1 修改sysctl.conf文件

[root@doea5db01 Downloads]# vi /etc/sysctl.conf

fs.aio-max-nr = 1048576

kernel.shmmax = 277495689510912

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

fs.file-max = 6815744

1.2 使参数生效

[root@doea5db01 Downloads]# sysctl –p

二、增加用户和组

[root@doea5db01 Downloads]# groupadd oinstall

[root@doea5db01 Downloads]# groupadd dba

[root@doea5db01 Downloads]# groupadd oper

[root@doea5db01 Downloads]# useradd -g oinstall -G dba,oper oracle

[root@doea5db01 Downloads]# passwd oracle

三、修改limits.conf限制

[root@doea5db01 Downloads]# vi /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

四、修改/etc/pam.d/login

[root@doea5db01 Downloads]# vi /etc/pam.d/login

session required /lib64/security/pam_limits.so

五、修改bash_profile文件

5.1 修改profile

[root@doea5db01 Downloads]# vi /etc/profile

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

5.2 修改bash_profile

[oracle@doea5db01 ~]$ vi .bash_profile

export EDITOR=vi

export ORACLE_SID=doea5db

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export INVENTORY_LOCATION=/oraInventory

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export NLS_LANG="American_america.zhs16gbk"

export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:$PATH:$HOME/bin

umask 022

5.3 使bash_profile生效

[oracle@doea5db01 ~]$ source .bash_profile

六、创建目录

[root@doea5db01 ~]# mkdir /doea5

[root@doea5db01 ~]# chown oracle:oinstall /doea5

七、安装oracle数据库软件

[oracle@doea5db01 ~]$ cd database/

[oracle@doea5db01 database]$ pwd

/home/oracle/database

7.1 运行runInstaller安装程序

7.2 仅安装oracle软件

选择“install database software only”选项：

选择“single instance database installation”:

选择语言(注：没有特殊需求，默认即可)：

选择“Enterprise Editor(4.7GB)”:

7.3选择安装目录(注：路径是从环境变量里读取的，一般不需要修改)：

选择用户dba和组oper：

确保检查结果无警告出现(注：下图提示的swap size是警告，是可以忽略的)：

7.4 root执行shell脚本

以root身份执行orainstRoot.sh和root.sh脚本(注：执行完脚本以后，在点击“ok”)：

[root@doea5db01 Packages]# /doea5/oraInventory/orainstRoot.sh

Changing permissions of /doea5/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /doea5/oraInventory to oinstall.

The execution of the script is complete.

[root@doea5db01 Packages]# /doea5/product/11.2.0/db_1/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /doea5/product/11.2.0/db_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.

Finished product-specific root actions.

点击“close”按钮完成安装：

八、创建listener

8.1 运行netca

8.2新增listener

8.3 命名listener

8.4 选择端口1521(注：1521是默认端口)：

九、创建实例

9.1 运行dbca

9.2 选择创建数据库实例

9.3选择实例名

9.3 填写内置账号的密码

9.4 取消归档和闪回

取消“Specify Fast Recovery Area”和“Enable Archiving”(注：待安装完成后，会单独定制这两个功能):

9.5 修改数据库进程数量

修改数据库最大进程的数量为3000：

9.6 修改数据库字符集

选择数据库字符集：ZHS16GBK –GBK 16-bit Simplified Chinese

十、打开归档和闪回功能

10.1 创建目录

[oracle@doea5db01 doea5]$

mkdir /doea5/{arch, flash_recovery }

[oracle@doea5db01 doea5]$ sqlplus / as sysdba

10.2 修改spfile参数

SQL> alter system set log_archive_dest_1='location=/doea5/arch';

SQL> alter system set log_archive_format='arch_%t_%s_%r.log' scope=spfile;

SQL> alter system set db_recovery_file_dest_size=20G;

SQL> alter system set db_recovery_file_dest='/doea5/flash_recovery';

SQL> alter system set db_flashback_retention_target=10080;

SQL> alter system set undo_retention=10800;

10.3 打开归档和闪回

SQL> shutdown immediate

SQL> startup mount

SQL> alter database archivelog ;

SQL> alter database flashback on;

SQL> alter database open;

十一、表空间分类及数据初始化

根据“A5业务系统.zip”附件里的README提示，运行脚本和命令完成表空间分类和数据初始化工作。