Solaris 10(x86)构建Oracle 10g RAC之--配置系统环境（2）-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Solaris 10(x86)构建Oracle 10g RAC之--配置系统环境（2）

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:36 PM

oraclesolarisConstructenvironmentsystemConfiguration

Solaris10(x86)构建Oracle10gRAC之--配置系统环境（2）系统环境：操作系统：Solaris10（x86-64）Cluster：OracleCRS10.2.0.1.0Oracle：Oracle10.2.0.1.0如图所示

Solaris 10(x86)构建Oracle 10g RAC之--配置系统环境（2）

系统环境：

操作系统：Solaris 10（x86-64）

Cluster： Oracle CRS 10.2.0.1.0

Oracle： Oracle 10.2.0.1.0

如图所示：RAC 系统架构

一、建立主机之间的信任关系（在所有node）

1、配置主机hosts.equiv文件

[root@node1:/]# cat /etc/hosts.equiv node1 root node1 oracle node1-vip root node1-vip oracle node1-priv root node1-priv oracle node2 root node2 oracle node2-vip root node2-vip oracle node2-priv root node2-priv oracle

2、配置Oracle用户.rhosts文件

[oracle@node1:/export/home/oracle]$ cat .rhosts node1 root node1 oracle node1-vip root node1-vip oracle node1-priv root node1-priv oracle node2 root node2 oracle node2-vip root node2-vip oracle node2-priv root node2-priv oracle

3、启动相关的服务，验证

[root@node1:/]# svcs -a |grep rlogin disabled 10:05:17 svc:/network/login:rlogin [root@node1:/]# svcadm enable svc:/network/login:rlogin [root@node1:/]# svcadm enable svc:/network/rexec:default [root@node1:/]# svcadm enable svc:/network/shell:default [root@node1:/]# svcs -a |grep rlogin online 11:37:34 svc:/network/login:rlogin [root@node1:/]# su - oracle Oracle Corporation SunOS 5.10 Generic Patch January 2005 [oracle@node1:/export/home/oracle]$ rlogin node1 Last login: Wed Jan 21 11:29:36 from node2-priv Oracle Corporation SunOS 5.10 Generic Patch January 2005

二、安装CRS前系统环境的检测（在node1）

[oracle@node1:/export/home/oracle]$ unzip 10201_clusterware_solx86_64.zip [oracle@node1:/export/home/oracle/clusterware/cluvfy]$ ./runcluvfy.sh USAGE: cluvfy [ -help ] cluvfy stage { -list | -help } cluvfy stage {-pre|-post}

[-verbose] cluvfy comp { -list | -help } cluvfy comp

[-verbose] [oracle@node1:/export/home/oracle/clusterware/cluvfy]$ ./runcluvfy.sh stage -pre crsinst -n node1,node2 -verbose Performing pre-checks for cluster services setup Checking node reachability... Check: Node reachability from node "node1" Destination Node Reachable? ------------------------------------ ------------------------ node1 yes node2 yes Result: Node reachability check passed from node "node1". Checking user equivalence... Check: User equivalence for user "oracle" Node Name Comment ------------------------------------ ------------------------ node2 passed node1 passed Result: User equivalence check passed for user "oracle". Checking administrative privileges... Check: Existence of user "oracle" Node Name User Exists Comment ------------ ------------------------ ------------------------ node2 yes passed node1 yes passed Result: User existence check passed for "oracle". Check: Existence of group "oinstall" Node Name Status Group ID ------------ ------------------------ ------------------------ node2 exists 200 node1 exists 200 Result: Group existence check passed for "oinstall". Check: Membership of user "oracle" in group "oinstall" [as Primary] Node Name User Exists Group Exists User in Group Primary Comment ---------------- ------------ ------------ ------------ ------------ ------------ node2 yes yes yes yes passed node1 yes yes yes yes passed Result: Membership check for user "oracle" in group "oinstall" [as Primary] passed. Administrative privileges check passed. Checking node connectivity... Interface information for node "node2" Interface Name IP Address Subnet ------------------------------ ------------------------------ ---------------- e1000g0 192.168.8.12 192.168.8.0 e1000g1 10.10.10.12 10.10.10.0 Interface information for node "node1" Interface Name IP Address Subnet ------------------------------ ------------------------------ ---------------- e1000g0 192.168.8.11 192.168.8.0 e1000g1 10.10.10.11 10.10.10.0 Check: Node connectivity of subnet "192.168.8.0" Source Destination Connected? ------------------------------ ------------------------------ ---------------- node2:e1000g0 node1:e1000g0 yes Result: Node connectivity check passed for subnet "192.168.8.0" with node(s) node2,node1. Check: Node connectivity of subnet "10.10.10.0" Source Destination Connected? ------------------------------ ------------------------------ ---------------- node2:e1000g1 node1:e1000g1 yes Result: Node connectivity check passed for subnet "10.10.10.0" with node(s) node2,node1. Suitable interfaces for the private interconnect on subnet "192.168.8.0": node2 e1000g0:192.168.8.12 node1 e1000g0:192.168.8.11 Suitable interfaces for the private interconnect on subnet "10.10.10.0": node2 e1000g1:10.10.10.12 node1 e1000g1:10.10.10.11 ERROR: Could not find a suitable set of interfaces for VIPs. Result: Node connectivity check failed. ---vip 网络检测失败 Checking system requirements for 'crs'... Check: Total memory Node Name Available Required Comment ------------ ------------------------ ------------------------ ---------- node2 1.76GB (1843200KB) 512MB (524288KB) passed node1 1.76GB (1843200KB) 512MB (524288KB) passed Result: Total memory check passed. Check: Free disk space in "/tmp" dir Node Name Available Required Comment ------------ ------------------------ ------------------------ ---------- node2 3GB (3150148KB) 400MB (409600KB) passed node1 2.74GB (2875128KB) 400MB (409600KB) passed Result: Free disk space check passed. Check: Swap space Node Name Available Required Comment ------------ ------------------------ ------------------------ ---------- node2 2GB (2096476KB) 512MB (524288KB) passed node1 2GB (2096476KB) 512MB (524288KB) passed Result: Swap space check passed. Check: System architecture Node Name Available Required Comment ------------ ------------------------ ------------------------ ---------- node2 64-bit 64-bit passed node1 64-bit 64-bit passed Result: System architecture check passed. Check: Operating system version Node Name Available Required Comment ------------ ------------------------ ------------------------ ---------- node2 SunOS 5.10 SunOS 5.10 passed node1 SunOS 5.10 SunOS 5.10 passed Result: Operating system version check passed. Check: Operating system patch for "118345-03" Node Name Applied Required Comment ------------ ------------------------ ------------------------ ---------- node2 unknown 118345-03 failed node1 unknown 118345-03 failed Result: Operating system patch check failed for "118345-03". Check: Operating system patch for "119961-01" Node Name Applied Required Comment ------------ ------------------------ ------------------------ ---------- node2 119961-06 119961-01 passed node1 119961-06 119961-01 passed Result: Operating system patch check passed for "119961-01". Check: Operating system patch for "117837-05" Node Name Applied Required Comment ------------ ------------------------ ------------------------ ---------- node2 unknown 117837-05 failed node1 unknown 117837-05 failed Result: Operating system patch check failed for "117837-05". Check: Operating system patch for "117846-08" Node Name Applied Required Comment ------------ ------------------------ ------------------------ ---------- node2 unknown 117846-08 failed node1 unknown 117846-08 failed Result: Operating system patch check failed for "117846-08". Check: Operating system patch for "118682-01" Node Name Applied Required Comment ------------ ------------------------ ------------------------ ---------- node2 unknown 118682-01 failed node1 unknown 118682-01 failed Result: Operating system patch check failed for "118682-01". ---系统补丁检测失败 Check: Group existence for "dba" Node Name Status Comment ------------ ------------------------ ------------------------ node2 exists passed node1 exists passed Result: Group existence check passed for "dba". Check: Group existence for "oinstall" Node Name Status Comment ------------ ------------------------ ------------------------ node2 exists passed node1 exists passed Result: Group existence check passed for "oinstall". Check: User existence for "oracle" Node Name Status Comment ------------ ------------------------ ------------------------ node2 exists passed node1 exists passed Result: User existence check passed for "oracle". Check: User existence for "nobody" Node Name Status Comment ------------ ------------------------ ------------------------ node2 exists passed node1 exists passed Result: User existence check passed for "nobody". System requirement failed for 'crs' Pre-check for cluster services setup was unsuccessful on all the nodes.

----在以上的系统环境检测中，VIP网络检查失败；

如果在检测前没有配置VIP网络，，可以用一下方式进行配置；如果已经配置过，就不会检测失败。

配置vip network（node1）：

[root@node1:/]# ifconfig e1000g0:1 plumb up

[root@node1:/]# ifconfig e1000g0:1 192.168.8.13 netmask 255.255.255.0

[root@node1:/]# ifconfig -a

lo0: flags=2001000849 mtu 8232 index 1

inet 127.0.0.1 netmask ff000000

e1000g0: flags=1000843 mtu 1500 index 2

inet 192.168.8.11 netmask ffffff00 broadcast 192.168.8.255

ether 8:0:27:28:b1:8c

e1000g0:1: flags=4001000842 mtu 1500 index 2

inet 192.168.8.13 netmask ffffff00 broadcast 192.168.8.255

e1000g1: flags=1000843 mtu 1500 index 3

inet 10.10.10.11 netmask ffffff00 broadcast 10.10.10.255

ether 8:0:27:6e:16:1

配置vip network（node2）：

[root@node2:/]# ifconfig e1000g0:1 plumb up

[root@node2:/]# ifconfig e1000g0:1 192.168.8.14 netmask 255.255.255.0

[root@node2:/]# ifconfig -a

lo0: flags=2001000849 mtu 8232 index 1

inet 127.0.0.1 netmask ff000000

e1000g0: flags=1000843 mtu 1500 index 2

inet 192.168.8.12 netmask ffffff00 broadcast 192.168.8.255

ether 8:0:27:1f:bf:4c

e1000g0:1: flags=1000843 mtu 1500 index 2

inet 192.168.8.14 netmask ffffff00 broadcast 192.168.8.255

e1000g1: flags=1000843 mtu 1500 index 3

inet 10.10.10.12 netmask ffffff00 broadcast 10.10.10.255

ether 8:0:27:a5:2c:db

----在以上的系统环境检测中，部分补丁没有安装（可以通过Oracle官方网站下载，本机为测试环境暂不安装）

本文出自 “天涯客的blog” 博客，请务必保留此出处

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AM

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AM

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AM

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AM

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

MySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AM

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

See all articles