ITPub博客

TNS-12541: TNS:no listener这次错误我总结一下有三种情况1. 本地监听程序没有开起来2. 服务器网络到客户端网络不通3. Hosts里面配置问题[oracle@his1 admin]$ tnsping crds3db2  客户端tnsping提示程序无监听TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 28-MAY-20...

新部署机器因为意外断电导致bugREASON:NOTE: GMON heartbeating for grp 1GMON querying group 1 at 5 for pid 23, osid 2872NOTE: cache opening disk 0 of grp 1: FRAVOL label:FRAVOLNOTE: F1X0 found on disk 0 au 2 fcn 0.0NOTE: cache mounting (first) external redundancy group 1/0x9B8856B5 (ORAARCH)Sun ...

 [grid@znode1 ~]$ crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online从11.2开始Oracle Cluterware标示voting...

[root@his2 soft]# /app/grid/product/11.2.0/grid/root.sh Running Oracle 11g root script...The following environment variables are set as:    ORACLE_OWNER= grid    ORACLE_HOME=  /app/grid/product/11.2.0/gridEnter the full pathname of the local bin direct...

11g集群新特性-scan机制关于11g集群跟10g有过一定的变化，虽然主要的集群件原理相同，不过关于集群的安装由原来的clusterware集群见改为GI，而asm则被封装到GI中，不像10g时asm是被封装到oracle database软件中，关于集群的管理也有些变化，例如集群命令更加多了，用grid用户来管理集群和asm，而oracle用户就只需要管...

otedisk OCR 文件管理votedisk 表决票完成步骤移动增加votediskcrsctl add css votedisk移动VOTEDISK[grid@his1 ~]$ crsctl replace votedisk +ORADATASuccessful addition of voting disk 1872e8b75a044f7ebff196ac40dcc659.Successful deletion of voting disk 6977382452284f23bff811784304398d.Success...

?[root@his2 bin]# ./crsctl check crs? 检查服务状态CRS-4047: No Oracle Clusterware components configured.CRS-4000: Command Check failed, or completed with errors.[root@his2 bin]# ./crsctl stat res -tCRS-4047: No Oracle Clusterware components configured.CRS-4000: Command Status fa...

rac数据日志频繁关闭和启动gtx进程Auto-tuning: Shutting down background process GTX6Thu Feb 13 13:43:36 2014Auto-tuning: Shutting down background process GTX5Thu Feb 13 13:47:12 2014Auto-tuning: Starting background process GTX5Starting background process GTX5Thu Feb 13 13:47:12 2014GTX5 star...

DB数据库迁移到rac环境数据库的版本均为11.2.0.2操作系统均为OEL5.5 64位一：目标数据库准备工作，rman备份的异机恢复要求数据库名要一致。[oracle@db1 ~]$ srvctl stop database -d orcl [oracle@db1 ~]$ srvctl remove database -d orcl  Remove the database racdb? (y/[n]) y[oracle@db1 ...

RAC local_listener错误应用程序时而连接的上去时而连接不上去数据库问题就是一个节点实例没有注册到本地监听导致集群监听负载均衡切换节点1时候本地监听没有注册到实例导致应用错误时而连接不上去切换正常因为节点2实例是注册本地监听解决方法重两台服务器启服务器用srvctl命令重启故障节点1数据库srvct...

已有节点rac1、rac2，下面做的是添加节点rac3rac3先安装下cvuqdisk包，这个包在GI安装文件中有。/home/grid/grid/rpm[root@rac3 rpm]# rpm -ivh cvuqdisk-1.0.9-1.rpm1.rac3节点安装集群软件GI①检查rac3是否满足rac安装条件[root@rac1 ~]# su - grid[grid@rac1 ~]$ cluvfy stage -pre nodeadd -n rac3 -fi...

 [oracle@his1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.2.0 Production on Wed Jan 15 13:12:42 2014Copyright (c) 1982, 2010, Oracle.  All rights reserved.Connected to an idle instance.下面可以启动数据库找不到spfileSQL> startupORA-01078: failure in processing syste...

 [root@his2 bin]# ./crsctl check crs  检查服务状态CRS-4047: No Oracle Clusterware components configured.CRS-4000: Command Check failed, or completed with errors.[root@his2 bin]# ./crsctl stat res -tCRS-4047: No Oracle Clusterware components configured.CRS-4000: Command Status fa...

  Oracle 的管理可以通过OEM或者命令行进行。 Oracle Clusterware的命令集可以分为以下4种：节点层：osnodes网络层：oifcfg集群层：crsctl, ocrcheck,ocrdump,ocrconfig应用层：srvctl,onsctl,crs_stat下面分别来介绍这些命令。 1         节点层只...

由于断电导致oracle 11g R2 asm 数据库不能启动，处理过程如下：aix1@grid[/oracle11/app/grid/11.2.0]$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 12 14:22:13 2012Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to an idle instance.SQL> ...

1、备份数据库[oracle@haozg dbs]$ rman target /Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 5 14:12:57 2012Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.connected to target database: ORA11 (DBID=729090162)RMAN> run{ allocat...

Oracle 11g R2 Grid Infrastructure 的安装与配置较之前的版本提供了更多的灵活性。在Grid Infrastructure安装完毕前执行root.sh经常容易出现错误，并且需要修复该错误才能得以继续。 在这个版本中我们可以直接通过执行脚本rootcrs.pl来重新配置Grid Infrastructure而无需先卸载Grid Infrastructure，然后修...

[grid@his2 install]$ ./rootcrs.pl --help  Unknown option: dconfigUsage:      rootcrs.pl [-verbose] [-upgrade | -patch]                 [-paramfile <parameter-file>]    ...

 [root@his1 ~]# vi /etc/hosts                                           修改hosts#...

[root@his1 bin]# ./crs_stop -all                                     停止所有的crs服务CRS-2500: Cannot stop resource ...