ORACLE 9i-23ai – Page 44

Installing Enterprise Manager Cloud Control 12c r2 Agent on Linux(安装em12c agent)

2016-04-252012-11-07 by weejar zhang

Oracle Management Agent 12c communicates only with Oracle Management Service 12c and not with any earlier release of Enterprise Manager

Installing Enterprise Manager Cloud Control 12c release2 on Linux(安装em12c)

2016-04-252012-11-06 by weejar zhang

EM 12c在安装时和11EM相似，只是增加了Plug-ins 的选择，Plug-ins 和 Connectors做为GRID CONTROLE的扩展并增加了一些非oracle的产品整合为”Cloud”云管理包含DATABASE,Middleware,VM server

SQL ordered by Version Count and Troubleshooting

2025-06-302012-10-31 by weejar zhang

the cause:
bug,related to name resolution issues, bind buffer length, fine grained access control, cursor invalidation, or any of the other common structural or coding reasons for multiple child cursors

DB_FILE_MULTIBLOCK_READ_COUNT parameter

2012-10-25 by weejar zhang

DB_FILE_MULTIBLOCK_READ_COUNT is one of the parameters you can use to minimize I/O during table scans. It specifies the maximum number of blocks read in one I/O operation during

RMAN-08137: WARNING archived log not deleted, needed for standby or upstream capture process

2024-11-122012-10-23 by weejar zhang

When he tried deleting archivelog manually with RMAN on primary db host, he got following warning:

“归档日志未删除, 因为备用或上游捕获进程需要它”

Memory Notification: Heap size nnnnK exceeds notification threshold (51200K)

2014-03-112012-10-19 by weejar zhang

Memory Notification: Library Cache Object loaded into SGA
Heap size 106084K exceeds notification threshold (51200K)
KGL object name …

know more about dbms_job fails

2012-10-19 by weejar zhang

When job execution fails, the SNP processes attempts to rerun the job one minute later. If this run fails, another attempt is made in two minutes and another in four minutes. The job queue doubles the retry interval until it exceeds the normal execution interval..

sqlplus autotrace sql Statistics value全部为0

2012-10-15 by weejar zhang

0 db block gets
0 consistent gets
0 physical reads
0 redo size
0 bytes sent via SQL*Net to client
0 bytes received via SQL*Net from client
0 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
62 rows processed

ora-600 [kcbgcur_9] internal error when ALTER DATABASE ADD SUPPLEMENTAL LOG DATA

2014-01-142012-10-10 by weejar zhang

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcbgcur_9], [8388681], [25],
[100663296], [33554432], [], [], []

How to stop or kill datapump jobs?(停止数据泵job)

2012-11-232012-09-17 by weejar zhang

3 begin
4 hdl := dbms_datapump.attach(‘SYS_IMPORT_FULL_03′,’SYSTEM’);
5 DBMS_DATAPUMP.STOP_JOB(hdl,1,0);
6 end;

迁移controlfile 从文件系统到ASM

2012-09-12 by weejar zhang

alter system set control_files=’+DATA/ANBOB/CONTROLFILE/current.260.793738081′,’+DATA/ANBOB/CONTROLFILE/current.261.793738087′,’+DATA/ANBOB/CONTROLFILE/current.276.793737555′ scope=spfile;

计算controlfile size，dd 迁移raw device中的controlfile

2012-11-232012-09-11 by weejar zhang

Control Seq=53995=0xd2eb, File size=594=0x252
File Number=0, Blksiz=16384, File Type=1 CONTROL
Logical block number 1 (header block)

Script: 查看datafile 的HWM,估算resize 最小size

2014-03-052012-09-07 by weejar zhang

数据文件如果有2g，先create一个大表占了1G,后来建了个几M小表，再把大表drop 掉加purge选项，向把数据文件resize到100M，往往会失败，在磁盘紧张的情况下，想知道数据文件最小值是多少？就要计算datafile HWM

How to list all events?（oracle事件列表）

2012-09-06 by weejar zhang

其中有两个编号段比较特殊
1，错误编号-10000到-10999 不是真正的错误，是保留下来用于debug使用
2，错误编号-20000到-20999是自定义异常，错误信息最大2048B

hanganalyze 分析 dbms_ijob.broken无效的问题

2012-09-04 by weejar zhang

HANG ANALYSIS:
==============
Open chains found:
Chain 1 : :
<0/1777/32406/0x5275fca0/13913/SQL*Net message from client>
— <0/1477/37455/0x5275e4e8/16043/enq: TX - row lock contention>

ora-600 [3708] [910] internal error issue

2014-01-142012-09-03 by weejar zhang

SQL> shutdown immediate
ORA-00600: internal error code, arguments: [3708], [910], [], [], [], [], [], []

Basically this error is raised because LGWR timmed out.