ITPub博客

RH4 构建ORACLE ASM --http://guojuanjun.blog.51cto.com/277646/288332原创作品，允许转载，转载时请务必以超链接形式标明文章 原始出处 、作者信息和本声明。否则将追究法律责任。http://guojuanjun.blog.51cto.com/277646/288332 ORACLE ASM没有提供LINUX2.6.9-5.EL驱动.详情见http://www.oracle.com/technology/software/tech/linux/asmlib/rhel4.html,安装ASM之前,需升级LINUX内核. 安装以下RPM包,升级到LINUX2.6.9-11.EL,ORACLE提供了相应有ASM驱动.kernel-2.6.9-11.EL.i686.rpmkernel-devel-2.6.9-11.EL.i686.rpmkernel-hugemem-2.

Solaris内存管理以及判定内存是否够用的方法http://blog.sina.com.cn/s/blog_592060b50100dmwa.htmlSolaris内存管理以及判定内存是否够用的方法Solaris内存管理的一些基本原理 首先需要对Solairs的内存管理有一个基本的了解。Solaris内存管理简单来说就是“虚拟内存管理”模型。（注：现代OS差不多都是虚拟内存管理，包括Windows，Linux）虚拟内存的定义是： 虚拟内存的定义是基于对地址空间的重定义的，即把地址空间定义为连续的虚拟内存地址，以借此欺骗程序，使它们以为自己正在使用一大块的连续地址。（参见：虚拟内存- 维基百科

v$controlfile_record_section[@more@]

MBIND: CANNOT ALLOCATE MEMORY ON STARTUP [ID 578536.1] 修改时间 02-APR-2009 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.4 Linux x86-64 Oracle Server Enterprise Edition - Version: 10.2.0.4 Symptoms Seeing memory errors upon starting the database after applying 10.2.0.4 patchset.Typic

http://space.itpub.net/786749/viewspace-511991这篇文档主要给大家介绍一下ORACLE RAC的crs的一些日常维护的常见命令：1. 手工启动crs # /etc/init.d/init.crs start 手工关闭crs # /etc/init.d/init.crs stop在不同的操作系统，该文件的路径可能不一样（下同，不同的系统，请转换为不同的路径）： sun: /etc/init.d/init.crs Linux: /etc/init.d/init.crsHP-UX: /sbin/init.d/init.crsHP Tru64: /sbin/init.d/init.crsIBM AIX: /etc/init.crs默认情况下，系统启动时，crs会自动起来，如果没有起来，则可以使用以

C:>sqlplus scott/aaaaaaSQL*Plus: Release 11.1.0.6.0 - Production on Fri Aug 19 10:27:42 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> desc scott.dept Name Null? Type ----------------------------------------- -------- ---------------------------- DEPTNO

oracle环境为:oracle 11.2.0.2 SQL> set pages 1000SQL> set line 200SQL> spool /tmp/info.htmlSQL> set markup html onSQL> select JOB_NAME, SCHEDULE_NAME,START_DATE,REPEAT_INTERVAL from dba_SCHEDULER_JOBS;SQL> set markup html offSQL> spool off[@more@]

sp_helpconstraint tablename sp_helpindex tablename[@more@]

The Bequeath Protocol Adapter [ID 16653.1][@more@]

(1) Introduction to SQL*Net/Net8 on UNIX [ID 16652.1][@more@]

RAC Connection Redirected To Wrong Host/IP ORA-12545 [ID 364855.1] 修改时间 16-APR-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution References Applies to: Oracle Net Services - Version: 9.2.0.8.0 to 11.1.0.7.0 - Release: 9.2 to 11.1Information in this document applies to any platform. Checked for relevance on 9-APR-2010. Symptoms When we try to connect to a RAC service nam

RAC的告警日志文件：枯荣长老(81637693) 2011-8-16 8:55:11CRS logs are in $ORA_CRS_HOME/log/<hostname>/crsd/CSS logs are in $ORA_CRS_HOME/log/<hostname>/cssd/EVM logs are in $ORA_CRS_HOME/log/<hostname>/evmd $ORA_CRS_HOME/evm/log/Resource specific logs are in $ORA_CRS_HOME/log/<hostname>/racg and the $ORACLE_HOME/log/<hostname>/racgSRVM logs are in $ORA_CRS_HOME/log/<hostname>/client and the $ORACLE_HOME/log/<hostname>/clientCluster Network Communication lo

alter system set RESOURCE_LIMIT=true; --立即生效添加一个oracle profile ，idle time 设置为1分钟新建一个user，赋予connect和resource 权限，此user使用刚刚建立的profile用此user登录sqlplus，不执行任何的命令，放置在那里即可select * from v$session where 条件是此用户，主要查看status列，一开始是inactive，后来是sniped等status状态变为sniped之后，去执行一条sql,就会报提示，SQL> select * from user_tables where 1=2;select * from user_tables where 1=2*第 1 行出现错误:ORA-02396: 超出最大空闲时间, 请重新连接此时

This issue is fixed in10.2.0.4 (Server Patch Set) 11.1.0.7 (Server Patch Set)[@more@]

select * from database_properties 能查询默认表空间类型，默认的临时表空间名称等select * from database_compatible_levelselect * from database_export_objects [@more@]

select * from dba_extentsDROP Datafile And Its Restrictions [ID 781225.1][@more@]k

DROP Datafile And Its Restrictions [ID 781225.1] 修改时间 22-MAR-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1Information in this document applies to any platform. Goal How to drop a datafile from a tablespace and what are its restrictions ?. Solution From 10g onwards we have a option to

修改时间 12-AUG-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1Information in this document applies to any platform. ***Checked for relevance on 27-Feb-2011*** Goal Is there any list of limits when configuring an ASM instance ? Solution ASM imposes the following limits:63 disk groups in a storage system10,0

ORA-15196 WITH ASM DISKS LARGER THAN 2TB [ID 736891.1]此问题是bug，此问题在The fix prevents using disks larger than 2TB and is included in the following patchsets: 10.2.0.4 11.1.0.7 被修复。准确的说，asm disk 大小超过2t并且在超过2t的空间中分配空间时报错ORA-15196[@more@]

Master Note for Automatic Storage Management (ASM) [ID 1187723.1] 修改时间 12-AUG-2011 类型 ANNOUNCEMENT 状态 PUBLISHED In this Document What is being announced? What do you need to do? Automatic Storage Management (ASM) Alerts: Automatic Storage Management (ASM) Concepts and Overview: Automatic Storage Management (ASM) Installation: Automatic Storage Management (ASM) Configuration: Auto