BI_DBA_安装(1):安装OS及DB

1.这部分没有什么好讲的,关键的点注意好就行了,

开启FTP\关闭防火墙等等.

为了方便DB的安装 直接使用Oracle提供的oracle-validated包来简化oracle安装。

[root@db03 ~]# cd /etc/yum.repos.d  
[root@db03 yum.repos.d]# wget http://public-yum.oracle.com/public-yum-el5.repo  

[root@db03 yum.repos.d]# yum install oracle-validated  

会安装以下几个部分:

（1）自动安装oracle所需的RPM包

（2）自动创建oracle用户和group组

（3）自动配置/etc/sysctl.conf内核参数

（4）自动配置/etc/security/limits.conf参数

（5）关闭NUMA=OFF   （关闭非一致内存访问）

ps.oracle linux 6_64bit上，提供了oracle-rdbms-server-11gR2-preinstall包

yum install oracle-rdbms-server-11gR2-preinstall

挂上光盘:

[oel6_local]

 name = oracle Enterprise Linux 6

 baseurl=file:///mnt/cdrom/Server/

 gpgcheck=0

 enabled=1

装完后配好监听等等

2.注意将JDK升级为1.6版本

export JAVA_HOME="/usr/local/jdk1.6.0_33"
export CLASS_PATH="$JAVA_HOME/lib:$JAVA_HOME/jre/lib"
export PATH=".:$PATH:$JAVA_HOME/bin"

3.创建DB相关信息

 

create tablespace bidimd datafile '/u01/app/oracle/oradata/bidw/bidimd01.dbf' size 2000M reuse autoextend off;  --informatica

create tablespace bidacd datafile '/u01/app/oracle/oradata/bidw/bidacd01.dbf' size 2000M reuse autoextend on; --dac

create tablespace bidwd datafile '/u01/app/oracle/oradata/bidw/bidwd01.dbf' size 4000M reuse autoextend OFF; --dw

create tablespace bidwx datafile '/u01/app/oracle/oradata/bidw/bidwx01.dbf' size 4000M reuse autoextend OFF;  --索引

创建用户：

create user infodomain identified by Test123 default tablespace bidimd temporary tablespace temp;

create user inforeps identified by Test123 default tablespace bidimd temporary tablespace temp;

create user dacreps identified by Test123 default tablespace bidacd temporary tablespace temp;

create user bidw identified by Test123 default tablespace bidwd temporary tablespace temp;

创建角色：

CREATE ROLE SSE_ROLE;

GRANT CONNECT, RESOURCE,DBA TO SSE_ROLE;

GRANT SELECT ANY TABLE TO SSE_ROLE;

GRANT INSERT ANY TABLE TO SSE_ROLE;

GRANT UPDATE ANY TABLE TO SSE_ROLE;

GRANT DELETE ANY TABLE TO SSE_ROLE;

GRANT GRANT ANY OBJECT PRIVILEGE TO SSE_ROLE;

GRANT GRANT ANY PRIVILEGES TO SSE_ROLE;

GRANT SSE_ROLE TO infodomain;

GRANT SSE_ROLE TO inforeps;

GRANT SSE_ROLE TO dacreps;    

GRANT SSE_ROLE TO  bidw;

Alter User inforeps QUOTA unlimited on bidimd;

Alter User infodomain QUOTA unlimited on bidimd;

Alter User dacreps QUOTA unlimited on bidacd;

Alter User bidw QUOTA unlimited on bidwd;

Alter User bidw QUOTA unlimited on bidwx;

修改数据库进程，会话，游标

alter  system set processes=1000 scope=spfile;

alter  system set open_cursors=1000 scope=spfile;

alter  system set sessions=2000 scope=spfile;

修改用户有效时间-永不过期:

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

备份文件：

.control_files='/u01/app/oracle/oradata/bidw/control01.ctl','/u01/app/oracle/fast_recovery_area/bidw/control02.ctl'

--alter user bidw identified by test123456 default tablespace bidwd temporary tablespace temp;

 

4.安装RCU

安装-链接DB-创建RCU前缀

选公用as方案\biee\选择相应的表空间