本地oracle重启后ORA-00119: LOCAL_LISTENER ORA-00132: LISTENER_ORCL

ゞ浴缸里的玫瑰 2022-11-16 04:50 144阅读 0赞

oracle监听器和网络配置如下:

目录:2个配置文件均在oracle目录\\NETWORK\\ADMIN下  
tnsnames.ora--网络配置文件

\# tnsnames.ora Network Configuration File: oracle目录\\network\\admin\\tnsnames.ora  
\# Generated by Oracle configuration tools.

ORACLR\_CONNECTION\_DATA =  
  (DESCRIPTION =  
    (ADDRESS\_LIST =  
      (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC1521))  
    )  
    (CONNECT\_DATA =  
      (SID = CLRExtProc)  
      (GLOBAL\_NAME = Oracle8)  
      (PRESENTATION = RO)  
    )  
  )

ORCL =  
  (DESCRIPTION =  
    (ADDRESS\_LIST =  
      (ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521))  
    )  
    (CONNECT\_DATA =  
      (SERVICE\_NAME = 实例1)  
    )  
  )  
  ZSTY =  
  (DESCRIPTION =  
    (ADDRESS\_LIST =  
      (ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521))  
    )  
    (CONNECT\_DATA =  
      (SERVICE\_NAME = 实例2)  
    )  
  )  
    
LISTENER\_ORCL =(Address=(Protocol=tcp) (Host=主机名)(Port=1521))

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*我本地配置了2个实例\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

listener.ora--监听器配置

\# listener.ora Network Configuration File: E:\\app\\57362\\product\\11.2.0\\dbhome\_1\\network\\admin\\listener.ora  
\# Generated by Oracle configuration tools.

SID\_LIST\_LISTENER =  
  (SID\_LIST =  
    (SID\_DESC =  
      (SID\_NAME = CLRExtProc)  
      (ORACLE\_HOME = E:\\app\\57362\\product\\11.2.0\\dbhome\_1)  
      (PROGRAM = extproc)  
      (ENVS = "EXTPROC\_DLLS=ONLY:E:\\app\\57362\\product\\11.2.0\\dbhome\_1\\bin\\oraclr11.dll")  
    )  
    (SID\_DESC =  
      (GLOBAL\_DBNAME = 实例2)  
      (SID\_NAME =实例2)  
    )  
    (SID\_DESC =  
      (GLOBAL\_DBNAME = 实例1)  
      (SID\_NAME = 实例1)  
    )  
  )

LISTENER =  
  (DESCRIPTION\_LIST =  
    (DESCRIPTION =  
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))  
      (ADDRESS = (PROTOCOL = TCP)(HOST = Hohn)(PORT = 1521))  
    )  
  )

ADR\_BASE\_LISTENER = E:\\app\\57362

问题:重启电脑后

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3M1NzM2MjY4MjI_size_16_color_FFFFFF_t_70][]

监听器和网络名初始化失败,oracle实例启动失败

解决办法:  
编辑 init实例名.ora，我的实例是oracl，因此文件如下  
oracle目录/database/initorcl.ora--------------oracle11g

oracle目录/database/dbs/initorcl.ora--------------oracle10g  
修改如下:  
local\_listener='(ADDRESS\_LIST=(Address=(Protocol=tcp) (自己的主机名)(Port=152  
1)))’  
使用sqlplus连接后输入  
SQL>create spfile from pfile=’ oracle目录\\database\\initorcl.ora';  
启动  
SQL>startup

问题解决

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3M1NzM2MjY4MjI_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3M1NzM2MjY4MjI_size_16_color_FFFFFF_t_70]: /images/20221022/5dd2f714eefc43fd9f9562a8c125e004.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3M1NzM2MjY4MjI_size_16_color_FFFFFF_t_70 1]: /images/20221022/47e987d09427440f8ad5b245087b8b8d.png