TNS-12514 may occur during clusterware upgrade
(Doc ID 2744321.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation 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
------
-----
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
-----
-----
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 |