收藏本站 收藏本站
积木网首页 - 软件测试 - 常用手册 - 站长工具 - 技术社区
首页 > 数据库 > Oracle > 正文

首页 - PHP - 数据库 - 操作系统 - 游戏开发 - JS - Android - MySql - Redis - MongoDB - Win8 - Shell编程 - DOS命令 - jQuery - CSS样式 - Python - Perl

Access - Oracle - DB2 - SQLServer - MsSql2008 - MsSql2005 - Sqlite - PostgreSQL - node.js - extjs - JavaScript vbs - Powershell - Ruby

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...

看到Insufficient privilege for operation这个字样觉得很纳闷,怎么会权限不足呢,于是尝试用root直接启动监听,依然报错:

[root@rhel7 .oracle]# lsnrctl start
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-NOV-2017 20:22:30
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/grid/bin/tnslsnr: please wait...
TNS-12546: TNS:permission denied
 TNS-12560: TNS:protocol adapter error
 TNS-00516: Permission denied
  Linux Error: 13: Permission denied

于是各种百度,下面把百度到内容列出来,可能会对看此文的同学有用,但是对我这种情况没有用:
主要是说 /var/tmp/.oracle、/tmp/.oracle 这两个目录的权限访问问题。 进入 一看,我的/var/tmp/.oracle权限 没问题,而/tmp/.oracle压根就没有这个文件。

于是直接查MOS,看有没有相关的文档,找到两篇文档:

Starting the Listener Fails With: TNS-12557 or TNS-12555: TNS:Permission Denied (文档 ID 343253.1)
Listener Fails To Start With IPC Permission Errors (TNS-12546 TNS-12555 TNS-00516 TNS-00525) (文档 ID 434062.1)

对比了文档中列出的问题,跟我的情况也不一相,看到最后发现这样一句话:

4. If you find that there are no adapters linked or they have errors (such as "Permission denied") then issue a "relink all"

Reference:
Doc ID 1467060.1

于是只有用这种方法来试试了,由于crs使用的是grid home下的监听命令所以对grid home做relink all操作。可是又出现报错:

[grid@rhel7 bin]$ relink all
 The Oracle home in which you are running this relinking tool does not 
have proper write permissions. Please run this relink script as the same
user who owns the Oracle home and ensure that the Oracle home has the
permissions from the original installation.
 If this is a Grid Infrastructure home, please refer to the 
documentation for the proper steps to relink and apply oneoff patches.

意思是说权限不足,使用root执行,又报错说不能用root执行

[root@rhel7 bin]# relink all
The relink script cannot be run as root.

又查看grid home目录权限

[root@rhel7 app]# ls -ld grid
total 8
drwxr-x--- 84 root  oinstall 4096 Jul 18 20:26 grid

原来owner是root,怪不得第一次执行不成功,修改owner(应该直接chmod也可以,这里没有做测试),重新执行relink all

[root@rhel7 app]# chown grid grid
[grid@rhel7 ~]$ relink all
writing relink log to: /u01/app/grid/install/relink.log

成功后再次启动监听,启动成功。

[grid@rhel7 ~]$ lsnrctl start
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-NOV-2017 20:50:59
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)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rhel7)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias           LISTENER
Version          TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date        15-NOV-2017 20:51:00
Uptime          0 days 0 hr. 0 min. 0 sec
Trace Level        off
Security         ON: Local OS Authentication
SNMP           OFF
Listener Parameter File  /u01/app/grid/network/admin/listener.ora
Listener Log File     /u01/app/12.2/grid/diag/tnslsnr/rhel7/listener/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel7)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

至次问题解决。

总结

以上所述是小编给大家介绍的Oracle 12.2监听无法启动解决方法,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对积木网网站的支持!

Oracle查询中OVER (PARTITION BY ..)用法
为了方便大家学习和测试,所有的例子都是在Oracle自带用户Scott下建立的。注:标题中的红色orderby是说明在使用该方法的时候必须要带上orderby。一、rank

解决Oracle字符串中包含数字、特殊符号的排序问题
问题描述:某小区,需要按照小区、楼栋、单元号、房间号进行排序,但是按照地址描述排序时,因为字符串中包含数字,所以造成了如下的结果,1号

Oracle 中Contains 函数的用法
1.查询住址在北京的学生SELECTstudent_id,student_nameFROMstudentsWHERECONTAINS(address,'beijing')remark:beijing是一个单词,要用单引号括起来。2.查询住址在河北省的学生S

本周排行

更新排行

强悍的草根IT技术社区,这里应该有您想要的! 友情链接:b2b电子商务
Copyright © 2010 Gimoo.Net. All Rights Rreserved  京ICP备05050695号