Oracle不可用11g R2

Question

我在一个环境中安装了几个月的Oracle 11g R2，它在过去的几个月中运行良好，但本周，我在连接时出现错误。

我的环境：Windows 7 64位SP1

所以我试图调查：

这是我的听众。ora公司

    # listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
        )
        (SID_DESC =
          (SID_NAME = orcl)
          (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
          (GLOBAL_DBNAME=orcl)
        )
      )
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
          )
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.100.134)(PORT = 1521))
          )
        )
      )

    ADR_BASE_LISTENER = D:\app\Administrator\product\11.2.0\dbhome_1\log

我的tnsnames.ora

    # tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
    # Generated by Oracle configuration tools.

    ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
        (CONNECT_DATA =
          (SID = CLRExtProc)
          (PRESENTATION = RO)
        )
      )

    ORCL =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.100.134)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = orcl)
          (GLOBAL_NAME = orcl)
        )
      )

以下是我的调查过程：

1. 使用LSNRCTL检查监听器状态（抱歉我从中文翻译成英文）

    LSNRCTL> status
    Connect to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    Listener status
    ------------------------
    Alias                    LISTENER
    Version                  TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
    Start Date               24-12-2014 11:13:04
    Normal operation Time    0 day 0 hour 21 minute 32 second
    Trace Level              off
    Security                 ON: Local OS Authentication
    SNMP                     OFF
    Listener config file     D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
    Listener log file        d:\app\administrator\product\11.2.0\dbhome_1\log\diag\tnslsnr\1300313-PC\listener\alert\log.xml
    Listener summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.100.134)(PORT=1521)))
    Service Summary...
    service "PLSExtProc" has 1 execute process.
      execute process "PLSExtProc", status UNKNOWN, has 1 handler for this service...
    service "orcl" has 1 execute process.
      execute process "orcl", status UNKNOWN, has 1 handler for this service...
    command complete

    D:\app\Administrator\product\11.2.0\dbhome_1\BIN>tnsping orcl

    TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-12-2014 11:39:23

    Copyright (c) 1997, 2010, Oracle.  All rights reserved.

    Config file:
    D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

    Using TNSNAMES adaptor to parse alias
    try connecting (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.100.134)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl) (GLOBAL_NAME = orcl)))
    OK (40 msec)

    D:\app\Administrator\product\11.2.0\dbhome_1\BIN>sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.1.0 Production on Wednesday 12.24 11:43:17 2014
    Copyright (c) 1982, 2010, Oracle.  All rights reserved.
    Connect to idle execution process.
    SQL> startup
    ORA-00119: invalid specification for system parameter LOCAL_LISTENER
    ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
    SQL> exit
    disconnected

    D:\app\Administrator\product\11.2.0\dbhome_1\BIN>sqlplus scott/tiger@orcl
    SQL*Plus: Release 11.2.0.1.0 Production on Wednesday 12.24 11:44:01 2014
    Copyright (c) 1982, 2010, Oracle.  All rights reserved.
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Process ID: 0
    Session ID: 0 Sequence: 0

我的环境变量as

    D:\app\Administrator\product\11.2.0\dbhome_1\BIN>echo %ORACLE_HOME%
    D:\app\Administrator\product\11.2.0\dbhome_1
    D:\app\Administrator\product\11.2.0\dbhome_1\BIN>echo %ORACLE_SID%
    orcl

感谢如果有任何想法。

Answer 1

抱歉，我找到了有线的东西，oracle初始化配置丢失了。非常感谢你。