- 浏览: 1088215 次
- 性别:
- 来自: 南京
博客专栏
-
Oracle管理和开发
浏览量:349937
最新评论
-
Simon.Ezer:
请问对于“如果非主键字段值发生改变,则不会同步过去”这种情况, ...
创建增量同步Oracle物化视图问题 -
dahai639:
挺好的,支持一下
Oracle的pipelined函数实现高性能大数据处理 -
zealotpz:
不错,原来是用户oracle 的所属组的问题
以sysdba身份登录oracle报ORA-1031权限不足错误之完美分析 -
mikixiyou:
zhangyuslam 写道如果担心全局索引失效,可以使用如下 ...
Oracle分区表的分区交互技术实现数据快速转移 -
sea0108:
...
Oracle sql loader使用速成
Oracle 11g grid infrastructure安装失败时,或者需要卸载时,不像10g的CRS组件卸载那么麻烦了。
以linux系统为例,10g手工删除CRS的操作步骤:
rm -f /etc/init.d/init.cssd
rm -f /etc/init.d/init.crs
rm -f /etc/init.d/init.crsd
rm -f /etc/init.d/init.evmd
rm -f /etc/rc2.d/K96init.crs
rm -f /etc/rc2.d/S96init.crs
rm -f /etc/rc3.d/K96init.crs
rm -f /etc/rc3.d/S96init.crs
rm -f /etc/rc5.d/K96init.crs
rm -f /etc/rc5.d/S96init.crs
rm -rf /etc/oracle/scls_scr
rm -f /etc/inittab.crs
cp /etc/inittab.orig /etc/inittab
在11g中,提供了一个卸载工具deinstall,如Linux系统下软件名称为linux.x64_11gR2_deinstall.zip。解压后可以直接使用。
第一步、使用grid用户登录操作系统,这个用户是grid infrastructure软件安装用户。
/home/grid/deinstall@serv2=>+ASM2$./deinstall
Location of logs /home/grid/deinstall/logs/
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
Usage:
deinstall -home <Complete path of Oracle home>
[ -silent ]
[ -checkonly ]
[ -local ]
[ -paramfile <complete path of input parameter property file> ]
[ -params <name1=value[ name2=value ...]> ]
[ -o <complete path of directory for saving files> ]
[ -help | -h: Type -h or -help to get more information on each o
f the above options. ]
Specify any of the above options.
############# ORACLE DEINSTALL & DECONFIG TOOL END #############
第二步,使用deinstall -home /u01/app/11.2.0/grid 卸载安装了的文件
/home/grid/deinstall@serv2=>+ASM2$./deinstall -home /u01/app/11.2.0/grid
ORACLE_HOME = /u01/app/11.2.0/grid
Location of logs /home/grid/deinstall/logs/
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################## CHECK OPERATION START ########################
Install check configuration START
Checking for existence of the Oracle home location /u01/app/11.2.0/grid
Oracle Home type selected for de-install is: CRS
Oracle Base selected for de-install is: /u01/app/grid
Checking for existence of central inventory location /u01/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /u01/app/11.2.0/gr
id
The following nodes are part of this cluster: serv1,serv2
Install check configuration END
Traces log file: /home/grid/deinstall/logs//crsdc.log
Enter an address or the name of the virtual IP used on node "serv1"[serv1-vip]
>
The following information can be collected by running ifconfig -a on node "serv1
"
Enter the IP netmask of Virtual IP "192.168.15.189" on node "serv1"[255.255.255.
0]
>
Enter the network interface name on which the virtual IP address "192.168.15.189
" is active
>
Enter an address or the name of the virtual IP used on node "serv2"[serv2-vip]
>
The following information can be collected by running ifconfig -a on node "serv2
"
Enter the IP netmask of Virtual IP "192.168.15.190" on node "serv2"[255.255.255.
0]
>
Enter the network interface name on which the virtual IP address "192.168.15.190
" is active
>
Enter an address or the name of the virtual IP[]
>
Network Configuration check config START
Network de-configuration trace file location: /home/grid/deinstall/logs/netdc_ch
eck59960.log
Network Configuration check config END
Asm Check Configuration START
ASM de-configuration trace file location: /home/grid/deinstall/logs/asmcadc_chec
k59961.log
ASM configuration was not detected in this Oracle home. Was ASM configured in th
is Oracle home (y|n) [n]: y
Specify the ASM Diagnostic Destination [ ]: /u01/app/11.2.0/grid
Specify the diskgroups that are managed by this ASM instance []: CRS
De-configuring ASM will drop all the diskgroups at cleanup time. Do you want dec
onfig tool to drop the diskgroups y|n [y]: y
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /u01/app/11.2.0/grid
The cluster node(s) on which the Oracle home exists are: (Please input nodes sep
erated by ",", eg: node1,node2,...)serv1,serv2
Oracle Home selected for de-install is: /u01/app/11.2.0/grid
Inventory Location where the Oracle home registered is: /u01/app/oraInventory
ASM instance will be de-configured from this Oracle home
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/home/grid/deinstall/logs/deinstall_d
econfig2012-04-24_10-21-03-AM.out'
Any error messages from this session will be written to: '/home/grid/deinstall/l
ogs/deinstall_deconfig2012-04-24_10-21-03-AM.err'
######################## CLEAN OPERATION START ########################
ASM de-configuration trace file location: /home/grid/deinstall/logs/asmcadc_clea
n59962.log
ASM Clean Configuration START
ASM Clean Configuration END
Network Configuration clean config START
Network de-configuration trace file location: /home/grid/deinstall/logs/netdc_cl
ean59963.log
De-configuring Naming Methods configuration file on all nodes...
Naming Methods configuration file de-configured successfully.
De-configuring Local Net Service Names configuration file on all nodes...
Local Net Service Names configuration file de-configured successfully.
De-configuring Directory Usage configuration file on all nodes...
Directory Usage configuration file de-configured successfully.
De-configuring backup files on all nodes...
Backup files de-configured successfully.
The network configuration has been cleaned up successfully.
Network Configuration clean config END
---------------------------------------->
Run the following command as the root user or the administrator on node "serv2".
/home/grid/deinstall/perl/bin/perl -I/home/grid/deinstall/perl/lib -I/home/grid/
deinstall/crs/install /home/grid/deinstall/crs/install/rootcrs.pl -force -delet
e -paramfile /home/grid/deinstall/response/deinstall_Ora11g_gridinfrahome1.rsp -
lastnode
Press Enter after you finish running the above commands
这个步骤中就是为了生成配置文件/home/grid/deinstall/response/deinstall_Ora11g_gridinfrahome1.rsp
第三步,使用root在节点上执行上一个步骤中生成的配置文件的perl脚本
/home/grid/deinstall/perl/bin/perl -I/home/grid/deinstall/perl/lib -I/home/grid/
deinstall/crs/install /home/grid/deinstall/crs/install/rootcrs.pl -force -delet
e -paramfile /home/grid/deinstall/response/deinstall_Ora11g_gridinfrahome1.rsp -
lastnode
至此,卸载grid infrastructure工作结束。在/etc/init.d中也不会有ohasd相关的文件了。
发表评论
-
Oracle分区表的分区交互技术实现数据快速转移
2013-01-22 11:48 14685有一个需求,将某业务表的某个时间点之前的记录转移到它的历史 ... -
等待事件enq TX row lock contention分析
2013-01-17 17:16 33221在Oracle数据库性能报告AWRRPT分析时,发现top ... -
Oracle的UNDO表空间管理总结
2013-01-14 15:06 12896UNDO是Oracle中的一个很 ... -
Oracle在不同windows系统中的迁移
2013-01-09 15:41 3717在Windows操作系统环境下 ... -
Oracle 10.2.0.1在windows 2008上安装失败经历
2013-01-07 10:29 8641这两天遇到这个一个项目上的数据库迁移的问题。原来的环境是数据库 ... -
所有的物化视图刷新脚本
2012-12-28 13:59 0select 'execute dbms_mview.refr ... -
Oracle数据库的SQL性能问题分析
2012-12-27 15:31 5238在Oracle 10.2.0.4数据库中,有一个SQL执行缓慢 ... -
db block gets和consistent gets的分析
2012-12-26 18:09 0在Oracle的文档中有这样一段解释: db block g ... -
创建增量同步Oracle物化视图问题
2012-12-25 14:07 15192我们采用Oracle的物化视图增量刷新机制定时将数据库A上的某 ... -
查归档日志文件每小时生成量
2012-12-18 16:13 10735在O racle数据库中,通过v$archived_lo ... -
如何删掉临时表空间的文件
2012-12-18 15:40 0Unlike Oracle datafiles which m ... -
Oracle sql性能诊断暨event 10046和10053使用
2012-12-17 10:24 0早上em grid control监控显示数据库的负载增加,其 ... -
查LOB字段占用的空间大小
2012-12-13 16:00 4499查询Oracle表中LOB字段的占用空间大小。表中每一个LOB ... -
Oracle Data Guard的重做日志传输和应用状况监控
2012-12-04 14:05 4030这是一个用来监控Oracle Data Guard环境下从主库 ... -
Oracle sql loader使用速成
2012-11-30 14:14 4843Oracle SQL LOADER是Oracle的 ... -
Oracle 11g2的监听器配置
2012-11-29 14:34 4327Oracle的监听器服务注册 ... -
Deleting archivelog on physical standby with RMAN in Oracle 10g
2012-11-28 13:25 0Turns out to be quite easy ... -
to_char将number转成string的小技巧
2012-11-27 14:14 10578很多数据转换处理操作时,会遇到将0.007007040000转 ... -
to_date转成字符串时ORA-01843 not a valid month 问题分析
2012-11-26 16:38 29162(注,本文三度易稿) 在开发Oracle SQL或PL/SQL ... -
Data Guard 10g 的保护级别为RESYNCHRONIZATION问题
2012-11-25 11:01 1881Oracle的data guard创建完成 ...
相关推荐
oracle 11g grid infrastructure and database r2 setup
Oracle Database 19c Grid Infrastructure (19.3)& RAC for Windows Server 2019 (64 -bit) --详细讲解windows server 2019系统下oracle19c rac安装
1)E10817 Oracle® Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Microsoft Windows 2)E10818 Oracle® Real Application ClustersInstallation Guide 11g Release 2 (11.2) for Microsoft ...
oracle11g的网络配置 Oracle培训视频课程-- 王二暖Oracle11g教室 9 王老师讲解Oracle从入门到精通 9 阿里巴巴前Oracle DBA 王老师讲解Oracle 9 [Oracle.10G.数据库系统教程.中科院培训老师讲授].13 9 [Oracle.10G....
Oracle Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Oracle Solaris-198
Oracle 11gR2 引入了很多新特性, Oracle 11gR2 将自动存储管理 (ASM) 和 Oracle Clusterware 集成在 Oracle Grid Infrastructure 中。Oracle ASM 和 Oracle Database 11gR2 提 供了较以前版本更为增强的存储解决方案...
Oracle Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Win x64
Oracle Grid Infrastructure Installation Guide for Windows
Oracle Database 11g Release 2 (11.2.0.3) RAC On Oracle Linux 6.3 Using VirtualBox This article describes the installation of Oracle Database 11g release 2 (11.2.0.3 64-bit) RAC on Linux (Oracle Linux ...
1.1.1 简化的基于映像的 Oracle Grid Infrastructure 安装 从 Oracle Grid Infrastructure 12c 第 2 版(12.2)开始,Oracle Grid Infrastructure 软件可用作下载和安装的映像文 件。 此功能大大简化了 Oracle Grid ...
3为grid infrastructure,用来升级RAC。如果要使用Clusterware、ASM、ACFS、ASM动态卷等功能时都需要先安装此包 4表示客户端(Client); 5为Gateway software,gateways是指透明网关,如果要从oracle访问其它数据库...
Grid Infrastructure Installation Guide for Microsoft Windows x64
第二部分,一步一步将10gR2 RAC 升级至Oracle 11gR2 RAC,数据库版本选择Oracle 11g最新的11.2.0.4.0 版本。 本文是第二部分: 主要步骤: 一、配置SCAN IP、DNS、停止ntpd 服务 二、将oracle 用户添加至oper 用户...
Supplemental Readme - Grid Infrastructure Release Update 12.2.0.1.x / 18c /19c Document 2246888.1
诊断 Grid Infrastructure 启动问题 (文档 ID 1623340.1)-RAC 诊断 Grid Infrastructure 启动问题 (文档 ID 1623340.1)-RAC
11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883.1] This document is intended for RAC Database Administrators and Oracle Support engineers.