Dataguard connection error:::Please Help me :)
orawissMar 23 2010 — edited Mar 25 2010hi to all,
I m trying to setup oracle dataguard for 10G ; both primary and standby databases are in 10GR2.
Configuring Oracle DataGuard using SQL commands - Creating a physical standby database ; I recieve an error when I try to connect between both databases ;
from Primary Database :
SQL> Select Status, Error from v$Archive_dest where dest_id=2;
STATUS ERROR
--------- -----------------------------------------------------------------
ERROR ORA-12154: TNS:could not resolve the connect identifier specified
Primary pfile contains the following entries :
ARCDB01.__db_cache_size=301989888
ARCDB01.__java_pool_size=4194304
ARCDB01.__large_pool_size=4194304
ARCDB01.__shared_pool_size=96468992
ARCDB01.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/admin/ARCDB01/adump'
*.background_dump_dest='/u01/app/oracle/admin/ARCDB01/bdump'
*.compatible='10.2.0.1.0'
*.control_file_record_keep_time=8
*.control_files='/u01/app/oracle/oradata/ARCDB01/control01.ctl','/u01/app/oracle/oradata/ARCDB01/control02.ctl','/u01/app/oracle/oradata/ARCDB01/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/ARCDB01/cdump'
*.db_block_checking='TRUE'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ARCDB01'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='PRIMARY'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ARCDB01XDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=/u01/app/oracle/flash_recovery_area/ARCDB01/archivelog/'
*.log_archive_format='%s_arc_ln%r_db%d_%t.arc'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=200
*.remote_login_passwordfile='SHARED'
*.sessions=205
*.sga_max_size=419430400
*.sga_target=419430400
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/ARCDB01/udump'
*.utl_file_dir='/home/oracle/my_logminer'
*.log_archive_dest_2='Service=to_standby lgwr'
*.log_archive_dest_state_2=ENABLE
*.Standby_File_Management='AUTO'
could you help me please?
thanks a lot
W