aix 安装oracle11RAC

网友投稿 710 2022-05-28

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

2,grid安装

选择高级安装

语言选择

输入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

aix 安装oracle11RAC

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

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

ONLINE 400989a13f264fa4bfbc5b9b63f1ff30 (/dev/rhdisk10) [HXDBCRS]

ONLINE 8a89f69a247b4fdcbf8ac5429e2b4b08 (/dev/rhdisk8) [HXDBCRS]

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

完成安装

3,Db安装

仅安装数据库软件

选择主机信息

语言选择

企业版安装

安装路径

用户组选择

安装预览

完成安装

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

Oracle

版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。

上一篇:文件IO操作,文件路径操作和文件
下一篇:MYSQL 两次写
相关文章