0
Oracle安装琐碎记录
236
30页
8次
墨值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
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜
近期活动
全部
暂无活动,敬请期待...
相关课程
全部