Re: ORA-12154 and standby
Date: Wed, 18 Mar 2009 11:33:34 -0500
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?
"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:
> 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.