Re: ORA-12154 and standby
Date: Wed, 18 Mar 2009 12:31:25 -0500
Bradd and Ray
Here are the relevant parameters
log_archive_dest_1 string LOCATION=/opt/oracle/admin/pcrp01/arch mandatory reopen=30 log_archive_dest_2 string SERVICE=pcrp01c ARCH NOAFFIRM OPTIONAL log_archive_dest_3 string SERVICE=pcrp01d ARCHNOAFFIRM OPTIONAL
log_archive_dest_state_1 string enable log_archive_dest_state_2 string enable log_archive_dest_state_3 string enable log_archive_config string fal_client string fal_server string
I have two standby DBs located on the same server and sharing the same oracle_home. No dataguard brokes used
Bradd Piontek <piontekdd_at_gmail. com> To genegurevich_at_discover.com 03/18/2009 11:33 cc AM oracle-l_at_freelists.org Subject Re: ORA-12154 and standby
Gene,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 Piontekis in having someone direction."
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
at the v$archive_dest view I see 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?
Please consider the environment before printing this email.
Please consider the environment before printing this email.Received on Wed Mar 18 2009 - 12:31:25 CDT