Oracle 10G RAC集群安装
2023-09-27 14:25:36 时间
一,基本环境配置
01,hosts
cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.0.240 SHLPDBWX01 192.168.0.241 SHLPDBWX02 172.168.0.240 SHLPDBWX01-priv 172.168.0.241 SHLPDBWX02-priv 192.168.0.243 SHLPDBWX01-vip 192.168.0.244 SHLPDBWX02-vip 192.168.0.242 dgwxpdb dgwxpdb.localdomain
02,用户环境配置
groupadd –g 501 oinstall useradd oracle –u 500 –g oinstall echo 123456|passwd --stdin oracle
03,配置目录
cat .bash_profile PATH=$PATH:$HOME/bin ORACLE_BASE=/u01/app/oracle export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORACLE_SID=WXPDB01 export PATH=$PATH:$ORA_CRS_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:. alias sqlplus='rlwrap sqlplus' # oracle sqlpls alias rman='rlwrap rman' # oracle rman alias ggsci='rlwrap ggsci' # oracle goldengate stty erase ^h export PATH 创建目录授予权限 mkdir /u01/app/oracle/product/10.2.0/db_1 -p chown -R oracle.oinstall /u01/ chmod -R 755 /u01/
04,磁盘配置
见https://www.cnblogs.com/kingle-study/p/10972214.html
05,配置参数
vi /etc/sysctl.conf kernel.core_uses_pid = 1 fs.file-max = 65536 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 1048576 net.core.rmem_max = 1048576 net.core.wmem_default = 262144 net.core.wmem_max = 262144 kernel.shmmni = 4096 kernel.sem = 500 64000 100 128 net.ipv4.tcp_tw_reuse = 1 net.ipv4.tcp_tw_recycle = 1
vi /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
06,安装包检测
检测 rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils \ compat-libstdc++ \ elfutils-libelf-devel \ elfutils-libelf-devel-static \ gcc \ gcc-c++ \ glibc \ glibc-common \ glibc-devel \ glibc-headers \ kernel-headers \ ksh \ libaio \ libaio-devel \ libgcc \ libgomp \ libstdc++ \ libstdc++-devel \ make \ sysstat \ unixODBC \ unixODBC-devel \ libXp
缺少的对应安装 10C的包可能有的需要i686
通过RPm包安装
07,配置互信
[oracle@SHLPDBWX01 ~]$ mkdir ~/.ssh mkdir: cannot create directory `/home/oracle/.ssh': File exists [oracle@SHLPDBWX01 ~]$ chmod 700 ~/.ssh [oracle@SHLPDBWX01 ~]$ cd .ssh/
下面这命令双截点操作(就下面一条) [oracle@SHLPDBWX01 .ssh]$ ssh-keygen -t rsa Generating public/private rsa key pair. Enter file in which to save the key (/home/oracle/.ssh/id_rsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /home/oracle/.ssh/id_rsa. Your public key has been saved in /home/oracle/.ssh/id_rsa.pub. The key fingerprint is: b1:17:b3:dd:7b:43:8b:8b:7c:06:22:58:c0:29:aa:0a oracle@SHLPDBWX01 The key's randomart image is: +--[ RSA 2048]----+ | . . | | . + | | . . . . o | | . . o = . | |. o S o . .. | |E . . o . o..| |o . . ...o.| |. . .o...| | oo. | +-----------------+
[oracle@SHLPDBWX01 .ssh]$ ssh SHLPDBWX01 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys The authenticity of host 'shlpdbwx01 (192.168.0.240)' can't be established. RSA key fingerprint is 11:46:62:ee:23:09:da:62:5f:ae:92:ee:19:6e:0c:4a. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'shlpdbwx01,192.168.0.240' (RSA) to the list of known hosts. oracle@shlpdbwx01's password: [oracle@SHLPDBWX01 .ssh]$ ssh SHLPDBWX02 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys The authenticity of host 'shlpdbwx02 (192.168.0.241)' can't be established. RSA key fingerprint is 11:46:62:ee:23:09:da:62:5f:ae:92:ee:19:6e:0c:4a. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'shlpdbwx02,192.168.0.241' (RSA) to the list of known hosts. oracle@shlpdbwx02's password: [oracle@SHLPDBWX01 .ssh]$ chmod 600 ~/.ssh/authorized_keys [oracle@SHLPDBWX01 .ssh]$ scp authorized_key SHLPDBWX02:/home/oracle/.ssh/ oracle@shlpdbwx02's password: authorized_key: No such file or directory [oracle@SHLPDBWX01 .ssh]$ scp authorized_keys SHLPDBWX02:/home/oracle/.ssh/ oracle@shlpdbwx02's password: authorized_keys 100% 798 0.8KB/s 00:00 [oracle@SHLPDBWX01 .ssh]$ ssh SHLPDBWX01 date Wed Jun 5 16:36:06 CST 2019 [oracle@SHLPDBWX01 .ssh]$ ssh SHLPDBWX02 date Wed Jun 5 16:36:09 CST 2019
二,集群安装
01,解压安装包
相关文章
- Oracle-Linux安装配置python3.6环境
- 静默安装oracle 11g,环境预检查时报错,SEVERE: [FATAL] PRVF-0002 : 无法检索本地节点名
- oracle 静默安装
- Oracle将CLOB字段类型转为Varchar2类型
- [转]看懂Oracle执行计划
- Oracle----dual
- Mysql集群-----(01) Oracle VM VirtualBox 安装Centos7
- 《Oracle数据库管理与维护实战》——1.1 Oracle产品组成
- PL/SQL不安装Oracle连接,Oracle instantclient安装
- oracle函数 NLS_UPPER(x[,y])
- oracle trunc(d1[,c1])
- 手工安装XDB 组件in oracle 11g
- winserver2008 Oracle 11g 安装
- 关于oracle数据库启动报ORA-01122,ORA-01110,ORA-01203错误的解决方法
- 安装Oracle 10g RAC是否需要安装HACMP
- Oracle单节点_Grid_Infrastructure_DB_安装过程图解(三/三)
- Oracle单节点_Grid_Infrastructure_DB_安装过程图解(一/三)
- Oracle 11g R2 数据库安装教程
- Oracle 11g R2 常用配置与日志的文件位置
- Oracle数据库安装中的问题及解决方法
- Oracle BI Publisher 企业版安装后的配置(BI Publisher Enterprise Edition)
- Oracle 数据库,远程访问 ora-12541:TNS:无监听程序