- 博客(810)
- 资源 (11)
- 收藏
- 关注
真机调试iOS13.0、iOS13.1.zip
如何导入调试包
打开 Finder
按下: Command⌘+Shift⇧+G
输入:
/Applications/Xcode.app/Contents/Developer/Platforms/iPhoneOS.platform/DeviceSupport
把文件解压到这个文件夹下,重新启动 Xcode,连上真机运行,Xcode 会开始下载调试组件(2-3G),下载完成之后就能在真机上运行了~
2019-10-10
iOS 11 真机运行镜像
不需要升级xcode 安装镜像文件 运行iOS11不需要升级xcode 安装镜像文件 运行iOS11不需要升级xcode 安装镜像文件 运行iOS11不需要升级xcode 安装镜像文件 运行iOS11不需要升级xcode 安装镜像文件 运行iOS11不需要升级xcode 安装镜像文件 运行iOS11不需要升级xcode 安装镜像文件 运行iOS11
2017-09-21
iOS自定义键盘
iOS自定义键盘 如果项目中有特定的输入需求,例如 银行类、金融类、交易类App,对输入的安全性要求较高 因此需要通过自定义键盘进行操作,可以提高用户的安全性。
2016-11-24
sql server 集群配置
分类: SQL Server
Windows server2003 + sql server2005 集群配置安装
一:环境
软硬件环境
虚拟3台windows server 2003主机。其中一台做域控DC,另外两台作为节点win1 win2.
域控DC网络设置:
Hostname
Private网卡
Public网卡
adtest
192.168.9.176
节点主机网络设置
Hostname
Private网卡
Public网卡
Win1
10.0.0.173
192.168.9.173
Win2
10.0.0.174
192.168.9.174
二:建域test.com
在域控主机192.168.9.176上安装域
1 设置DC的ip 192.168.9.176
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739037lWe2.png" \* MERGEFORMATINET
2 在DC中使用DCPROMO命令创建域 (后面的步骤中需要更新windows组件,必须先挂载安装盘)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077391708Ti6.jpg" \* MERGEFORMATINET
3 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739247Oq09.jpg" \* MERGEFORMATINET
4 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739274XN5X.jpg" \* MERGEFORMATINET
5 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077393012nbo.png" \* MERGEFORMATINET
6 选择新林中的域
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739354rKwn.png" \* MERGEFORMATINET
7 填入所要创建域的完整的域名
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739377CMKf.png" \* MERGEFORMATINET
8 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739509vRI0.png" \* MERGEFORMATINET
9 选择AD数据库和日志文件的存放位置
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739565AxuX.png" \* MERGEFORMATINET
10 存放SYSVOL的存放位置(注意:一定要放在NTFS的分区中)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739603KBsU.png" \* MERGEFORMATINET
11 注意:AD是离不开DNS服务的,因为客户机加入域和登录域都需要把域名解析为IP地址,因为此时DC没有DNS服务器,所以选择第二项让系统在创建DC的同时把DNS服务随之一起安装上.当然你也可以安装DC后自己手动再安装和配置DNS服务器(当时是您给会正确配置DNS服务器),建议和DC一起让系统帮我们创建,因为省事
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739851kpky.png" \* MERGEFORMATINET
12 选择兼容的模式,为了以后可以方便windows2000和2003兼容
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407739883TU02.jpg" \* MERGEFORMATINET
13 设置AD的还原密码(为了以后对AD数据库做完备份,开机按F8进入AD还原模式需要的还原密码,如果在此设置了密码,一定切记):
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077399565Eoz.jpg" \* MERGEFORMATINET
14 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407740932ypMd.jpg" \* MERGEFORMATINET
15 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407741371FFnB.jpg" \* MERGEFORMATINET
16 需要挂载有关盘,才会自动安装DNS
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407741434D07d.jpg" \* MERGEFORMATINET
17 完成
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077425689rnx.jpg" \* MERGEFORMATINET
18 重启
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742596D44S.jpg" \* MERGEFORMATINET
19 安装完重起系统后登录界面为使用域中的管理员和密码登录到域
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077426257kHs.png" \* MERGEFORMATINET
20 进入系统后查看计算机的状态
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742652R7uD.png" \* MERGEFORMATINET
21查看管理工具会增加DNS和有关AD的工具,以及安全策略
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742694MvtT.png" \* MERGEFORMATINET
22 点开用户和计算机域控管理界面 (创建域test.com完成)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742729f3b0.png" \* MERGEFORMATINET
三:配置节点win1 和 节点win2的网络,并添加到域中
1 网络配置
win1 网络配置
网卡1:
DNS需要配置DC的IP
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742769IgEN.jpg" \* MERGEFORMATINET
网卡2
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742840A6l3.jpg" \* MERGEFORMATINET
“高级”里面配置一下禁用NetBIOS 不勾选前面两项
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407742943Fy03.jpg" \* MERGEFORMATINET
Win2网络设置
网卡1:
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743537GJ7l.jpg" \* MERGEFORMATINET
网卡2
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077435693D38.png" \* MERGEFORMATINET
Win1 win2 进行相同的操作
2 更改计算机名,以及加入域test.com
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743633bYBe.png" \* MERGEFORMATINET
3 属于域控制账号密码
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743676gbuo.jpg" \* MERGEFORMATINET
4 完成后重启
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743709vOFZ.jpg" \* MERGEFORMATINET
5 域登录
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743759G5G5.png" \* MERGEFORMATINET
6 加入域后的计算机属性
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743787p33j.png" \* MERGEFORMATINET
Win2 也是一样的步骤加入到域中
6 在域控主机192.168.9.176中可以看到新添加的成员
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743817WsaU.png" \* MERGEFORMATINET
在步骤五中可能会提示报错指定域的名称或安全标识(SID)与该域的信任信息不一致 (因为指定域的名称或安全标识(SID)与该域的信任信息不一致)需要修改
修改方法:
1 .从安装盘中 support\tools\deploy.cab中提取sysprep.exe和setuppcl.exe 到桌面
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743850SDwD.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743871Py6C.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407743888vP01.png" \* MERGEFORMATINET
2 运行sysprep.exe"确定"开始重新封装
往下就是下一步下一步安装即可 (不能远程操作,封装一次即可,不作详述了)
四:安装win server2003集群
Win1节点上进行操作,关闭其他节点
1 依次单击“开始”、“所有程序”和“管理工具”,然后单击“群集管理器”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077439293FFp.png" \* MERGEFORMATINET
2 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077440578D3X.png" \* MERGEFORMATINET
3 选择域(test.com),键入群集名win2003cluster。下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744070JRQx.png" \* MERGEFORMATINET
4 机器名输入 win1。下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744154ehw0.png" \* MERGEFORMATINET
5 这一步是检测硬件环境是否符合群集要求。如果这一步出现错误提示,可以点击“查看日志”,按照提示检查网络设置和磁盘阵列连接是否正确
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744230SSkp.gif" \* MERGEFORMATINET
1 通过下一步,输入集群的IP地址,操作系统虚拟服务器的IP 地址
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744249x6HR.gif" \* MERGEFORMATINET
6 输入域用户名和密码,这里使用的是域管理员administrator
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744263857b.gif" \* MERGEFORMATINET
说明:在项目实施时一定不能用域的管理员administrator。应该要求用户网络管理员提供一个专门管理
群集的新用户。这个新用户在各个群集节点中应该在本地管理员组(local administrator group)中。
7 点击“仲裁”按钮,在弹出的窗口中选择仲裁资源。我们选择磁盘Q(QDisk)作为仲裁盘
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744272ks9Q.gif" \* MERGEFORMATINET
8
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744294mA7n.gif" \* MERGEFORMATINET
9 完成
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744319FJ6n.gif" \* MERGEFORMATINET
10 群集 win2003cluster 已经配置成功。但是目前只有win1,我们需要将第二个节点加入,构建出容灾群集。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744358n8K5.gif" \* MERGEFORMATINET
11 新建节点
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744371gd4L.gif" \* MERGEFORMATINET
12 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744385peeG.gif" \* MERGEFORMATINET
13 输入“win2”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744396zcBj.png" \* MERGEFORMATINET
14 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744468rsZ5.gif" \* MERGEFORMATINET
15 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744481R038.gif" \* MERGEFORMATINET
16 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744502HRQ7.gif" \* MERGEFORMATINET
17 下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744520a8xd.gif" \* MERGEFORMATINET
Win2上的共享磁盘QDisk 和ClusterData 已经被win1 所独占。这个警告不用理会
18 下一步,完成win2节点添加
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744536ppLl.gif" \* MERGEFORMATINET
19 操作系统容灾群集已经安装完毕。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744552ya8d.gif" \* MERGEFORMATINET
20 配置群集网络通信 右键选择群集“属性”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744587KWB4.gif" \* MERGEFORMATINET
21 本地连接2 -à属性
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744602x808.png" \* MERGEFORMATINET
22 专门用于群集节点内部通讯使用的
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077446226FNs.png" \* MERGEFORMATINET
23确保private 在public 上面(private 优先级更高)。确定完成网络设置。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744651WcyM.jpg" \* MERGEFORMATINET
24 测试操作系统群集
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744660XhOo.gif" \* MERGEFORMATINET
25 点击移动组可以相互切换资源
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744686wgRC.png" \* MERGEFORMATINET
26为了测试群集的可用性,在win1 上右键选择“停止群集服务”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744699WCOe.png" \* MERGEFORMATINET
27 Win2 接管了资源,成为目前群集的工作节点
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744712kFdi.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744730Lazx.png" \* MERGEFORMATINET
28 重新启动win1
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744745g883.jpg" \* MERGEFORMATINET
Windowns server2003集群完成配置
五 :配置SQL Server 2005 群集
1说明:如果群集环境不需要安装报表服务(SQL Server Reporting Services),可以忽略此步骤。
安装IIS
2 打开组件服务---计算机---我的电脑---属性—安全配置,选择administrator 用户登陆,输入administrator
的密码。
这一步是必须的,否则在安装SQL server 2005 的时候会出现COM+错误。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077447844cHJ.gif" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077447977j94.gif" \* MERGEFORMATINET
3 配置MSDTC 到资源组中
进入 CMD 运行
net stop msdtc
msdtc –uninstall
msdtc –install
net start msdtc
此操作之后在群集组直接出现 MSDTC 资源
如果出现msdtc无法正常使用,也可以用此方法重新配置
一般性增加MSDTC资源方法:
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_140774481409IC.png" \* MERGEFORMATINET
“资源类型”选择“分布式事务协调器(DTC)”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077448256dP6.gif" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744854jfNM.gif" \* MERGEFORMATINET
选择仲裁盘和群集名作为其依存资源。完成
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744867nQMJ.gif" \* MERGEFORMATINET
确定,完成MSDTC 配置。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744885M46X.gif" \* MERGEFORMATINET
4 注意,在安装SQL server 2005 前, 如果主机是多核心的处理器,请修改boot.ini 文件,把CPU 核心数
改为1
.可以在msconfig 选项中直接选择修改 ,这个是2005 本身的bug,等完成安装后打SP3 或更高的补丁。
补丁打完之后可修改回正常核心数量
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744896HzT9.gif" \* MERGEFORMATINET
5安装SQL Server 2005
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744939QYbK.png" \* MERGEFORMATINET
下一步
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077449503Df3.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744968I81t.png" \* MERGEFORMATINET
下一步(步骤2处理不好,会出现com+错误)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077449795J34.png" \* MERGEFORMATINET
开始安装必备组件
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407744989AIgW.png" \* MERGEFORMATINET
系统配置检查
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745003rYzQ.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077450180cuh.gif" \* MERGEFORMATINET
输入注册信息
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745031baoA.png" \* MERGEFORMATINET
选择要安装的组件
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745057vz41.png" \* MERGEFORMATINET
(所提供光盘只有SQL Server Database Services组件)
输入实例名:MSSQL2005
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745072podT.png" \* MERGEFORMATINET
输入虚拟服务器的名称:SH-sqldbc
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745107ArP0.png" \* MERGEFORMATINET
输入虚拟服务器名称,下一步(区别于集群虚拟服务器IP)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745121U1uU.gif" \* MERGEFORMATINET
为虚拟服务器指定IP 地址,点击“添加”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745126XcS5.gif" \* MERGEFORMATINET
为数据文件指定安装路径,请注意这里的S 盘是数据存储盘(ClusterData),千万不要把数据文件安装到仲裁盘(QDisk)上。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745139mnRW.gif" \* MERGEFORMATINET
可以在集群管理器上分一下组
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745149zX6d.gif" \* MERGEFORMATINET
该用户其实应该是cluster,如果用administrator,会造成不能在远程计算机安装(后面述修改方法,也可以之前在域中建好用户)
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745155lTGS.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745190BL3x.gif" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077451973Bma.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745210d8k8.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077452234KZ9.png" \* MERGEFORMATINET
选择混合模式验证
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745234SblE.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745246Aqpq.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745262pPPB.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745273LV55.png" \* MERGEFORMATINET
开始安装
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745288YFsc.png" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745350t0Wp.png" \* MERGEFORMATINET
安装程序。
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745365spAH.png" \* MERGEFORMATINET
完成后在另一个节点安装。
六:解决远程不能安装问题,创建swg域用户,委托管理
1 打开域控制管理
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_14077453825h6y.png" \* MERGEFORMATINET
2 新建用户
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745628BIXb.png" \* MERGEFORMATINET
3 添加到组
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745724heZa.png" \* MERGEFORMATINET
4 添加到administrator组中
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745737U5xo.png" \* MERGEFORMATINET
5 查看属性
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745745VMv1.jpg" \* MERGEFORMATINET
6 win1 win2 节点上加用户权限
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745754s7Nj.jpg" \* MERGEFORMATINET
7 添加到swg组
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745762t1Z5.jpg" \* MERGEFORMATINET
8 最后全部用swg用户等test.com域上的主机win1,win2
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745778Klvg.jpg" \* MERGEFORMATINET
七:安装完成后测试
1 win1上查看增加的资源
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745798o54e.jpg" \* MERGEFORMATINET
2 停止其中win1节点,服务自动转移
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745807BB77.jpg" \* MERGEFORMATINET
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745813HCSC.jpg" \* MERGEFORMATINET
八:访问数据库,导入数据
1 右键“数据库” “附加”
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745821o56o.jpg" \* MERGEFORMATINET
2 导入整个数据库
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745830HtaT.jpg" \* MERGEFORMATINET
3 导入完成后,显示数据
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745846B7dG.jpg" \* MERGEFORMATINET
4 做故障转移时,数据库可以正常被访问
INCLUDEPICTURE \d "http://blog.itpub.net/attachment/201408/11/29500582_1407745935DEw2.jpg" \* MERGEFORMATINET
2015-07-13
oracle 11g安装配置
软件环境的一般要求
RHEL 5.x系统、RHEL 6.x系统
图形桌面环境 + 开发工具 + 中文Java支持
—— 在RHEL 6.x中安装时,ksh需改用5.x的软件包
准备工作:
yum install yum*
yum groupinstall “X 窗口系统” “桌面” “桌面平台” “中文支持” “开发工具”
[root@dbserver ~]# yum -y install java-*
[root@dbserver ~]# cd /usr/lib/jvm/jre-1.6.0/lib
[root@dbserver lib]# mv fontconfig.bfc fontconfig.bfc.origin
[root@dbserver lib]# cp fontconfig.RedHat.6.bfc fontconfig.bfc
[root@dbserver ~]# rpm -e ksh 因为默认没有装
[root@dbserver ~]# rpm -ivh .../ksh-5.2.14-36.el5.i386.rpm
用户环境要求
创建组账号oinstall、dba,用户账号oracle
创建Oracle基本目录
为用户oracle设置环境变量,并允许使用X终端
[root@dbserver ~]# groupadd oinstall //安装组
[root@dbserver ~]# groupadd dba //管理组
[root@dbserver ~]# useradd -g oinstall -G dba oracle
[root@dbserver ~]# passwd oracle
[root@dbserver ~]# mkdir /opt/oracle
[root@dbserver ~]# chown -R oracle:oinstall /opt/oracle/
[root@dbserver ~]# chmod -R 775 /opt/oracle/
[root@dbserver ~]# vi /home/oralce/.bash_profile
……
umask 022
export ORACLE_BASE=/opt/oracle
export ORACLE_SID=orcl
export DISPLAY=:0.0
export LANG=zh_CN.UTF-8
export ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_2
[root@dbserver ~]# xhost + //须在图形环境执行
access control disabled, clients can connect from any host
内核及会话要求
修改内存调度参数、端口范围、I/O请求……
增大用户oracle的进程数、文件数限制
[root@dbserver ~]# vi /etc/sysctl.conf
……
fs.aio-max-nr = 1048576 限制并发未完成的请求,应该设置避免I/O子系统故障
fs.file-max = 6815744 文件句柄设置代表linux系统中可以打开的文件的数量。
kernel.shmmni = 4096 共享内存的总页数
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
[root@dbserver ~]# sysctl –p
kernel.sem:
以kernel.sem = 250 32000 100 128为例:
250是参数semmsl的值,表示一个信号量集合中能够包含的信号量最大数目。
32000是参数semmns的值,表示系统内可允许的信号量最大数目。
100是参数semopm的值,表示单个semopm()调用在一个信号量集合上可以执行的操作数量。
128是参数semmni的值,表示系统信号量集合总数
net.core.rmem_default:
表示套接字接收缓冲区大小的缺省值。
net.core.rmem_max:
表示套接字接收缓冲区大小的最大值。
net.core.wmem_default:
表示套接字发送缓冲区大小的缺省值。
net.core.wmem_max:
表示套接字发送缓冲区大小的最大值
[root@dbserver ~]# vi /etc/pam.d/login
……
session required pam_limits.so
[root@dbserver ~]# vi /etc/security/limits.conf
……
oracle soft nproc 8192
oracle hard nproc 16384
oracle soft nofile 32768
oracle hard nofile 65536
运行runInstaller安装程序
将下载的两个zip包解压到同一位置
进入database目录,由用户oracle执行安装
通过 -jreLoc 参数指定中文Java环境的路径
[root@dbserver ~]# su - oracle
[oracle@dbserver ~]$ cd /var/ftp/pub/database/
[oracle@dbserver database]$ ./runInstaller -jreLoc /usr/lib/jvm/jre-1.6.0
正在启动 Oracle Universal Installer...
检查临时空间: 必须大于 80 MB。 实际为 64829 MB 通过
检查交换空间: 必须大于 150 MB。 实际为 2047 MB 通过
检查监视器: 监视器配置至少必须显示 256 种颜色。 实际为 16777216 通过
准备从以下地址启动 Oracle Universal Installer /tmp/OraInstall2011-10-12_08-07-32PM. 请稍候...
SHAPE \* MERGEFORMAT
典型的安装设置
单实例数据库、企业版、管理口令
基本目录:/opt/oracle/
软件位置:/opt/oracle/product/11.2.0/dbhome_1/
数据库位置:/opt/oracle/oradata/
产品清单:/opt/oracle/oraInventory/
SHAPE \* MERGEFORMAT
SHAPE \* MERGEFORMAT
验证安装结果
从命令行使用sqlplus工具访问数据库
从浏览器访问 https://dbserver:1158/em/
用户名sys、管理口令、连接身份SYSDBA
[root@dbserver ~]# cd /opt/oracle/product/11.2.0/dbhome_1/bin/
[root@dbserver bin]# ./sqlplus sys AS SYSDBA
……
Enter password: //输入管理密码
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SHOW USER; //查看当前用户
USER is "SYS“
SQL> HELP INDEX; //查看指令列表
……
COMPUTE LIST SET XQUERY
CONNECT PASSWORD SHOW
SHAPE \* MERGEFORMAT
优化执行环境
全局配置/etc/profile,添加基目录、执行路径……
修改/etc/oratab,使orcl实例随数据库软件启动
[root@dbserver ~]# vi /etc/profile
……
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_OWNER=oracle
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
export PATH=\$PATH:\$ORACLE_HOME/bin
[root@dbserver ~]# vi /etc/oratab
orcl:/opt/oracle/product/11.2.0/dbhome_1:Y
Oracle的服务组件
监听器lsnrctl:提供数据库访问,默认端口1521
启动器dbstart、dushut:启动、停止数据库实例
控制器emctl:开启、关闭OEM平台,默认端口1158
[oracle@dbserver ~]$ lsnrctl status
[oracle@dbserver ~]$ emctl stop dbconsole
[oracle@dbserver ~]$ dbshut $ORACLE_HOME
[oracle@dbserver ~]$ dbstart $ORACLE_HOME
[oracle@dbserver ~]$ emctl stop dbconsole
使用系统服务脚本
编写/etc/init.d/oracle控制脚本
使用chkconfig工具添加为系统服务
使用service工具来启动、停止、重启oracle服务
SHAPE \* MERGEFORMAT
逻辑备份与恢复
配置Oracle备份目录
创建本地目录(如 /opt/mydbbackup),并调整属性
在SQL>环境中指定备份位置,并授权备份用户
[root@dbserver ~]# mkdir /opt/mydbbackup
[root@dbserver ~]# chown oracle:oinstall /opt/mydbbackup/
[root@dbserver ~]# sqlplus sys AS SYSDBA
Enter password:
SQL> CREATE DIRECTORY dmpdir AS '/opt/mydbbackup';
Directory created.
SQL> GRANT read,write ON DIRECTORY dmpdir TO sysman;
Grant succeeded.
SQL> GRANT all ON DIRECTORY dmpdir TO system;
Grant succeeded.
逻辑备份与恢复
执行逻辑备份
使用expdp工具导出数据库
[root@dbserver ~]# expdp lisi/123456 DIRECTORY=dmpdir
DUMPFILE=lisi-20111014.dmp #导出用户lisi的数据库
…….
[root@dbserver ~]# expdp system/123456 DIRECTORY=dmpdir
DUMPFILE=orcl-full-20111014.dmp FULL=Y #导出整个数据库
……
执行逻辑恢复
使用impdp工具导入数据库
[root@dbserver ~]# impdp lisi/123456 DIRECTORY=dmpdir
DUMPFILE=lisi-20111014.dmp REUSE_DATAFILES=Y
TABLE_EXISTS_ACTION=REPLACE #恢复用户lisi的数据库
[root@dbserver ~]# impdp system/123456 DIRECTORY=dmpdir
DUMPFILE=orcl-full-20111014.dmp REUSE_DATAFILES=Y
TABLE_EXISTS_ACTION=REPLACE FULL=Y #恢复整个数据库
注意:
glibc-32bit-8.1-9
glibc-devel-32bit-8.1-9
compat-libstdc++-33-3.2.3-47.3.x86_64.rpm
libaio-0.3.105-2.x86_64.rpm
2015-07-13
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人