Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Ora-00439: feature not enabled: managed standby     - Java NIO2: Buffer (Programming)

- The Oracle VM VirtualBox use U disk under ubuntu (Linux)

- RPM package fabrication method (Linux)

- Difference between TCP and UDP protocols (Linux)

- Installation and configuration of Hadoop under Linux (Server)

- php performance monitoring module XHProf (Linux)

- MySQL in order by inaccurate results in problems and solutions (Database)

- An Example of GoldenGate Extract Process Hang Problem Solving (Database)

- UNIX file permissions in the "set user ID bit" (Linux)

- To install Docker under CentOS7 (Linux)

- GoldenGate for Oracle data consistency initializing (Database)

- Linux Tutorial ---- fundamentals of data traffic redirection (Linux)

- Linux find command to find files (Linux)

- Docker: installation under Ubuntu (Server)

- dmidecode command Detailed (Hardware information) (Linux)

- To explore the caching mechanism for Android ListView (Programming)

- Linux, security encryption to transfer files between machines (Linux)

- Mutt - an email client that sends messages through the terminal (Linux)

- CentOS7 compile and install Tengine + PHP + MariaDB notes (Server)

- Linux kernel VLAN study notes (Programming)

 
         
  Ora-00439: feature not enabled: managed standby
     
  Add Date : 2018-11-21      
         
         
         
  1, Start the Oracle instance error:

SQL> startup nomount
ORA-32004: obsolete or deprecated parameter (s) specified for RDBMS instance
ORA-00439: feature not enabled: Managed Standby
SQL>

SQL> startup nomount;
ORA-32004: obsolete or deprecated parameter (s) specified for RDBMS instance
ORA-00439: feature not enabled: Managed Standby
SQL>
2. Background alert log log trac given as follows:

ORA-00439: feature not enabled: Managed Standby
Thu Dec 03 11:39:24 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file /oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/powerdes_ora_5717.trc:
ORA-00439: feature not enabled: Managed Standby
Analysis: Is the reason being given the boot parameters

3. Export Parameter File

SQL> create pfile = '/ oracle / pfile1203.ora' from spfile;

File created.

SQL>

Parameter file as follows:

    powerdes .__ db_cache_size = 3087007744
    powerdes .__ java_pool_size = 67108864
    powerdes .__ large_pool_size = 67108864
    powerdes .__ oracle_base = '/ oracle / app / oracle' # ORACLE_BASE set from environment
    powerdes .__ pga_aggregate_target = 3959422976
    powerdes .__ sga_target = 7449083904
    powerdes .__ shared_io_pool_size = 0
    powerdes .__ shared_pool_size = 4026531840
    powerdes .__ streams_pool_size = 134217728
    * .audit_file_dest = '/ Oracle / app / oracle / admin / powerdes / adump'
    * .audit_sys_operations = TRUE
    * .audit_trail = 'NONE'
    * .compatible = '11 .2.0.0.0 '
    * .control_files = '/ Home / oradata / powerdes / control01.ctl', '/ oracle / app / oracle / flash_recovery_area / powerdes / control02.ctl'
    * .db_block_size = 8192
    * .db_domain = ''
    * .db_file_name_convert = '/ Home / oradata / powerdes', '/ home / oradata / pwerdes'
    * .db_name = 'Powerdes'
    * .db_recovery_file_dest = '/ Oracle / app / oracle / flash_recovery_area'
    * .db_recovery_file_dest_size = 16106127360
    * .db_unique_name = 'Pdunq'
    * .diagnostic_dest = '/ Oracle / app / oracle'
    * .dispatchers = '(PROTOCOL = TCP) (SERVICE = powerdesXDB)'
    * .fal_client = 'PD'
    * .fal_server = 'PD_DG'
    * .global_names = FALSE
    * .job_queue_processes = 1000
    * .log_archive_config = 'DG_CONFIG = (pdunq, pddgunq)'
    * .log_archive_dest_1 = 'LOCATION = / oracle / app / oracle / flash_recovery_area / archivelog VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = pdunq'
    * .log_archive_dest_2 = 'SERVICE = PD_DG VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = pddgunq lgwr sync affirm'
    * .log_archive_dest_3 = ''
    * .log_archive_dest_state_1 = 'ENABLE'
    * .log_archive_dest_state_2 = 'Defer'
    * .log_archive_dest_state_3 = 'ENABLE'
    * .log_archive_format = '% T_% s_% r.dbf'
    * .log_archive_max_processes = 20
    * .log_archive_start = FALSE
    * .log_file_name_convert = '/ Home / oradata / powerdes', '/ home / oradata / powerdes'
    * .memory_target = 11379146752
    * .open_cursors = 300
    * .optimizer_index_caching = 90
    * .optimizer_index_cost_adj = 25
    * .optimizer_mode = 'FIRST_ROWS'
    * .processes = 1000
    * .remote_login_passwordfile = 'EXCLUSIVE'
    * .sessions = 335
    * .standby_file_management = 'AUTO'
    * .undo_tablespace = 'UNDOTBS1'
4, modify the parameter file

Remove archive_dest

    * .log_archive_config = 'DG_CONFIG = (pdunq, pddgunq)'
    * .log_archive_dest_1 = 'LOCATION = / oracle / app / oracle / flash_recovery_area / archivelog VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = pdunq'
    * .log_archive_dest_2 = 'SERVICE = PD_DG VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = pddgunq lgwr sync affirm'
    * .log_archive_dest_3 = ''
    * .log_archive_dest_state_1 = 'ENABLE'
    * .log_archive_dest_state_2 = 'Defer'
    * .log_archive_dest_state_3 = 'ENABLE'
Remove fal

* .fal_client = 'PD'
* .fal_server = 'PD_DG'
Remove the standby

* .standby_file_management = 'AUTO'
Save as pfile1203_01.ora:

powerdes .__ db_cache_size = 3087007744
powerdes .__ java_pool_size = 67108864
powerdes .__ large_pool_size = 67108864
powerdes .__ oracle_base = '/ oracle / app / oracle' # ORACLE_BASE set from environment
powerdes .__ pga_aggregate_target = 3959422976
powerdes .__ sga_target = 7449083904
powerdes .__ shared_io_pool_size = 0
powerdes .__ shared_pool_size = 4026531840
powerdes .__ streams_pool_size = 134217728
* .audit_file_dest = '/ Oracle / app / oracle / admin / powerdes / adump'
* .audit_sys_operations = TRUE
* .audit_trail = 'NONE'
* .compatible = '11 .2.0.0.0 '
* .control_files = '/ Home / oradata / powerdes / control01.ctl'
* .db_block_size = 8192
* .db_domain = ''
* .db_file_name_convert = '/ Home / oradata / powerdes', '/ home / oradata / pwerdes'
* .db_name = 'Powerdes'
* .db_recovery_file_dest = '/ Oracle / app / oracle / flash_recovery_area'
* .db_recovery_file_dest_size = 16106127360
* .db_unique_name = 'Pdunq'
* .diagnostic_dest = '/ Oracle / app / oracle'
* .dispatchers = '(PROTOCOL = TCP) (SERVICE = powerdesXDB)'
* .global_names = FALSE
* .job_queue_processes = 1000
* .log_archive_dest_1 = 'LOCATION = / oracle / app / oracle / flash_recovery_area / archivelog VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = pdunq'
* .log_archive_dest_state_1 = 'ENABLE'
* .log_archive_format = '% T_% s_% r.dbf'
* .log_archive_max_processes = 20
* .log_archive_start = FALSE
* .log_file_name_convert = '/ Home / oradata / powerdes', '/ home / oradata / powerdes'
* .memory_target = 11379146752
* .open_cursors = 300
* .optimizer_index_caching = 90
* .optimizer_index_cost_adj = 25
* .optimizer_mode = 'FIRST_ROWS'
* .processes = 1000
* .remote_login_passwordfile = 'EXCLUSIVE'
* .sessions = 335
* .undo_tablespace = 'UNDOTBS1'
5. Rebuild parameter files

SQL> create spfile from pfile = '/ oracle / pfile1203_01.ora';

File created.

SQL>
6, restart the nomount

SQL> startup nomount;
ORA-32004: obsolete or deprecated parameter (s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1.1358E + 10 bytes
Fixed Size 2216744 bytes
Variable Size 8254393560 bytes
Database Buffers 3087007744 bytes
Redo Buffers 13946880 bytes
SQL>
     
         
         
         
  More:      
 
- Oracle View Object Information (Database)
- Embedded Linux Optimization (Programming)
- CentOS of NFS (Server)
- Talk about Java in the collection (Programming)
- PyCharm new Python file name and the name of the module will import the same problem might arise (Programming)
- Oracle TDE transparent data encryption (Database)
- Java string equal size comparison (Programming)
- stat - Get more information than ls (Linux)
- Ubuntu install Lighttpd + Mono support .net (Linux)
- Some MySQL interview questions (Database)
- Linux performance optimization features Tuned and ktune (Linux)
- Linux Getting Started tutorial: Borrow Windows fonts in Ubuntu 14.10 (Linux)
- Solve the compatibility problem between Linux and Java at the source in bold font (Linux)
- Practical Handbook: 130+ improve the efficiency of commonly used commands Vim (Linux)
- Internet proxy workaround can not be used under Linux YUM (Linux)
- About Linux operating system security (Linux)
- How to install new fonts on Ubuntu 14.04 and 14.10 (Linux)
- To generate a certificate using OpenSSL under Linux (Server)
- Debian (Wheezy) were installed wxPython GUI development (Linux)
- Smack 4.1.x Upgrade Guide (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.