Re: ora_reco process throwing ORA-12154 TNS error

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Thu, 12 May 2022 09:46:19 -0600
Message-ID: <CAJzM94AWoLDnvnMNSPgYan6B9poNX-FE4cyMGy+GWMa=1wnskw_at_mail.gmail.com>



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

On Thu, May 12, 2022 at 9:30 AM Sandra Becker <sbecker6925_at_gmail.com> wrote:

> Oracle 9i
> SunOS 5.8
>
> Unfortunately, the application our stakeholder is using cannot be
> upgraded, so we are not allowed to upgrade the database. A project is
> under way to move to a new application, but that won't be completed for
> another 6-12 months. In the meantime, I need to work with what we have.
>
> I am trying to clone the production database to a dev database, but the
> ora_reco process keeps throwing the ORA-12154 error. I also was seeing
> undo segment errors. I'm guessing they are related, but I don't know how
> to resolve the problem. I have used the rman "DUPLICATE TO TARGET DATABASE
> TO" successfully just two weeks ago. No changes were made to the server or
> the scripts since that last run. I've used this same process at least half
> a dozen times since last November without any errors.
>
> I can't seem to find any articles that will tell me what's going on and
> how to resolve it. Any suggestions would be appreciated.
>
> --
> Sandy B.
>
>

-- 
Sandy B.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 12 2022 - 17:46:19 CEST

Original text of this message