Hi,
I am at the
sql> startup mount
stage of my standby db creation. I am getting the following error:
ORA-00439: feature not enabled: Managed Standby
i have enterprise edition of Oracle on both servers.
here is the primary init.ora file:
OPWAPPS.__db_cache_size=423624704
OPWAPPS.__java_pool_size=4194304
OPWAPPS.__large_pool_size=4194304
OPWAPPS.__shared_pool_size=163577856
OPWAPPS.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/OPWAPPS/adump'
*.background_dump_dest='/u01/app/oracle/admin/OPWAPPS/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u02/oradata/OPWAPPS/control01.ctl','/u03/oradata/OPWAPPS/control02.ctl','/u01/app/oracle/oradata/OPWAPPS/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/OPWAPPS/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='OPWAPPS'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=31457280000
*.dispatchers='(PROTOCOL=TCP) (SERVICE=OPWAPPSXDB)'
*.job_queue_processes=10
#*.log_archive_start=TRUE
*.open_cursors=300
*.pga_aggregate_target=199229440
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=598736896
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/OPWAPPS/udump'
*.FAL_CLIENT='OPWAPPS'
*.FAL_SERVER='OPWAPPS2'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(OPWAPPS,OPWAPPS2)'
*.log_archive_dest='SERVICE=OPWAPPS2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=OPWAPPS2'
#*.log_archive_dest_1='location=/u01/app/oracle'
*.log_archive_dest=ENABLE
#*.log_archive_dest_1=ENABLE
*.log_archive_format=%t_%s_%r.arc
*.db_unique_name='OPWAPPS'
-----------------------------
and here is the standby
OPWAPPS.__db_cache_size=423624704
OPWAPPS.__java_pool_size=4194304
OPWAPPS.__large_pool_size=4194304
OPWAPPS.__shared_pool_size=163577856
OPWAPPS.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/OPWAPPS/adump'
*.background_dump_dest='/u01/app/oracle/admin/OPWAPPS/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u02/oradata/OPWAPPS/control01.ctl','/u03/oradata/OPWAPPS/control02.ctl','/u01/app/oracle/oradata/OPWAPPS/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/OPWAPPS/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='OPWAPPS'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=31457280000
*.dispatchers='(PROTOCOL=TCP) (SERVICE=OPWAPPSXDB)'
*.job_queue_processes=10
#*.log_archive_start=TRUE
*.open_cursors=300
*.pga_aggregate_target=199229440
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=598736896
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/OPWAPPS/udump'
*.FAL_CLIENT='OPWAPPS2'
*.FAL_SERVER='OPWAPPS'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(OPWAPPS,OPWAPPS2)'
*.log_archive_dest_1='SERVICE=OPWAPPS LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=OPWAPPS'
#*.log_archive_dest_1='location=/u01/app/oracle'
*.log_archive_dest_1=ENABLE
#*.log_archive_dest_1=ENABLE
*.log_archive_format=%t_%s_%r.arc
*.db_unique_name='OPWAPPS2'
Any ideas? I was also getting this error earlier on the primary until i changed log_archive_dest_1 to log_archive_dest
Thanks
I am at the
sql> startup mount
stage of my standby db creation. I am getting the following error:
ORA-00439: feature not enabled: Managed Standby
i have enterprise edition of Oracle on both servers.
here is the primary init.ora file:
OPWAPPS.__db_cache_size=423624704
OPWAPPS.__java_pool_size=4194304
OPWAPPS.__large_pool_size=4194304
OPWAPPS.__shared_pool_size=163577856
OPWAPPS.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/OPWAPPS/adump'
*.background_dump_dest='/u01/app/oracle/admin/OPWAPPS/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u02/oradata/OPWAPPS/control01.ctl','/u03/oradata/OPWAPPS/control02.ctl','/u01/app/oracle/oradata/OPWAPPS/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/OPWAPPS/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='OPWAPPS'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=31457280000
*.dispatchers='(PROTOCOL=TCP) (SERVICE=OPWAPPSXDB)'
*.job_queue_processes=10
#*.log_archive_start=TRUE
*.open_cursors=300
*.pga_aggregate_target=199229440
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=598736896
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/OPWAPPS/udump'
*.FAL_CLIENT='OPWAPPS'
*.FAL_SERVER='OPWAPPS2'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(OPWAPPS,OPWAPPS2)'
*.log_archive_dest='SERVICE=OPWAPPS2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=OPWAPPS2'
#*.log_archive_dest_1='location=/u01/app/oracle'
*.log_archive_dest=ENABLE
#*.log_archive_dest_1=ENABLE
*.log_archive_format=%t_%s_%r.arc
*.db_unique_name='OPWAPPS'
-----------------------------
and here is the standby
OPWAPPS.__db_cache_size=423624704
OPWAPPS.__java_pool_size=4194304
OPWAPPS.__large_pool_size=4194304
OPWAPPS.__shared_pool_size=163577856
OPWAPPS.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/OPWAPPS/adump'
*.background_dump_dest='/u01/app/oracle/admin/OPWAPPS/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u02/oradata/OPWAPPS/control01.ctl','/u03/oradata/OPWAPPS/control02.ctl','/u01/app/oracle/oradata/OPWAPPS/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/OPWAPPS/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='OPWAPPS'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=31457280000
*.dispatchers='(PROTOCOL=TCP) (SERVICE=OPWAPPSXDB)'
*.job_queue_processes=10
#*.log_archive_start=TRUE
*.open_cursors=300
*.pga_aggregate_target=199229440
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=598736896
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/OPWAPPS/udump'
*.FAL_CLIENT='OPWAPPS2'
*.FAL_SERVER='OPWAPPS'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(OPWAPPS,OPWAPPS2)'
*.log_archive_dest_1='SERVICE=OPWAPPS LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=OPWAPPS'
#*.log_archive_dest_1='location=/u01/app/oracle'
*.log_archive_dest_1=ENABLE
#*.log_archive_dest_1=ENABLE
*.log_archive_format=%t_%s_%r.arc
*.db_unique_name='OPWAPPS2'
Any ideas? I was also getting this error earlier on the primary until i changed log_archive_dest_1 to log_archive_dest
Thanks