IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    ORA-27300 ORA-27301 ORA-27302

    惜分飞发表于 2016-10-29 03:07:48
    love 0

    联系:手机(+86 13429648788) QQ(107644445)QQ咨询惜分飞

    标题:ORA-27300 ORA-27301 ORA-27302

    作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

    有朋友库中alert日志报ORA-27300 ORA-27301 ORA-27302错误,让帮忙分析原因
    ORA-27300 ORA-27301 ORA-27302

    Fri Oct 28 22:15:33 2016
    Process startup failed, error stack:
    Errors in file d:\app\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_psp0_4856.trc:
    ORA-27300: OS system dependent operation:CreateThread failed with status: 8
    ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
    ORA-27302: failure occurred at: ssthrddcr
    Fri Oct 28 22:15:34 2016
    Process J001 died, see its trace file
    kkjcre1p: unable to spawn jobq slave process 
    Errors in file d:\app\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_cjq0_5664.trc:
    Fri Oct 28 22:16:35 2016
    Process startup failed, error stack:
    Errors in file d:\app\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_psp0_4856.trc:
    ORA-27300: OS system dependent operation:CreateThread failed with status: 8
    ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
    ORA-27302: failure occurred at: ssthrddcr
    Fri Oct 28 22:16:36 2016
    Process J001 died, see its trace file
    kkjcre1p: unable to spawn jobq slave process 
    Errors in file d:\app\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_cjq0_5664.trc:
    Fri Oct 28 22:17:36 2016
    Process startup failed, error stack:
    Errors in file d:\app\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_psp0_4856.trc:
    ORA-27300: OS system dependent operation:CreateThread failed with status: 8
    ORA-27301: OS failure message: 存储空间不足,无法处理此命令。
    ORA-27302: failure occurred at: ssthrddcr
    

    系统版本win 2008 32位
    os


    系统状态
    os2

    数据库版本
    version

    数据库内存配置
    db-memory

    新会话无法连接

    28-10月-2016 22:46:59 * (CONNECT_DATA=(SID=xifenfei)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.91.5)(PORT=54383)) * establish * xifenfei * 12518
    TNS-12518: TNS: 监听程序无法分发客户机连接
     TNS-12560: TNS: 协议适配器错误
    28-10月-2016 22:46:59 * (CONNECT_DATA=(SID=xifenfei)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.91.5)(PORT=54384)) * establish * xifenfei * 12518
    TNS-12518: TNS: 监听程序无法分发客户机连接
     TNS-12560: TNS: 协议适配器错误
    28-10月-2016 22:46:59 * (CONNECT_DATA=(SID=xifenfei)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.91.5)(PORT=54385)) * establish * xifenfei * 12518
    TNS-12518: TNS: 监听程序无法分发客户机连接
     TNS-12560: TNS: 协议适配器错误
    28-10月-2016 22:46:59 * (CONNECT_DATA=(SID=xifenfei)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.91.5)(PORT=54386)) * establish * xifenfei * 12518
    TNS-12518: TNS: 监听程序无法分发客户机连接
     TNS-12560: TNS: 协议适配器错误
    28-10月-2016 22:46:59 * (CONNECT_DATA=(SID=xifenfei)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.91.5)(PORT=54388)) * establish * xifenfei * 12518
    TNS-12518: TNS: 监听程序无法分发客户机连接
     TNS-12560: TNS: 协议适配器错误
    28-10月-2016 22:46:59 * (CONNECT_DATA=(SID=xifenfei)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.91.5)(PORT=54389)) * establish * xifenfei * 12518
    TNS-12518: TNS: 监听程序无法分发客户机连接
     TNS-12560: TNS: 协议适配器错误
    28-10月-2016 22:46:59 * (CONNECT_DATA=(SID=xifenfei)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.91.5)(PORT=54390)) * establish * xifenfei * 12518
    TNS-12518: TNS: 监听程序无法分发客户机连接
     TNS-12560: TNS: 协议适配器错误
    28-10月-2016 22:47:00 * (CONNECT_DATA=(SID=xifenfei)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.91.5)(PORT=54391)) * establish * xifenfei * 12518
    TNS-12518: TNS: 监听程序无法分发客户机连接
     TNS-12560: TNS: 协议适配器错误
    

    20161028224020


    故障处理

    HKEY_LOCAL_MACHINE SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
    
    Value Name: IRPStackSize
    Data Type: DWORD
    The default value of the IRPStackSize parameter is 15. The range is from 11 (0xb hexadecimal) through 50 (0x32 hexadecimal).
    

    register


    参考:Ora-27300: OS System Dependent Operation:Createthread Failed With Status: 8 (Doc ID 1310453.1)

    • VMware vSphere6.0 初试
    • dbca创建数据库报ORA-00443
    • TNS-12525 TNS-12535 TNS-12606
    • RAC Failover三种方式
    • Enterprise Manager Database Express 12c 欣赏
    • vSphere ssh登陆配置
    • _OFFLINE_ROLLBACK_SEGMENTS/_CORRUPTED_ROLLBACK_SEGMENTS
    • 单网卡绑定多IP导致TNS-12542等错误
    • 12.1中出现大量Result Cache: RC Latch处理
    • ORA-28040: No matching authentication protocol
    • RAC负载均衡配置
    • 因IPC导致多个监听不能正常启动


沪ICP备19023445号-2号
友情链接