Solution for Oracle 12.2 listening failure, oracle12.2
In their own virtual machine experiments, suddenly found that the use of PL/SQL Developer can not connect to the database, error ORA-12514, said the listen was not started.
First, introduce the virtual machine environment: redhat7.2 + GI 12.2.0.1 + Oracle 12.2.0.1. To test the ASM feature of MySQL 12.2, install GI. In normal times, the listener is enabled by default. But today I don't know why it didn't start. Use crsctl to view the resource status: the status of the listener is indeed OFFLINE.
[root@rhel7 .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--------------------------------------------------------------------------------
When you try to manually start the listener, the following error still appears:
[grid@rhel7 ~]$ 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
View the trc file as prompted and 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...
I was puzzled when I saw the Insufficient privilege for operation. Why is there a lack of permission? So I tried to start the listener directly with root and still reported an error:
[root@rhel7 .oracle]# lsnrctl startLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 15-NOV-2017 20:22:30Copyright (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
As a result, Baidu may be useful to those who read this article by listing Baidu content below, but it is useless to me in this situation:
It mainly refers to the permission access issue for the/var/tmp/. oracle and/tmp/. oracle directories. At first glance, my/var/tmp/. oracle permissions are fine, And/tmp/. oracle does not have this file at all.
Check MOS directly to see if there are any relevant 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)
I have compared the problems listed in this document, which is not the same as my situation. I finally found this sentence:
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
Therefore, we can only try this method. Since crs uses the monitoring command under grid home, it performs the relink all operation on grid home. However, an error occurs:
[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 sameuser who owns the Oracle home and ensure that the Oracle home has thepermissions 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.
This means that the permission is insufficient and the root user is used for execution, and an error is reported that the root user cannot be used for execution.
[root@rhel7 bin]# relink allThe relink script cannot be run as root.
View the permissions of the grid home directory
[root@rhel7 app]# ls -ld gridtotal 8drwxr-x--- 84 root oinstall 4096 Jul 18 20:26 grid
The original owner is root. No wonder the first execution is unsuccessful. Modify the owner (either chmod or chmod. No test is performed here) and re-Execute relink all.
[root@rhel7 app]# chown grid grid[grid@rhel7 ~]$ relink allwriting relink log to: /u01/app/grid/install/relink.log
After successful, the listener is started again.
[grid@rhel7 ~]$ 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 solve the problem.
Summary
The above is a small part of the Oracle 12.2 listener can not start the solution, I hope to help you, if you have any questions, please leave a message, xiaobian will reply to you in a timely manner. Thank you very much for your support for the help House website!