oradbHome http://space.itpub.net/471666 专著oracle 技术 记录维护生产数据库的点点滴滴.... Copyright(C) oradbHome SupeSite/X-Space Sat, 11 Oct 2008 08:05:29 GMT HP-UNIX 命名 －转载 http://space.itpub.net/471666/viewspace-470008 下面是查看HP小型机的信息的命令集：
1、机型
#model
9000/800/L2000-44
注意：其中44是指每个cpu有440MHZ。
2、cpu个数
#top
CPU   LOAD   USER   NICE    SYS   I...]]> blog oradbHome Sat, 11 Oct 2008 07:27:16 GMT ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file http://space.itpub.net/471666/viewspace-466012 Errors in file f:\oracle\admin\jjoracle\bdump\jjoracle_dbw0_152.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 11 (block # 174017)
ORA-01110: data file 11: 'F:\ORA...]]> blog oradbHome Sun, 28 Sep 2008 11:37:08 GMT ORA-27061: waiting for async I/Os failed http://space.itpub.net/471666/viewspace-462902  
OS: HP-UNIX
 
SQL> ORA-27061: waiting for async I/Os failed
SQL> Disconnected
SQL> logout
参考metalink Note:457898.1
 
Cau...]]> blog oradbHome Wed, 24 Sep 2008 16:24:40 GMT not in / not exists null 一点区别 http://space.itpub.net/471666/viewspace-448642 test@racdb.> select t.*, t.rowid from t_a t;

         A          B ROWID
---------- ---------- ------------------
&...]]> blog oradbHome Tue, 16 Sep 2008 16:59:32 GMT oracle 调用外部程序 C++ 常见问题解决 http://space.itpub.net/471666/viewspace-444277 同事咨询的oracle 调用c++ dll程序不能执行.记录过程.

创建的  library                            &n...]]> blog oradbHome Thu, 11 Sep 2008 14:13:16 GMT ORA-10631: SHRINK clause should not be specified for this object http://space.itpub.net/471666/viewspace-442333 今天进行shrink space 时 发生 ORA-10631错误. 查找原因. shrink space 有一些限制.

原来是表上有函数索引, 删除后就可以了.

1) "Shrink operations can only be performed on segments in tablespaces
with automatic segment-space management" ...]]> blog oradbHome Mon, 08 Sep 2008 15:09:53 GMT local + uniform size 设置 http://space.itpub.net/471666/viewspace-442297 我都用local + uniform
每个系统有多个不同uniform的tablespace
基本有
100M for data  ==> 存放 size 将超过 500M 的table
20M for index ==> 对应上面100M_data的table的index
20M for data ==> 80M to 500M 的 table
8M for i...]]> blog oradbHome Mon, 08 Sep 2008 11:18:04 GMT oracle10g SKIP_UNUSABLE_INDEXES 作用 http://space.itpub.net/471666/viewspace-441969 SKIP_UNUSABLE_INDEXES  是10g 新增加的参数,在9i中不存在.增强了系统的健壮性.

sys@stat.regre> create table tt (id number);             ...]]> blog oradbHome Fri, 05 Sep 2008 10:00:27 GMT PL/SQL 游标 FETCH BUIK COLLECT -- 转载 http://space.itpub.net/471666/viewspace-440688 PL/SQL里的游标可以分为显式和隐式两种，而隐式有分为select into隐式游标和for .. in 隐式游标两种。所以，我们可以认为，有3种游标用法：
A. 显式游标
B. select into隐式游标
C. for .. in 隐式游标

如...]]> blog oradbHome Wed, 03 Sep 2008 09:17:29 GMT AIX RAC swap 不足, 实例down --解决 http://space.itpub.net/471666/viewspace-440330 db : 10.2.0. 3 rac

alert.log
Mon Sep  1 03:49:17 2008
Process startup failed, error stack:
Mon Sep  1 03:49:17 2008
Errors in file /app/oracle/admin/racdb/bdump/racdb1_psp0_479298.trc...]]> blog oradbHome Mon, 01 Sep 2008 11:34:35 GMT 外键不建立index , 引起阻塞的问题. http://space.itpub.net/471666/viewspace-438913
session1:

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

test@oradb.>
tes...]]> blog oradbHome Fri, 29 Aug 2008 14:31:12 GMT Oracle常用dump命令 http://space.itpub.net/471666/viewspace-438624 Oracle常用dump命令

Oracle常用dump命令，记录一下备查。


一.Memory Dumps

1).Global Area
ALTER SESSION SET EVENTS ‘immediate trace name global_area level n’...]]> blog oradbHome Thu, 28 Aug 2008 10:26:52 GMT 自定义函数索引使用注意的问题 http://space.itpub.net/471666/viewspace-434653 今天一个朋友问我自定义函数索引 加上hint 也在执行计划中也不能使用函数索引, 我做了个测试记录了一下:
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Relea...]]> blog oradbHome Tue, 26 Aug 2008 10:17:02 GMT 自治事务 导致一个session 产生死锁 http://space.itpub.net/471666/viewspace-431719
v$log 信息
ADDR     KADDR      SID TY  ID1    ID2LMODE REQUEST  CTIME  BLOCK         
-------- -------- ---------- -- ...]]> blog oradbHome Thu, 21 Aug 2008 17:12:12 GMT shrink table 总结 http://space.itpub.net/471666/viewspace-430079 test@racdb.> exec show_space('tab_1');                             &n...]]> blog oradbHome Wed, 20 Aug 2008 09:56:24 GMT 16进制 和10进制 , 2进制 和10进制 转换函数 http://space.itpub.net/471666/viewspace-429774 16进制 和10进制 , 2进制 和10进制 转换函数

1> 16--> 10
SQL> SELECT to_number('806d','xxxxxxx') FROM dual;
 
TO_NUMBER('806D','XXXXXXX')
---------------------------
        &...]]> blog oradbHome Mon, 18 Aug 2008 14:59:04 GMT SHOW_SPACE 函数 http://space.itpub.net/471666/viewspace-429761 CREATE OR REPLACE PROCEDURE SYS.SHOW_SPACE(p_segname_1 IN VARCHAR2,
                             &nbs...]]> blog oradbHome Mon, 18 Aug 2008 14:35:02 GMT STREAM 流复制表 脚本 http://space.itpub.net/471666/viewspace-429422
-- source database

CREATE DATABASE LINK stat CONNECT TO streamadmin IDENTIFIED BY streamadmin USING 'stat'


BEGIN
  DBMS_STREAMS_ADM.SET_UP_QUEUE(queue_table => 'streamadmin.s_queue_table',
   &nb...]]> blog oradbHome Fri, 15 Aug 2008 16:11:42 GMT v$sesson_wait cursor: pin S wait on X http://space.itpub.net/471666/viewspace-425647 v$sesson_wait cursor: pin S wait on X

数据库的job hang 主 , 是很多物化视图的刷新的job , 正常是凌晨2点执行, 早上9点还在执行.
查询 v$sesson_wait.event ='cursor: pin S wait on X'

查询v$session.process 然后kill 掉. job 重新执行, ok blog oradbHome Wed, 13 Aug 2008 11:18:56 GMT LINUX 配置 nfs , rman 备份使用. http://space.itpub.net/471666/viewspace-422969 1.-- 需要的软件包
[root@lb01 ~]# rpm -qa | grep nfs
nfs-utils-1.0.6-70.EL4
system-config-nfs-1.2.8-1
nfs-utils-lib-1.0.6-3
[root@lb01 ~]#

2.
[root@lb01 ~]# more /etc/exports
/App/nfs 192.168.60.*(rw,sync,root_squash)<...]]> blog oradbHome Mon, 11 Aug 2008 14:15:45 GMT RAC 环境切换undo 表空间 http://space.itpub.net/471666/viewspace-421402 由于程序异常到知道undo 扩展, 一般情况下 resize 就不行的.只能切换undo tbs .

sys@racdb.> show parameter undo                 ...]]> blog oradbHome Thu, 07 Aug 2008 11:42:43 GMT ORA-00600: [17285], [0x2A97236770], [4294967295], [0x10D4A6070], [], [], [], [] http://space.itpub.net/471666/viewspace-420766 Wed Aug  6 14:26:31 2008
Errors in file /app/oracle/admin/racdb/udump/racdb1_ora_13115.trc:
ORA-00600: internal error code, arguments: [17285], [0x2A97236770], [4294967295], [0x10D4A6070], [], [], [], []
ORA-00604: error occurred at re...]]> blog oradbHome Wed, 06 Aug 2008 16:19:38 GMT 开发人员咨询的一个sql - 行转列 http://space.itpub.net/471666/viewspace-419066 有张表 cardInof

card             tel
---------    ----------   ...]]> blog oradbHome Tue, 05 Aug 2008 17:03:37 GMT 奥运来了. ..安检.... http://space.itpub.net/471666/viewspace-419049 早就等说了 地铁 开始检查包包了. .今天早上做公共汽车刷完卡 还看到有个座位,呵呵.本想坐下.
就在这时 旁边的一个大姐拉了我一下.我还以为什么事情呢.. .说"把你的包打开看一下" 我愣了一下.
没有反应过来.看到大姐的胳膊上面有个治安红标.才明白过来.原来公交车...]]> blog oradbHome Tue, 05 Aug 2008 14:38:25 GMT WARNING: inbound connection timed out (ORA-3136) http://space.itpub.net/471666/viewspace-418932 WARNING: inbound connection timed out (ORA-3136)

DB: ORACLE10.2.03 RAC

1.listener.ora

添加 INBOUND_CONNECT_TIMEOUT_<listener_name>=0

2.sqlnet.ora

SQLNET.INBOUND_CONNECT_TIMEOUT=0

3. lsnrctl reloa...]]> blog oradbHome Tue, 05 Aug 2008 09:04:57 GMT Oracle10g 后台进程及从进程详解 http://space.itpub.net/471666/viewspace-417757 后台进程包括:

1)Focused Background Processes
2)Utility Background Processes

 blog oradbHome Mon, 04 Aug 2008 15:16:50 GMT ORA-1461 encountered when generating server alert SMG-4121 http://space.itpub.net/471666/viewspace-417704 ORA-1461 encountered when generating server alert SMG-4121

Error:  ORA 1461
Text:   can bind a LONG value only for insert into a LONG column
----------------------------------------------------------...]]> blog oradbHome Mon, 04 Aug 2008 10:59:04 GMT ORA-00210: cannot open the specified control file http://space.itpub.net/471666/viewspace-417460 奇怪的错误 ORA-00210: cannot open the specified control file , 在执行 srvctl stop database -d racdb -i racdb1

alert.log

Fri Aug  1 11:18:00 2008
Process OS id : 12612 alive after kill
Errors in file /app/oracle/admin/racdb...]]> blog oradbHome Fri, 01 Aug 2008 16:56:44 GMT ORA-00600: internal error code, arguments: [kolaslGetLength-1] http://space.itpub.net/471666/viewspace-417409  

又遇到bug ORA-00600: internal error code, arguments: [kolaslGetLength-1], [], [], [], [], [], [], []

alert.log

Thu Jul 31 19:53:29 2008
Errors in file /app/oracle/admin/jx1db/udump/jx1db1_ora_22911.trc:
ORA-00600...]]> blog oradbHome Fri, 01 Aug 2008 12:52:06 GMT ORA-1461 encountered when generating server alert SMG-3500 http://space.itpub.net/471666/viewspace-416147 os : linux x86-64

db: 10.2.03 rac

ORA-1461 encountered when generating server alert SMG-3500

今天 alert.log 报警.ORA-1461 , 竟然是个bug ,