Home » Server Options » Data Guard » Data Broker fails to enable databse (oracle 10g R2 Linux EL 4)
Data Broker fails to enable databse [message #501166] Sat, 26 March 2011 12:27 Go to next message
farnaw4u
Messages: 22
Registered: October 2006
Location: pakistan
Junior Member
Dear all

I have configuring oracle data Physical standby data Guard on Linux
i did configure the same three times fails in data guard Broker.

Primary database name PRIM
Physical Standby name STAN

tnsping PRIM ......OK
tnsping STAN ........OK



Initially every was fine redo was successfully was being transmitted to standby

the Problem starts when i enable DG broker configuration and after this redo transmission become STOPPED and i dont know where is problem and how to solve it.....

here are files to look at


PRIMARY init.ora file

###########################################
db_block_size=8192
db_file_multiblock_read_count=16

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name=PRIM

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/u01/app/oracle/admin/PRIM/bdump
core_dump_dest=/u01/app/oracle/admin/PRIM/cdump
user_dump_dest=/u01/app/oracle/admin/PRIM/udump

###########################################
# File Configuration
###########################################
control_files=("/u01/app/oracle/oradata/PRIM/control01.ctl", "/u01/app/oracle/oradata/PRIM/control02.ctl", "/u01/app/oracle/oradata/PRIM/control03.ctl")
db_recovery_file_dest=/u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size=2147483648

###########################################
# Job Queues
###########################################
job_queue_processes=10

###########################################
# Miscellaneous
###########################################
compatible=10.2.0.1.0

###########################################
# Network Registration
###########################################
local_listener=LISTENER_PRIM

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# SGA Memory
###########################################
sga_target=283115520

###########################################
# Security and Auditing
###########################################
audit_file_dest=/u01/app/oracle/admin/PRIM/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=PRIMXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=94371840

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1


########################################################

dg_broker_start=true


db_name=PRIM
db_unique_name=PRIM


LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM,STAN)'


LOG_ARCHIVE_DEST_1=
'LOCATION=/u01/app/oracle/flash_recovery_area/PRIM/archivelog/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=PRIM'



LOG_ARCHIVE_DEST_2=
'SERVICE=STAN LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=STAN'


LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30

remote_login_passwordfile='EXCLUSIVE'


FAL_SERVER=STAN
FAL_CLIENT=PRIM


STANDBY_FILE_MANAGEMENT=AUTO


DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/STAN','/u01/app/oracle/oradata/PRIM'

LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/STAN','/u01/app/oracleoradata/PRIM'

==============================================================






Physical STAND BY init.ora



db_block_size=8192
db_file_multiblock_read_count=16

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name=STAN

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/u01/app/oracle/admin/STAN/bdump
core_dump_dest=/u01/app/oracle/admin/STAN/cdump
user_dump_dest=/u01/app/oracle/admin/STAN/udump

###########################################
# File Configuration
###########################################
control_files=("/u01/app/oracle/oradata/STAN/control01.ctl")
db_recovery_file_dest=/u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size=2147483648

###########################################
# Job Queues
###########################################
job_queue_processes=10

###########################################
# Miscellaneous
###########################################
compatible=10.2.0.1.0

###########################################
# Network Registration
###########################################
local_listener=LISTENER_STAN

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# SGA Memory
###########################################
sga_target=601882624

###########################################
# Security and Auditing
###########################################
audit_file_dest=/u01/app/oracle/admin/STAN/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=STANXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=200278016

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1




##################################################

dg_broker_start=true


db_name=PRIM
db_unique_name=STAN


LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRIM,STAN)'


LOG_ARCHIVE_DEST_1=
'LOCATION=/u01/app/oracle/flash_recovery_area/STAN/archivelog/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=STAN'





LOG_ARCHIVE_DEST_2=
'SERVICE=STAN LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=PRIM'


LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30

remote_login_passwordfile='EXCLUSIVE'


FAL_SERVER=PRIM
FAL_CLIENT=STAN


STANDBY_FILE_MANAGEMENT=AUTO


DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/PRIM','/u01/app/oracle/oradata/STAN'

LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/PRIM','/u01/app/oracle/oradata/STAN'

=================================================================



BROKER configuration





[oracle@PRIM ~]$ dgmgrl
DGMGRL for Linux: Version 10.2.0.1.0 - Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected.
DGMGRL> create configuration test_config as
> primary database is PRIM
> connect identifier is PRIM;
Configuration "test_config" created with primary database "prim"
DGMGRL> add database STAN as connect identifier is STAN
> maintained as primary;
maintained as primary;
^
Syntax error before or at "primary"
DGMGRL> add standby database STAN
> connect identifier is STAN
> maintained as physical;
add standby database STAN
^
Syntax error before or at "standby"
DGMGRL> add database STAN as
> connect identifier is STAN
> maintained as physical;
Database "stan" added
DGMGRL> show configuration;

Configuration
Name: test_config
Enabled: NO
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
prim - Primary database
stan - Physical standby database

Current status for "test_config":
DISABLED

DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration

Configuration
Name: test_config
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
prim - Primary database
stan - Physical standby database

Current status for "test_config":
Warning: ORA-16607: one or more databases have failed



After this error alert log shows..............




LNS1 started with pid=18, OS id=5628
Sun Sep 17 20:52:35 2006
Thread 1 advanced to log sequence 7
Current log# 3 seq# 7 mem# 0: /u01/app/oracle/oradata/PRIM/redo03.log
Sun Sep 17 20:52:35 2006
ARC9: Standby redo logfile selected for thread 1 sequence 6 for destination LOG_ARCHIVE_DEST_2
Sun Sep 17 20:52:36 2006
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 7 for destination LOG_ARCHIVE_DEST_2
Sun Sep 17 20:52:59 2006
Thread 1 advanced to log sequence 8
Current log# 1 seq# 8 mem# 0: /u01/app/oracle/oradata/PRIM/redo01.log
Sun Sep 17 20:53:00 2006
LNS: Standby redo logfile selected for thread 1 sequence 8 for destination LOG_ARCHIVE_DEST_2
Sun Sep 17 20:53:54 2006
Thread 1 cannot allocate new log, sequence 9
Checkpoint not complete
Current log# 1 seq# 8 mem# 0: /u01/app/oracle/oradata/PRIM/redo01.log
Thread 1 advanced to log sequence 9
Current log# 2 seq# 9 mem# 0: /u01/app/oracle/oradata/PRIM/redo02.log
Sun Sep 17 20:53:56 2006
LNS: Standby redo logfile selected for thread 1 sequence 9 for destination LOG_ARCHIVE_DEST_2
INSV started with pid=17, OS id=5663
NSV1 started with pid=52, OS id=5673
RSM0 started with pid=53, OS id=5675
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET log_archive_dest_2='service=" (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=stan_XPT)(INSTANCE_NAME=STAN)( SERVER=dedicated))) "',' LGWR ASYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="stan" register net_timeout=180 valid_for=(online_logfile,primary_role)' SCOPE=BOTH;
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='PRIM';
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET log_archive_format='%t_%s_%r.arc' SCOPE=SPFILE SID='PRIM';
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET standby_archive_dest='' SCOPE=BOTH SID='PRIM';
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET log_archive_dest_1='location="/u01/app/oracle/flash_recovery_area/PRIM/archivelog/"','valid_for=(ONLINE_LOGFILE,ALL_ROLES)' SCOPE=BOTH SID='PRIM';
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET log_archive_dest_state_1='ENABLE' SCOPE=BOTH SID='PRIM';
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET log_archive_max_processes=30 SCOPE=BOTH SID='*';
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET db_file_name_convert='/u01/app/oracle/oradata/STAN','/u01/app/oracle/oradata/PRIM' SCOPE=SPFILE;
Sun Sep 17 20:59:38 2006
ALTER SYSTEM SET log_file_name_convert='/u01/app/oracle/oradata/STAN','/u01/app/oracleoradata/PRIM' SCOPE=SPFILE;
LNS1 started with pid=18, OS id=5677
Sun Sep 17 20:59:45 2006
Thread 1 advanced to log sequence 10
Current log# 3 seq# 10 mem# 0: /u01/app/oracle/oradata/PRIM/redo03.log
Sun Sep 17 20:59:45 2006
Error 12545 received logging on to the standby
Sun Sep 17 20:59:45 2006
Errors in file /u01/app/oracle/admin/PRIM/bdump/prim_arcg_5421.trc:
ORA-12545: Connect failed because target host or object does not exist
Sun Sep 17 20:59:45 2006
ALTER SYSTEM SET log_archive_dest_2='service=" (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=stan_XPT)(INSTANCE_NAME=STAN)( SERVER=dedicated))) "',' LGWR ASYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="stan" register net_timeout=180 valid_for=(online_logfile,primary_role)' SCOPE=BOTH;
Sun Sep 17 20:59:45 2006
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
FAL[server, ARCg]: Error 12545 creating remote archivelog file '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=stan_XPT)(INSTANCE_NAME=STAN) (SERVER=dedicated)))'
FAL[server, ARCg]: FAL archive failed, see trace file.
Sun Sep 17 20:59:45 2006
Errors in file /u01/app/oracle/admin/PRIM/bdump/prim_arcg_5421.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Sun Sep 17 20:59:45 2006
ORACLE Instance PRIM - Archival Error. Archiver continuing.
Sun Sep 17 20:59:46 2006
Thread 1 advanced to log sequence 11
Current log# 1 seq# 11 mem# 0: /u01/app/oracle/oradata/PRIM/redo01.log
Sun Sep 17 21:05:19 2006
Error 12545 received logging on to the standby
Sun Sep 17 21:05:19 2006
Errors in file /u01/app/oracle/admin/PRIM/bdump/prim_arcq_5441.trc:
ORA-12545: Connect failed because target host or object does not exist
PING[ARCq]: Heartbeat failed to connect to standby '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=stan_XPT)(INSTANCE_NAME=STAN) (SERVER=dedicated)))'. Error is 12545.
Sun Sep 17 21:10:19 2006
Error 12545 received logging on to the standby
Sun Sep 17 21:10:19 2006
Errors in file /u01/app/oracle/admin/PRIM/bdump/prim_arcq_5441.trc:
ORA-12545: Connect failed because target host or object does not exist
PING[ARCq]: Heartbeat failed to connect to standby '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=stan_XPT)(INSTANCE_NAME=STAN) (SERVER=dedicated)))'. Error is 12545.
Sun Sep 17 21:15:19 2006
Error 12545 received logging on to the standby
Sun Sep 17 21:15:19 2006
Errors in file /u01/app/oracle/admin/PRIM/bdump/prim_arcq_5441.trc:
ORA-12545: Connect failed because target host or object does not exist
PING[ARCq]: Heartbeat failed to connect to standby '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=STAND)(PORT=1523)))(CONNECT_DATA=(SERVICE_NAME=stan_XPT)(INSTANCE_NAME=STAN) (SERVER=dedicated)))'. Error is 12545.

[





CAN ANY BODY HELP ME PLEASE..............
Re: Data Broker fails to enable databse [message #501167 is a reply to message #501166] Sat, 26 March 2011 13:32 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Hello. You say that it worked until you attempted to enable the Data Guard broker, but I don't think it did. For example, you have this in your standby parameter file:

LOG_ARCHIVE_DEST_2=
'SERVICE=STAN LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=PRIM'

that is wrong, a switchover would have failed. And the 12545 errors in your alert log show that your Oracle Net config is not corrent. Neither of those problems is anything to do with the broker. If I were you, I would start again, and make sure that the redo transport and apply really is working, before enabling the broker. The broker can't be the source of the problems.
Re: Data Broker fails to enable databse [message #501370 is a reply to message #501166] Mon, 28 March 2011 13:08 Go to previous messageGo to next message
farnaw4u
Messages: 22
Registered: October 2006
Location: pakistan
Junior Member
Dear John Watson


you are right it was the problem with the spfile when it went fine and now redo are being transported to standby

but when it write DGMGRL with global name in listener my net config service PRIM or STAN fails and alert log is returned with error ORA-12545 host does not exists.


any idea ........?




thanks again

[Updated on: Mon, 28 March 2011 13:21]

Report message to a moderator

Re: Data Broker fails to enable databse [message #501373 is a reply to message #501370] Mon, 28 March 2011 13:13 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
12545, 00000, "Connect failed because target host or object does not exist"
// *Cause: The address specified is not valid, or the program being
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly; the
// most likely incorrect parameter is the node name. Ensure that the
// executable for the server exists (perhaps "oracle" is missing.)
// If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
// host name to a numeric IP address and try again.
Previous Topic: Data Guard setup/ Archive Destination configuration
Next Topic: Physical Standby Error
Goto Forum:
  


Current Time: Thu Mar 28 12:44:25 CDT 2024