ora
关注
分享
扫一扫
文章平均质量分 81
rgb_rgb
dba
展开
-
expdp 问题和 ORA-00600: internal error code, arguments: [25027], [6], [0], [], [], [], [], [], [], [],
Export: Release 11.2.0.4.0 - Production on Thu Nov 30 17:12:48 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition原创 2017-11-30 18:28:04 · 1933 阅读 · 0 评论 -
系统HANG住分析工具及方法
如果系统HANG住了，这个时候做一个SYSTEM STATE DUMP，对于分析HANG的原因十分重要。但是很多情况下，系统HANG住了就无法登录，那么如何进行分析呢？METALINK DOC :359536.1提供了一些好的办法，在这里和大家共享：支持的数据库版本：9.2.0.1-10.2平台（部分是UNIX平台，部分适用于所有平台）1、10G以前，使用DBX,G原创 2014-04-18 14:52:31 · 4430 阅读 · 0 评论 -
ORA-00600: [2662]、 [4097]
P720:/u01/app_new/product/11.2/dbs$sqlplus / as sysdbaConnected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 3.7413E+10 bytesFixed Size原创 2013-06-03 00:24:10 · 1617 阅读 · 0 评论 -
errorstack 工具介绍
原文：http://www.orafan.net/blog/223.html/comment-page-1#comment-131.alter system set event ：此方法对spfile生效，无法对memory生效SQL> ALTER system SET event='1461 trace name errorstack level 3';ALTER system转载 2013-01-03 13:43:34 · 3089 阅读 · 2 评论 -
ORA-04021: timeout occurred while waiting to lock object
ORA-04021: timeout occurred while waiting to lock object原创 2014-02-02 11:29:20 · 1374 阅读 · 0 评论 -
20121225_不完全恢复记录(rman)
restore controlfile from '/orabak/AutoCtl_SGERP5_20121222_c-3580899532-20121222-00';oracle:srvctl add database -d sgerp5 -o /u01/app/product/11.2--检查备份状态目录权限rman:list backup;P550:/u01/app/pr原创 2012-12-25 23:32:24 · 7965 阅读 · 5 评论 -
文件系统异机恢复到ASM中
文件系统异机恢复到ASM中源端：操作系统：Red Hat Enterprise Linux Server release 5.5 (Tikanga)数据库：11.2.0.3使用文件系统目标：操作系统：Enterprise Linux Enterprise Linux Server release 5.8 (Carthage)数据库：11.2.0.3使用ASM原创 2013-11-27 13:46:11 · 1582 阅读 · 1 评论 -
20130601 RMAN异机不完全恢复记录
AIX6.1,11.2.0.3 #############添加隐含参数################*._allow_resetlogs_corruption=true*._allow_error_simulation=truealter system set "_allow_error_simulation"=true scope=spfile;alter system原创 2013-06-01 20:12:11 · 3285 阅读 · 0 评论 -
Unexpected error occurred while trying to check for group existence.
Cause:Unexpected error occurred while trying to check for group existence. Action:Refer to the logs or contact Oracle Support Services. Note for advanced users: Launch the installer by passing原创 2013-11-23 18:00:31 · 2972 阅读 · 0 评论 -
ORA-01591: lock held by in-doubt distributed transaction 22.10.18863
ORA-01591: lock held by in-doubt distributed transaction 22.10.18863Fri Apr 04 13:53:49 2014DISTRIB TRAN 44444444.DFA786C45D1C944F97483DAF3B2517E400000000 is local tran 22.10.18863 (hex=16.原创 2014-04-04 14:29:12 · 1302 阅读 · 0 评论 -
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP --总的使用情况 select tablespace_name,current_users,total_extents,used_extents,free_extents from v$sort_segment; --原创 2014-06-17 10:58:19 · 3387 阅读 · 0 评论 -
strace sqlplus
11045 22:54:27.292728 execve("/u01/app/product/11.2.0/dbhome_1/bin/sqlplus", ["sqlplus", "/as sysdba"], [/* 40 vars */]) = 0 11045 22:54:27.293739 brk(0) = 0x1bca000 11045 22:54:27.294223原创 2017-06-02 23:00:16 · 1450 阅读 · 0 评论 -
strace tnsping
10919 22:43:11.828322 execve("/u01/app/product/11.2.0/dbhome_1/bin/tnsping", ["tnsping", "t127"], [/* 40 vars */]) = 0 10919 22:43:11.829246 brk(0) = 0xb0f000 10919 22:43:11.829661 mmap原创 2017-06-02 22:49:49 · 548 阅读 · 1 评论 -
模拟坏块及rman恢复坏块测试（二）
损坏发生在只有归档，没有备份的数据库中该如何操作：DBV只报告物理损坏，validate check logical database可以验证物理损坏和逻辑损坏，执行VALIDATE命令后通过查询V$DATABASE_BLOCK_CORRUPTION视图可以获得坏块的详细信息，块被修复后V$DATABASE_BLOCK_CORRUPTION中相应的记录会被删除。该命令只能运行在归档原创 2016-09-21 10:30:13 · 589 阅读 · 0 评论 -
模拟坏块及rman恢复坏块测试（一）
准备：create table t_block(id integer primary key,name varchar2(10)); insert into t_block values(1,'tcaaaa a'); insert into t_block values(2,'ad阿@奥迪'); insert into t_block values(3,'ABa$23省道')原创 2016-09-20 18:08:38 · 800 阅读 · 1 评论 -
ORA-01555
问题：Tue Sep 06 08:50:15 2016ORA-01555 caused by SQL statement below (SQL ID: c3w7vx7m9zuw4, Query Duration=46697 sec, SCN: 0x0cef.8558a045):select * from ( SELECT c.CardCode »áÔ±¿原创 2016-09-06 16:03:16 · 423 阅读 · 0 评论 -
[INS-40406] 未检测到现有的 Oracle Grid Infrastructure 软件
问题：11.2.0.3升级到11.2.0.4，报错：解决：# cat /etc/oraInst.locinventory_loc=/u01/oraInventoryinst_group=oinstall# pwd/u01/oraInventory/ContentsXML# more inventory.xml原创 2016-05-27 22:20:59 · 1229 阅读 · 0 评论 -
ORA-19505: failed to identify file "/orabak/expdp/TB201411.dmp"
[oracle@erpcrmtest expdp]$ impdp userid=\"/ as sysdba\" DIRECTORY=DATA_EXP parallel=8 DUMPFILE=TB201411.dmp logfile=impdp_TB201411.logImport: Release 11.2.0.3.0 - Production on Tue Dec 16 09:12:40 201原创 2014-12-16 09:32:04 · 3461 阅读 · 0 评论 -
WARNING: inbound connection timed out (ORA-3136)
$sqlplus devcrm/adsfee@crmSQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 14 09:40:58 2014Copyright (c) 1982, 2011, Oracle. All rights reserved.ERROR:ORA-01017: invalid usernam原创 2014-07-14 10:12:44 · 2040 阅读 · 0 评论 -
move table and purge table
ALTER TABLE "xxx".xxx COMPRESS FOR OLTP;ALTER TABLE "xxx".xxx MOVE TABLESPACE ERP2012;PURGE TABLE "BIN$04LhcpndanfgMAAAAAANPw==$0";purge index in_test1_01;PURGE TABLESPACE USER;PURGE TAB原创 2013-11-06 18:29:31 · 1045 阅读 · 1 评论 -
latch: cache buffers chains
latch: cache buffers chains转载 2013-10-18 23:07:49 · 1890 阅读 · 3 评论 -
模拟当前redo日志损坏
SQL> create table tb1 as select * from dba_tables;Table created.SQL> insert into tb1 select * from tb1;27206 rows created.SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTE原创 2013-09-25 14:37:11 · 2740 阅读 · 0 评论 -
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Thu Dec 20 15:40:18 2012Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 3WARNING: db_recovery_file_dest is same as db_create_原创 2012-12-20 03:56:19 · 2813 阅读 · 2 评论 -
11.2.0.3+ASM 安装报 ohasd failed to start
# /g01/grid/asm/root.shPerforming root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /g01/grid/asmEnter the full pathna原创 2012-12-27 21:24:02 · 9346 阅读 · 0 评论 -
aix 6.1 安装 oracle 11gR2 报java错误解决方法
sys-/tools/database >./runInstallerStarting Oracle Universal Installer...Checking Temp space: must be greater than 190 MB. Actual 7005 MB PassedChecking swap space: must be greater than 150原创 2012-11-22 23:04:36 · 1490 阅读 · 0 评论 -
ORA-02049: 超时: 分布式事务处理等待锁
02049, 00000, "timeout: distributed transaction waiting for lock"// *Cause: exceeded INIT.ORA distributed_lock_timeout seconds waiting for lock.// *Action: treat as a deadlockDISTRIBUTED_LOCK_原创 2012-11-30 22:27:52 · 17150 阅读 · 2 评论 -
ORA-00845: MEMORY_TARGET not supported on this system
Elapsed: 00:00:00.00SQL> alter system set memory_max_target=20288M scope=spfile; System altered.Elapsed: 00:00:00.02SQL> alter system set memory_target=20288M scope=spfile; System alte原创 2012-09-14 16:52:27 · 804 阅读 · 0 评论 -
ORA错误记录
2012-9-7 10:43:03：Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_21692692.trc (incident=842436):ORA-00600: 内部错误代码, 参数: [kdoirp-1], [2], [], [], [], [], [], []Incident details原创 2012-09-08 14:40:45 · 1599 阅读 · 0 评论 -
ORA-04030: 在尝试分配 55813624 字节 (Typecheck,qry_text : qcpisqt) 时进程内存不足
Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_22348042.trc (incident=841652):ORA-04030: 在尝试分配 55813624 字节 (Typecheck,qry_text : qcpisqt) 时进程内存不足Incident details in: /oracle/dia原创 2012-09-08 14:01:44 · 1562 阅读 · 0 评论 -
ORA-29701: unable to connect to Cluster Synchronization Service
[grid@test170 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 3 14:36:19 2012Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to an idle instance.原创 2012-09-03 14:45:13 · 11640 阅读 · 0 评论 -
CRS-4639: Could not contact Oracle High Availability Services
P720:/home/grid&sqlplus / as sysasmSQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 4 11:24:19 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to an idle instance.SQL> s原创 2013-01-05 00:37:29 · 13722 阅读 · 1 评论 -
ORA-00845: MEMORY_TARGET not supported on this system
SQL> startup nomount;ORA-00845: MEMORY_TARGET not supported on this systemSQL> alert_log:Wed Mar 13 10:38:04 2013Adjusting the default value of parameter parallel_max_serversfrom 160 to 13原创 2013-03-13 10:50:39 · 931 阅读 · 0 评论 -
SYSAUX表空间中的WRH$_SQLTEXT，WRH$_SQL_PLAN 移动LOBSEGMENT类型
SELECT A.TABLE_NAME, A.COLUMN_NAME, B.SEGMENT_NAME, B.SEGMENT_TYPE, B.TABLESPACE_NAME, B.BYTES / 1024 / 1024, B.BLOCKS,原创 2013-07-23 11:30:06 · 2601 阅读 · 0 评论 -
RMAN-06094: datafile 209 must be restored
--错误信息RMAN-06094: datafile 209 must be restoredSQL> ALTER DATABASE CREATE DATAFILE 209;ALTER DATABASE CREATE DATAFILE 209*ERROR at line 1:ORA-01111: name for data file /u01/app_new/produ原创 2013-05-31 17:26:40 · 7597 阅读 · 0 评论 -
ORA-27140: attach to post/wait facility failed
P720:/u01/app_new/product/11.2/bin$rman target /Recovery Manager: Release 11.2.0.3.0 - Production on Thu May 30 20:14:51 2013Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights res原创 2013-05-30 21:05:44 · 4563 阅读 · 0 评论 -
20121218_异机恢复记录
总结：1.控制文件名称2.备份权限、目录、状态3.注册数据库4.asm操作：run{allocate channel cha1 type disk;allocate channel cha2 type disk;allocate channel cha3 type disk;allocate channel cha4 type disk;allocate c原创 2012-12-19 14:31:48 · 1613 阅读 · 4 评论 -
ORA-29701: unable to connect to Cluster Synchronization Service
SQL*Plus: Release 11.2.0.3.0 Production on Mon May 6 17:18:19 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to an idle instance.SQL> startupORA-01078: failure in process原创 2013-05-06 17:31:54 · 1064 阅读 · 0 评论 -
ORA-01591: lock held by in-doubt distributed transaction
ORA-01591: lock held by in-doubt distributed transaction 14.19.171170> select LOCAL_TRAN_ID,STATE,COMMIT# from dba_2pc_pending;LOCAL_TRAN_ID STATE COMMIT#--------------------原创 2013-05-01 01:26:29 · 1343 阅读 · 0 评论 -
ORA-00018: maximum number of sessions exceeded
现象：*** 2013-04-11 16:50:00.413*** SESSION ID:(874.1) 2013-04-11 16:50:00.413*** CLIENT ID:() 2013-04-11 16:50:00.413*** SERVICE NAME:(SYS$BACKGROUND) 2013-04-11 16:50:00.413*** MODULE NAME原创 2013-04-12 00:04:00 · 2287 阅读 · 0 评论 -
ORA-19815: WARNING: db_recovery_file_dest_size of 36676042752 bytes is 100.00% used
Fri Mar 29 13:25:48 2013Errors in file /u01/app/oracle/diag/rdbms/sg01/sgerp5/trace/sgerp5_m000_15862.trc:ORA-19815: WARNING: db_recovery_file_dest_size of 36676042752 bytes is 100.00% used, and h原创 2013-03-29 13:40:12 · 3128 阅读 · 4 评论