Oralce中的命令非常丰富,oerr命令是一个不错的辅助工具,很多看起来没有眉目的错误代码,可以让DBA很快定位问题的缘由,我们根本不需要去记有哪些ORA错误,除非那些错误已经完全和你的工作分不开。...绝大多数的命令都是二进制的形式,比如sqlplus我们可一窥其中的奥妙,oerr是一个shell脚本,而且实现原理也不难,我们来剖析一下,看看这个工具的设计思想。...[oracle@db117 ~]$ ll $ORACLE_HOME/bin/oerr -rwxr-xr-x 1 oracle oinstall 2567 Apr 23 2014 /U01/app/oracle.../product/11.2.0.4/bin/oerr 但是我就是喜欢折腾,所以无意中就打开了这个文件。...可以看到这个脚本的注释如下: # Usage: oerr facility error # # This shell script is used to get the description and
oerr ORA-2730* [oracle@p19c01 ~]$ oerr ORA 27300 27300, 00000, "OS system dependent operation:%s failed...status: %s" // *Cause: OS system call error // *Action: contact Oracle Support [oracle@p19c01 ~]$ oerr...message: %s" // *Cause: OS system call error // *Action: contact Oracle Support // [oracle@p19c01 ~]$ oerr...See: Oracle Linux: ORA-27301:OS Failure Message: No Buffer Space Available (Doc ID 2041723.1) ?...Notes:以下内容摘自:https://blog.csdn.net/zzt_2009/article/details/111436334 ★ 参数简述 该Linux系统参数的功能是用来设置一个最小内存空间给系统内核使用
bdump/orclls_p000_47020.trc: ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O Linux-x86...bdump/orclls_p002_47024.trc: ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O Linux-x86...directory Additional information: 3 Additional information: 128 Additional information: 65536 2、故障分析 #调用oerr...,没有获得比较有价值的信息,如下: suse11b:oracle:orcl102 > oerr ora 27090 27090, 00000, "Unable to reserve kernel resources...and Real Application Testing options ORACLE_HOME = /u01/app/oracle/product/10.2/db_1 System name: Linux
Linux下安装Oracle 11g,有时会提示一个错误: ? 提示是不能获取本地节点名。...使用oerr工具看看, oerr prvf 0002 0002, ERROR_LOCAL_NODENAME_NOT_FOUND, "Could not retrieve local nodename"
Keyword: ORA- , ERROR, ORACLE数据库错误 ,ORA-nnnn,oerr 概述 本文为数据库错误(如ORA-nnnn等)的概要和一般处理方法的介绍。...Oracle/Oracle Database/Release 12.2 Error Messages https://docs.oracle.com/database/122/ERRMG/toc.htm 2. oerr...oerr 例: 对于ORA-00001错误,可以通过如下查询:-bash-4.1$ oerr ora 1 00001, 00000, "unique constraint (...smgus.msg dgmus.msg impus.msg kgpus.msg nidus.msg qsmus.msg udeus.msg ORA-错误相关的文件为oraus.msg,在Linux
1、产生ORA-39125与ORA-04063 oracle@linux-ejad:~> export ORACLE_SID=SZ4701 oracle@linux-ejad:~> expdp \'\...SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 13:49:37 2、分析错误 oracle@linux-ejad:~> oerr ora 39125...--第一个ORA告诉我们是一个内部错误,联系Oracle Support oracle@linux-ejad:~> oerr ora 04063 04063, 00000, "%s has errors
~]$ cat /etc/issue Enterprise Linux Enterprise Linux Server release 5.5 (Carthage) Kernel \r on an \..."100.00% used" #下面我们来看看错误的解决方案是是什么 [oracle@linux1 usbo]$ oerr ora 19815 19815, 00000, "WARNING: %s of...[oracle@linux1 usbo]$ oerr ora 19809 19809, 00000, "limit exceeded for recovery files" //*Cause: The...archivelog]$ cd /u02/database/usbo #下面查看当前数据库对应闪回区的大小,仅仅242M [oracle@linux1 usbo]$ du -sh * 1.1G ...Oracle给出的解决方案来实施 #也就是说Oracle根本认为其闪回区的空间根本没有得到释放 [oracle@linux1 ~]$ sqlplus / as sysdba idle> startup
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 08-JUL-2014 17:05:49 Copyright (c) 1991, 2006,...TNSLSNR for Linux: Version 10.2.0.3.0 - Production System parameter file is /users/oracle/OraHome10g/...00:00:00 /users/oracle/OraHome10g/bin/tnslsnr listener_USBO2 -inherit 2、故障分析 oracle@sysreportDB:~> oerr...TNSNAMES.ORA file to change the // host name to a numeric IP address and try again. oracle@sysreportDB:~> oerr...Turn off tracing when the operation is complete. oracle@sysreportDB:~> oerr tns 00515 00515, 00000, "
| ' not found%' THEN 8 DBMS_OUTPUT.PUT_LINE(ERR_MSG); 9 END IF; 10 END LOOP; 11END; 12/ 在Linux...诊断事件可以像普通的ORA错误一样采用oerr命令来查询,如下所示: 1[oracle@orclalhr ~]$ oerr ora 10046 210046, 00000, "enable SQL...statement timing" 3// *Cause: 4// *Action: 5[oracle@orclalhr ~]$ oerr ora 10053 610053, 00000, "CBO...Enable optimizer trace" 7// *Cause: 8// *Action: 9[oracle@orclalhr ~]$ oerr ora 10704 1010704, 00000
:OCIStmtExecute Process ID: 10704 Session ID: 125 Serial number: 5 2、故障分析 --首先看看提示的几个ORA说什么 [oracle@linux1...~]$ oerr ora 1092 01092, 00000, "ORACLE instance terminated....--上面的 ora 1092通常由于shutdown abort导致,需要查看alert日志 [oracle@linux1 ~]$ oerr ora 12432 12432, 00000, "LBAC
TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux...TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux...Error: 32: Broken pipe oracle@SZDB:~> oerr ora 12537 12537, 00000, "TNS:connection closed" // *Cause...oracle@SZDB:~> oerr ora 12518 12518, 00000, "TNS:listener could not hand off client connection" // *Cause
1005 0 28009 28000 7 rows selected 查询这些值对应的相关错误信息: [oracle@JY-DB01 u01]$ oerr...SYS/ as SYSDBA or // connect SYS/ as SYSOPER // [oracle@JY-DB01 u01]$ oerr...has locked the account // *Action: Wait for PASSWORD_LOCK_TIME or contact DBA [oracle@JY-DB01 u01]$ oerr...[oracle@JY-DB01 u01]$ oerr ora 1005 01005, 00000, "null password given; logon denied" // *Cause: // *...Action: [oracle@JY-DB01 u01]$ oerr ora 2002 02002, 00000, "error while writing to audit trail" // *Cause
1.首先查下oerr给出的简要说明 2.查询V$RECOVERY_AREA_USAGE信息 3.根据实际空间剩余情况先适当增加归档目录的大小,保证先恢复业务 4.查看备份是否存在问题 1.首先查下oerr...给出的简要说明 oerr ora 257 00257, 00000, "archiver error.
1.查看报错信息 2.oerr查看该错误说明 3.尝试sqlplus连接到standby 4.尝试relocate监听 5.继续排查发现是参数问题 6.总结和延伸 1.查看报错信息 1)主库alert日志...2.oerr查看该错误说明 [oracle@bogon 2023_01_28]$ oerr ora 12514 12514, 00000, "TNS:listener does not currently...-------------------- Alias LISTENER_SCAN1 Version TNSLSNR for Linux...再次查看LISTENER_SCAN1监听状态,已经正常有服务注册了: [grid@db01rac1 admin]$ lsnrctl status LISTENER_SCAN1 LSNRCTL for Linux...-------------------- Alias LISTENER_SCAN1 Version TNSLSNR for Linux
一、问题分析 1、查看错误代码 通过 Oracle oerr 查看错误代码解释: 可以发现,ORA-600 是 Oracle 的内部错误,无法从错误代码提示上看出什么问题!...补丁安装所需介质如下: p20250147_112040_Linux-x86-64.zip p6880880_112000_Linux-x86-64.zip 补丁安装步骤 补丁安装的详细步骤可以查看补丁...2、替换最新的OPATCH补丁包(p6880880) unzip -o p6880880_112040_Linux-x86-64.zip -d $ORACLE_HOME 3、解压 20250147 补丁包...,并安装补丁 首先解压补丁包: unzip -d /soft p20250147_112040_Linux-x86-64.zip 安装补丁前检查: cd /soft/20250147 opatch prereq
现拥有Oracle OCP,OceanBase OBCA认证,擅长Oracle数据库运维开发,备份恢复,安装迁移,Linux自动化运维脚本编写等。...一、问题分析 1 通过Oracle oerr工具查看错误代码 ? 可以发现,ORA-2730x 显示是OS系统层面的错误。...通过查询MOS文档,发现该错误相符合的文档 Troubleshooting ORA-27300 ORA-27301 ORA-27302 Errors (Doc ID 579365.1) Oracle Linux
ERROR: ORA-12547: TNS:lost contact Enter user-name: ^C 使用oerr查看错误描述: [grid@dbm0dbadm01 ~]$ oerr ora...这个oerr的描述在这里有些迷惑性,我们知道实际新刷机环境也没有什么负载,根据经验查看基本信息: [grid@dbm0dbadm01 ~]$ ps -ef|grep pmon grid 138569
: ORA-04028: cannot generate diana for object gx_adm.IMP_BAT_ACC_AUTH_TMP_TBL 2、分析与解决 robin@SZDB:~> oerr...>没有发现任何对象被锁定 no rows selected --下面是来自metalink的信息,也没有看到什么可用的帮助信息,提示我们检查语法错误以及也是锁冲突 (Doc ID 19834.1)OERR...: ORA 4028 cannot generate diana for object (Doc ID 19834.1) OERR: ORA 4028 cannot generate diana
使用oerr简单先查看该错误号的说明: [oracle@oradb23 ~]$ oerr ora 27504 27504, 00000, "IPC error creating OSD context"...it is necessary to use the following init.ora parameter when using NAS with all versions of RAC on Linux
200G db_unrecoverable_scn_tracking boolean TRUE recovery_parallelism integer 0 [oracle@redhat3919 ~]$ oerr...[oracle@redhat3919 ~]$ oerr ora 01105 01105, 00000, "mount is incompatible with mounts by other instances
领取专属 10元无门槛券
手把手带您无忧上云