ITPub博客

 [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...

Windows_server_2008的详细安装步骤.doc 

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

 检查数据库状态 确认所有的INSTANCE状态以及listener状态正常,登陆到所有数据库或例程,检测ORACLE后台进程: $ ps –ef|grep ora $ lsnrctl statusSQL> select status from v$instance;检查文件系统如果文件系统的剩余...

由于断电导致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>]    ...

查看os系统块的大小[root]# /sbin/tune2fs -l /dev/sda1[root@his1 ~]# fdisk -lDisk /dev/sda: 12.3 GB, 12328140800 bytes255 heads, 63 sectors/track, 1498 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes   Device Boot      Start  &nbs...

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

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

 [root@his1 ~]#cat/app/grid/product/11.2.0/grid/log/his1/ohasd/ohasd.log[ohasd(28152)]CRS-0704:Oracle High Availability Service aborted due to Oracle Local Registry error [PROCL-26: Error while accessing the physical storage Operating System error [No such file or directory] [2]...