Oracle 12.2 Listener fails to start solve a case

In their own virtual machine to do experiments, suddenly found that the use of PL/SQL developer can not connect to the database, error ORA-12514, said to be monitoring does not start.

First introduce the virtual machine environment: Redhat7.2+gi 12.2.0.1+oracle 12.2.0.1, in order to test the 12.2 ASM features installed GI. Usually the listener program is on by default. But today I don't know why it didn't start. Use Crsctl to view resource status: Discover that the state of the listener is indeed offline state

[[email protected] .oracle]#  Crsstat--------------------------------------------------------------------------------name            Target  State         Server                    State details       -------------------------- ------------------------------------------------------local  Resources--------------------------------------------------------------------------------ora.data.dg                online  online        rhel7                     STABLEora.LISTENER.lsnr                online  offline      rhel7                      STABLEora.asm                online  online       rhel7                     started,stableora.ons                offline offline       rhel7                      STABLE--------------------------------------------------------------------------------cluster  Resources--------------------------------------------------------------------------------Ora.cssd      1        online   online       rhel7                     STABLEora.diskmon       1        OFFLINE OFFLINE                                 STABLEora.driver.afd       1        online  online        rhel7                     STABLEora.evmd      1         online  online       rhel7                     STABLEora.ora12c.db       1        ONLINE  ONLINE        rhel7                     Open,HOME=/u01/app/o                                                                racle/product/ 12.2/d                                                                b_home1, STABLE--------------------------------------------------------------------------------

Try to manually start the monitoring, still error:

[Email protected] ~]$ srvctl start listenerprcr-1079:failed to start resource Ora.  Listener.lsnrcrs-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

According to the prompt to view TRC file, see the following error:

lsnrctl for linux: version 12.2.0.1.0 - production on 15-nov-2017  20:03:28Copyright  (c)  1991, 2016, oracle.  all rights reserved. Starting /u01/app/grid/bin/tnslsnr: please wait ... tnslsnr for linux: version 12.2.0.1.0 - productionsystem parameter  File is /u01/app/grid/network/admin/listener.oralog messages written to /u01/app /12.2/grid/diag/tnslsnr/rhel7/listener/alert/log.xmllistening 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 permittedlistener faIled to start. see the error message (s)  above ... 

See insufficient privilege for operation this word feel very puzzled, how can insufficient authority, so try to use root directly start monitoring, still error:

[email protected]. oracle]# lsnrctl startlsnrctl for linux:version 12.2.0.1.0-production on 15-nov-2017 20:22:30copyri  Ght (c) 1991, 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:pe Rmission denied

So all kinds of Baidu, the following Baidu to the content listed, may be to see this article of the students useful, but for me this situation is not used:

The main point is that/var/tmp/.oracle,/tmp/.oracle these two directories permissions access problem. In a look, my/var/tmp/.oracle permission is not a problem, and/tmp/.oracle there is no such file.

So check MOS directly, see if there are any related documents, find two documents:

Starting the Listener fails with:tns-12557 or tns-12555:tns:permission Denied (document ID 343253.1)

Listener fails to Start with IPC Permission Errors (TNS-12546 TNS-12555 TNS-00516 TNS-00525) (document ID 434062.1)

Compared to the problems listed in the document, and my situation is also inconsistent, see finally found such a sentence:

4. If you find That there is no adapters linked or they have errors (such as " permission denied ") then issue a" Relink All "
reference:
< Span style= "font-family: ' Times New Roman '; Font-size:small;background-color:rgb (255,255,255);" >doc ID 1467060.1

So only in this way to try, because CRS using the grid home under the Monitoring command, so the grid home do relink all operation. But there is an error:

[[email protected] bin]$ relink all the Oracle home in which is running this relinking tool does does have proper WRI Te permissions. Please run this relink script as the Sameuser who owns the Oracle home and ensure that the Oracle home have thepermissions  From the original installation. If This was a Grid Infrastructure home, please refer to the documentation for the proper steps to relink and apply OneOff p Atches.

This means that the permissions are insufficient, the use of root execution, and the error that can not be executed with root

[Email protected] bin]# relink allthe relink script cannot be run as root.

and view the grid home directory permissions

[Email protected] app]# ls-ld gridtotal 8drwxr-x---root oinstall 4096 Jul 20:26 grid

Originally owner is root, no wonder the first execution unsuccessful, modify owner (should directly chmod also can, here did not do test), re-execute relink all

[[email protected] app]# chown grid grid[[email protected] ~]$ relink allwriting relink log to:/u01/app/grid/install/reli Nk.log

After successful start monitoring again, start successfully.

[[email protected] ~]$ lsnrctl startlsnrctl for linux: version  12.2.0.1.0 - production on 15-nov-2017 20:50:59copyright  (c)  1991,  2016, oracle.  all rights reserved. Starting /u01/app/grid/bin/tnslsnr: please wait ... tnslsnr for linux: version 12.2.0.1.0 - productionsystem parameter  File is /u01/app/grid/network/admin/listener.oralog messages written to /u01/app /12.2/grid/diag/tnslsnr/rhel7/listener/alert/log.xmllistening 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                      listenerversion                    tnslsnr for linux: version  12.2.0.1.0 - ProductionStart Date                 15-NOV-2017 20:51:00Uptime                     0 days 0  hr. 0 min. 0 sectrace level                offSecurity                   ON: Local OS AuthenticationSNMP                        offlistener parameter file   /u01/app/grid/network/admin/listener.oralistener log file          /u01/app/12.2/grid/diag/tnslsnr/rhel7/listener/alert/ log.xmllistening endpoints summary...   (description= (address= (PROTOCOL=tcp) (HOST=RHEL7) ( port=1521))    (description= (address= (PROTOCOL=IPC) (key=extproc1521))) The listener supports  no servicesthe command completed successfully

-to-minor problem resolution.

This article is from the "DBA fighting!" blog, so be sure to keep this source http://hbxztc.blog.51cto.com/1587495/1982138

Oracle 12.2 Listener fails to start solve a case