Oracle安装琐碎记录 - 墨天轮文档

Oracle安装琐碎记录

ziyoo0830

586

30页

8次

2019-09-05

5墨值下载

Oracle安装文档

创建用户和组

组

11g

12c



用户

# groupadd --gid 54321 oinstall

# groupadd --gid 54322 dba

# groupadd --gid 54326 oper

如果是rac环境，还需要创建以下组：

# groupadd --gid 54323 asmdba

# groupadd --gid 54324 asmoper

# groupadd --gid 54325 asmadmin

除以上11g相关的组，还需要加如下的组：

OSDBA group ( DBA ) – determines OS user accounts with DBA privileges

OSOPER group ( OPER ) – an optional group created to assign limited DBA

privileges ( SYSOPER privilege) to particular OS user accounts

OSBACKUPDBA group ( BACKUPDBA ) – an optional group created to assign limited

administrative privileges ( SYSBACKUP privilege) to a user for database backup

and recovery

OSDGDBA group ( DGDBA ) – an optional group created to assign limited

administrative privileges ( SYSDG privilege) to a user for administering and

monitoring Oracle Data Guard

OSKMDBA group ( KMDBA ) – an optional group created to assign limited

administrative privileges ( SYSKM privilege) to a user for encryption key

management when using Oracle Wallet Manager

OSDBA group ( ASMDBA ) – provides administrative access to Oracle ASM instances

OSASM group ( ASMADMIN ) – provides administrative access for storage files via

the SYSASM privilege

OSOPER group ( ASMOPER ) – an optional group created to assign limited DBA

privileges with regards to ASM to particular OS user accounts

# groupadd -g 54324 backupdba

# groupadd -g 54325 dgdba

# groupadd -g 54326 kmdba

# groupadd -g 54327 asmdba

# groupadd -g 54328 asmoper

# groupadd -g 54329 asmadmin

# groupadd -g 54330 racdba

11g

12c

创建安装目录

配置用户环境变量

grid用户

oracle用户

# useradd --uid 54310 -g oinstall -G dba,asmdba,asmadmin,asmoper grid

# useradd --uid 54311 -g oinstall -G dba,oper,asmdba oracle

# useradd --uid 54321 --gid oinstall --groups dba,oper,asmdba,asmoper,

backupdba,dgdba,kmdba oracle

# useradd --uid 54322 --gid oinstall --groups dba,asmadmin,asmdba,asmoper grid

# mkdir -p /u01/app/11.2.0/grid

# mkdir -p /u01/app/grid

# mkdir -p /u01/app/oracle

# chown grid:oinstall /u01/app/11.2.0/grid

# chown grid:oinstall /u01/app/grid

# chown -R oracle:oinstall /u01/app/oracle

# chmod -R 775 /u01/

# chown -R grid:oinstall /u01

如果是单机环境，可根据实际情况进行调整。

export TMP=/tmp

export TMPDIR=\$TMP

export ORACLE_HOSTNAME=rac1.xl.com

export ORACLE_SID=+ASM1

export ORACLE_BASE=/u01/app/grid

export ORACLE_HOME=/u01/app/11.2.0/grid

export NLS_DATE_FORMAT="yy-mm-dd HH24:MI:SS"

export PATH=$ORACLE_HOME/bin:$PATH

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=ora112

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

export ORACLE_UNQNAME=prod

export ORACLE_SID=ora112

export ORACLE_TERM=xterm

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

of 30

5墨值下载

oracle 安装部署

关注

评论