Hi everybody,

I am trying to configure a physical standby database using Oracle 10g and the Data Guard CLI. I installed both databases and configured everything for doing the switching over the SQL Plus interface. (Activated the archivelog, force logging, set the necessary parameters, etc.) A switchover by using “alter database commit to switchover to primary with session shutdown;” works absolutely fine.
So next I wanted to set up the DGBroker using the CLI.
To spawn the DMON process I’ve set the DG_BROKER_START=true.
I connected to the dgmgrl and created my configuration as the following:
Create configuration ‘MyDR’ as
Primary database is ‘prd’
Connect identifier is prd;

Add database ‘stb’ as
Connect identifier is to_standby
Maintained as physical;
After enabling the configuration I tried to switchover to ‘stb’. Here is the console output what he did:

switchover to 'stb'
Performing switchover NOW. Please wait...
Operation requires shutdown of instance "prd" on database "prd".
Shutting down instance "prd"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires shutdown of instance "prd" on database "stb".
Shutting down instance "prd"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "prd" on database "prd".
Starting instance "prd"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Failed.
You are no longer connected to ORACLE
Please connect again.
Unable to start instance "prd".
You must start instance "prd" manually.
Operation requires startup of instance "prd" on database "stb".
You must start instance "prd" manually.
Switchover succeeded. New primary is "stb"
I have no clue where the ORA-12514 error results from (using the SQL Plus everything works fine....). Is the connect identifier wrong or is something else wrong configured? I have tried a couple different connect identifier, but I always get the same error. For the better understanding of my configuration I attach the content of the init.oras and tnsnames.oras to the thread.
Please help me by solving my startup problems when using the CLI. I really need it for my project work I am doing for my college so I can start working on my diploma thesis. (without completing the project I can’t start ) If you need any additional information just let me know.

Regards

Fabian

Primary Site init.ora: (deleted some of the “not important” entries)
archive_lag_target=0
background_dump_dest='C:\oracle\admin\prd\bdump'
compatible='10.1.0.2.0'
control_files='C:\oracle\oradata\prd\control01.ctl ','C:\oracle\oradata\prd\control02.ctl','C:\oracle \oradata\prd\control03.ctl'
db_domain=''
db_name='prd'
DB_UNIQUE_NAME='prd'
dg_broker_start=TRUE
dispatchers='(PROTOCOL=TCP) (SERVICE=prdXDB)'
fal_client='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(P ROTOCOL=tcp)(HOST=ORACLE-DB)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=prd_XP T)(INSTANCE_NAME=prd)(SERVER=dedicated)))'
fal_server='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(P ROTOCOL=tcp)(HOST=ORACLE-STBY)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=stb_ XPT)(SERVER=dedicated)))'
log_archive_config='dg_config=(stb)'
LOG_ARCHIVE_DEST_1='LOCATION=C:\oracle\admin\prd\a rch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=prd'
prd.log_archive_dest_1='location="C:\oracle\admin\ prd\arch"','valid_for=(ONLINE_LOGFILE,ALL_ROLES)'
log_archive_dest_2='SERVICE=to_standby VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=stb'
LOG_ARCHIVE_DEST_STATE_1='ENABLE'
log_archive_dest_state_2='ENABLE'
prd.log_archive_format='ARC%S_%R.%T'
prd.log_archive_trace=0
remote_login_passwordfile='EXCLUSIVE'
service_names='prd','prd_XPT'
prd.standby_archive_dest='C:\oracle\admin\prd\arch '
standby_file_management='AUTO'
undo_management='AUTO'
tnsnames.ora:
TO_STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-stby)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = stb)
)
)
PRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-db.oracle)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prd)
)
)

Standby Site:
archive_lag_target=0
background_dump_dest='C:\oracle\admin\prd\bdump'
compatible='10.1.0.2.0'
control_files='C:\oracle\oradata\prd\control01.ctl '
db_domain=''
db_name='prd'
DB_UNIQUE_NAME='stb'
dg_broker_start=TRUE
dispatchers='(PROTOCOL=TCP) (SERVICE=prdXDB)'
fal_client='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(P ROTOCOL=tcp)(HOST=ORACLE-STBY)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=stb_ XPT)(INSTANCE_NAME=prd)(SERVER=dedicated)))'
fal_server='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(P ROTOCOL=tcp)(HOST=ORACLE-DB)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=prd_XP T)(SERVER=dedicated)))'
log_archive_config='dg_config=(prd)'
LOG_ARCHIVE_DEST_1='LOCATION=C:\oracle\admin\prd\a rch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stb'
prd.log_archive_dest_1='location="C:\oracle\admin\ prd\arch"','valid_for=(ALL_LOGFILES,ALL_ROLES)'
log_archive_dest_2='SERVICE=to_prd VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=prd'
LOG_ARCHIVE_DEST_STATE_1='ENABLE'
log_archive_dest_state_2='ENABLE'
prd.log_archive_format='ARC%S_%R.%T'
prd.log_archive_trace=0
remote_login_passwordfile='EXCLUSIVE'
service_names='stb','stb_XPT'
prd.standby_archive_dest='C:\oracle\admin\prd\arch '
standby_file_management='AUTO'
undo_management='AUTO'
tnsnames.ora:
TO_PRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-db)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prd)
)
)
PRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-stby.oracle)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stb)
)
)

PS: Sorry if it is a repost, but I did not find anything searching the Forum regarding this topic.