aix 安装oracle11RAC

举报
snowofsummer 发表于 2021/12/12 17:07:31 2021/12/12
【摘要】 1,系统初始化新建用户:mkgroup -A id=54421 oinstallmkgroup -A id=54322 dbamkgroup -A id=54323 opermkgroup -A id=54325 dgdbamkgroup -A id=54326 kmdbamkgroup -A id=54327 asmdbamkgroup -A id=54328 asmopermkgroup...

1,系统初始化

新建用户:

mkgroup -A id=54421 oinstall

mkgroup -A id=54322 dba

mkgroup -A id=54323 oper

mkgroup -A id=54325 dgdba

mkgroup -A id=54326 kmdba

mkgroup -A id=54327 asmdba

mkgroup -A id=54328 asmoper

mkgroup -A id=54329 asmadmin

mkgroup -A id=54330 racdba

mkuser id='53322' pgrp='oinstall' groups='asmadmin,asmdba' home='/home/grid' grid

mkuser id='53321' pgrp='oinstall' groups='dba,asmdba' home='/home/oracle' oracle

 

/usr/bin/chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid

/usr/bin/chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle

/usr/bin/lsuser -a capabilities grid

/usr/bin/lsuser -a capabilities oracle

 

修改系统参数:

ioo -r -o aio_maxservers=65536

 

/usr/sbin/chdev -l sys0 -a ncargs='1024'

 

vmo -p -o minperm%=3

vmo -p -o maxperm%=90

vmo -p -o maxclient%=90

vmo -p -o lru_file_repage=0

vmo -p -o strict_maxclient=1

vmo -p -o strict_maxperm=0

 

 

/usr/sbin/no -o udp_sendspace=65536          

/usr/sbin/no -o udp_recvspace=655360         

/usr/sbin/no -o tcp_sendspace=65536          

/usr/sbin/no -o tcp_recvspace=65536          

/usr/sbin/no -o rfc1323=1                    

/usr/sbin/no -o sb_max=1310720               

no -r -o ipqmaxlen=512  

/usr/sbin/no -p -o tcp_ephemeral_low=9000 -o tcp_ephemeral_high=65500

/usr/sbin/no -p -o udp_ephemeral_low=9000 -o udp_ephemeral_high=6550

 

修改磁盘权限:

lsattr -El hdisk8|grep reserve

lsattr -El hdisk9|grep reserve

lsattr -El hdisk10|grep reserve

 

chmod 660 /dev/rhdisk8

chmod 660 /dev/rhdisk9

chmod 660 /dev/rhdisk10

chdev -l hdisk8 -a reserve_policy=no_reserve

chdev -l hdisk9 -a reserve_policy=no_reserve

chdev -l hdisk10 -a reserve_policy=no_reserve

 

chown grid:asmadmin /dev/rhdisk8

chown grid:asmadmin /dev/rhdisk9

chown grid:asmadmin /dev/rhdisk10

 

 

修改u01目录权限:

Chown grid:oinstall /u01

 

Hosts文件设置:

10.0.248.181      hxdb1

10.0.248.183      hxdb2

192.168.128.11  hxdb1-priv

192.168.128.12  hxdb2-priv

10.0.248.182      hxdb1-vip

10.0.248.184      hxdb2-vip

10.0.248.185    hxdb-scan

2grid安装

选择高级安装


语言选择


 

 

输入SCAN地址


输入主机信息


选择网络信息


选择asm


输入磁盘组名称


输入asm密码:oracle


 

选择用户组


 

安装路径


 

安装预览


 

 

 

运行root.sh


 

Hxdb01:

root@hxdb1:/>/u01/app/11.2.0/grid/root.sh

Performing root user operation for Oracle 11g

 

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /u01/app/11.2.0/grid

 

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

 

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.

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

User grid has the required capabilities to run CSSD in realtime mode

OLR initialization - successful

  root wallet

  root wallet cert

  root cert export

  peer wallet

  profile reader wallet

  pa wallet

  peer wallet keys

  pa wallet keys

  peer cert request

  pa cert request

  peer cert

  pa cert

  peer root cert TP

  profile reader root cert TP

  pa root cert TP

  peer pa cert TP

  pa peer cert TP

  profile reader pa cert TP

  profile reader peer cert TP

  peer user cert

  pa user cert

Adding Clusterware entries to inittab

CRS-2672: Attempting to start 'ora.mdnsd' on 'hxdb1'

CRS-2676: Start of 'ora.mdnsd' on 'hxdb1' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'hxdb1'

CRS-2676: Start of 'ora.gpnpd' on 'hxdb1' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'hxdb1'

CRS-2672: Attempting to start 'ora.gipcd' on 'hxdb1'

CRS-2676: Start of 'ora.cssdmonitor' on 'hxdb1' succeeded

CRS-2676: Start of 'ora.gipcd' on 'hxdb1' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'hxdb1'

CRS-2672: Attempting to start 'ora.diskmon' on 'hxdb1'

CRS-2676: Start of 'ora.diskmon' on 'hxdb1' succeeded

CRS-2676: Start of 'ora.cssd' on 'hxdb1' succeeded

 

ASM created and started successfully.

 

Disk Group hxdbcrs created successfully.

 

clscfg: -install mode specified

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'system'..

Operation successful.

CRS-4256: Updating the profile

Successful addition of voting disk 400989a13f264fa4bfbc5b9b63f1ff30.

Successful addition of voting disk 8a89f69a247b4fdcbf8ac5429e2b4b08.

Successful addition of voting disk 892f04ce76ca4f83bf5c317767ae3b3b.

Successfully replaced voting disk group with +hxdbcrs.

CRS-4256: Updating the profile

CRS-4266: Voting file(s) successfully replaced

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

  1. ONLINE 400989a13f264fa4bfbc5b9b63f1ff30 (/dev/rhdisk10) [HXDBCRS]
  2. ONLINE 8a89f69a247b4fdcbf8ac5429e2b4b08 (/dev/rhdisk8) [HXDBCRS]
  3. ONLINE 892f04ce76ca4f83bf5c317767ae3b3b (/dev/rhdisk9) [HXDBCRS]

Located 3 voting disk(s).

CRS-2672: Attempting to start 'ora.asm' on 'hxdb1'

CRS-2676: Start of 'ora.asm' on 'hxdb1' succeeded

CRS-2672: Attempting to start 'ora.HXDBCRS.dg' on 'hxdb1'

CRS-2676: Start of 'ora.HXDBCRS.dg' on 'hxdb1' succeeded

CRS-2672: Attempting to start 'ora.registry.acfs' on 'hxdb1'

CRS-2676: Start of 'ora.registry.acfs' on 'hxdb1' succeeded

Configure Oracle Grid Infrastructure for a Cluster ... succeeded

 

Hxdb02

root@hxdb2:/>/u01/app/11.2.0/grid/root.sh

Performing root user operation for Oracle 11g

 

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /u01/app/11.2.0/grid

 

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

 

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.

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

User grid has the required capabilities to run CSSD in realtime mode

OLR initialization - successful

Adding Clusterware entries to inittab

CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node hxdb1, number 1, and is terminating

An active cluster was found during exclusive startup, restarting to join the cluster

Configure Oracle Grid Infrastructure for a Cluster ... succeeded

 

完成安装


 


 

 

3Db安装

仅安装数据库软件


选择主机信息


语言选择


企业版安装


安装路径


 

用户组选择


 

安装预览


 

 

完成安装


4,存储迁移并启动数据库

更改磁盘属性:

chown grid:asmadmin /dev/rhdiskXX

chmod 660 /dev/rhdiskXX

chdev -l hdiskXX -a reserve_policy=no_reserve

 

挂在asm磁盘组:

Asmcmd

Mount datadg

 

5,启动数据库

Sqlplus / as sysdba

Startup

 

 

 

【版权声明】本文为华为云社区用户原创内容,转载时必须标注文章的来源(华为云社区)、文章链接、文章作者等基本信息, 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@huaweicloud.com
  • 点赞
  • 收藏
  • 关注作者

评论(0

0/1000
抱歉,系统识别当前为高风险访问,暂不支持该操作

全部回复

上滑加载中

设置昵称

在此一键设置昵称,即可参与社区互动!

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。