ITPub博客

SQL> col name format a34SQL> set pagesize 15SQL> col name format a34SQL> set pagesize 15SQL> select name ,sequence#,creator,REGISTRAR,STANDBY_DEST,ARCHIVED,applied from v$archived_log;NAME SEQUENCE# CREATOR REGISTR STA ARC APP---------------------------------- ---------- ------- ------- --- --- ---/home/oracle/archive/1_12.dbf 12 ARCH RFS NO YES YES/home/oracle/archive/1_13.dbf 13 ARCH RFS NO YES YES/home/o

1.在主库上，alter system switch logfile; 在备库上:tail -f alert_orac.log 查看：Tue Jul 12 15:25:01 2011Media Recovery Log /home/oracle/archive/1_20.dbfMedia Recovery Waiting for thread 1 seq# 212。在主库上：SQL> select open_mode from v$database;OPEN_MODE----------READ WRITESQL> select database_role from v$database;DATABASE_ROLE----------------PRIMARY在备库上：^X[oracle@rhel43 bdump]$ sqlplus " / as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 12 15:26:38 2011Copyr

Linux系统时区时间配置详解Linux时区相关 1. 查看当前时区 # vi /etc/sysconfig/clock # date -u # date -R 2. 修改设置时区 方法(1) tzselect 方法(2) 仅限于RedHat Linux 和 CentOS timeconfig 方法(3) 适用于Debian dpkg-reconfigure tzdata 3. 复制相应的时区文件，替换系统默认时区 # ln -sf /usr/share/zoneinfo/$主时区/$次时区 /etc/localtime 对于中国服务器则执行： # ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime 4. 将当前时间写入BIOS永久生效（避免重启后失效） # hwclo

1.每个节点用root停止cluster (先进入到grid_home/bin目录) crsctl stop cluster2. 每个节点用root执行：date -s '12:00:00'3. 每个节点用root执行（此步是写入机器的cmos时钟）：clock -w 4.重启每个节点验证修改是否生效。[@more@]

The number of nodes supported is not limited by Oracle, but more generally by the clustering software/hardware in question. When using solely Oracle Clusterware: 63 nodes (Oracle 9i or Oracle RAC 10g Release 1) With 10g Release 2, the maximum nodes is 100 When using a third party clusterware: Sun: 8 HP UX: 16 HP Tru64: 8 IBM AIX: * 8 nodes for Physical Shared (CLVM) SSA disk * 16 nodes for Physical Shared (CLVM) non-SSA disk * 128 nodes for Virtual Shared Disk (VSD) *

RAC: Frequently Asked Questions [ID 220970.1] 修改时间 06-JUL-2011 类型 FAQ 状态 PUBLISHED Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.1 - Release: 9.2 to 11.2Information in this document applies to any platform. Purpose Frequently Asked Questions for Real Application Clusters and Grid Infrastructure. Questions and Answers p.MsoNormal, li.MsoNormal, div.MsoNormal

RAC Assurance Support Team: RAC Starter Kit and Best Practices (Windows) [ID 811271.1] 修改时间 14-JUN-2011 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application RAC Assurance Support Team: RAC Starter Kit and Best Practices (Windows) RAC Assurance Support Team: RAC and Oracle Clusterware Starter Kit and Best Practices (Generic) RAC Platform Specific Starter Kits and Best Practic

在windows x64bit上安装oracle 11.2.0.2 rac 要求必须使用域用户安装（必须使用域用户安装的报错是在grid软件安装到“先决条件检查”部分弹出的提示）而在相同的os平台上，安装oracle 11.2.0.1 rac，可以用本地administrator用户来安装。[@more@]za

Oracle RAC Technologies Certification Matrix for Microsoft Windows Platforms Oracle will support the Oracle software on clusters comprised of RAC compatible technologies and supported software combinationsNOTE: Please consult your hardware and software vendors as not all vendors may choose to support their hardware or software in every possible cluster combinationFor RAC database and server virtualization (Oracle VM, LPAR, vPAR, LDOM, etc.) support see here.For RAC dat

最近在客户处执行sqlplus / as sysdba 进入sqlplus,提示权限不足，于是很自然的就想到sqlnet.ora文件中的设置：看这个一行是否是这么写的：SQLNET.AUTHENTICATION_SERVICES= (NTS)此时处于生产时段，我当时没有修改sqlnet.ora。而是到了晚上，才修改sqlnet.ora文件的内容，将SQLNET.AUTHENTICATION_SERVICES= (NONE)改为SQLNET.AUTHENTICATION_SERVICES= (NTS)此次修改主要是为了sqlplus / as sysdba 能进入sqlplus进行操作。当操作完毕后，sqlnet.ora的内容没有改会原来的。之后，前台应用报错，连不上数据库，报错为ORA-12637:包接收失败

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/process.htm#sthref1626Other Background Processes There are several other background processes that might be running. These can include the following: MMON performs various manageability-related background tasks, for example: Issuing alerts whenever a given metrics violates its threshold value Taking snapshots by spawning additional process (MMON slaves) Capturing statistics value for SQL objects which have been recently mo

Job Queue Processes Job queue processes are used for batch processing. They run user jobs. They can be viewed as a scheduler service that can be used to schedule jobs as PL/SQL statements or procedures on an Oracle instance. Given a start date and an interval, the job queue processes try to run the job at the next occurrence of the interval. Job queue processes are managed dynamically. This allows job queue clients to use more job queue processes when required. The resources used b

mkdir %date:`0,10%[@more@]j

[root@rhel42 logs]# pwd/web/weblogic/Oracle/Middleware/logs[root@rhel42 logs]# cat log.txt 2011-7-4 6:07:29 -- install "WebLogic Platform" 10.3.3.0 在 /web/weblogic/Oracle/Middleware 版本 10.3.3.0 [已添加] |_____Common Infrastructure Engineering 7.0.0.0 [已添加] | |_____Uninstall [已添加] | |_____Patch Client [已添加] | |_____Patch Attachment Facility [已添加] | |_____Clone Facility [已添加] |_____WebLogic Server 10.3.3.0 [已添加] | |_____Core Ap

本文转自：http://blog.xb668.com/?action=show&id=24 感谢原作者。请以root用户权限执行： 1) # snap -r 回答Y（如果以前未做过snap,系统会报错说明没有可清理的内容,显示“nothing to clean up”）， 完成后继续 2) 2) # snap -gbc 完成后,通过ftp (用binary方式,在命令行下执行:bin) 取得/tmp/ibmsupt/snap.pax.* 文件 (snap.pax.Z 或者snap.tar.Z) 然后执行 #errpt -a > /tmp/errpt.txt[@more@]

linux --sysreport ，还有一个dmidecode，不过dmidecode输出的信息都是些硬件的信息。aix--prtconf 或者snapwindows --msinfo32.exe 其实就是系统信息窗口。里边"文件"-"导出" 可以导出为txt文本格式hpux 有啥？[@more@]

检查定时任务的脚本发现：export ORACLE_SID= orcl注意，orcl前面多了个空格，把空格去掉即可。export ORACLE_SID=orcl[@more@]

Selects Against ALL_SYNONYMS Perform Badly on 10g Release 10.2 [ID 377037.1] 修改时间 01-DEC-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2Information in this document applies to any platform. Symptoms In some cases queries against the ALL_SYNONYMS vi

DBA_LOGSTDBY_NOT_UNIQUE displays all tables that have no primary and no non-null unique indexes. Most of the tables displayed by this view are supported because their columns contain enough information to be maintained in a logical standby database. Some tables, however, cannot be supported because their columns do not contain the necessary information. Unsupported tables usually contain a column defined using an unsupported datatype.Column Datatype NULL Description OWNER

关于oracle在linux系统下安装后，如何在系统重启的情况下让服务自动启动起来，网上有很多的教程和现成的脚本，这里只是个人工作中的一点经验。 以redhat as4和oracle 10g为例。单机在安装过程依照oracle官方的文档一步步下来，只要设置好参数、安装好必要的包，一般不会出什么问题。安装好了以后系统重 启，oracle重启服务，网上很多人建议自己写脚本（其实脚本也很简单），这里讲的是用oracle本身的脚本实现，当然不可避免最后还要写一点点的。 1、配置dbstart和dbshut 在$ORACLE_HOME/bin中，有dbstart和dbshut这两个脚本，