Emcli Create_standby_database Failing (Doc ID 2533678.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

You are running the following emcli command to create a physical standby database.

 emcli create_standby_database \
  2 -source_db_target_name="<name>" \
  3 -source_db_target_type="rac_database" \
  4 -dest_oracle_sid="<oracle SID>" \
  5 -spname="<name>" \
  6 -use_duplicate="yes" \
  7 -source_db_creds_name="DATABASE_ODS_SYS" \
  8 -source_host_creds_name="ODSORA1" \
  9 -dest_host_name="<hostname>" \
  10 -dest_oracle_home="/<path>" \
  11 -dest_target_name="<name>" \
  12 -dest_db_database_area="/<path>" \
  13 -dest_db_recovery_area="/<path>" \
  14 -storage_type="FILE_SYSTEM" \
  15 -dest_listener_selection="<listener name>" \
  16 -dest_listener_name="LISTENER" \
  17 -dest_listener_port="1521" \
  18 -stby_type="PHYSICAL" \
  19 -use_sys_dba_monitoring_creds="YES" \
  20 -use_broker="YES"


It always gives this error in OEM under job activity:
An internal Error has occurred. Refer to the Management Server and Agent log files for more details.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.