VirtualBox安装3节点oracle11GRAC(超级详细)
Oracle-RAC以及ASM安装全过程整理

RAC以及ASM安装全过程整理RAC以及ASM安装全过程整理更改主机名第一步:#hostname oratest第二步:修改/etc/sysconfig/network中的hostname第三步:修改/etc/hosts文件设置hosts文件可参考:[root@amdocs01 mapper]# cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.localhostamdocs02amdocs02-vipamdocs02-priv设置IPeth01eth1绑定裸设备先在逻辑卷组上分出逻辑卷,全部为裸设备,必须包含:逻辑盘:ocrlv ,votelv 是必须的,因为后面安装ASM要用到data01,data02,data03,data04,data05,softlv,oralv可选1、裸设备定义:一块没有分区的硬盘,称为原始设备(RAWDEVICE)或者是一个分区,但是没有用EXT3,OCFS等文件系统格式化,称为原始分区(RAWPARTITION)以上两者都是裸设备2、裸设备的绑定有文件系统的分区是采用mount的方式挂载到某一个挂载点的(目录)而裸设备不能mount,只能绑定到/dev/raw/下的某一个设备名比如/dev/raw/raw13、裸设备的绑定方法先介绍第一种方法:修改/etc/sysconfig/rawdevices,添加以下内容,这里sdd1和sdd2是原始分区名或者原始设备(硬盘)名,raw1和raw2是/dev目录下的原始设备名,编号从raw1到raw8191,也就是最多可以绑定255个裸设备/dev/raw/raw1/dev/sdd1/dev/raw/raw2/dev/sdd2然后修改裸设备的属主和访问权限chown oracle:dba /dev/raw/raw1chown oracle:dba /dev/raw/raw2chmod 660 /dev/raw/raw1chmod 660 /dev/raw/raw2最后使得裸设备生效,并且在机器启动的时候就自动加载执行/sbin/chkconfig rawdevices on保证机器启动的时候裸设备能够加载,这一步很重要裸设备的绑定方法第二种方法,修改文件的方法#!/bin/sh## This script will be executed *after* all the other init scripts. # You can put your own initialization stuff in here if you don't # want to do the full Sys V style init stuff.touch /var/lock/subsys/localraw /dev/raw/raw1 /dev/mapper/vg00-ocrlvraw /dev/raw/raw2 /dev/mapper/vg00-votelvraw /dev/raw/raw3 /dev/mapper/vg00-data01raw /dev/raw/raw4 /dev/mapper/vg00-data02raw /dev/raw/raw5 /dev/mapper/vg00-data03raw /dev/raw/raw6 /dev/mapper/vg00-data04chmod 775 /dev/raw/raw1chmod 775 /dev/raw/raw2chmod 775 /dev/raw/raw3chmod 775 /dev/raw/raw4chmod 775 /dev/raw/raw5chmod 775 /dev/raw/raw6chown oracle:dba /dev/raw/raw1chown oracle:dba /dev/raw/raw2chown oracle:dba /dev/raw/raw3chown oracle:dba /dev/raw/raw4chown oracle:dba /dev/raw/raw5chown oracle:dba /dev/raw/raw6chown oracle:dba /dev/raw/raw7modprobe hangcheck-timer hangcheck-tick=30 hangcheck_margin=1804、裸设备的读写不能用cp等命令操作,写入内容用dd命令,可以参阅相关资料5、清空裸设备相当于格式化啦bs是快的大小,blocksizecount是快的数量,这两者相乘大于裸设备的容量即可ddif=/dev/zeroof=/dev/raw/raw1bs=8192count=12800ddif=/dev/zeroof=/dev/raw/raw2bs=8192count=12800-------另外,注意:rhel4使用udev来管理设备手动修改/dev/raw/raw1不能永久生效要想使得权限持久生效raw/*:root:disk:0660改成raw/*:oracle:dba:0660重启机器如果/dev/下没有/raw/目录,可以自己手工建立。
ORACLE 11G RAC 安装部署及测试方案

ORACLE 11G RAC 安装部署及测试方案BY:JM.CAO一、系统要求1.1硬件环境要求Oracle11gR2 RAC 最低安装要求:内存:安装 grid infrastructure 最少需要 1.5GB 的内存,安装grid infrastructure 和 RAC 最少需要 2.5GB 的内存swap:最少需要 1.5GB,推荐等于实际物理内存temp:最少 1GB /tmp安装目录:grid infrastructure最少需要 15GB空间,oracle database 至少15GB ,建议为安装目录创建单独的文件系统,如: /u01。
操作系统:aix 6.1,并且需要安装如下软件包:lslpp -l bos.adt.base bos.adt.lib \bos.adt.libm bos.perf.libperfstat\bos.perf.perfstat bos.perf.proctools rsct.basic.rte \ pat.clients.rte xlC.aix61.rte1.2 网络环境要求1.2.1、IP 地址要求Oracle 11gR2 RAC 中对网络的要求与 10g 稍有些不同,除 Public IP、Private IP、VIP外,在Oracle 11gR2RAC 中还引入了 SCAN IP的概念。
SCAN 全称是 Single Client Access Name ,它是 Oracle RAC 11gR2 版本的一个新特性。
它为需要访问Oracle 集群数据的客户端提供一个简单名字。
1.2.2、DNS 服务器在 Oracle 11gR2 RAC 中引入了 SCAN 的概念,而 ORACLE 推荐使用DNS 解析的方法来实现 SCAN,这就要求网络中有一台 DNS 服务器用来解析SCAN 地址。
如果你网络中没有专用的 DNS 服务器,那么也可以使用hosts文件进行解析。
CentOS6.5下Oracle11G完整安装步骤

CentOS6.5下Oracle11g安装完整步骤一、硬件要求本部分内容命令,均以root用户执行。
1、内存建议内存应大于2G以上,1G可以运行,但比较吃力。
内存查看命令:[root@tsp-rls-dbserver /]# cat /proc/meminfo或[root@tsp-rls-dbserver /]# free -mtotal used free shared buffers cachedMem: 32062 1301 30760 0 40 552-/+ buffers/cache: 708 31354Swap: 16095 0 160952、交换分区交换分区大小,通常设为内存的1.5倍以上,也可以根据实际情况进行调整。
交换分区查看命令:[root@tsp-rls-dbserver /]# grep SwapTotal /proc/meminfoSwapTotal: 67682296 kB3、硬盘空间建议数据使用独立的挂载分区,本文中采用/data作为数据分区。
要求/tmp目录空间不小于400M。
磁盘空间查看命令:[root@tsp-rls-dbserver /]# df -hFilesystem Size Used Avail Use% Mounted on/dev/mapper/vg_tsprlsdbserver-lv_root 50G 4.3G 43G 10% /tmpfs 16G 348K 16G 1% /dev/shm/dev/sda1 485M 39M 421M 9% /boot/dev/mapper/vg_tsprlsdbserver-lv_home 210G 190M 199G 1% /home/dev/sdb1 1.1T 4.5G 1.1T 1% /data目录空间大小查看命令:[root@tsp-rls-dbserver tmp]# du -ch /tmp二、软件要求1、安装依赖包建议安装系统时,选择开发库。
OracleVMVirtualBox虚拟机安装MacOSX详细图解

此前曾多次尝试用硬盘安装助手和变色龙来安装Mac OS X 但均未成功。
镜像可以写入硬盘,电脑的启动选项里也出现了Mac OS X 和变色龙的选项,可都不能进入进行安装。
就其原因有二:第一我的PC从CUP到主板芯片组再到显卡都是AMD的,兼容程度上不如INTEL的;第二因为是单位给配的电脑,都有增霸卡,启动系统是无法绕过此硬件。
终于,改变思路,用虚拟机VirtualBox安装。
我用的版本是3.2.4的,最新的版本是3.2.10。
其实界面和操作都差不多,在这里就不多说什么了,论坛里和网上都有很细致的教程。
只有一点要提的,建立虚拟介质时,操作系统选Mac OS ,下一个选项当然就选Mac OS server。
1.打开虚拟机,再打开你建立好的虚拟硬盘,会出现以下画面按任意键,开始安装。
2.选择简体中文3.选择实用工具里的磁盘工具,进行摸盘,这是必须的。
4.摸盘完成后就真正进入了安装阶段5.此时一定不能直接点安装,要点下图最左边的自定。
6.此时会出现各种驱动的选项,第一项已经默认选择了,不要动,剩下的要根据你电脑的具体配置进行选择,这一步至关重要,如果做不好会导致你安装的mac os 不能运行。
后面会有详细的配置驱动选择说明。
7.等待安装,大约20分钟左右8.安装成功,重启。
9.此时点Show All ,再选China,不说相信大家都知道吧。
10.这里的ID可以不填,如下图12.下图可以随意填写。
13.下图的用户名和密码即PASSWOED请记住,以后安装软件时需要输入的。
14 好了进入只属于你的MAC OS世界吧!下面是我安装好的MAC OS X 截图iDeneb 10.5.6自定义驱动详细中文说明警告!不要将这个版本覆盖安装到已存在的Mac OS X上,这可能导致安装失败。
不要选择两个或更多相同种类的驱动,比如说,同时安装两个声卡或SMBIOS的驱动,很多情况下会导致安装失败。
默认安装9.6原版内核。
Oracle11g 安装 培训 视频教程

王二暖Oracle11g教室时间和具体内容第0部分本视频课程简介.wmv 38分钟第1部分Oracle11g简介.wmv 46分钟第2.1部分oracle11g的基本SQL语句和函数.wmv 1小时22分钟第2.2部分oracle11g的复杂SQL语句.wmv 1小时47分钟第3部分用户和权限.wmv 45分钟第4部分完整行约束.wmv 37分钟第5部分oracle11g的网络配置.wmv 1小时11分钟第6部分oracle11g的锁.wmv 29分钟第7部分Oracle11g的体系结构.wmv 2小时36分钟第8部分Oracle11g的启动和关闭.wmv 33分钟第9部分oracle11g的表.wmv 1小时20分钟第10部分oracle11g的表分区.wmv 1小时10分钟第11部分同义词.wmv 17分钟第12部分序列视频.wmv 26分钟第13部分oracle11g的视图.wmv 41分钟第14部分索引.wmv 1小时10分钟第15部分JAVA操纵Oracle11g.wmv 45分钟第16部分oracle11g中的事务.wmv 57分钟第17部分oracle11g的数据字典和动态性能视图.wmv 38分钟第18部分ORACLE11g的归档方式和日志文件的相关操作.wmv 1小时11分钟第19部分oracle11g的PLSQL基础.wmv 2小时12分钟第20部分oracle11g的过程和函数.wmv 51分钟第21部分oracle11g的游标.wmv 1小时27分钟第22部分oracle11g的触发器.wmv 1小时23分钟第23部分oracle11g的程序包.wmv 1小时10分钟第24部分JAVA访问oracle11g中的存储过程.wmv 55分钟第25部分oracle11g的临时表空间.wmv 28分钟第26部分oracle11g的UNDO表空间.wmv 37分钟第27部分oracle11g的逻辑备份恢复.wmv 2小时46分钟第28部分Oracle11g的数据装载.wmv 50分钟第29部分oracle11g的闪回Flashback.wmv 1小时15分钟第30部分oracle11g的物化视图.wmv 58分钟第31部分使用物化视图和exp实现生产库的逻辑备份的例子.wmv 16分钟具体课程目录如下:第1部分Oracle11g简介1.1 Oracle的发展1.2 Oracle的主要产品1.3 为什么要学习Oracle11g1.4 Oracle11g简介1.5 Oracle11g的认证1.6 Oracle11g的安装(for Windows)1.7 Oracle11g的服务1.8 Oracle11g的卸载1.9 访问Oracle11g的工具1.10 Oracle11g常用的SQL*Plus命令1.11 Oracle11g的网络配置第2.1部分Oracle11g的基本SQL语句和函数2.1.1 Oracle的数据类型2.1.2 数据定义语言2.1.3 数据操纵语言2.1.4 SELECT命令详解2.1.5 Oracle中的CREATE TABLE <new_table_name> AS ...和insert into <table_name> select ...的使用2.1.6 数据控制语言2.1.7 SQL操作符2.1.8 Oracle的单行函数2.1.9 GROUP BY和HAVING子句的使用2.1.10 多表连接的方式2.1.11 集合操作符2.1.12 表和列的重命名第2.2部分Oracle11g的复杂SQL语句2.2.1 SQL语句执行顺序的分析2.2.2 EXISTS执行过程的分析2.2.3 子查询的使用2.2.4 GROUP BY的练习2.2.5 自连接的使用2.2.6 SELECT CASE WHEN的的使用2.2.7 复杂更新语句的使用(UPDATE执行过程的分析)2.2.8 分析函数的使用2.2.9 DECODE的使用2.2.10 Oracle中的行列转换2.2.11 ROWNUM的使用2.2.12 使用三种SQL命令来删除表中的重复记录2.2.13 GROUP BY GROUPING SETS 的使用第3部分用户和权限管理3.1 Oracle11g的默认用户3.2 创建新用户3.3 概要文件profile的使用3.4 Oracle11g的权限分类3.5 Oracle11g的系统权限3.6 Oracle11g的对象权限3.7 Oracle11g的角色管理3.8 删除、修改用户第4部分完整行约束4.1 举例说明数据完整性的含义4.2 维护数据完整性的五种方式的举例说明4.3 建立主键的五种不同方式4.4 完整性约束的习题讲解4.5 给已有表添加、删除约束的方法第5部分Oracle11g的网络配置5.1 Oracle11g的网络连接方式5.2 Oracle11g至少需要启动的服务5.3 lsnrctl命令的使用5.4 sqlnet.ora的作用5.5 客户端连接的两种方式5.6 tnsnames.ora的作用5.7 Oracle11g的服务名的含义5.8 listener.ora的作用5.9 静态注册、动态注册的含义及其相互转化的方式第6部分Oracle11g的锁6.1 锁的概念和优点6.2 行级锁6.3 表级锁的五种方式6.4 死锁第7部分Oracle11g的体系结构7.1 Oracle11g的主要组件7.2 Oracle11g内存结构7.3 Oracle11g的SGA的组成7.4 Oracle11g的PGA的组成7.5 Oracle11g的进程概念7.6 Oracle11g的后台进程7.7 9i中的自动PGA管理7.8 10g中的自动SGA管理7.9 11g中的自动内存管理7.10 Oracle11g的物理文件7.11 Oracle11g的逻辑结构第8部分Oracle11g的启动和关闭8.1 Oracle11g的参数文件8.2 Oracle11g的四种状态8.3 Oracle的启动8.4 Oracle的关闭第9部分Oracle11g的表9.1 术语----高水位线9.2 术语---- PCTFREE9.3 术语---- PCTUSED9.4 PCTFREE和PCTUSED的使用场合9.5 普通表(包含分配空间、移动表、收缩表、截断表等操作的方式)9.6 IOT表9.7 簇表9.8 临时表第10部分Oracle11g的表分区10.1 表分区的含义10.2 范围分区10.3 散列分区10.4 列表分区10.5 复合分区10.6 Oracle11g的引用分区10.7 Oracle11g的间隔分区10.8 Oracle11g的基于虚拟列的分区10.9 Oracle11g的系统分区10.10 分区的维护操作第11部分同义词11.1 同义词的含义11.2 共有同义词的建立和使用11.3 私有同义词的建立和使用11.4 tab是什么?第12部分序列12.1 序列的含义12.2 建立序列(包括重要参数的含义)12.3 访问序列12.4 更改、删除序列12.5 程序中如何实现自增第13部分Oracle11g的视图13.1 Oracle11g中创建视图的语法13.2 多表视图的建立13.3 单表视图的更新13.4 视图上的DML语句13.5 视图中的函数第14部分索引14.1 索引的概念和作用14.2 B树索引的工作原理(查询过程分析)14.3 创建标准索引14.4 如何分析索引中是否存在碎片和使用率14.5 创建唯一索引、组合索引、反向键索引、位图索引14.6 基于函数的索引14.7 重建索引的条件和方法14.8 索引的分区14.9 获取索引信息的视图第15部分JAVA操纵Oracle11g15.1 Oracle11g的驱动所在的位置15.2 ODBC访问方式15.3 JDBC-ODBC桥访问方式,输入Java代码演示15.4 JDBC访问方式,输入Java代码演示第16部分Oracle11g中的事务16.1 举例说明事务的四个特性16.2 Oracle11g事务的命令(与SqlServer进行对比)16.3 JAVA中进行oracle11g的事务处理(举2个经典例子,输入Java代码演示)第17部分Oracle11g的数据字典和动态性能视图17.1 Oreacle11g中的数据字典的含义是什么17.2 数据字典基本表怎么被创建的17.3 数据字典视图是什么?怎么被创建的17.4 Oracle11g的数据字典视图的三种类型(分析user_tables究竟是什么)17.5 Oracle11g的动态性能视图(分析V$SESSION究竟是什么)第18部分Oracle11g的归档方式和日志文件的相关操作18.1 在线日志文件的作用18.2 数据库归档方式的转换18.3 Oracle11g的归档日志位置的设置18.4 归档中,被废弃的早期的初始化参数18.5 联机日志文件和联机日志文件组18.6 联机日志文件组的四种常见状态18.7 增加、清除联机日志文件18.8 自动归档、手工归档第19部分Oracle11g的PL/SQL基础19.1 PL/SQL简介19.2 PL/SQL 块的结构19.3 变量和常量(与T-SQL进行比较)19.4 PL/SQL中的数据类型(包含Oracle11g中新增的类型)19.5 如何把大文件保存到表BLOB列中19.6 如何把大内容保存到表的CLOB列中19.7 Oracle11g新特性:无dual的序列19.8 PL/SQL中的流程控制结构(重点讲循环的几种方式)19.9 Oracle11g新特性:continue语句的使用19.10 动态SQL的使用19.11 PL/SQL中的错误处理机制第20部分Oracle11g的过程和函数20.1 创建过程的语法20.2 过程参数的三种模式20.3 在两种方式下(Sql*Plus中和其他过程内),执行过程的方法20.4 执行过程的权限20.5 创建函数的语法20.6 函数的课堂题目和解答20.7 函数和过程的比较20.8 Oracle11g的自主事务处理第21部分Oracle11g的游标21.1 游标的简介和分类21.2 Oracle11g的隐式游标21.3 Oracle11g的显式游标21.4 Oracle11g的带参数的显式游标21.5 使用显式游标更新行(更新、删除)21.6 Oracle11g的循环游标21.7 使用fetch ... bulk collect into进行批量提取21.8 Oracle11g的REF游标21.9 显式游标、REF游标的课堂题目和分析解答第22部分Oracle11g的触发器22.1 触发器的作用22.2 创建触发器的语句(与SqlServer进行比较)22.3 for each row子句的含义22.4 after、before两种类型的触发器的区别22.5 instead of触发器的使用22.6 模式触发器的使用22.7 数据库启动、关闭触发器的使用22.8 用户登录、退出触发器的使用22.9 启用、禁用、查看触发器第23部分Oracle11g的程序包23.1 程序包的含义23.2 建立包规范23.3 建立包体23.4 程序包中游标的使用23.5 常用的内置程序包(dbms_output、dbms_random、utl_file、dbms_job等)第24部分JAVA访问Oracle11g中的存储过程24.1 java程序中调用Oracle11g中的没有返回参数的存储过程(插入记录)24.2 java程序中调用Oracle11g中的没有返回参数的存储过程(更新记录)24.3 java程序中调用Oracle11g中的有返回参数的存储过程(查询记录)24.4 java程序中调用Oracle11g中的返回列表的存储过程24.5 java程序中调用Oracle11g中的分页存储过程(存储过程返回分页的列表)第25部分Oracle11g的临时表空间25.1 Oracle11g中临时表空间的作用25.2 Oracle11g的临时表空间和临时表空间组25.3 oracle11g的临时表空间的操作第26部分Oracle11g的UNDO表空间26.1 9i到11g的Undo管理的方式改变26.2 UNDO块的作用26.3 UNDO表空间的作用26.4 Oracle11g的UNDO相关的重要参数26.5 Oracle11g的UNDO表空间的操作26.6 Oracle11g的UNDO表空间的新特性第27部分Oracle11g的逻辑备份恢复27.1 数据库备份、恢复简介27.2 Oracle环境中可能发生的故障类型27.3 传统的导出程序exp27.4 传统的导入程序imp27.5 可传输表空间27.6 11g的数据泵简介27.7 expdp的重要参数27.8 impdp的重要参数27.9 exp/imp与数据泵的区别第28部分Oracle11g的数据装载28.1 数据装载的使用场合和几种方式28.2 SQL*LOADER的使用28.3 外部表的使用第29部分Oracle11g的闪回Flashback29.1 Oracle9i的闪回查询29.2 Oracle10g的闪回版本查询29.3 Oracle10g的闪回事务查询29.4 Oracle10g的闪回表29.5 Oracle10g的闪回删除29.6 Oracle10g的闪回数据库第30部分Oracle11g的物化视图30.1 物化视图的发展、简介30.2 物化视图的作用30.3 创建物化视图的权限30.4 创建物化视图的选项30.5 基于主键的物化视图30.6 基于rowid的物化视图第31部分使用物化视图和exp实现生产库的逻辑备份的例子31.1 问题的提出31.2 问题的解决。
在linux64上安装oracle11g_完整版本

Oracle 11g安装手册1、在linux的root用户下建立一个oracle用户//添加用户组及用户groupadd dbagroupadd oinstalluseradd oracle -g oinstall -G dbapasswd oracle//新建目录权限mkdir -p /u01chown -R oracle:dba /u01chmod -R 755 /u01安装时步骤8、9会指向此位置(建议:用户更改/opt/oracle11g)2、将Oracle11g安装文件复制到linux中的指定目录下(/home/oracle/tools)cp /光盘目录/linux.x64_11gR2_database_1of2 /home/oracle/tools3、执行目录中的runInstallsu - oracleLANG=zh_CN.gbk4、开始图像界面安装可能需要export DIAPLAY=:1.0xdpyinfo步骤1:将红框中的内容勾选去掉,点击下一步。
提示“未指定电子邮件地址”点击“是”步骤2:点选“创建和配置数据库”此选项也为默认选项,点击下一步。
步骤3:点击选中“服务器类”,点击“下一步”步骤4:点击选中“单实例数据库安装”,点击下一步。
步骤5:点击选中“高级安装”,点击“下一步”步骤6:选择需要的语言,点击“下一步”,此处客户确认是否需要增加其他语言步骤7:点击选中“企业版(4.29GB)”,点击“下一步”点击上图的“选择选项”,勾选需要的组件,此处全部勾选。
步骤8:此处为默认路径,u01的建立参考第1点orcale用户的建立,点击“下一步”步骤9:此处默认即可,点击“下一步”步骤10:点击选中“一般用途/事务处理”,点击“下一步”步骤11:此处默认,点击“下一步”vpmsdbs步骤12:此处可以设置内存、字符集、安全性、示例方案(可根据用户环境调整),点击“下一步”,内存分配建议至少50%步骤13:此处默认,点击“下一步”步骤14:此处默认处理,点击“下一步”步骤15:点击选中“不启用自动备份”,点击“下一步”步骤16:各帐号口令设定,此处统一使用相同口令,客户现场请在同客户确认口令设定规则步骤17:点击“下一步”步骤18:点击“修补并在此检查”,会产生修补文件,按照提示内容执行即可A、切换到root用户,此处为测试环境执行内容如上述步骤执行完成后依旧存在失败内容,请到linux光盘中寻找对应的rpm文件,复制到linux某一目录中,按下图命令执行步骤19:修补完成后,出现如下信息,点击“完成”步骤20:执行安装过程复制文件,创建实例过程完成后信息,点击“确定”完成后,如出现以下内容,请按照操作步骤,执行完成后,完成安装过程配置监听器1、执行su - oraclesh /u01/app/oracle/product/11.2.0/dbhome_1/bin/netca2、点击选中“监听程序配置”,点击“下一步”3、点击选中“添加”,点击“下一步”4、设定监听程序名,点击“下一步”5、选定协议所有协议,点击“下一步”6、设定标准端口号,点击“下一步”7、设定标准TCP/IP SSL端口号,点击“下一步”8、设置IPC键值,点击“下一步”9、提示是否配置另一个监听程序,点“是”,再点击“下一步”配置数据库1、执行sh /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbca2、点击“下一步”3、点选“创建数据库”,点击“下一步”4、点选“一般用途或事物处理”,点击“下一步”5、设定数据库名及SID,点击“下一步”6、配置管理选项,此处暂时用7、设定口令,点击“下一步”8、网络配置,点击“下一步”9、数据库文件所在位置,点击“下一步”,按照实际的文件规划位置10、恢复配置,点击“下一步”11、数据库内容,点击“下一步”12、初始化参数,点击“下一步”13、数据库存储,点击“下一步”14、创建选项,点击“完成”15、概要显示,点击“确定”16、创建进行17、创建完成,点击“退出”环境变量设置及启动1、设置环境变量在服务器上配置环境变量,编辑vi /etc/profile,在末尾加入以下配置export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1export PATH=.:$ORACLE_HOME/bin:$PATHexport ORACLE_SID=VPMSDBS (数据库SID)保存并退出vi /etc/oratab最后的N 改成Y(否则dbstart和dbshut命令无效)lsnrctl start (启动oracle监听)提示:The listener supports no servicesThe command completed successfully这样启动后远程连接会造成oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor-----方案一-------------------------在listener.ora里面添加了一行SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = VENDB)(ORACLE_HOME = /opt/oracle11g/app/oracle/product/11.2.0/dbhome_1)(SID_NAME = VENDB)))-----方案二-------------------------linux上面:[oracle@localhost ~]$ netmgr在下图的Listeners->Database Services中配置要监听的SID及ORACLE_HOME,退出保存。
Oracle_VM_VirtualBox下载及安装教程 2

基于 Oracle VM VirtualBox的Windows XP虚拟机安装与配置编辑者:个人宿醉注:安装路径必需是全英文的,装好才显示中文。
要不然装出来是英文的哦。
、如图:2一.安装Oracle VM VirtualBox1、先下载VirtualBox 最新版本:/wiki/Downloads 。
2、清理你的计算机,停止不必要的程序,准备VirtualBox 安装程序。
3、安装。
找到下载的安装程序VirtualBox-4.2.12-84980-Win.exe 如下图:点击进行安装, 选择安装路径:如果中途弹出安装驱动的提示请选择“继续安装”。
二.创建虚拟机1、首先运行VirtualBox,然后单击左上角的“新建”。
双击快捷键2、接下来给虚拟机取名,同时选择要安装的系统版本(注:取的名为系统名时自动识别版本)。
33、接下来就是为虚拟机分配内存的大小。
最小内存为512MB ,本例为1G 。
根据自己的内存而定。
以下保持默认。
4、到这里要选择存放硬盘镜像的位置以及硬盘虚拟空间的大小。
<本例40G>45、点击创建完成。
接下来开始设置。
效果如下图所示。
6、现在对“显示”、“存储”、“共享文件夹”进行设置。
其余的保持默认。
设置显存大小并勾上扩展特性的两项。
(显存大小设置在100左右即可<本例120MB>)6.1.2 添加Windows XP 镜像文件。
图中步骤2是打开文件位置。
5接下来是添加Windows XP镜像文件成功。
6.1.3 设置共享文件夹。
图中步骤2是打开已建好的共享文件夹。
如下图:6.1.4下图为添加共享文件夹成功点击确定。
到这里创建虚拟机完成。
三.设置虚拟机IP拨号,以方便系统装完后,设置系统IP拨号,当然,系统装完后,再弄这步也可以。
右键---设置。
如下图:网络--网卡1--连接方式选(桥接网卡)--高级模式--混杂模式--全部允许--接入网线上打勾如下图:6四.开始安装虚拟机操作系统1、单击左上角的“启动”。
Oracle 11gRAC数据库安装(HPUX11.31+ASM without MC-SG)

HPUX11.31+RAC11G数据库安装2011年6月Author: ma.yu@目录1.用户需求: (3)2.安装过程: (4)2.1 系统环境准备,检查两台机器的状况: (4)2.2 网络环境准备: (7)2.3 补丁: (7)2.4 内核参数修改: (7)2.5 创建ORACLE用户: (8)2.6 磁盘分配: (10)2.7 ORACLE 安装前准备: (13)2.8 ORACLE Clusterware安装: (15)2.9 ORACLE RAC database软件安装: (30)2.10 升级11.1.0.6到11.1.0.7: (38)2.11 Listener创建: (53)2.12 dbca创建数据库: (54)1.用户需求:用户需要安装一套数据库RAC:数据库软件:Oracle11g数据库软件版本:11.1.0.6 ,升级到11.1.0.7。
模式:rac数据库sid:MIS数据库ip 规划如下:目前这边硬件环境是两台rx6600 ,操作系统版本:HP-UX B.11.31存贮设备hp storage works P2000,总存储空间2.8T ,这套存储设备供MIS系统使用的磁盘分为四个,分别为1G,800G*3。
2.安装过程:由于用户没有购买SGeRAC,所以在这次的安装过程中,使用Clusterware+RACdatabase+ASM的方式,不使用SGeRAC。
这样的话,所有的非ASM数据都要保存在共享磁盘分区裸设备上,而不是共享的lv 上。
2.1 系统环境准备,检查两台机器的状况:A.检查内存大小,至少>1GB.# /usr/contrib/bin/machinfo | grep -i Memory# /usr/sbin/dmesg | grep "Physical:"16GB.B.交换空间的检查:-If RAM between 1GB and 2GB, then swap space required is 1.5 times the size of RAM-If RAM > 2GB, then swap space required is equal to the size of RAM# /usr/sbin/swapinfo –a16GB。
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
使用vbox创建oracle11GR2 --3节点rac操作系统cenos6.5数据库版本11.2.0.4修改服务器的配置文件:配置网卡cd /etc/sysconfig/network-scripts/关闭防火墙chkconfig iptables offiptables –Fiptables –L关闭内核防火墙:vi /etc/sysconfig/selinux修改hosts内容:192.168.1.110 rac1 192.168.1.111 rac2 192.168.1.112 rac3 #virtual192.168.1.120 rac1-vip 192.168.1.121 rac2-vip 192.168.1.122 rac3-vip #eth1 private18.1.30.50 rac1-priv 18.1.30.51 rac2-priv 18.1.30.52 rac3-priv #scan192.168.1.130 rac-scan给系统打补丁包:之后给系统打包(这个应该先做后调网络)binutils-2.17.50.0.6compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (32 bit)elfutils-libelf-0.125elfutils-libelf-devel-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-2.5-24 (32 bit)glibc-common-2.5glibc-devel-2.5glibc-devel-2.5 (32 bit)libaio-0.3.106libaio-0.3.106 (32 bit)libaio-devel-0.3.106libaio-devel-0.3.106 (32 bit)libgcc-4.1.2libgcc-4.1.2 (32 bit)libstdc++-4.1.2libstdc++-4.1.2 (32 bit)libstdc++-devel 4.1.2make-3.81sysstat-7.0.2yum install XXXXX所有节点执行:[root@rac1 ~]# vi /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=rac1建两个用户和组groupadd oinstallgroupadd dbauseradd -g oinstall -G dba griduseradd -g oinstall -G dba oracleecho -n yangbo|passwd --stdin gridecho -n yangbo|passwd --stdin oraclemkdir -p /u02/app/11.2.0/gridmkdir -p /u02/app/gridmkdir -p /u02/app/oraclechown grid:oinstall /u02/app/11.2.0/gridchown grid:oinstall /u02/app/gridchown -R oracle:oinstall /u02/app/oraclechmod -R 775 /u02/chown -R grid:oinstall /u02修改系统参数sed -i 's/kernel.shmmax/#kernel.shmmax/g' /etc/sysctl.conf sed -i 's/kernel.shmall/#kernel.shmall/g' /etc/sysctl.confcat >> /etc/sysctl.conf << EOFfs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 1073741824kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586EOF配置/etc/security/limits.confcat >> /etc/security/limits.conf << EOForacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240grid soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard nofile 65536grid soft stack 10240EOF用户环境变量Oracle:(vi ~/bash_profiel)umask 022unset ORA_NLS10export ORACLE_BASE=/u02/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export ORACLE_SID=base1export NLS_LANG=american_america.zhs16gbkexport NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/binexport PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexport PATH=${PATH}:$ORACLE_BASE/common/oracle/binexportORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin export ORACLE_TERM=xtermexport TNS_ADMIN=$ORACLE_HOME/network/adminexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libexport LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexport CLASSPATH=$ORACLE_HOME/JREexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib#export ORA_NLS10=$ORACLE_HOME/nls/dataexport THREADS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmpgrid用户的变量(vi ~/bash_profiel)umask 022unset ORA_NLS10export ORACLE_BASE=/u02/app/gridexport ORACLE_HOME=/u02/app/11.2/gridexport ORACLE_SID=+ASM1export NLS_LANG=american_america.zhs16gbkexport NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/binexport PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexport PATH=${PATH}:$ORACLE_BASE/common/oracle/binexportORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin export ORACLE_TERM=xtermexport TNS_ADMIN=$ORACLE_HOME/network/admin#export ORA_NLS10=$ORACLE_HOME/nls/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libexport LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexport CLASSPATH=$ORACLE_HOME/JREexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexport THREADS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmp八.配置NTP服务8.1节点1sed -i 's/OPTIONS/#OPTIONS/g' /etc/sysconfig/ntpdB.cat >> /etc/sysconfig/ntpd << EOFOPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"EOFC.mv /etc/ntp.conf /etc/ntp.confbakD.cat > /etc/ntp.conf << EOFrestrict 0.0.0.0 mask 0.0.0.0 nomodifyserver 127.127.1.0fudge 127.127.1.0 stratum 10driftfile /var/lib/ntp/driftbroadcastdelay 0.008authenticate nokeys /etc/ntp/keysEOF8.2节点2A.sed -i 's/OPTIONS/#OPTIONS/g' /etc/sysconfig/ntpdB.cat >> /etc/sysconfig/ntpd << EOFOPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"EOFC.mv /etc/ntp.conf /etc/ntp.confbakD.cat >> /etc/ntp.conf << XLrestrict default kod nomodify notrap nopeer noquery restrict 192.168.1.0 mask 255.255.255.0 nomodify notrap restrict 127.0.0.1server 192.168.8.199server 127.127.1.0 # local clockfudge 127.127.1.0 stratum 10driftfile /var/lib/ntp/driftbroadcastdelay 0.008authenticate nokeys /etc/ntp/keysXL8.3启动服务(双节点执行)#service ntpd restart8.4系统启动自动加载(双节点执行)#chkconfig ntpd on 关闭虚拟机:添加磁盘控制器;创建共享磁盘修改共享磁盘属性为可共享:调整RAC2的控制器:修改其他两个节点的网络配置和主机名配置oracle、grid用户的ssh对等性Oracle用户ssh对等性配置Oracle对等性配置Rac1节点[root@rac1 ~]# su - oraclerac1-> clearrac1-> mkdir ~/.sshrac1-> chmod 755 ~/.ssh/rac1-> ssh-keygen -t rsaGenerating 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:26:c6:8a:60:1b:78:c3:6d:09:b0:c0:f3:a3:e5:ff:ce oracle@rac1 The key's randomart image is:+--[ RSA 2048]----+|+ ||.= ||. + ||.. * o ||ooB = + S ||.+o= o o || .. o || .. || oE |+-----------------+rac1-> ssh-keygen -t dsaGenerating public/private dsa key pair.Enter file in which to save the key (/home/oracle/.ssh/id_dsa): Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/oracle/.ssh/id_dsa. Your public key has been saved in /home/oracle/.ssh/id_dsa.pub. The key fingerprint is:d0:05:5d:0c:5b:72:42:87:f8:e8:04:66:e4:b5:bd:8c oracle@rac1 The key's randomart image is:+--[ DSA 1024]----+| .. o=*== || .+o.+oB. || oo.ooo || .oo.. || oE o || . || || || |+-----------------+rac1-> cat ~/.ssh/id_rsa.pub >> .ssh/authorized_keysrac1-> cat ~/.ssh/id_dsa.pub >> .ssh/authorized_keysrac1-> ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysoracle@rac2's password:rac1-> ssh rac2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysoracle@rac2's password:rac1-> scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keysoracle@rac2's password:authorized_keys 100% 1992 2.0KB/s 00:00rac1-> ssh rac3 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysoracle@rac3's password:rac1-> ssh rac3 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysoracle@rac2's password:rac1-> scp ~/.ssh/authorized_keys rac3:~/.ssh/authorized_keysoracle@rac3's password:authorized_keys 100% 1992 2.0KB/s 00:00Rac2节点[root@rac2 ~]# su - oraclerac2-> mkdir ~/.sshrac2-> chmod 755 .ssh/rac2-> ssh-keygen -t rsaGenerating 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:92:05:4d:35:d2:c9:da:21:b4:06:43:bb:ef:4c:6e:45 oracle@rac2The key's randomart image is:+--[ RSA 2048]----+| .=+++o. || =oo=. || . ++ . || =. E || + S. || o . || o. || =. || .+ |+-----------------+rac2-> ssh-keygen -t dsaGenerating public/private dsa key pair.Enter file in which to save the key (/home/oracle/.ssh/id_dsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/oracle/.ssh/id_dsa.Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.The key fingerprint is:99:00:7e:00:b1:a9:d8:45:68:03:4c:ce:ce:ef:30:0d oracle@rac2The key's randomart image is:+--[ DSA 1024]----+|+oo++ ||o.+= o || +o.o o ||+o . . . o ||oE. S || + || o o || + || . |+-----------------+rac2-> cat ~/.ssh/id_rsa.pub >> .ssh/authorized_keysrac2-> cat ~/.ssh/id_dsa.pub >> .ssh/authorized_keysrac2-> ssh rac1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysThe authenticity of host 'rac1 (192.168.37.21)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1,192.168.37.21' (RSA) to the list of known hosts.rac2-> ssh rac1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysrac2-> scp ~/.ssh/authorized_keys rac1:~/.ssh/authorized_keysauthorized_keys 100% 2988 2.9KB/s 00:00rac1-> ssh rac3 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysoracle@rac3's password:rac1-> ssh rac3 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysoracle@rac2's password:rac1-> scp ~/.ssh/authorized_keys rac3:~/.ssh/authorized_keysoracle@rac3's password:authorized_keys 100% 1992 2.0KB/s 00:00Rac3节点[root@rac2 ~]# su - oraclerac2-> mkdir ~/.sshrac2-> chmod 755 .ssh/rac2-> ssh-keygen -t rsaGenerating 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:92:05:4d:35:d2:c9:da:21:b4:06:43:bb:ef:4c:6e:45 oracle@rac2The key's randomart image is:+--[ RSA 2048]----+| .=+++o. || =oo=. || . ++ . || =. E || + S. || o . || o. || =. || .+ |+-----------------+rac2-> ssh-keygen -t dsaGenerating public/private dsa key pair.Enter file in which to save the key (/home/oracle/.ssh/id_dsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/oracle/.ssh/id_dsa.Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.The key fingerprint is:99:00:7e:00:b1:a9:d8:45:68:03:4c:ce:ce:ef:30:0d oracle@rac2The key's randomart image is:+--[ DSA 1024]----+|+oo++ ||o.+= o || +o.o o ||+o . . . o ||oE. S || + || o o || + || . |+-----------------+rac2-> cat ~/.ssh/id_rsa.pub >> .ssh/authorized_keysrac2-> cat ~/.ssh/id_dsa.pub >> .ssh/authorized_keysrac2-> ssh rac1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysThe authenticity of host 'rac1 (192.168.37.21)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1,192.168.37.21' (RSA) to the list of known hosts.rac2-> ssh rac1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysrac2-> scp ~/.ssh/authorized_keys rac1:~/.ssh/authorized_keysauthorized_keys 100% 2988 2.9KB/s 00:00rac1-> ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysoracle@rac2's password:rac1-> ssh rac2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysoracle@rac2's password:rac1-> scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keysoracle@rac3's password:authorized_keys 100% 1992 2.0KB/s 00:00 Oracle用户对等性检测Rac1节点rac1-> ssh rac2 dateTue Jun 17 12:35:32 CST 2014rac1-> ssh rac3 dateTue Jun 17 12:35:32 CST 2014rac1-> ssh rac1 dateThe authenticity of host 'rac1 (192.168.37.21)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1,192.168.37.21' (RSA) to the list of known hosts. Tue Jun 17 12:35:39 CST 2014rac1-> ssh rac1 dateTue Jun 17 12:35:42 CST 2014rac1-> ssh rac1-priv dateThe authenticity of host 'rac1-priv (172.16.1.1)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1-priv,172.16.1.1' (RSA) to the list of known hosts. Tue Jun 17 12:42:40 CST 2014rac1-> ssh rac1-priv dateTue Jun 17 12:42:43 CST 2014rac1-> ssh rac2-priv dateThe authenticity of host 'rac2-priv (172.16.1.2)' can't be established.RSA key fingerprint is c3:1c:e5:62:f2:35:87:4b:51:55:40:41:29:c7:bb:b1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac2-priv,172.16.1.2' (RSA) to the list of known hosts. Tue Jun 17 12:42:48 CST 2014rac1-> ssh rac2-priv dateTue Jun 17 12:42:50 CST 2014rac1-> ssh rac3-priv dateThe authenticity of host 'rac2-priv (172.16.1.2)' can't be established.RSA key fingerprint is c3:1c:e5:62:f2:35:87:4b:51:55:40:41:29:c7:bb:b1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac2-priv,172.16.1.2' (RSA) to the list of known hosts. Tue Jun 17 12:42:48 CST 2014rac1-> ssh rac3-priv dateTue Jun 17 12:42:50 CST 2014成功!!!Rac2节点rac2-> ssh rac1 dateTue Jun 17 12:43:06 CST 2014rac2-> ssh rac2 dateThe authenticity of host 'rac2 (192.168.37.22)' can't be established.RSA key fingerprint is c3:1c:e5:62:f2:35:87:4b:51:55:40:41:29:c7:bb:b1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac2,192.168.37.22' (RSA) to the list of known hosts. Tue Jun 17 12:43:11 CST 2014rac2-> ssh rac2 dateTue Jun 17 12:43:14 CST 2014rac2-> ssh rac3 dateThe authenticity of host 'rac2 (192.168.37.22)' can't be established.RSA key fingerprint is c3:1c:e5:62:f2:35:87:4b:51:55:40:41:29:c7:bb:b1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac2,192.168.37.22' (RSA) to the list of known hosts. Tue Jun 17 12:43:11 CST 2014rac2-> ssh rac3 dateTue Jun 17 12:43:14 CST 2014rac2-> ssh rac1-priv dateThe authenticity of host 'rac1-priv (172.16.1.1)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1-priv,172.16.1.1' (RSA) to the list of known hosts. Tue Jun 17 12:43:22 CST 2014rac2-> ssh rac1-priv dateTue Jun 17 12:43:24 CST 2014rac2-> ssh rac3-priv dateThe authenticity of host 'rac1-priv (172.16.1.1)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1-priv,172.16.1.1' (RSA) to the list of known hosts. Tue Jun 17 12:43:22 CST 2014rac2-> ssh rac3-priv dateTue Jun 17 12:43:24 CST 2014rac2-> ssh rac2-priv dateThe authenticity of host 'rac2-priv (172.16.1.2)' can't be established.RSA key fingerprint is c3:1c:e5:62:f2:35:87:4b:51:55:40:41:29:c7:bb:b1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac2-priv,172.16.1.2' (RSA) to the list of known hosts. Tue Jun 17 12:43:28 CST 2014rac2-> ssh rac2-priv dateTue Jun 17 12:43:31 CST 2014成功!!!Rac3节点rac2-> ssh rac1 dateTue Jun 17 12:43:06 CST 2014rac2-> ssh rac2 dateTue Jun 17 12:43:14 CST 2014rac2-> ssh rac3 dateThe authenticity of host 'rac2 (192.168.37.22)' can't be established.RSA key fingerprint is c3:1c:e5:62:f2:35:87:4b:51:55:40:41:29:c7:bb:b1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac2,192.168.37.22' (RSA) to the list of known hosts. Tue Jun 17 12:43:11 CST 2014rac2-> ssh rac3 dateTue Jun 17 12:43:14 CST 2014rac2-> ssh rac1-priv dateThe authenticity of host 'rac1-priv (172.16.1.1)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1-priv,172.16.1.1' (RSA) to the list of known hosts. Tue Jun 17 12:43:22 CST 2014rac2-> ssh rac1-priv dateTue Jun 17 12:43:24 CST 2014rac2-> ssh rac2-priv dateThe authenticity of host 'rac1-priv (172.16.1.1)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1-priv,172.16.1.1' (RSA) to the list of known hosts. Tue Jun 17 12:43:22 CST 2014rac2-> ssh rac2-priv dateTue Jun 17 12:43:24 CST 2014rac2-> ssh rac3-priv dateThe authenticity of host 'rac2-priv (172.16.1.2)' can't be established.RSA key fingerprint is c3:1c:e5:62:f2:35:87:4b:51:55:40:41:29:c7:bb:b1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac2-priv,172.16.1.2' (RSA) to the list of known hosts. Tue Jun 17 12:43:28 CST 2014rac2-> ssh rac3-priv dateTue Jun 17 12:43:31 CST 2014成功!!!Grid用户ssh对等性配置Grid用户对等性配置Rac1节点[root@rac1 ~]# su - gridrac1-> mkdir ~/.sshrac1-> chmod 755 ~/.ssh/rac1-> ssh-keygen -t rsaGenerating public/private rsa key pair.Enter file in which to save the key (/home/grid/.ssh/id_rsa): Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/grid/.ssh/id_rsa.Your public key has been saved in /home/grid/.ssh/id_rsa.pub.The key fingerprint is:99:cd:f4:44:a9:f1:23:16:40:d6:a9:b7:99:a0:e7:76 grid@rac1The key's randomart image is:+--[ RSA 2048]----+| .+o ... || . =.. || ..=. || o*=oo || .S+o=.. || . . + || o || o E || . . |+-----------------+rac1-> ssh-keygen -t dsaGenerating public/private dsa key pair.Enter file in which to save the key (/home/grid/.ssh/id_dsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/grid/.ssh/id_dsa.Your public key has been saved in /home/grid/.ssh/id_dsa.pub.The key fingerprint is:03:60:03:14:2e:c1:77:ee:d2:55:46:00:4b:ac:bb:68 grid@rac1The key's randomart image is:+--[ DSA 1024]----+|o.+o=o..o. || + o.=. o ||. o +.. o || . . . o || + . S || o o . || . o || E . ||. |+-----------------+rac1-> cat ~/.ssh/id_rsa.pub >> .ssh/authorized_keysrac1-> cat ~/.ssh/id_dsa.pub >> .ssh/authorized_keysrac1-> ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysThe authenticity of host 'rac2 (192.168.37.22)' can't be established.RSA key fingerprint is c3:1c:e5:62:f2:35:87:4b:51:55:40:41:29:c7:bb:b1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac2,192.168.37.22' (RSA) to the list of known hosts.grid@rac2's password:rac1-> ssh rac2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysgrid@rac2's password:rac1-> scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keysgrid@rac2's password:authorized_keys 100% 1984 1.9KB/s 00:00rac1-> ssh rac3 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysThe authenticity of host 'rac2 (192.168.37.22)' can't be established.RSA key fingerprint is c3:1c:e5:62:f2:35:87:4b:51:55:40:41:29:c7:bb:b1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac2,192.168.37.22' (RSA) to the list of known hosts.grid@rac2's password:rac1-> ssh rac3 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysgrid@rac2's password:rac1-> scp ~/.ssh/authorized_keys rac3:~/.ssh/authorized_keysgrid@rac2's password:authorized_keys 100% 1984 1.9KB/s 00:00 Rac2节点[root@rac2 ~]# su - gridrac2-> mkdir ~/.sshrac2-> chmod 755 ~/.ssh/rac2-> ssh-keygen -t rsaGenerating public/private rsa key pair.Enter file in which to save the key (/home/grid/.ssh/id_rsa): Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/grid/.ssh/id_rsa.Your public key has been saved in /home/grid/.ssh/id_rsa.pub.The key fingerprint is:ae:87:bc:30:60:98:98:d4:36:bb:60:d6:dd:df:3d:54 grid@rac2The key's randomart image is:+--[ RSA 2048]----+| || . || . + E ||o+o + . . ||=+oo . .S . ||o.... .. . o || .o. ... . o || oo.. . || oo |+-----------------+rac2-> ssh-keygen -t dsaGenerating public/private dsa key pair.Enter file in which to save the key (/home/grid/.ssh/id_dsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/grid/.ssh/id_dsa.Your public key has been saved in /home/grid/.ssh/id_dsa.pub.The key fingerprint is:63:49:2d:9b:55:54:8a:52:d8:5e:4a:c0:fc:ff:ff:91 grid@rac2The key's randomart image is:+--[ DSA 1024]----+| o.+..o.. || +ooo.. || +++o. || . B+ || S . || . . . .|| . E || . .|| .+|+-----------------+rac2-> cat ~/.ssh/id_rsa.pub >> .ssh/authorized_keysrac2-> cat ~/.ssh/id_dsa.pub >> .ssh/authorized_keysrac2-> ssh rac1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysThe authenticity of host 'rac1 (192.168.37.21)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1,192.168.37.21' (RSA) to the list of known hosts.rac2-> ssh rac1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysrac2-> scp ~/.ssh/authorized_keys rac1:~/.ssh/authorized_keysauthorized_keys 100% 2976 2.9KB/s 00:00rac2-> ssh rac3 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysThe authenticity of host 'rac1 (192.168.37.21)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1,192.168.37.21' (RSA) to the list of known hosts.rac2-> ssh rac3 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysrac2-> scp ~/.ssh/authorized_keys rac3:~/.ssh/authorized_keysauthorized_keys 100% 2976 2.9KB/s 00:00Rac3节点[root@rac2 ~]# su - gridrac2-> mkdir ~/.sshrac2-> chmod 755 ~/.ssh/rac2-> ssh-keygen -t rsaGenerating public/private rsa key pair.Enter file in which to save the key (/home/grid/.ssh/id_rsa): Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/grid/.ssh/id_rsa.Your public key has been saved in /home/grid/.ssh/id_rsa.pub.The key fingerprint is:ae:87:bc:30:60:98:98:d4:36:bb:60:d6:dd:df:3d:54 grid@rac2The key's randomart image is:+--[ RSA 2048]----+| || . || . + E ||o+o + . . ||=+oo . .S . ||o.... .. . o || .o. ... . o || oo.. . || oo |+-----------------+rac2-> ssh-keygen -t dsaGenerating public/private dsa key pair.Enter file in which to save the key (/home/grid/.ssh/id_dsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /home/grid/.ssh/id_dsa.Your public key has been saved in /home/grid/.ssh/id_dsa.pub.The key fingerprint is:63:49:2d:9b:55:54:8a:52:d8:5e:4a:c0:fc:ff:ff:91 grid@rac2The key's randomart image is:+--[ DSA 1024]----+| o.+..o.. || +ooo.. || +++o. || . B+ || S . || . . . .|| . E || . .|| .+|+-----------------+rac2-> cat ~/.ssh/id_rsa.pub >> .ssh/authorized_keysrac2-> cat ~/.ssh/id_dsa.pub >> .ssh/authorized_keysrac2-> ssh rac1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysThe authenticity of host 'rac1 (192.168.37.21)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1,192.168.37.21' (RSA) to the list of known hosts.rac2-> ssh rac1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysrac2-> scp ~/.ssh/authorized_keys rac1:~/.ssh/authorized_keysauthorized_keys 100% 2976 2.9KB/s 00:00rac2-> ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keysThe authenticity of host 'rac1 (192.168.37.21)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1,192.168.37.21' (RSA) to the list of known hosts.rac2-> ssh rac2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keysrac2-> scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keysauthorized_keys 100% 2976 2.9KB/s 00:00Oracle用户对等性检测Rac1节点rac1-> iduid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper)context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023rac1-> ssh rac1 dateThe authenticity of host 'rac1 (192.168.37.21)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1,192.168.37.21' (RSA) to the list of known hosts.Tue Jun 17 13:10:05 CST 2014rac1-> ssh rac1 dateTue Jun 17 13:10:08 CST 2014rac1-> ssh rac2 dateTue Jun 17 13:10:12 CST 2014rac1-> ssh rac3 dateTue Jun 17 13:10:12 CST 2014rac1-> ssh rac1-priv dateThe authenticity of host 'rac1-priv (172.16.1.1)' can't be established.RSA key fingerprint is 53:b8:a1:de:30:e3:d4:80:17:d3:7f:f5:b2:9d:11:45.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1-priv,172.16.1.1' (RSA) to the list of known hosts.Tue Jun 17 13:10:36 CST 2014rac1-> ssh rac1-priv dateTue Jun 17 13:10:37 CST 2014rac1-> ssh rac2-priv dateThe authenticity of host 'rac2-priv (172.16.1.2)' can't be established.RSA key fingerprint is c3:1c:e5:62:f2:35:87:4b:51:55:40:41:29:c7:bb:b1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac2-priv,172.16.1.2' (RSA) to the list of known hosts.Tue Jun 17 13:10:42 CST 2014rac1-> ssh rac2-priv dateTue Jun 17 13:10:45 CST 2014rac1-> ssh rac3-priv dateThe authenticity of host 'rac2-priv (172.16.1.2)' can't be established.。