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  |
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  |
John Watson
Messages: 8989
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 |
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 |
 |
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.
|
|
|
|
Goto Forum:
Current Time: Tue Nov 04 07:38:17 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
