Re: ora_reco process throwing ORA-12154 TNS error
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 13 May 2022 16:35:41 -0400
Message-ID: <f340e5a2-3926-0494-6668-f4a9961126de_at_gmail.com>
On 5/12/22 11:46, Sandra Becker wrote:
Date: Fri, 13 May 2022 16:35:41 -0400
Message-ID: <f340e5a2-3926-0494-6668-f4a9961126de_at_gmail.com>
On 5/12/22 11:46, Sandra Becker wrote:
Forgot to include the errors from the alert log.
Thu May 12 01:26:39 2022
SMON: about to recover undo segment 16
SMON: mark undo segment 16 as needs recovery
Thu May 12 01:28:02 2022
Errors in file /apps/oracle/admin/findev/bdump/findev_reco_6298.trc:
ORA-12154: TNS:could not resolve service name
ORA-12154: TNS:could not resolve service name
ORA-12154: TNS:could not resolve service name
Hi Sandy,
RECO process is global recovery
process, it recovers global transactions. Your RECO is complaining
that it cannot find one of the delinquents participating in the
aborted global transaction. You can update tnsnames.ora and help
RECO find the wanted database, dead or alive, or you can use
DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY to murder the problematic
transaction manually. You can find all the necessary data in
DBA_2PC_PENDING.
Have a great weekend.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com-- http://www.freelists.org/webpage/oracle-l Received on Fri May 13 2022 - 22:35:41 CEST