Yesterday I’ve come across a small request from a customer.
They were receiving REGULARLY critical alerts in EM12c from some listeners due to error TNS-12508.

The facts:

• only 10g listeners were affected

• every day, only one occurrence of the error and always at the same time on a named host

• no apparent correlations between times on different hosts

I’ve analyzed the log to see the error.

Notice that after the error there are two requests: show log_directory and show trc_directory.
So I’ve supposed that it’s an additional request failing on 10g listeners but not on 11g listeners.
The “help” command of 10g and 11g releases shows that the two releases have some different commands. One of them is “show oracle_home” that has been introduced in 11g.

• First I’ve searched for scheduled scripts (the customer literally have a huge library of scripts run against the databases to automate maintenance tasks)

• Then I’ve asked to the team that manages an automatic discovery tool that feeds the CMDB

• Finally, I’ve come across this note on Metalink that explain the error:

Repetitive TNS-12508 Errors logged for a listener target after upgrade to 12.1.0.3 DB plugin or higher (Doc ID 1596633.1)

I’ve applied the change to the metrics in EM12c to ignore the error for 10g listeners.
—
Ludovico

The following two tabs change content below.

• Bio
• Latest Posts

Ludovico

Principal Product Manager at Oracle

Ludovico is a member of the Oracle Database High Availability (HA), Scalability & Maximum Availability Architecture (MAA) Product Management team in Oracle. He focuses on Oracle Data Guard, Flashback technologies, and Cloud MAA.

Latest posts by Ludovico (see all)

• New views in Oracle Data Guard 23c - January 3, 2024
• New in Data Guard 21c and 23c: Automatic preparation of the primary - December 22, 2023
• Does FLASHBACK QUERY work across incarnations or after a Data Guard failover? - December 13, 2023