ITPub博客

RAC1 RAC2 都需需要配置监听，各自监听自己的 实例；客户端使用SERVER的虚拟IP配置2个监听地址；为什么使用虚拟地址?监听地址使用 VIP(如果没有vip，连接失败节点的process会有一个比较长的tcp超时等待，才能返回错误，有了vip后，节点失效后，由于vip漂移到其它节点，连接该vip的process很快就能返回错误，从而更快的尝试连接其它活动的节点)客户最终连接到哪个INSTANCE？如果客户端没有指定连接到哪个实例则 决定分配到哪个实例由以下2个设置决定：Client-Side Load Balancing（CLB）:由客户端tnsname.ora配置Server-Side Load Balancin

CREATE OR REPLACE PROCEDURE search_col1(p_look varchar2) IStmpVar NUMBER;v_col varchar2(3200);v_look varchar2(32);-已知的要查找的列内容v_colname varchar2(32);v_sql varchar2(3200);/**************************t**************************************************** NAME: search_col PURPOSE: REVISIONS: Ver Date Author Description --------- ---------- --------------- ------------------------------------ 1.0 2008-11-24 1. Created this proce

创建目录：CREATE OR REPLACE DIRECTORY ALERT_LOG AS 'D:oracleproduct10.2.0adminorclbdump';GRANT READ, WRITE ON DIRECTORY ALERT_LOG TO PLOG WITH GRANT OPTION;创建外部表：CREATE TABLE PLOG.ALERT_PTS( TEXT VARCHAR2(1000 BYTE) NULL)ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY ALERT_LOG ACCESS PARAMETERS ( records delimited by newline ) LOCATION (ALERT_LOG:'alert_orcl.log') )REJECT LIMIT UNLIMITEDNOPARALLELNOMONITORING;创建关机 开机字符时

症状：执行SQL提示"ORA-01846: 周中的日无效"select to_date('Sun Aug 23 00:05:13 2009','Dy Mon DD HH24:MI:SS YYYY' from dual 原因分析：查看客户端注册表（客户端环境变量）nls_lang=SIMPLIFIED CHINESE_CHINA.ZHS16GBK解决：修改为客户端注册表（客户端环境变量）nls_lang=AMERICAN_AMERICA.zhs16cgb231280或者 会话级修改SQL> alter session set nls_language='AMERICAN';结果验证：SQL> select to_date(to_date('Sun Aug 23 00:05:13 2009','Dy Mon DD HH24:MI:SS YYYY'),'yyyy-mm-dd hh24:mi:ss') from dual;

一：parent cursor与child cursor得区别 联系SQL> ALTER SESSION SET optimizer_mode = all_rows;SQL> SELECT count(*) FROM t;SQL> ALTER SESSION SET optimizer_mode = first_rows_10;SQL> SELECT count(*) FROM t;The result is that a single parent cursor (5tjqf7sx5dzmj) and two child cursors (0 and 1) arecreated.parent cursor:10g中v$sql,v$sqlarea的sql_id代表一个parent cursor.child cursors:child_number代表一个child cursors，plan_hash_value代表相同的执行计划user global area (UGA):存储指向SHARE P

环境10G RAC（2NODES）+WINDOWS2003:症状：一直用着好好的，重启 数据库后，一开始偶尔出现以下错误，到后面 都连接不上 ：ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE_NAME 错误的解决分析：1：tnsping 服务名 OK2：ping IP 网络正常 无掉包3:查看监听日志，没有 大量客户请求 排除监听负荷过大可能造成的问题；4：有一个节点的监听日志 显示所有请求都能正确服务，另外个节点 都 是 “ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE_NAME 错误的解决”5：重启 instance,asm,nodeapps 后半小时内

文本 字符 串格式：jpg "Mozilla/4.0 (compatible; MSIE“ cc分析：通常分割符为 空格问题：这里双引号内包含有空格 （导致问题：双引号内字符串将不能作为一个字段处理），解决：创建表时增加特定语句实现双引号内字符串为一个字段： OPTIONALLY ENCLOSED BY '"' AND '"'CREATE TABLE PLOGXI.PROXY_LOG_01( str1 VARCHAR2(60 BYTE) NULL, str2 VARCHAR2(60 BYTE) NULL, str3 VARCHAR2(60 BYTE) NULL,)ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER

一：查看 卷组及对应的所有物理卷xxx:xx >lspvhdisk0 0009bebc4e6d09a9 rootvg activehdisk1 0009bebcc15ace7a rootvg activehdisk2 0009bebcc1961887 oracle active二：查看卷组及对应的文件系统#smit lsvg选择 第3项oracle: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT loglv00 jfs2log 1 1 1 open/syncd N/A fslv00 jfs2 25

主题: WAITEVENT: "library cache pin" Reference Note 文档 ID: 34579.1 类型: REFERENCE Modified Date: 06-OCT-2009 状态: PUBLISHED "library cache pin" Reference Note This is a reference note for the wait event "library cache pin" which includes the following subsections: Brief definition Individual wait details (eg: For waits seen in <View:V$SESSION_WAIT>) Systemwide wait details (eg: For waits seen in <View:V$SYSTEM_EVEN

Commands Reference, Volume 3, i - m lslpp Command Purpose Lists installed software products. Syntax lslpp { -d | -E | -f | -h | -i | -l | -L | -p } [ -a] [ -c] [ -J ] [ -q ] [ -I ] [ -O { [ r ] [ s ] [ u ] } ] [ FilesetName ... | -b File | all ] lslpp -w [ -c ] [ -q ] [ -O { [ r ] [ s ] [ u ] } ] [ FileName ... | all ] lslpp -L -c [ -v] lslpp -S [A|O] lslpp -e Description The lslpp command displays information about installed fi

症状：数据库日志记录Thu Oct 8 12:11:51 2009Errors in file /oracle/admin/cpqs/bdump/cpqs_dbw0_315766.trc:ORA-27061: waiting for async I/Os failedIBM AIX RISC System/6000 Error: 22: Invalid argumentThu Oct 8 12:11:51 2009DBW0: terminating instance due to error 27061Instance terminated by DBW0, pid = 315766原因分析 ：主题: ORA-27061: waiting for async I/Os failed on IBM AIX RISC System/6000 Error: 22: Invalid argument 文档 ID: 464768.1 类型: PROBLEM Modified Date: 04-APR-2

主题: Oracle Clusterware: Patch installation 文档 ID: 557934.1 类型: REFERENCE Modified Date: 30-JUL-2009 状态: PUBLISHED In this Document Purpose Scope Oracle Clusterware: Patch installation How Oracle Clusterware is Different from the RDBMS Types of patches Applying PatchSets Applying Bundle Patches (CRSBP/MLR) Conclusion References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.4 to 11.1

主题: OCRDUMP -BACKUPFILE Is Failing With PROT-302 文档 ID: 782233.1 类型: PROBLEM Modified Date: 27-MAY-2009 状态: PUBLISHED In this Document Symptoms Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 This problem can occur on any platform. Symptoms The command : ocrdump -backupfile <filename> ; used to dump contents of a backup Oracle Cluster Registry (OCR) file will fa

密码字符串要求：-- Check if the password is same as the username-- Check for the minimum length of the password-- Check if the password contains at least one letter, one digit and one-- Check if the password differs from the previous password by at leastCREATE OR REPLACE FUNCTION SYS.verify_function(username varchar2, password varchar2, old_password varchar2) RETURN boolean IS n boolean; m integer; differ integer; isdigit boolean; ischar boolean; ispunct boolean; digitarray va

主题: OCR Corruption after Adding/Removing voting disk to a cluster when CRS stack is running 文档 ID: 390880.1 类型: ALERT Modified Date: 13-MAR-2009 状态: PUBLISHED In this Document Description Likelihood of Occurrence Possible Symptoms Workaround or Resolution Patches Modification History References Applies to: Oracle Server Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 Information in this document applies to any platfo

主题: OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE), including moving from RAW Devices to Block Devices. 文档 ID: 428681.1 类型: HOWTO Modified Date: 02-JUN-2009 状态: PUBLISHED In this Document Goal Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6 Information in this document applies to any platform. Oracle Server Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 G

How ASM Handles Disk FailuresDepending on the redundancy level of a disk group and how failure groups aredefined, the failure of one or more disks could result in either of the following:■ The disks are first taken offline and then automatically dropped.#2个DISKGROUP不一定必须大小相等#磁盘组失败的定义和失败时的动作The disk group remains mounted and serviceable, and, thanks to mirroring, alldisk group data remains accessible. Following the disk drop, ASM performs arebalance to restore full red

主题: CRS-215 Srvctl unable to start ASM, Listener, RDBMS Resources 文档 ID: 740319.1 类型: PROBLEM Modified Date: 20-FEB-2009 状态: PUBLISHED In this Document Symptoms Changes Cause Solution Applies to: Oracle Server Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 This problem can occur on any platform. Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 Symptoms After patching CRS, RDBMS & ASM ORACLE_HOME, u

主题: Troubleshooting when srvctl can't a RAC instance, but sqlplus can start it 文档 ID: 844272.1 类型: TROUBLESHOOTING Modified Date: 30-JUL-2009 状态: PUBLISHED In this Document Purpose Last Review Date Instructions for the Reader Troubleshooting Details I. Introduction II. Troubleshooting References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 Information in this document applies to

RDA 4.x Overview Note: Please review installation and execution instructions below. If you experience difficulties or receive errors please follow the RDA Troubleshooting Guide and RDA FAQ for instructions on reporting problems. Overview Remote Diagnostic Agent (RDA) is a command-line diagnostic tool that is executed by an engine written in the Perl programming language. RDA provides a unified package of support diagnostics tools and preventive s