My Oracle Support Banner

TNS-12514 may occur during clusterware upgrade (Doc ID 2744321.1)

Last updated on APRIL 19, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

 Client connectioin fails with TNS-12514 during clusterware upgrade.

In this situation, Listener is reloaded.

listener.log
-----
18-12-2020 12:24:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=<hostname>)(USER=grid))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=202375680)) * reload * 0

..

18-12-2020 12:25:04 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=<servicename>)) * (ADDRESS=(PROTOCOL=tcp)(HOST=<IPADDRESS>)(PORT=45387)) * establish * <servicename> * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

...

18-12-2020 12:25:22 * service_register * +ASM1 * 0
18-12-2020 12:25:25 * service_register * <INSTANCENAME> * 0
------



crsd_oraagent_grid.trc
-----
  2020-12-18 12:24:43.015412 :CLSDYNAM:1765955328: [ora.LISTENER.lsnr]{0:2:18} [check] lsnrctl reload LISTENER <--*******
  2020-12-18 12:24:43.015437 :CLSDYNAM:1765955328: [ora.LISTENER.lsnr]{0:2:18} [check] LsnrAgent::Lsnrctl::execLsnrctl oracleHome:/u01/app/12.1.0/grid crsHome:/u01/app/12.1.0/grid usrOraEnv:
  2020-12-18 12:24:43.015597 :CLSDYNAM:1765955328: [ora.LISTENER.lsnr]{0:2:18} [check] LsnrAgent::Lsnrctl::execLsnrctl mask=
  2020-12-18 12:24:43.015645 :CLSDYNAM:1765955328: [ora.LISTENER.lsnr]{0:2:18} [check] Utils::getOracleHomeAttrib oracle_home:/u01/app/12.1.0/grid
  2020-12-18 12:24:43.015655 :CLSDYNAM:1765955328: [ora.LISTENER.lsnr]{0:2:18} [check] Utils::execCmd 1 USR_ORA_ENV: oracleHome:/u01/app/12.1.0/grid CrsHome:/u01/app/12.1.0/grid
  2020-12-18 12:24:43.015669 :CLSDYNAM:1765955328: [ora.LISTENER.lsnr]{0:2:18} [check] Adding Environment Variables ORACLE_HOME=/u01/app/12.1.0/grid
  2020-12-18 12:24:43.015674 :CLSDYNAM:1765955328: [ora.LISTENER.lsnr]{0:2:18} [check] Adding Environment Variables TNS_ADMIN=/u01/app/12.1.0/grid/network/admin/
  2020-12-18 12:24:43.015682 :CLSDYNAM:1765955328: [ora.LISTENER.lsnr]{0:2:18} [check] Utils:execCmd action = 3 flags = 38 ohome = (null) cmdname = lsnrctl.
  2020-12-18 12:24:43.015700 :CLSDYNAM:1765955328: [ora.LISTENER.lsnr]{0:2:18} [check] Utils::getOracleHomeAttrib oracle_home:/u01/app/12.1.0/grid
-----

 

Changes

Clusterware upgrade

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.