展开

关键词

ORA-27300,ORA-27301到ORA-00064

看是比较简单的一个问题,却遭遇了ORA-27300,ORA-27301。因为这个涉及到了有关内核参数kernel.sem的修改。下面是其具体描述。 -27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates 另外一篇与该错误有关Bug 5959853 - ORA-64 DURING DATABASE STARTUP WITH PROCESSES>6000. DocID:1457812.1

25310

重启数据库遇到错误ORA-27154,ORA-27300,ORA-27301,ORA-27302

processes 值为 8000 时, ipcs 可以看到 NSEMS 的数值是 8004,此时可以满足 8000 的 processes;设置 processes 值为 16000 时,启动数据库则报错 ORA -27154,ORA-27300,ORA-27301,ORA-27302;根据这个也没法确定两者的关系,但确实两者之间有所关联,而且算法还不简单,现在已经太晚了,只能等后续有时间再看了,晚安,小伙伴们! article/details/80743753 https://www.cnblogs.com/jyzhao/p/9124373.html Instance Startup Fails With Error ORA -27154,ORA-27300,ORA-27301,ORA-27302 (Doc ID 314179.1) Database Startup Fails with ORA-27300: OS system

25330
  • 广告
    关闭

    90+款云产品免费体验

    提供包括云服务器,云数据库在内的90+款云计算产品。打造一站式的云产品试用服务,助力开发者和企业零门槛上云。

  • 您找到你想要的搜索结果了吗?
    是的
    没有找到

    Oracle 12.2报错ORA-15032、ORA-15410或ORA-15411解决

    现象:在Oracle 12.2.0.1 RAC环境,在其ASM实例中,如果添加不同大小或者不同数量的LUN到failgroup中,会报错: ORA-15032: not all alterations performed ORA-15410: Disks in disk group OCRVT do not have equal size. 或者 ORA-15032: not all alterations performed ORA-15411: Failure groups in disk group OCRVT have different -15032: not all alterations performed ORA-15410: Disks in disk group OCRVT do not have equal size. mpathi'; alter diskgroup ocrvt add FAILGROUP OCRVT_0000 disk '/dev/mapper/mpathi' * ERROR at line 1: ORA

    81130

    HP-UX平台Oracle启动实例遭遇:ORA-27154,ORA-27300,ORA-27301,ORA-27302

    报错如下: ORA-27154:post/wait create failed ORA-27300:OS system dependent operation:semget failed with status : 28 ORA-27301:OS failure message: No space left on device ORA-27302:failure occurred at: sskgpcreates :semget failed with status: 28 (文档 ID 949468.1) Instance Startup Fails With Error ORA-27154,ORA-27300 ,ORA-27301,ORA-27302 (文档 ID 314179.1) 而这些文档的原因基本定位在sem相关的内核参数调整上。 -27154,ORA-27300,ORA-27301,ORA-27302,实例启动不成功,所以没有oracle用户的任何分配。

    6810

    ORA-00119,ORA-00132 错误处理

    --****************************** -- ORA-00119,ORA-00132 错误处理 --****************************** 最近系统启动时 ,收到了ORA-00119以及ORA-00132的错误,该错误实际上跟LISTENER有关,通常的处理办法是将spfile转储为pfile然后从pfile启动 并生成新的spfile,不过该操作方式代价太高 一.错误提示 SQL> startup nomount; ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_ODBP' 二、分析错误 1.查看错误号对应的具体描述 [oracle@odbp admin]$ oerr ora 00132 00132, 00000, "syntax error or unresolved network name '%s'" // *Cause: Listener

    56520

    Oracle expdp 时遭遇ORA-39125 ORA-04063

    数据库在使用DataPump导出时碰到了ORA-39125与ORA-04063。 1、产生ORA-39125与ORA-04063 oracle@linux-ejad:~> export ORACLE_SID=SZ4701 oracle@linux-ejad:~> expdp \'\ -04063: view "SYS.KU$_CLUSTER_VIEW" has errors ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-06512 --第一个ORA告诉我们是一个内部错误,联系Oracle Support oracle@linux-ejad:~> oerr ora 04063 04063, 00000, "%s has errors --第二个ORA给出了相对比较具体一些的信息,执行过程或使用试图时有一些错误发生。

    37110

    ORA-19815,ORA-19809 :limit exceeded for recovery files

    数据库重新启动的时候,收到了ORA-19815的错误。从错误的提示来看,是由于闪回区的空间被填满导致无法成功启动。这种情形我们通常考虑的是清除归档日志,那就直接在OS层面rm了,真的是这样吗? ORA-03113: end-of-file on communication channel Process ID: 3562 Session ID: 125 Serial number: 5 Fri pid=27, OS id=4231 Errors in file /u02/database/usbo/diag/rdbms/usbo/usbo/trace/usbo_ora_4205.trc: ORA ******************* Errors in file /u02/database/usbo/diag/rdbms/usbo/usbo/trace/usbo_ora_4205.trc: ORA -16038: log 3 sequence# 12 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312:

    23830

    无法成功执行catalog.sql,ORA-04045 ORA-04064

    一、故障现象 --后台alert log日志出现大量的ORA-00604,ORA-04045的错误信息 Tue Nov  5 14:14:02 2013 Errors in file /u02/database /XA4701/udump/XA4701_ora_30871.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS ORA-04064: not executed, invalidated ORA-04064 unit being called: "LBACSYS.LBAC_EVENTS" ORA-06512: at line 2 ORA-06508: PL/SQL: could not find program ORA-04064: not executed, invalidated package body "LBACSYS.LBAC_EVENTS" ORA-06508: PL/SQL: could not

    39430

    【故障处理】ORA-31600和ORA-04063错误

    今天小麦苗给大家分享的是【故障处理】ORA-31600和ORA-04063错误。 【故障处理】ORA-31600和ORA-04063错误 有朋友在执行drop操作时,报了如下的错误,经过查询mos文档和远程协助最后终于处理了,记录下。 ORA-00604: error occurred at recursive SQL level 1 ORA-31600: invalid input value COMPATIBLE for parameter VERSION in function GET_DDL ORA-06512: at "SYS.DBMS_METADATA", line 5805 ORA-06512: at "SYS.DBMS_METADATA ", line 8344 ORA-06512: at line 1 ORA-06512: at line 10 ERROR at line 1: ORA-00604: error occurred at

    38020

    ORA-01092 ORA-12432: LBAC error: zllegnp:OCIStmtExecute 故障一例

    最近由于数据库hang住,无奈之下直接干掉了pmon进程,再次启动的时候收到了ORA-01092: ORACLE instance terminated. Disconnection forced以及ORA-12432: LBAC error: zllegnp:OCIStmtExecute。这下好了,有的整了,是个从来没有遇见的错误。 ORA-01092: ORACLE instance terminated. Serial number: 5 2、故障分析 --首先看看提示的几个ORA说什么 [oracle@linux1 ~]$ oerr ora 1092 01092, 00000, "ORACLE instance --上面的 ora 1092通常由于shutdown abort导致,需要查看alert日志 [oracle@linux1 ~]$ oerr ora 12432 12432, 00000, "LBAC

    28110

    RMAN duplicate from active 时遭遇 ORA-17627 ORA-12154

    最近在从活动数据库进行异机克隆时碰到了ORA-17629,ORA-17627,ORA-12154的错误,起初以为是一个Bug呢。Oracle Bug着实太多了,已经成了习惯性思维了。汗! ' auxiliary format      '/u01/oracle/db_1/dbs/spfilesybo3.ora'   ;        sql clone "alter system set -17629: Cannot connect to the remote database server                            ORA-17627: ORA-12154 -03009     其次是ORA-17629,不能连接到远程数据库服务器,ORA-17627后跟着ORA-12154,说明是由于无法解析字符串     下面来看看ORA-17629到底是什么问题     connect to the remote database server     ORA-17627: ORA-12154: TNS:could not resolve the connect identifier

    82820

    数据导入时遭遇 ORA-01187 ORA-01110

    最近的数据导入(IMP)时碰到了ORA-01187 ORA-01110 错误,由于这个数据库是使用热备恢复过来的,且恢复也是成功的,因为数据库能够成功open,那到底是哪里有遗漏呢? 1、故障现象 IMP-00003: ORACLE error 1187 encountered ORA-01187: cannot read from file 202 because it failed verification tests ORA-01110: data file 202: '/u02/database/EC0320/temp/EC0320_tempEC0320.dbf' IMP-00017 /database/EC0320/temp/tempEC0320.dbf' 2、故障分析 --上面的ORA错误时和临时表空间数据文件有关的错误,无法读取temp数据文件 --查看一下ora-01187错误信息描述 之类的错误,最快的了解错误的详细信息是系统命令提示符下输入oerr ora <err_no> c、相关临时表空间的文章可参考: 临时表空间的管理与受损恢复 收缩临时表空间

    53730

    impdp ORA-39002,ORA-39166,ORA-39164的问题及解决(r2第6天)

    SKIP_CONSTRAINT_ERRORS With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA -39002: invalid operation ORA-39166: Object MIG_TEST.MO1_MEMO was not found. ORA-39164: Partition MIG_TEST.MO1_MEMO:P9_A0_E5 was not found. 尝试了各种方法。还是没有效果。

    91570

    【已解决】ORA-01034: ORACLE not available ORA-27101

    回车再输入startup,回车.这步是启动oracle服务。如果startup启动被告知已经启动了,可以先输入shutdown immediate;等shutd...

    2.2K20

    ORA-00392 ORA-00312 日志正在清除故障

    最近在还原Oracle数据库后open的时候碰到了ORA-00392: log 3 of thread 1 is being cleared, operation not allowed,其字面含义则是日志文件正在被清除 一、故障现象 SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00392 : log 3 of thread 1 is being cleared, operation not allowed ORA-00312: online log 3 thread 1: '/oradata /sincnet/redo03.log' -- 查看故障描述信息 SQL> ho oerr ora 00392 00392, 00000, "log %s of thread %s is being Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE

    43020

    ORA-01658 错误

    --****************** -- ORA-01658 错误 --****************** 最近重新装个了Oracle 11g,在对分区表导入导出时碰到了ORA-01658错误的问题 -31626: job does not exist ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user SCOTT ORA-06512 : at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT_INT", line 798 ORA-39244: Event to disable ORA-06512: at "SYS.KUPC$QUE_INT", line 1825 ORA-02320: failure in creating storage table for nested > ho oerr ora 31637 -- ORA-31637不能创建作业 31637, 00000, "cannot create job %s for user %s" // *Cause:

    34820

    记录一则ORA-00054,ORA-00031解决过程

    普通表改造分区表,历史数据不要 这个需求很简单: pl/sql导出建表语句,依次修改成分区的建表语句,注意将索引修改成本地索引; drop 原表; create 新分区表. 1.重建过程中遇到问题:删除某表时报错ORA by ……(……); create unique index …… on MOD_RESALT_PERF_CARR_1X_ZTE(……) local tablespace …… compress; ORA -00054: resource busy and acquire with NOWAIT specified ORA-00955: name is already used by an existing object ORA-14016: underlying table of a LOCAL partitioned index must be partitioned 2.查询造成此表锁定的会话。 marked for kill 此状态下,若drop 此表仍然会报错ORA-00054。

    52120

    Oracle ADG备库SYSAUX数据文件坏块恢复处理(ORA-00600,ORA-10567,ORA-10564......

    本文阐述了Oracle ADG备库SYSAUX数据文件坏块恢复处理(ORA-00600,ORA-10567,ORA-10564,ORA-01110,ORA-10561)的思路、步骤、解决方案。 -10564: tablespace SYSAUX ORA-01110: data file 3: '+DATA/TESTDBDG/DATAFILE/sysaux.268.1081620609' ORA -10564: tablespace SYSAUX ORA-01110: data file 3: '+DATA/TESTDBDG/DATAFILE/sysaux.268.1081620609' ORA -10564: tablespace SYSAUX ORA-01110: data file 3: '+DATA/TESTDBDG/DATAFILE/sysaux.268.1081620609' ORA -10564: tablespace SYSAUX ORA-01110: data file 3: '+DATA/TESTDBDG/DATAFILE/sysaux.268.1081620609' ORA

    11820

    RAC某节点启动遭遇ORA-01105,ORA-01606

    1.故障现象 2.解决过程 3.总结 1.故障现象 尝试启动RAC 节点1,遭遇ORA-01105,ORA-01606: SQL> startup mount; ORACLE instance started 5.0197E+10 bytes Database Buffers 4.4560E+10 bytes Redo Buffers 109174784 bytes ORA -01105: mount is incompatible with mounts by other instances ORA-01606: parameter not identical to that of another mounted instance 数据库节点1目前状态是NOMOUNT. 2.解决过程 错误代码说明: $ oerr ora 1105 01105, 00000, "mount SQL> shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down.

    46110

    oracle--ORA常见报错 常见错误地址ORA-01034和ORA-27101的解决办法

    常见错误地址 http://ora-12xyz.com/error/ora-01911 ORA-01034和ORA-27101的解决办法 出现ORA-01034和ORA-27101的原因是多方面的:主要是 这样数据库就正常启动了,就不会报ORA-01034和ORA-27101两个启动异常了。 recover database until time '2019-01-14 09:00:00' alter database open resetlogs; shutdown startup ORA

    81940

    相关产品

    • 云服务器

      云服务器

      云端获取和启用云服务器,并实时扩展或缩减云计算资源。云服务器 支持按实际使用的资源计费,可以为您节约计算成本。 腾讯云服务器(CVM)为您提供安全可靠的弹性云计算服务。只需几分钟,您就可以在云端获取和启用云服务器,并实时扩展或缩减云计算资源。云服务器 支持按实际使用的资源计费,可以为您节约计算成本。

    相关资讯

    热门标签

    扫码关注云+社区

    领取腾讯云代金券