Oracle 12.2监听无法启动解决一例

在自己的虚拟机的做实验,突然发现使用PL/SQL Developer无法连接到数据库,报错ORA-12514,说是监听没有启动。

先介绍虚拟机一下环境:RedHat7.2+GI 12.2.0.1+Oracle 12.2.0.1,为了测试12.2的ASM特性安装了GI。平时监听程序默认是开启启动的。但是今天不知道为什么没有启动。使用crsctl查看资源状态:发现监听的状态确实是OFFLINE状态

[root@rhel7 .oracle]# crsstat

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details       

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE       rhel7                    STABLE

ora.LISTENER.lsnr

               ONLINE  OFFLINE      rhel7                    STABLE

ora.asm

               ONLINE  ONLINE       rhel7                    Started,STABLE

ora.ons

               OFFLINE OFFLINE      rhel7                    STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       rhel7                    STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.driver.afd

      1        ONLINE  ONLINE       rhel7                    STABLE

ora.evmd

      1        ONLINE  ONLINE       rhel7                    STABLE

ora.ora12c.db

      1        ONLINE  ONLINE       rhel7                    Open,HOME=/u01/app/o

                                                             racle/product/12.2/d

                                                             b_home1,STABLE

--------------------------------------------------------------------------------

尝试手动启动监听,依然报错:
[grid@rhel7 ~]$ srvctl start listener
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-5016: Process "/u01/app/grid/bin/lsnrctl" spawned by agent "ORAAGENT" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/12.2/grid/diag/crs/rhel7/crs/trace/ohasd_oraagent_grid.trc"
CRS-5016: Process "/u01/app/grid/bin/lsnrctl" spawned by agent "ORAAGENT" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/12.2/grid/diag/crs/rhel7/crs/trace/ohasd_oraagent_grid.trc"
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'rhel7' failed

根据提示查看trc文件,看到如下报错:
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-NOV-2017 20:03:28
 
Copyright (c) 1991, 2016, Oracle.  All rights reserved.
 
Starting /u01/app/grid/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/grid/network/admin/listener.ora
Log messages written to /u01/app/12.2/grid/diag/tnslsnr/rhel7/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel7)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12555: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
  TNS-00525: Insufficient privilege for operation
  Linux Error: 1: Operation not permitted
 
Listener failed to start. See the error message(s) above...

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/b519081f7b790f4a56b283c67c6d7ad0.html