Re: ORA-12154 and standby

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Wed, 18 Mar 2009 11:33:34 -0500
Message-ID: <e9569ef30903180933l159cb16ch54eeaa26c8cc6d7c_at_mail.gmail.com>

Gene,
  It may help to see your standby configuration. log_archive_dest_n entries, as well as the log_archive_dest_state_n, fal_server, fal_client, log_archive_config, as well as the tnsnames.ora entries.

Is there more than one home? Are you using a dataguard broker?

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
        direction."

• William Feather

On Wed, Mar 18, 2009 at 10:58 AM, <genegurevich_at_discover.com> wrote:

> Hello:
>
> I have set up a standby database under oracle 10.2.0.1 and everything
> looked great except for a minor detail -
> the archived logfiles do not get copied to the standby server. When I look
> at the v$archive_dest view I see
> ORA-12154: TNS:could not resolve the connect identifier specified
> 03-18-2009 10:47:32 pcrp01d
> for dest_ID which correspond to my standby.
>
> I have checked the tnsnames.ora on the primary side and it looks OK.
> tnsping finds the standby; I can
> ping the host. I have tried bouncing the listener on the standby side;
> bouncind the standby DB itself
> as well as primary db, but this error keep reapearring after 5 min pause.
> If tnsnames.ora is OK, what
> else could be the issue?
>
>
> thank you
>
> Gene Gurevich
>
>
> Please consider the environment before printing this email.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 18 2009 - 11:33:34 CDT