打不开公式编辑器(公式编辑器用不了)
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
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小时内删除侵权内容。