原创作品,出自 深蓝的blog 博客,欢迎转载,转载时请务必注明以下出处,否则追究版权法律责任。 深蓝的blog:http://blog.csdn.net/huangyanlong/article/details/40782379 CentOS6.4下安装Oracle11G集群 前提:使用图形化完成ssh配置,如下图: 错误现象:
原创作品,出自 “深蓝的blog” 博客,欢迎转载,转载时请务必注明以下出处,否则追究版权法律责任。
深蓝的blog:http://blog.csdn.net/huangyanlong/article/details/40782379
CentOS6.4下安装Oracle11G集群
前提:使用图形化完成ssh配置,如下图:
错误现象:
安装grid软件时报错INS-41112错误,如下图所示:
两节点进行ping测试,分别ping“公有IP”和“私有IP”,两节点ping通正常后,按如下方式配置:
1、两节点进行SSH验证
节点1:
[grid@test1 ~]$ ssh rac2priv date
--验证节点2私有IP
The authenticity of host 'rac2priv (192.168.56.73)' can't be established.
RSA key fingerprint is a3:ab:da:a3:f1:0a:40:02:97:0c:96:2b:ad:43:60:b7.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'rac2priv,192.168.56.73' (RSA) to the list of known hosts.
Wed Oct 29 17:04:12 CST 2014
[grid@test1 ~]$ ssh rac2priv date
Wed Oct 29 17:04:14 CST 2014
[grid@test1 ~]$ ssh rac1priv date
--验证节点1私有IP
The authenticity of host 'rac1priv (192.168.56.72)' can't be established.
RSA key fingerprint is 48:3b:19:c1:d6:5d:fb:9e:32:09:3a:82:4f:2e:ad:81.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'rac1priv,192.168.56.72' (RSA) to the list of known hosts.
Wed Oct 29 16:40:47 CST 2014
[grid@test1 ~]$ ssh rac1priv date
Wed Oct 29 16:40:48 CST 2014
[grid@test2 ~]$ ssh test1 date
--验证节点1公有IP
Wed Oct 29 17:04:14 CST 2014
[grid@test2 ~]$ ssh test2 date
--验证节点2公有IP
Wed Oct 29 17:04:14 CST 2014
节点2:
[grid@test2 ~]$ ssh rac1priv date
The authenticity of host 'rac1priv (192.168.56.72)' can't be established.
RSA key fingerprint is 48:3b:19:c1:d6:5d:fb:9e:32:09:3a:82:4f:2e:ad:81.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'rac1priv,192.168.56.72' (RSA) to the list of known hosts.
Wed Oct 29 16:41:59 CST 2014
[grid@test2 ~]$ ssh rac1priv date
Wed Oct 29 16:42:01 CST 2014
[grid@test2 ~]$ ssh rac2priv date
The authenticity of host 'rac2priv (192.168.56.73)' can't be established.
RSA key fingerprint is a3:ab:da:a3:f1:0a:40:02:97:0c:96:2b:ad:43:60:b7.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'rac2priv,192.168.56.73' (RSA) to the list of known hosts.
Wed Oct 29 17:05:47 CST 2014
[grid@test2 ~]$ ssh rac2priv date
Wed Oct 29 17:05:48 CST 2014
[grid@test2 ~]$ ssh rac1priv date
Wed Oct 29 16:46:32 CST 2014
[grid@test2 ~]$ ssh test1 date
--验证节点1公有IP
Wed Oct 29 16:46:48 CST 2014
[grid@test2 ~]$ ssh test2 date
--验证节点2公有IP
Wed Oct 29 17:10:46 CST 2014
2、在两个节点上关闭不必要的服务
节点1:
[root@test1 /]# chkconfig NetworkManager off
[root@test1 /]# sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
[root@test1 /]# chkconfig iptables off
节点2:
[root@test2 ~]# chkconfig NetworkManager off
[root@test2 ~]# sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
[root@test2 ~]# chkconfig iptables off
重新执行grid安装,正常通过了。
原创作品,出自 “深蓝的blog” 博客,欢迎转载,转载时请务必注明以下出处,否则追究版权法律责任。
深蓝的blog:http://blog.csdn.net/huangyanlong/article/details/40782379

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

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

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

MySQloffersechar, Varchar, text, Anddenumforstringdata.usecharforfixed-Lengthstrings, VarcharerForvariable-Length, text forlarger text, AndenumforenforcingdataAntegritywithaetofvalues.

Optimizing MySQLBLOB requests can be done through the following strategies: 1. Reduce the frequency of BLOB query, use independent requests or delay loading; 2. Select the appropriate BLOB type (such as TINYBLOB); 3. Separate the BLOB data into separate tables; 4. Compress the BLOB data at the application layer; 5. Index the BLOB metadata. These methods can effectively improve performance by combining monitoring, caching and data sharding in actual applications.

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

Atom editor mac version download
The most popular open source editor

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
