Os novos parâmetros do Oracle Database 12c
setembro 11, 2014

A cada nova versão do Oracle Database, novas funcionalidades, novas features e novas correções de bug’s são adicionados ao banco de dados e com isso novos parâmetros para controlar tudo isso. E não é de hoje que esses novos parâmetros são adicionados a uma nova versão de Oracle.

Exatamente na versão 9i Release 9.2.0.8.0 existiam cerca de 871 parâmetros de configuração do Oracle entre é claro parâmetros documentados e não documentados, já na versão 10g no Release 10.2.0.4.0 esse número passou para incríveis 1495 parâmetros, exatos 624 parâmetros a mais do que na versão anterior. Já com a versão 11g Release 11.2.0.4.0 que contém exatamente 2914 parâmetros, cerca de 2043 parâmetros a mais do que na versão 9i.

Com o lançamento do Oracle Database 12c, podemos mais uma vez fazer esse comparativo, isso através da table Oracle memory x$ksppi, que fornece todos os parâmetros documentados, parâmetros ocultos documentos e parâmetros ocultos não documentados pelo Oracle Database. É por intermédio dessa x$ table que podemos observar as diferenças de parâmetros entre uma versão e outra.

Veja o caso na versão 11g Release 11.2.0.4.0, temos exatos 2914 parâmetros:

SQ> select count(*) from x$ksppi;

  COUNT(*)
----------
      2914

1 row selected.

SQL>

Já na versão 12c (12.1.0.2.0), esse número passou para 3978:

SQL> select count(*) from x$ksppi;

  COUNT(*)
----------
      3978

SQL> 

Quase mil parâmetros a mais do que na versão anterior. Outro fato interessante que na versão 12.1.0.1.0 para a versão 12.1.0.2.0, já temos uma grande diferenças de novos parâmetros:

Oracle 12c (12.1.0.1.0)

SQL> select count(*) from x$ksppi;

  COUNT(*)
----------
      3351

1 row selected.

SQL>

Oracle 12c (12.1.0.2.0)


SQL> select count(*) from x$ksppi;

  COUNT(*)
----------
      3978

1 row selected.

SQL>

Abaixo está a lista completa de todos os parâmetros que estão somente na versão Oracle 12c, ou seja, todos os parâmetros a seguir são os novos parâmetros do Oracle 12c. Para conseguir isso, estou utilizando uma tabela temporária que criei chamada ksppi, que nada mais é que uma CTAS (Create Table AS) da x$ table x$ksppi, isso foi feito para conseguir realizar a consulta nos dados da x$ utilizando dblink.

Lembrando também que essa é a lista de todos os parâmetros documentos, ocultos documentados e ocultos não documentados. Nem preciso dizer que não é para você mudar qualquer um dos parâmetros ocultos abaixo, principalmente no seu banco de produção, sem antes ter a permissão do suporte Oracle. Tenha muito cuidado com qualquer um desses parâmetro ocultos.

Aqui a lista, com a descrição de cada parâmetro:

SQL> COLUMN PARAMETER_ONLY_12C FORMAT a50
SQL> COLUMN description FORMAT a80

SQL> SELECT 
2	KSPPINM PARAMETER_ONLY_12C, KSPPDESC description 
3    FROM ksppi 
4    WHERE KSPPINM NOT IN (SELECT KSPPINM parameter_name_11g FROM ksppi@db11g);

PARAMETER_ONLY_12C					     DESCRIPTION
-----------------------------------------------------        --------------------------------------------------------
_appqos_po_multiplier					     Multiplier for PC performance objective value
_appqos_cdb_setting					     QoSM CDB Performance Class Setting
_latch_wait_list_pri_sleep_secs 			     Time to sleep on latch wait list until getting priority
__wait_test_param					     wait test parameter
_system_state_runtime_limit				     runtime limit for system state dump
_system_state_cputime_limit				     cputime limit for system state dump
_enqueue_sync_retry_attempts				     max number of times the bg process to retry synchronous enqueue open if it faile
							     d because master could not allocate memory

_enqueue_sync_sim_mem_error				     simulate master instance running out of memory when synchronously getting a remo
							     tely mastered enqueue

_number_group_memberships_per_cache_line		     maximum number of group memberships per cache line
_ksdxw_stack_readable					     dump readable stack when watchpoint is hit
_touch_sga_pages_during_allocation			     touch SGA pages during allocation
_realfree_heap_pagesize 				     hint for real-free page size in bytes
_realfree_pq_heap_pagesize				     hint for pq real-free page size in bytes
_kgh_restricted_trace					     trace level for heap dump-restricted mode
_kgh_restricted_subheaps				     number of subheaps in heap restricted mode
_defer_sga_enabled					     Enable deferred shared memory allocation for SGA
_defer_sga_min_total_defer_segs_sz			     Minimum total deferred segs size for defer sga allocation
_defer_sga_alloc_chunk_size				     Chunk size for defer sga allocation
_defer_sga_min_spsz_at_startup				     Minimum shared pool size at startup with deferred sga enabled
_defer_sga_test_alloc_intv				     SA** sleeps for N secs before allocating a deferred segment
_sga_alloc_slaves_term_timeout_secs			     Termination timeout in secs for SA** slaves
_ksmlsaf						     KSM log alloc and free
_pga_limit_target_perc					     default percent of pga_aggregate_target for pga_aggregate_limit
_pga_limit_watch_perc					     percentage of limit to have processes watch
_pga_limit_time_to_interrupt				     seconds to wait until direct interrupt
_pga_limit_interrupt_smaller				     whether to interrupt smaller eligible processes
_pga_limit_time_until_idle				     seconds to wait before treating process as idle
_pga_limit_time_until_killed				     seconds to wait before killing session over limit
_pga_limit_use_immediate_kill				     use immediate kill for sessions over limit
_pga_limit_dump_summary 				     dump PGA summary when signalling ORA-4036
_pga_limit_watch_size					     bytes of PGA usage at which process will begin watching limit
_pga_limit_min_req_size 				     bytes of PGA usage below which process will not get ORA-4036
_pga_limit_check_wait_time				     microseconds to wait for over limit confirmation
_pga_limit_simulated_physmem_size			     bytes of physical memory to determine pga_aggregate_limit with
_pga_limit_physmem_perc 				     default percent of physical memory for pga_aggregate_limit and SGA
_sga_data_protection_disabled				     disable SGA data protection
_sga_dp_precise_errors					     enable precise SGA data protection errors
_sga_heap_chunk_alignment				     force SGA heap chunk alignment
_sga_heap_chunk_alignment_disabled			     force SGA heap chunks not to be aligned
_sga_dp_bytes_per_alloc 				     bytes per allocation that have SGA data protection
_NUMA_bind_mode 					     Numa bind mode
pga_aggregate_limit					     limit of aggregate PGA memory consumed by the instance
_pga_limit_tracing					     trace pga_aggregate_limit activity
_test_param_8						     test parameter 8 - cdb tests
_highest_priority_processes				     Highest Priority Process Name Mask
_os_sched_highest_priority				     OS highest priority level
_bg_spawn_diag_opts					     background processes spawn diagnostic options
_mpmt_enabled_backgrounds				     mpmt enabled backgrounds
_background_process_opts				     Misc BG procs parameter
_kse_snap_ring_suppress 				     List of error numbers to suppress in the snap error history
_kse_snap_ring_disable					     set to TRUE or FALSE to disable or enable error logging
_enqueue_deadlock_detect_all_global_locks		     enable deadlock detection on all global enqueues
_enable_kernel_io_outliers				     enable kernel I/O outlier feature
_dnfs_rdma_max						     Maximum size of dNFS RDMA transfer
_dnfs_rdma_min						     Minimum size of dNFS RDMA transfer
_dnfs_rdma_enable					     Enable dNFS RDMA transfers
_simulate_logical_sectorsize				     Enables skgfr to report simulated logical disk sector size
_io_outlier_threshold					     Latency threshold for io_outlier table
_lgwr_io_outlier					     LGWR I/O outlier frequency
_asm_access						     ASM File access mechanism
_ksfd_fob_pct						     percentage of FOB state objects allocation
_use_dynamic_shares					     use dynamic shares
_dynamic_share_range_factor				     dynamic share range factor
_cpu_util_adj_force					     force cpu util adjustment
_cpu_util_adj_target					     cpu utilization adjustment target
_high_threshold_delta					     high threshold delta
db_performance_profile					     Database performance category
_rm_force_caging
_ksv_slave_exit_timeout 				     slave exit timeout
_twenty-ninth_spare_parameter				     twenty-ninth spare parameter - integer
_thirty-ninth_spare_parameter				     thirty-ninth spare parameter - integer
_forty-first_spare_parameter				     forty-first spare parameter - integer
_forty-second_spare_parameter				     forty-second spare parameter - integer
_forty-third_spare_parameter				     forty-third spare parameter - integer
_forty-fourth_spare_parameter				     forty-fourth spare parameter - integer
_forty-fifth_spare_parameter				     forty-fifth spare parameter - integer
_forty-sixth_spare_parameter				     forty-sixth spare parameter - integer
_forty-seventh_spare_parameter				     forty-seventh spare parameter - integer
_forty-eighth_spare_parameter				     forty-eighth spare parameter - integer
_forty-ninth_spare_parameter				     forty-ninth spare parameter - integer
_fiftieth_spare_parameter				     fiftieth spare parameter - integer
_fifty-first_spare_parameter				     fifty-first spare parameter - integer
_fifty-second_spare_parameter				     fifty-second spare parameter - integer
_fifty-third_spare_parameter				     fifty-third spare parameter - integer
_fifty-fourth_spare_parameter				     fifty-fourth spare parameter - integer
_fifty-fifth_spare_parameter				     fifty-fifth spare parameter - integer
_fifty-sixth_spare_parameter				     fifty-sixth spare parameter - integer
_fifty-seventh_spare_parameter				     fifty-seventh spare parameter - integer
_fifty-eighth_spare_parameter				     fifty-eighth spare parameter - integer
_fifty-ninth_spare_parameter				     fifty-ninth spare parameter - integer
_sixtieth_spare_parameter				     sixtieth spare parameter - integer
_sixty-first_spare_parameter				     sixty-first spare parameter - integer
_sixty-second_spare_parameter				     sixty-second spare parameter - integer
_sixty-third_spare_parameter				     sixty-third spare parameter - integer
_sixty-fourth_spare_parameter				     sixty-fourth spare parameter - integer
_sixty-fifth_spare_parameter				     sixty-fifth spare parameter - integer
_sixty-sixth_spare_parameter				     sixty-sixth spare parameter - integer
_sixty-seventh_spare_parameter				     sixty-seventh spare parameter - integer
_sixty-eighth_spare_parameter				     sixty-eighth spare parameter - integer
_sixty-ninth_spare_parameter				     sixty-ninth spare parameter - integer
_seventieth_spare_parameter				     seventieth spare parameter - integer
_seventy-first_spare_parameter				     seventy-first spare parameter - integer
_seventy-second_spare_parameter 			     seventy-second spare parameter - integer
_seventy-third_spare_parameter				     seventy-third spare parameter - integer
_seventy-fourth_spare_parameter 			     seventy-fourth spare parameter - integer
_seventy-fifth_spare_parameter				     seventy-fifth spare parameter - integer
_seventy-sixth_spare_parameter				     seventy-sixth spare parameter - integer
_seventy-seventh_spare_parameter			     seventy-seventh spare parameter - integer
_seventy-eighth_spare_parameter 			     seventy-eighth spare parameter - integer
_seventy-ninth_spare_parameter				     seventy-ninth spare parameter - integer
_eightieth_spare_parameter				     eightieth spare parameter - integer
_eighty-first_spare_parameter				     eighty-first spare parameter - string
_eighty-second_spare_parameter				     eighty-second spare parameter - string
_eighty-third_spare_parameter				     eighty-third spare parameter - string
_eighty-fourth_spare_parameter				     eighty-fourth spare parameter - string
_eighty-fifth_spare_parameter				     eighty-fifth spare parameter - string
_eighty-sixth_spare_parameter				     eighty-sixth spare parameter - string
_eighty-seventh_spare_parameter 			     eighty-seventh spare parameter - string
_eighty-eighth_spare_parameter				     eighty-eighth spare parameter - string
_eighty-ninth_spare_parameter				     eighty-ninth spare parameter - string
_ninetieth_spare_parameter				     ninetieth spare parameter - string
_ninety-first_spare_parameter				     ninety-first spare parameter - string
_ninety-second_spare_parameter				     ninety-second spare parameter - string
_ninety-third_spare_parameter				     ninety-third spare parameter - string
_ninety-fourth_spare_parameter				     ninety-fourth spare parameter - string
_ninety-fifth_spare_parameter				     ninety-fifth spare parameter - string
_ninety-sixth_spare_parameter				     ninety-sixth spare parameter - string
_ninety-seventh_spare_parameter 			     ninety-seventh spare parameter - string
_ninety-eighth_spare_parameter				     ninety-eighth spare parameter - string
_ninety-ninth_spare_parameter				     ninety-ninth spare parameter - string
_one-hundredth_spare_parameter				     one-hundredth spare parameter - string
_one-hundred-and-first_spare_parameter			     one-hundred-and-first spare parameter - string
_one-hundred-and-second_spare_parameter 		     one-hundred-and-second spare parameter - string
_one-hundred-and-third_spare_parameter			     one-hundred-and-third spare parameter - string
_one-hundred-and-fourth_spare_parameter 		     one-hundred-and-fourth spare parameter - string
_one-hundred-and-fifth_spare_parameter			     one-hundred-and-fifth spare parameter - string
_one-hundred-and-sixth_spare_parameter			     one-hundred-and-sixth spare parameter - string
_one-hundred-and-seventh_spare_parameter		     one-hundred-and-seventh spare parameter - string
_one-hundred-and-eighth_spare_parameter 		     one-hundred-and-eighth spare parameter - string
_one-hundred-and-ninth_spare_parameter			     one-hundred-and-ninth spare parameter - string
_one-hundred-and-tenth_spare_parameter			     one-hundred-and-tenth spare parameter - string
_one-hundred-and-eleventh_spare_parameter		     one-hundred-and-eleventh spare parameter - string
_one-hundred-and-twelfth_spare_parameter		     one-hundred-and-twelfth spare parameter - string
_one-hundred-and-thirteenth_spare_parameter		     one-hundred-and-thirteenth spare parameter - string
_one-hundred-and-fourteenth_spare_parameter		     one-hundred-and-fourteenth spare parameter - string
_one-hundred-and-fifteenth_spare_parameter		     one-hundred-and-fifteenth spare parameter - string
_one-hundred-and-sixteenth_spare_parameter		     one-hundred-and-sixteenth spare parameter - string
_one-hundred-and-seventeenth_spare_parameter		     one-hundred-and-seventeenth spare parameter - string
_one-hundred-and-eighteenth_spare_parameter		     one-hundred-and-eighteenth spare parameter - string
_one-hundred-and-nineteenth_spare_parameter		     one-hundred-and-nineteenth spare parameter - string
_one-hundred-and-twentieth_spare_parameter		     one-hundred-and-twentieth spare parameter - string
_one-hundred-and-twenty-first_spare_parameter		     one-hundred-and-twenty-first spare parameter - string
_one-hundred-and-twenty-second_spare_parameter		     one-hundred-and-twenty-second spare parameter - string
_one-hundred-and-twenty-third_spare_parameter		     one-hundred-and-twenty-third spare parameter - string
_one-hundred-and-twenty-fourth_spare_parameter		     one-hundred-and-twenty-fourth spare parameter - string
_one-hundred-and-twenty-fifth_spare_parameter		     one-hundred-and-twenty-fifth spare parameter - string
_one-hundred-and-twenty-sixth_spare_parameter		     one-hundred-and-twenty-sixth spare parameter - string
_one-hundred-and-twenty-seventh_spare_parameter 	     one-hundred-and-twenty-seventh spare parameter - string
_one-hundred-and-twenty-eighth_spare_parameter		     one-hundred-and-twenty-eighth spare parameter - string
_one-hundred-and-twenty-ninth_spare_parameter		     one-hundred-and-twenty-ninth spare parameter - string
_one-hundred-and-thirtieth_spare_parameter		     one-hundred-and-thirtieth spare parameter - string
_one-hundred-and-thirty-first_spare_parameter		     one-hundred-and-thirty-first spare parameter - string list
_one-hundred-and-thirty-second_spare_parameter		     one-hundred-and-thirty-second spare parameter - string list
_one-hundred-and-thirty-third_spare_parameter		     one-hundred-and-thirty-third spare parameter - string list
_one-hundred-and-thirty-fourth_spare_parameter		     one-hundred-and-thirty-fourth spare parameter - string list
_one-hundred-and-thirty-fifth_spare_parameter		     one-hundred-and-thirty-fifth spare parameter - string list
_one-hundred-and-thirty-sixth_spare_parameter		     one-hundred-and-thirty-sixth spare parameter - string list
_one-hundred-and-thirty-seventh_spare_parameter 	     one-hundred-and-thirty-seventh spare parameter - string list
_one-hundred-and-thirty-eighth_spare_parameter		     one-hundred-and-thirty-eighth spare parameter - string list
_one-hundred-and-thirty-ninth_spare_parameter		     one-hundred-and-thirty-ninth spare parameter - string list
_one-hundred-and-fortieth_spare_parameter		     one-hundred-and-fortieth spare parameter - string list
_one-hundred-and-forty-first_spare_parameter		     one-hundred-and-forty-first spare parameter - boolean
_one-hundred-and-forty-second_spare_parameter		     one-hundred-and-forty-second spare parameter - boolean
_one-hundred-and-forty-third_spare_parameter		     one-hundred-and-forty-third spare parameter - boolean
_one-hundred-and-forty-fourth_spare_parameter		     one-hundred-and-forty-fourth spare parameter - boolean
_one-hundred-and-forty-fifth_spare_parameter		     one-hundred-and-forty-fifth spare parameter - boolean
_one-hundred-and-forty-sixth_spare_parameter		     one-hundred-and-forty-sixth spare parameter - boolean
_one-hundred-and-forty-seventh_spare_parameter		     one-hundred-and-forty-seventh spare parameter - boolean
_one-hundred-and-forty-eighth_spare_parameter		     one-hundred-and-forty-eighth spare parameter - boolean
_one-hundred-and-forty-ninth_spare_parameter		     one-hundred-and-forty-ninth spare parameter - boolean
_one-hundred-and-fiftieth_spare_parameter		     one-hundred-and-fiftieth spare parameter - boolean
_one-hundred-and-fifty-first_spare_parameter		     one-hundred-and-fifty-first spare parameter - boolean
_one-hundred-and-fifty-second_spare_parameter		     one-hundred-and-fifty-second spare parameter - boolean
_one-hundred-and-fifty-third_spare_parameter		     one-hundred-and-fifty-third spare parameter - boolean
_one-hundred-and-fifty-fourth_spare_parameter		     one-hundred-and-fifty-fourth spare parameter - boolean
_one-hundred-and-fifty-fifth_spare_parameter		     one-hundred-and-fifty-fifth spare parameter - boolean
_one-hundred-and-fifty-sixth_spare_parameter		     one-hundred-and-fifty-sixth spare parameter - boolean
_one-hundred-and-fifty-seventh_spare_parameter		     one-hundred-and-fifty-seventh spare parameter - boolean
_one-hundred-and-fifty-eighth_spare_parameter		     one-hundred-and-fifty-eighth spare parameter - boolean
_one-hundred-and-fifty-ninth_spare_parameter		     one-hundred-and-fifty-ninth spare parameter - boolean
_one-hundred-and-sixtieth_spare_parameter		     one-hundred-and-sixtieth spare parameter - boolean
_one-hundred-and-sixty-first_spare_parameter		     one-hundred-and-sixty-first spare parameter - boolean
_one-hundred-and-sixty-second_spare_parameter		     one-hundred-and-sixty-second spare parameter - boolean
_one-hundred-and-sixty-third_spare_parameter		     one-hundred-and-sixty-third spare parameter - boolean
_one-hundred-and-sixty-fourth_spare_parameter		     one-hundred-and-sixty-fourth spare parameter - boolean
_one-hundred-and-sixty-fifth_spare_parameter		     one-hundred-and-sixty-fifth spare parameter - boolean
_one-hundred-and-sixty-sixth_spare_parameter		     one-hundred-and-sixty-sixth spare parameter - boolean
_one-hundred-and-sixty-seventh_spare_parameter		     one-hundred-and-sixty-seventh spare parameter - boolean
_one-hundred-and-sixty-eighth_spare_parameter		     one-hundred-and-sixty-eighth spare parameter - boolean
_one-hundred-and-sixty-ninth_spare_parameter		     one-hundred-and-sixty-ninth spare parameter - boolean
_one-hundred-and-seventieth_spare_parameter		     one-hundred-and-seventieth spare parameter - boolean
_one-hundred-and-seventy-first_spare_parameter		     one-hundred-and-seventy-first spare parameter - boolean
_one-hundred-and-seventy-second_spare_parameter 	     one-hundred-and-seventy-second spare parameter - boolean
_one-hundred-and-seventy-third_spare_parameter		     one-hundred-and-seventy-third spare parameter - boolean
_one-hundred-and-seventy-fourth_spare_parameter 	     one-hundred-and-seventy-fourth spare parameter - boolean
_one-hundred-and-seventy-fifth_spare_parameter		     one-hundred-and-seventy-fifth spare parameter - boolean
_one-hundred-and-seventy-sixth_spare_parameter		     one-hundred-and-seventy-sixth spare parameter - boolean
_one-hundred-and-seventy-seventh_spare_parameter	     one-hundred-and-seventy-seventh spare parameter - boolean
_one-hundred-and-seventy-eighth_spare_parameter 	     one-hundred-and-seventy-eighth spare parameter - boolean
_one-hundred-and-seventy-ninth_spare_parameter		     one-hundred-and-seventy-ninth spare parameter - boolean
_one-hundred-and-eightieth_spare_parameter		     one-hundred-and-eightieth spare parameter - boolean
_one-hundred-and-eighty-first_spare_parameter		     one-hundred-and-eighty-first spare parameter - boolean
_one-hundred-and-eighty-second_spare_parameter		     one-hundred-and-eighty-second spare parameter - boolean
_one-hundred-and-eighty-third_spare_parameter		     one-hundred-and-eighty-third spare parameter - boolean
_one-hundred-and-eighty-fourth_spare_parameter		     one-hundred-and-eighty-fourth spare parameter - boolean
_one-hundred-and-eighty-fifth_spare_parameter		     one-hundred-and-eighty-fifth spare parameter - boolean
_one-hundred-and-eighty-sixth_spare_parameter		     one-hundred-and-eighty-sixth spare parameter - boolean
_one-hundred-and-eighty-seventh_spare_parameter 	     one-hundred-and-eighty-seventh spare parameter - boolean
_one-hundred-and-eighty-eighth_spare_parameter		     one-hundred-and-eighty-eighth spare parameter - boolean
_one-hundred-and-eighty-ninth_spare_parameter		     one-hundred-and-eighty-ninth spare parameter - boolean
_one-hundred-and-ninetieth_spare_parameter		     one-hundred-and-ninetieth spare parameter - boolean
_one-hundred-and-ninety-first_spare_parameter		     one-hundred-and-ninety-first spare parameter - boolean
_one-hundred-and-ninety-second_spare_parameter		     one-hundred-and-ninety-second spare parameter - boolean
_one-hundred-and-ninety-third_spare_parameter		     one-hundred-and-ninety-third spare parameter - boolean
_one-hundred-and-ninety-fourth_spare_parameter		     one-hundred-and-ninety-fourth spare parameter - boolean
_one-hundred-and-ninety-fifth_spare_parameter		     one-hundred-and-ninety-fifth spare parameter - boolean
_one-hundred-and-ninety-sixth_spare_parameter		     one-hundred-and-ninety-sixth spare parameter - boolean
_one-hundred-and-ninety-seventh_spare_parameter 	     one-hundred-and-ninety-seventh spare parameter - boolean
_one-hundred-and-ninety-eighth_spare_parameter		     one-hundred-and-ninety-eighth spare parameter - boolean
_one-hundred-and-ninety-ninth_spare_parameter		     one-hundred-and-ninety-ninth spare parameter - boolean
_two-hundredth_spare_parameter				     two-hundredth spare parameter - boolean
_two-hundred-and-first_spare_parameter			     two-hundred-and-first spare parameter - boolean
_two-hundred-and-second_spare_parameter 		     two-hundred-and-second spare parameter - boolean
_two-hundred-and-third_spare_parameter			     two-hundred-and-third spare parameter - boolean
_two-hundred-and-fourth_spare_parameter 		     two-hundred-and-fourth spare parameter - boolean
_two-hundred-and-fifth_spare_parameter			     two-hundred-and-fifth spare parameter - boolean
_two-hundred-and-sixth_spare_parameter			     two-hundred-and-sixth spare parameter - boolean
_two-hundred-and-seventh_spare_parameter		     two-hundred-and-seventh spare parameter - boolean
_two-hundred-and-eighth_spare_parameter 		     two-hundred-and-eighth spare parameter - boolean
_two-hundred-and-ninth_spare_parameter			     two-hundred-and-ninth spare parameter - boolean
_two-hundred-and-tenth_spare_parameter			     two-hundred-and-tenth spare parameter - boolean
_two-hundred-and-eleventh_spare_parameter		     two-hundred-and-eleventh spare parameter - boolean
_two-hundred-and-twelfth_spare_parameter		     two-hundred-and-twelfth spare parameter - boolean
_two-hundred-and-thirteenth_spare_parameter		     two-hundred-and-thirteenth spare parameter - boolean
_two-hundred-and-fourteenth_spare_parameter		     two-hundred-and-fourteenth spare parameter - boolean
_two-hundred-and-fifteenth_spare_parameter		     two-hundred-and-fifteenth spare parameter - boolean
_two-hundred-and-sixteenth_spare_parameter		     two-hundred-and-sixteenth spare parameter - boolean
_two-hundred-and-seventeenth_spare_parameter		     two-hundred-and-seventeenth spare parameter - boolean
_two-hundred-and-eighteenth_spare_parameter		     two-hundred-and-eighteenth spare parameter - boolean
_two-hundred-and-nineteenth_spare_parameter		     two-hundred-and-nineteenth spare parameter - boolean
_two-hundred-and-twentieth_spare_parameter		     two-hundred-and-twentieth spare parameter - boolean
_ksipc_mode						     ksipc mode
_ksipc_libipc_path					     over-ride default location of libipc
_ksipc_wait_flags					     tune ksipcwait
_ksipc_spare_param1					     ksipc spare param 1
_ksipc_spare_param2					     ksipc spare param 2
_ksxp_ksmsq_ip_config					     ksxp ksmsq ip config
_ksxp_ipclw_enabled					     enable ipclw for KSXP
_ipc_config_opts_stat					     static config for ipclw startup
_ipc_config_opts_dyn					     Dyn config for ipclw startup
_ksipc_efchecks 					     Check HCA/OS version for Exafusion
_datapump_metadata_buffer_size				     specifies buffer size for metadata file I/O
_datapump_tabledata_buffer_size 			     specifies buffer size for table data file I/O
_datapump_compressbas_buffer_size			     specifies buffer size for BASIC compression algorithm
_midtier_affinity_cluswait_prc_threshold		     cluster wait precentage threshold to enter affinity
_disable_modsvc_refresh 				     disable modify service cache refresh
threaded_execution					     Threaded Execution Mode
_mpmt_single_process_instance				     MPMT - single process instance mode enabled
_mpmt_procs_per_osp					     max procs per osp
_prespawn_batch_count					     prespawn batch count
_dataguard_prespawn_count				     prespawn foreground init count
_proc_grp_enabled					     proc-group enabled
_min_time_between_psp0_diag_secs			     minimum time between PSP0 diagnostic used for flow control
_disable_rolling_patch					     Disable Rolling Patch Feature
_deadlock_record_to_alert_log				     record resolved deadlocks to the alert log
_process_heartbeat_range				     Process heartbeat range
_lthread_cleanup_intv_secs				     interval for cleaning lightweight threads in secs
_lthread_enabled					     Enable lightweight threads
_lthread_debug						     Enable Debugging mode for lightweight threads
_lthread_max_spawn_time_csecs				     maximum time interval a spawner will wait for a lthread to get ready
_lthread_spawn_check_intv_ms				     time interval for a spawner to check for spawnee to get ready
_lthread_clnup_pmon_softkill_wait_secs			     wait timeout for PMON between soft kill and hard kill of lthreads
_lthread_clnup_spawner_sk_wait_secs			     timeout for spawner between soft kill and hard kill of lthreads
_lthread_clnup_hk_wait_secs				     timeout after hard killing operation for lthread to exit
_lthread_step_debugging 				     Enable Step wise Debugging mode for lightweight threads
_full_diag_on_rim					     rim nodes have full DIA* function
_hang_cross_boundary_hang_detection_enabled		     Hang Management Cross Boundary detection
_hang_resolution_percent_hung_sessions_threshold	     Hang Manager hang resolution percent hung sessions threshold
_hang_terminate_session_replay_enabled			     Hang Management terminates sessions allowing replay
_diag_xm_enabled					     If TRUE, DIAG allows message exchanges across DB/ASM boundary
_hm_xm_enabled						     If TRUE, DIA0 allows message exchanges across DB/ASM boundary
_lm_hash_control					     bit field controlling the hashing behavior of the lock manager
_ges_server_processes					     number of background global enqueue server processes
_lm_lms_opt_priority					     enable freeslot lms priority optimization
_lm_lms_priority_check_frequency			     frequency of LMS priority decisions in milliseconds
_lm_db_rank						     rank of this DB for process priority purposes
_lm_db_ranks						     ranks of DBs on this node
_lm_cache_enqueue					     string of enqueues to cache at the client: separate by |, use DECIMAL identifier
							     s or '*' as wildcard, eg. AK-12-*

_lm_reloc_use_mhint					     if TRUE, AR-/AH-enqueues use mastering hints
_lm_rcfg_kjcdump_time					     dlm reconfiguration communication dump interval
_lm_enqueue_blocker_dump_timeout_cnt			     enqueue blocker dump timeout count
_lm_num_bnft_stats_buckets				     number of buckets in the benefit stats hash table
_lm_exchange_opt					     exchange step optimization in reconfig
_lm_drm_we_size 					     size of drm wait events statistics
_lm_drm_we_interval					     drm wait events collection interval in seconds
_read_mostly_instance					     indicates this is a read_mostly instance
_read_mostly_instance_qa_control			     internal parameter to control read mostly instance QA
_read_mostly_slave_timeout				     Time to wait on read mostly node when hub not available
_read_mostly_enable_logon				     Read mostly instances enable non-privileged logons
_lm_big_cluster_optimizations				     enable certain big cluster optimizations in drm
_ges_lmd_mapping					     enqueue to lmd mapping
_ges_hash_groups					     enqueue hash table groups
_ges_default_lmds					     default lmds for enqueue hashing
_ges_nres_divide					     how to divide number of enqueue resources among hash tables
_lm_drmopt12						     enable drm scan optimizations in 12
_lm_adrm_options					     active drm options
_lm_adrm_scan_timeout					     active drm f2a/flush scan timeout in centisecs
_lm_adrm_interval					     active drm interval in centiseconds
_lm_adrm_time_out					     active drm timeout in minutes
_lm_resend_open_convert_timeout 			     timeout in secs before resubmitting the open-convert
_lm_process_lock_q_scan_limit				     limit on scanning process lock queue instead of resource convert lock queue
_ges_gather_res_reuse_stats				     if TRUE, gather resource reuse statistics
_ges_freeable_res_chunk_free				     if TRUE, free dynamic resource chunks which are freeable
_lm_share_lock_restype					     string of resource types using S-lock optimisation
_ges_freeable_res_chunk_free_interval			     time interval for freeing freeable dynamic resource chunks
_ges_dump_open_locks					     if TRUE, dump open locks for the LCK process during shutdown
_lm_exadata_fence_type					     if FALSE disable Exadata fence type
_rond_test_mode 					     rac one node test mode
_adg_distributed_lockmaster				     standby runs under ADG distributed lockmaster mode
_kjdd_call_stack_dump_enabled				     Enables printing of short call stack with the WFG
_kjdd_wfg_dump_cntrl					     To control the way Wait-For_Graph is dumped
_omni_enqueue_enable					     Enable Omni Enqueue feature (0 = disable, 1 = enable on ASM (default), 2 = enabl
							     e)

_lm_idle_connection_kill_max_skips			     GES idle connection max skip kill request
_lm_idle_connection_quorum_threshold			     GES idle connection health quorum threshold
_lm_msg_pool_dump_threshold				     GES message pool dump threshold in terms of buffer count
_lm_msg_pool_user_callstack_dump			     GES message pool call stack dump upon exceeding of threshold
_lm_idle_connection_max_ignore_kill_count		     GES maximum idle connection kill request ignore count
_lm_mp_avail_queue_threshold				     GES MP avail queue threshold
_lm_mp_bulk_mbuf_free					     GES MP bulk free message buffer queues
_lm_wait_pending_send_queue				     GES wait on pending send queue
_lm_hashtable_bkt_low					     Low element threshold in hash table bucket
_lm_hashtable_bkt_high					     High element threshold in hash table bucket
_lm_hashtable_bkt_thr					     Threshold for hash table resizing
_lm_comm_tkts_adaptive					     Adpative ticketing enabled
_lm_comm_tkts_calc_period_length			     Weighted average calculation interval length (second)
_lm_comm_tkts_max_periods				     Max number of periods used in weighted avearage calculation
_lm_comm_tkts_min_increase_wait 			     Seconds to wait before allowing an allocation increase
_lm_comm_tkts_min_decrease_wait 			     Seconds to wait before allowing an allocation decrease
_lm_comm_tkts_nullreq_threshold 			     Null request threshold
_lm_comm_tkts_mult_factor				     Ticket allocation multiplication factor
_lm_comm_tkts_sub_factor				     Ticket allocation subtraction factor
_lm_comm_tkts_max_add					     Ticket allocation maximum allotments
_exafusion_enabled					     enable exafusion
_lm_comm_channel					     GES communication channel type
_lm_comm_msgq_busywait					     busy wait time in microsecond for msgq
_lm_comm_reap_count					     message reap count for receive
_lm_gl_hash_scheme					     group lock table hashing scheme (0|1|2)
_cluster_flash_cache_slave_file 			     cluster flash cache slave file for default block size
_gcs_res_hash_buckets					     number of gcs resource hash buckets to be allocated
_gcs_reserved_resources 				     allocate the number of reserved resources in reconfiguration
_gcs_min_slaves 					     if non zero, it enables the minimum number of gcs slaves
_gcs_dynamic_slaves					     if TRUE, it enables dynamic adjustment of the number of gcs slaves
_gcs_reserved_shadows					     allocate the number of reserved shadows in reconfiguration
_broadcast_scn_mode					     broadcast-on-commit scn mode
_nameservice_consistency_check				     NameService Consistency check switch
_nameservice_request_batching				     NameService request batching switch
_cgs_ticket_sendback					     CGS ticket active sendback percentage threshold
_cgs_msg_batch_size					     CGS message batch size in bytes
_cgs_msg_batching					     CGS message batching
_cgs_comm_readiness_check				     CGS communication readiness check
_imr_rr_holder_kill_time				     IMR max time instance is allowed to hold RR lock in seconds
_imr_check_css_incarnation_number			     IMR verify the global consistency of CSS incarnation number
_cgs_memberkill_from_rim_instance			     allow a RIM instance to issue a CSS member kill
_cgs_os_level_connection_check				     allow OS level connection and interface check
_cgs_os_level_connection_reqno				     number of ping rqst to process at once, threads created
_cgs_big_group_enabled					     big group membership support
_cgs_support_rim_disc					     rim instance disconnect and reconnect event support
_lm_rm_slaves						     if non zero, it enables remastering slaves
_lm_timed_statistics_level				     if non zero, it enables timed statistics on lmd and lms
_shutdown_sync_enable					     if TRUE, shutdown sync is issued before shutdown normal
_crs_2phase						     crs 2phase
_ges_vbfreelists					     number of valueblock freelists (will be adjusted to power of 2)
_lm_hb_enable_acl_check 				     to enable the wait analysis with acceptable condition lists
_lm_hb_acceptable_hang_condition			     list of acceptable hang conditions in heartbeat check
_lm_hb_maximum_hang_report_count			     maximum heartbeat hang report count
_lm_hb_exponential_hang_time_factor			     heartbeat exponential hang time multiplier
_gcr_enable_high_memory_kill				     if TRUE, GCR may kill foregrounds under high memory load
_gcr_high_memory_threshold				     minimum amount of Memory process must consume to be kill target
_gcr_cpu_min_free					     minimum amount of free CPU to flag an anomaly
_gcr_mem_min_free					     minimum amount of free memory to flag an anomaly
_gcr_css_use_2group_lock				     if FALSE, GCR will not try to lock 2 CSS groups at the same time
_gcr_css_group_try_lock_delay				     minimum delay between group locking attempts, secs
_gcr_css_group_query_boost				     allowed number of serial multiple queries
_gcr_css_group_update_interval				     interval between CSS group updates, secs
_gcr_css_group_update2_interval 			     interval between CSS group updates when busy, secs
_gcr_css_group_large					     size of large CSS group above which query/update disabled
_gcr_tick						     duration of time tick used by state machine, centisecs
_gcr_enable_statistical_cpu_check			     if FALSE, revert to old cpu load metric
_gcr_enable_new_drm_check				     if FALSE, revert to old drm load metric
_gcr_max_rt_procs					     maximum number of RT DLM processes allowed by GCR
_kjac_force_outcome_current_session			     if TRUE, enable to run force outcome on the current session
_ka_enabled						     Enable/disable kernel accelerator
_ka_mode						     kernel accelerator mode
_ka_locks_per_sector					     locks per sector in kernel accelerator
_ka_msg_reap_count					     maximum number of KA messages to receive and process per wait
_ka_compatibility_requirement				     kernel accelerator compatibility operation requirement
_ka_allow_reenable					     reenability of kernel accelerator service after disable
_ka_pbatch_messages					     kernel accelerator perform pbatch messages
_ka_doorbell						     kernel accelerator doorbell mode
_ka_scn_enabled 					     KA SCN processing enabled
_ka_scn_accel_shrmem					     KA SCN accelerate shr memory
_ka_scn_use_ka_msgs					     KA SCN use KA type messages
_ka_grant_policy					     KA grant policy to favor fusion grant, make it automatic, or favor KA
_ka_msg_wait_count					     KA maximum number of requests to retrieve per OSD wait
_ka_max_wait_delay					     KA maximum amount of time before forcing OSD wait call
_gcs_cluster_flash_cache_mode				     cluster flash cache mode
_gcs_flash_cache_mode					     flash cache mode
_max_defer_gran_xfer_atonce				     Maximum deferred granules transferred by MMAN atonce
_asm_allow_small_memory_target				     Allow a small memory_target for ASM instances
_controlfile_split_brain_check				     Check for a split-brain in distributed lock manager domain
db_big_table_cache_percent_target			     Big table cache target size in percentage
_db_full_db_cache_diff_pct				     Cache at least this % larger than DB size for full db caching
_db_writer_coalesce_encrypted_buffers			     Coalecsing for encrypted buffers
_dbwr_stall_write_detection_interval			     dbwriter stall write detection interval
_pin_time_statistics					     if TRUE collect statistics for how long a current pin is held
_adg_buffer_wait_timeout				     Active Dataguard buffer wait time in cs
_db_full_caching					     enable full db implicit caching
_db_flash_cache_disable_write_batchsize 		     Flash cache disable writes processing batchsize
_switch_current_scan_scn				     switch current uses scan scn
_cleanout_shrcur_buffers				     if TRUE, cleanout shrcur buffers
_child_read_ahead_dba_check				     if TRUE, assert child read ahead dba to be continuous of parent
_data_warehousing_scan_buffers				     if TRUE, enable data warehousing scan buffers
_data_warehousing_scan_flash_buffers			     if TRUE, enable data warehousing scan flash buffers
_data_warehousing_serial_scan				     if TRUE, enable data warehousing serial scans
_db_dw_scan_obj_cooling_policy				     DW scan objtect cooling policy
_db_dw_scan_obj_cooling_interval			     DW Scan object cooling interval in number of scans, seconds, or pct of cache siz
							     e

_db_dw_scan_obj_cooling_factor				     DW Scan object cooling factor to cool all temperatures
_db_dw_scan_obj_warming_increment			     DW Scan object warming increment when an object is scanned
_db_dw_scan_adaptive_cooling				     if TRUE, enable adaptive DW scan cooling
_db_dw_scan_max_shadow_count				     DW Scan adaptive cooling max shadow count
_pq_numa_working_set_affinity				     if TRUE, enable pq slave NUMA affinity
_db_cache_advice_hash_latch_multiple			     cache advisory hash latch multiple
_redo_log_record_life					     Life time in hours for redo log table records
_redo_log_debug_config					     Various configuration flags for debugging redo logs
_redo_log_check_backup					     time interval in minutes between wakeups to check backup of redo logs
_cache_orl_during_open					     cache online logs
_target_log_write_size					     Do log write if this many redo blocks in buffer (auto=0)
_target_log_write_size_timeout				     How long LGWR will wait for redo to accumulate (csecs)
_use_single_log_writer					     Use a single process for redo log writing
_max_outstanding_log_writes				     Maximum number of outstanding redo log writes
_adaptive_scalable_log_writer_enable_worker_threshold	     Increase in redo generation rate as a percentage
_adaptive_scalable_log_writer_disable_worker_threshold	     Percentage of overlap across multiple outstanding writes
_adaptive_scalable_log_writer_sampling_count		     Evaluate single versus scalable LGWR every N writes
_adaptive_scalable_log_writer_sampling_time		     Evaluate single versus scalable LGWR every N seconds
_adaptive_scalable_log_writer_enable_worker_aging	     Per million of redo gen rate when LGWR workers were last used
_max_log_write_parallelism				     Maximum parallelism within a log write (auto=0)
_max_log_write_io_parallelism				     Maximum I/O parallelism within a log write (auto=0)
_serial_log_write_worker_io				     Serialize log write slave I/O
_simulated_log_write_usecs				     Simulated latency of log writes (usecs)
_adaptive_log_file_sync_use_postwait_threshold_aging	     Permille of foreground load from when post/wait was last used
_adaptive_log_file_sync_sampling_count			     Evaluate post/wait versus polling every N writes
_adaptive_log_file_sync_sampling_time			     Evaluate post/wait versus polling every N seconds
_check_pdbid_in_redo					     Enable checking of pluggable database ID in redo
_ping_wait_for_log_force				     Wait for log force before block ping
_log_writer_worker_dlm_hearbeat_update_freq		     LGWR worker DLM health-monitoring heartbeat update frequency (ms)
_hb_redo_interval					     generic heartbeat redo frequency
_disable_file_resize_logging				     disable file resize logging to alert log
_file_set_enqueue_timeout				     Timeout to acquire file set enqueue (secs)
_file_offline_sync_timeout				     Timeout to sync file offline enqueue (secs)
_gc_policy_rm_dirty_percent				     percent of cache which can be dirty for readmostly
_gc_dump_remote_lock					     if TRUE, dump remote lock
_gc_save_cleanout					     if TRUE, save cleanout to apply later
_gc_temp_affinity					     if TRUE, enable global temporary affinity
_gc_fg_spin_time					     foreground msgq spin time
_gc_async_send						     send blocks asynchronously
_gc_try_to_skip_imc_flush				     if TRUE, try to skip an imc populate flush
_gc_msgq_buffer_size					     MSGQ buffer size
_gc_msgq_buffers					     number of MSGQ buffers
_gc_serve_from_flash_cache				     if TRUE, try to serve a flash cache buffer
_gc_trace_freelist_empty				     if TRUE, dump a trace when we run out of lock elements
_kcbl_assert_reset_slot 				     assert slot state in kcblResetSlot
_thread_state_change_timeout_pnp			     Thread state change timeout for PnP instance (in sec)
_allow_file_1_offline_error_1245			     don't signal ORA-1245 due to file 1 being offline
_switchover_timeout					     Switchover timeout in minutes
_fast_psby_conversion					     Enable fast physical standby conversion
_ac_enable_dscn_in_rac					     Enable Dependent Commit SCN tracking
_ac_strict_SCN_check					     enforce strict SCN check for AC replay across DG failover
_allow_convert_to_standby				     allow convert to standby to go through
_early_flush_delta					     SCN delta to trigger early log flush
_backup_ksfq_bufmem_max 				     maximum amount of memory (in bytes) used for buffers for backup/restore
_backup_min_ct_unused_optim				     mimimun size in bytes of change tracking to apply unused space optimuzation
_krb_trace_buffer_size					     size of per-process I/O trace buffer
_catalog_foreign_restore				     catalog foreign file restore
_prefered_standby					     standby db_unique_name prefered for krb operations
_krbabr_trace_buffer_size				     size of I/O trace buffer
_backup_appliance_enabled				     Backup Appliance Enabled
_ba_container_filesystem_ausize 			     allocation unit size for Backup Appliance containers
_ba_max_groups						     maximum number of Backup Appliance container groups
_ba_max_containers					     maximum number of Backup Appliance containers
_ba_max_seg_bytes					     maximum number of bytes per array segment
_ba_cf_trace_buffer_size				     size of per-process I/O KBC trace buffer
_ba_timeouts_enabled					     enable timeouts
_aux_dfc_keep_time					     auxiliary datafile copy keep time in minutes
_undo_tbs_slave_percent 				     Percentage of redo slaves for undo tablespace
_clone_one_pdb_recovery 				     Recover ROOT and only one PDB in clone database
_time_based_rcv_ckpt_target				     time-based incremental recovery checkpoint target in sec
_time_based_rcv_hdr_update_interval			     time-based incremental recovery file header update interval in sec
_use_pdb_parselock					     use PDB level parselock on ADG
_snapshot_recovery_enabled				     enable/disable snapshot recovery
_bct_public_dba_buffer_dynresize			     allow dynamic resizing of public dba buffers, zero to disable
_bct_public_dba_buffer_maxsize				     max buffer size permitted for public dba buffers, in bytes
_krc_trace_buffer_size					     size of I/O trace buffer
_kra_trace_buffer_size					     size of I/O trace buffer
_kcfis_qm_prioritize_sys_plan				     Prioritize Quaranitine Manager system plan
_kcfis_qm_user_plan_name				     Quaranitine Manager user plan name
_kcfis_xtgran_prefetch_count				     External Table Smart Scan granule prefetch count
_nologging_sendbuf_ratio				     Nologging standby: outstanding send buffer ratio
_nologging_load_slotsz					     Nologging standby: direct load buffer size
_force_logging_in_upgrade				     force logging during upgrade mode
_nologging_kcnbuf_hash_buckets				     Number of nologging buffer hash buckets
_nologging_kcnbuf_hash_latches				     Number of nologging buffer hash latches
_nologging_sdcl_append_wait				     Nologging standby append sdcl wait time
_nologging_txn_cmt_wait 				     Nologging standby transaction commit wait time
_max_data_transfer_cache_size				     Maximum size of data transfer cache
_data_transfer_cache_bc_perc_x100			     Percentange * 100 of buffer cache to transfer to data transfer cache
_data_transfer_cache_size				     Size of data transfer cache
__data_transfer_cache_size				     Actual size of data transfer cache
_max_kcnibr_ranges					     Max number of nonlogged data block ranges
_log_undo_df_info					     generate marker to log file# that belong to undo tablespace
_cvmap_buffers						     Number of change vector buffers for multi instance media recovery
_txn_control_trace_buf_size				     size the in-memory buffer size of txn control
_collect_tempundo_stats 				     Collect Statistics v$tempundostat
temp_undo_enabled					     is temporary undo enabled
_temp_undo_disable_adg					     is temp undo disabled on ADG
_resumable_critical_alert				     raise critical alert for resumable failure
_securefile_log_num_latches				     Maximum number of open descriptors for securefile log
_securefile_log_shared_pool_size			     Size of securefile log buffer pool from SGA
_cli_cachebktalloc					     Percentage of memory to allocate
_ilm_mem_limit						     percentage of the max shared pool heat-map can use - internal
_ktilmsc_exp						     expiration time of ktilm segment cache (in second)
_inmemory_check_prot_meta				     If true, marks SMU area read only to prevent stray writes
_inmemory_private_journal_quota 			     quota for transaction in-memory private journals
_inmemory_private_journal_sharedpool_quota		     quota for transaction in-memory objects
_inmemory_private_journal_numbkts			     Number of priv jrnl ht bkts
_inmemory_private_journal_numgran			     Number of granules per HT node
_inmemory_jscan 					     inmemory jscan enable
_inmemory_pin_hist_mode 				     settings for IM pinned buffer history
_inmemory_txn_checksum					     checksum for SMUs and private journals
_inmemory_buffer_waittime				     wait interval for one SMU or IMCU to be freed
_inmemory_cu_timeout					     maximum wait time for one IMCU to be freed
_inmemory_cudrop_timeout				     maximum wait time for IMCU to be freed during drop
_inmemory_exclto_timeout				     maximum wait time to pin SMU for cleanout
_inmemory_num_hash_latches				     Maximum number of latches for IM buffers
_inmemory_strdlxid_timeout				     max time to determine straddling transactions
_inmemory_incremental_repopulation			     If true, incremental repopulation of IMCU will be attempted
_inmemory_lock_for_smucreate				     take object lock during smu creation
_old_extent_scheme					     Revert to old extent allocation
_trace_temp						     Trace Tempspace Management
_concurrency_chosen					     what is the chosen value of concurrency
_no_small_file						     Not to apply new extent scheme for small file temp spaces
_assm_test_force_rej					     assm min number of blocks to cbk-reject
_assm_test_force_rej2					     assm min number of blocks to kdt-reject
_assm_test_reentrant_gsp				     assm test reentrant gsp
_disable_flashback_recyclebin_opt			     Don't use the Flashback Recyclebin optimization
_enable_securefile_flashback_opt			     Enable securefile flashback optimization
_enable_12g_bft 					     enable 12g bigfile tablespace
_undotbs_stepdown_pcent 				     Undo Tablespace small allocation step down percentage
_undotbs_regular_tables 				     Create regular tables in undo tablespace
_minmax_spacebg_slaves					     min-max space management background slaves
_min_spacebg_slaves					     minimum space management background slaves
_securefiles_breakreten_retry				     segment retry before dishonoring retention
_securefiles_spcutl					     securefiles segment utl optimization
_trace_ktfs						     Trace ILM Stats Tracking
_trace_ktfs_mem 					     Debug memleak
heat_map						     ILM Heatmap Tracking
_enable_ilm_flush_stats 				     Enable ILM Stats Flush
_enable_ilm_testflush_stats				     Enable Test ILM Stats Flush
_disable_12cbigfile					     DIsable Storing ILM Statistics in 12cBigFiles
_enable_heatmap_internal				     heatmap related - to be used by oracle dev only
_heatmap_format_1block					     heatmap related - to be used by oracle dev only
_test_hm_extent_map					     heatmap related - to be used by oracle dev only
_ilmset_stat_limit					     ILM set statistics limit - Internal testing only
_ilmflush_stat_limit					     ILM flush statistics limit - Internal testing only
_heatmap_min_maxsize					     Internal testing only
_ilmstat_memlimit					     Percentage of shared pool for use by ILM Statistics
_flush_ilm_stats					     flush ilm stats
_create_stat_segment					     create ilm statistics segment
_drop_stat_segment					     drop ilm statistics segment
_print_stat_segment					     print ilm statistics segment
_print_inmem_heatmap					     print inmem ilm heatmap
_inmemory_auto_distribute				     If true, enable auto distribute
_inmemory_autodist_2safe				     If true, enable auto distribute with 2safe
_inmemory_distribute_timeout				     If true, enable auto distribute with 2safe
_inmemory_distribute_ondemand_timeout			     On demand timeout for redistribute
inmemory_size						     size in bytes of in-memory area
_inmemory_64k_percent					     percentage of in-memory area for 64k pools
_inmemory_min_ima_defersize				     Defer in-memory area allocation beyond this size
_inmemory_memprot					     enable or disable memory protection for in-memory
_trace_ktds						     Trace block reuse
_track_space_reuse					     SpaceReuse Tracking
_spacereuse_track_memlimit				     Percentage of shared pool for use by spacereuse tracking
_print_inmem_srmap					     print inmem spacereuse map
_sage_block_checking					     enable block checking of blocks returned by smartscan
_suppress_identifiers_on_dupkey 			     supress owner index name err msg
_widetab_comp_enabled					     wide table compression enabled
_force_sys_compress					     Sys compress
_oltp_comp_dbg_scan					     oltp compression scan debug
_cu_row_locking 					     CU row level locking
_oltp_spill						     spill rows for oltp compression if loader pga limit is exceeded
_pdb_use_sequence_cache 				     Use sequence cache in PDB mode
_index_max_inc_trans_pct				     max itl expand percentage soft limit during index insert
_advanced_index_compression_options			     advanced index compression options
_advanced_index_compression_options_value		     advanced index compression options2
_advanced_index_compression_trace			     advanced index compression trace
db_index_compression_inheritance			     options for table or tablespace level compression inheritance
_ldr_tempseg_threshold					     amount to buffer prior to allocating temp segment (extent sizing)
_kdli_descn_adj 					     coalesce extents with deallocation scn adjustment
_kdli_mts_so						     use state objects in shared server for asyncIO pipelines
_kdli_ralc_length					     lob length threshold to trigger rounded allocations
_kdli_ralc_rounding					     rounding granularity for rounded allocations
_kdli_space_cache_segments				     #segments in space cache
_sf_default_enabled					     enable 12g securefile default
_kdlf_read_flag 					     kdlf read flag
_kdz_pcode_flags					     pcode flags
_enable_columnar_cache					     Enable Columnar Flash Cache Rewrite
_kdz_proj_nrows 					     Number of rows to project at a time in kdzt
_kdz_pred_nrows 					     Number of rows to predicate at a time in kdzt
_kdzk_enable_init_trace 				     Enable kdzk initialization tracing
_kdzk_load_specialized_library				     Flags for loading HPK specialized library
_kdzk_trace_level					     HPK trace level
_hpk_project_cost_weighting				     hpk project cost weighting
_hpk_throughput_range					     hpk throughput range
_hpk_compression_range					     hpk compression range
_inmemory_analyzer_optimize_for 			     inmemory analyzer optimize for
_dbfs_modify_implicit_fetch				     DBFS Link allows implicit fetch on modify - only on SecureFiles
_ILM_FILTER_TIME					     Upper filter time for ILM block compression
_ILM_FILTER_TIME_LOWER					     Lower filter time for ILM block compression
_ILM_POLICY_NAME					     User specified ILM policy name
_inmemory_default_flags 				     Default flags based on inmemory_clause_default
_inmemory_default_new					     Force in-memory on new tables
inmemory_clause_default 				     Default in-memory clause for new tables
inmemory_force						     Force tables to be in-memory or not
inmemory_query						     Specifies whether in-memory queries are allowed
_inmemory_query_scan					     In-memory scan enabled
_inmemory_scan_override 				     In-memory scan override
_inmemory_scan_threshold_percent_noscan 		     In-memory scan threshold maximum percent dirty no scan
_inmemory_small_segment_threshold			     In-memory small segment threshold (must be larger for in-memory)
_inmemory_query_fetch_by_rowid				     In-memory fetch-by-rowid enabled
_inmemory_pruning					     In-memory pruning
_inmemory_enable_sys					     enable in-memory on system tablespace with sys user
_inmemory_populate_fg					     populate in foreground
_inmemory_pga_per_server				     minimum pga needed per inmemory populate server
inmemory_max_populate_servers				     maximum inmemory populate servers
_inmemory_servers_throttle_pgalim_percent		     In-memory populate servers throttling pga limit percentage
inmemory_trickle_repopulate_servers_percent		     inmemory trickle repopulate servers percent
_inmemory_populate_wait 				     wait for population to complete
_inmemory_populate_wait_max				     maximum wait time in seconds for segment populate
_inmemory_imco_cycle					     IMCO cycle in seconds (sleep period)
_inmemory_enable_population_verify			     verify in-memory population
_inmemory_log_level					     in-memory log level
_inmemory_fs_verify					     in-memory faststart verify
_inmemory_force_fs					     in-memory faststart force
_inmemory_force_fs_tbs					     in-memory faststart force tablespace
_inmemory_force_fs_tbs_size				     in-memory faststart force tablespace size
_inmemory_fs_raise_error				     in-memory faststart raise error
_inmemory_fs_nodml					     in-memory faststart assumes no dmls while populating
_inmemory_fs_enable					     in-memory faststart enable
_inmemory_fs_enable_blk_lvl_inv 			     in-memory faststart enable block level invalidation
_inmemory_fs_blk_inv_blkcnt				     in-memory faststart CU invalidation threshold(blocks)
_inmemory_fs_blk_inv_blk_percent			     in-memory faststart CU invalidation threshold(blocks)
_inmemory_enable_stat_alert				     dump in-memory stats in alert log file
_inmemory_imcu_align					     Enforce 8M IMCU alignment
_inmemory_max_populate_retry				     IM populate maximum number of retry
_inmemory_imcu_target_rows				     IMCU target number of rows
_inmemory_imcu_target_bytes				     IMCU target size in bytes
_inmemory_imcu_source_extents				     number of source extents per IMCU
_inmemory_imcu_source_blocks				     number of source blocks per IMCU
_inmemory_imcu_source_minbytes				     number of minimum source bytes per IMCU
_inmemory_imcu_populate_minbytes			     minimum free space in IMA for populating IMCU
_inmemory_imcu_source_analyze_bytes			     number of source analyze bytes per IMCU
_inmemory_imcu_target_maxrows				     IMCU maximum target number of rows
_inmemory_imcu_source_maxbytes				     IMCU maximum source size in bytes
_inmemory_max_queued_tasks				     Maximum queued populating tasks on the auxiliary queue
_inmemory_repopulate_threshold_rows			     In-memory repopulate threshold number of modified rows
_inmemory_repopulate_threshold_blocks			     In-memory repopulate threshold number of modified blocks
_inmemory_pct_inv_rows_invalidate_imcu			     In-memory percentage invalid rows for IMCU invalidation
_inmemory_pct_inv_blocks_invalidate_imcu		     In-memory percentage invalid blocks for IMCU invalidation
_inmemory_repopulate_threshold_mintime_factor		     In-memory repopulate minimum interval (N*timetorepop)
_inmemory_repopulate_threshold_mintime			     In-memory repopulate minimum interval (millisec)
_inmemory_repopulate_threshold_scans			     In-memory repopulate threshold number of scans
_inmemory_repopulate_priority_scale_factor		     In-memory repopulate priority threshold scale factor
_inmemory_repopulate_invalidate_rate_percent		     In-memory repopulate invalidate rate percent
_inmemory_repopulate_priority_threshold_row		     In-memory repopulate priority threshold row
_inmemory_repopulate_priority_threshold_block		     In-memory repopulate priority threshold block
_inmemory_repopulate_threshold_rows_percent		     In-memory repopulate threshold rows invalid percentage
_inmemory_repopulate_threshold_blocks_percent		     In-memory repopulate threshold blocks invalid percentage
_inmemory_repopulate_disable				     disable In-memory repopulate
_inmemory_check_protect 				     If true, marks in-memory area read only to prevent stray writes
_inmemory_checksum					     If true, checksums in-memory area to detect stray writes
_inmemory_validate_fetch				     If true, validate single-row fetch between in-memory and disk
_inmemory_journal_row_logging				     If true, log the entire row into the in-memory journal
_inmemory_journal_check 				     Depending on value does one of the DML verifications
_inmemory_rows_check_interrupt				     Number of rows buffered before interrupt check
_inmemory_dbg_scan					     In-memory scan debugging
_inmemory_segment_populate_verify			     In-memory segment populate verification
_inmemory_query_check					     In-memory query checking
_inmemory_test_verification				     In-memory verification testing
_inmemory_invalidate_cursors				     In-memory populate enable cursor invalidations
_inmemory_prepopulate_fg				     Force prepopulate of in-memory segment in foreground
_inmemory_prepopulate					     Enable inmemory populate by IMCO
_inmemory_trickle_repopulate				     Enable inmemory trickle repopulate
_inmemory_trickle_repopulate_threshold_dirty_ratio	     IMCO Trickle Repopulate threshold dirty ratio
_inmemory_trickle_repopulate_min_interval		     IMCO Trickle Repopulate Interval
_inmemory_trickle_repopulate_fg 			     Trickle Repopulate in the Foreground
_inmemory_force_non_engineered				     force non-engineered systems in-memory behavior on RAC
_inmemory_suppress_vsga_ima				     Suppress inmemory area in v$sga
_index_load_buf_oltp_sacrifice_pct			     index load buf oltp sacrifice pct
_index_load_buf_oltp_under_pct				     index load buf and comp oltp under-estimation pct
_kdizoltp_uncompsentinal_freq				     kdizoltp uncomp sentinal frequency
_kqdsn_min_instance_bits				     minimum bits used for instance value in sequence partition
_kqdsn_max_instance_bits				     maximum bits used for instance value in sequence partition
_kqdsn_partition_ratio					     ratio of instance to session bits in sequence partition
_kgl_large_heap_assert_threshold			     maximum heap size before KGL raises an internal error
_revoke_new_semantics					     Enable revoke semantics
_tsenc_obfuscate_key					     Encryption key obfuscation in memory
_db_discard_lost_masterkey				     discard lost masterkey handles
_db_generate_dummy_masterkey				     if TRUE, use old havior and generate dummy master key
_use_fips_mode						     Enable use of crypographic libraries in FIPS mode
DBFIPS_140						     Enable use of crypographic libraries in FIPS mode, public
_pbkdf2_sder_count					     The PBKDF2 count to use for session key derivation
_resource_includes_unlimited_tablespace 		     Whether RESOURCE role includes UNLIMITED TABLESPACE privilege
_xs_cleanup_task					     Triton Session Cleanup
_xds_max_child_cursors					     Maximum number of XDS user-specific child cursors
_xs_dispatcher_only					     XS dispatcher only mode
_unified_audit_policy_disabled				     Disable Default Unified Audit Policies on DB Create
unified_audit_sga_queue_size				     Size of Unified audit SGA Queue
_unified_audit_flush_threshold				     Unified Audit SGA Queue Flush Threshold
_unified_audit_flush_interval				     Unified Audit SGA Queue Flush Interval
_reco_sessions_max_percentage				     allowed RECO sessions as a percentage of total sessions allowed
_disable_duplicate_service_warning			     disable listener warning for duplicate service
_dispatcher_listen_on_vip				     Determines if dispatcher listens on VIP if no HOST is supplied
use_dedicated_broker					     Use dedicated connection broker
_mpmt_fg_enabled					     MPMT mode foreground enabled
connection_brokers					     connection brokers specification
_cursor_reload_failure_threshold			     Number of failed reloads before marking cursor unusable
_kks_obsolete_dump_threshold				     Number of parent cursor obsoletions before dumping cursor
_plsql_icd_arg_dump					     Dump arguments to ICD
_redef_on_statement					     Use on-statement refresh in online redefinition
_AllowMultInsteadofDDLTrigger				     Oracle internal parameter to allow multiple instead of DDL triggers
_kktAllowInsteadOfDDLTriggeronDDL			     Oracle internal parameter to allow instead of DDL triggers on specified DDLs
_lock_next_constraint_count				     max number of attempts to lock _NEXT_CONSTRAINT
_max_string_size_bypass 				     controls error checking for the max_string_size parameter
_bigdata_external_table 				     enables use of ORACLE_HIVE and ORACLE_HDFS access drivers
_kxscio_cap_stacks					     capture location when kxscio is set to null
_px_proactive_slave_alloc_threshold			     parallel proactive slave allocation threshold/unit
_px_load_balancing_policy				     parallel load balancing policy
_px_dp_array_size					     Max number of pq processes supported
_sort_sync_min_spillsize				     controls the size of mininum run size for synchronized spill (in kb)
_sort_sync_min_spill_threshold				     controls the mininum spill size for synchronized spill (in percent)
_cell_offload_expressions				     enable offload of expressions to cells
_cell_materialize_virtual_columns			     enable offload of expressions underlying virtual columns to cells
_cell_materialize_all_expressions			     Force materialization of all offloadable expressions on the cells
_cell_offload_sys_context				     enable offload of SYS_CONTEXT evaluation to cells
_gby_vector_aggregation_enabled 			     enable group-by and aggregation using vector scheme
_optimizer_vector_transformation			     perform vector transform
_optimizer_vector_fact_dim_ratio			     cost based vector transform dimension to fact ratio
_key_vector_max_size					     maximum key vector size (in KB)
_key_vector_predicate_enabled				     enables or disables key vector filter predicate pushdown
_key_vector_predicate_threshold 			     selectivity pct for key vector filter predicate pushdown
_key_vector_offload					     controls key vector offload to cells
_key_vector_caching					     Enables vector key vector caching
_vector_operations_control				     control different uses/algorithms related to vector transform
_optimizer_vector_min_fact_rows 			     min number of rows required for vector aggregation transform
_vector_serialize_temp_threshold			     threshold for serializing vector transform temp table writes
_always_vector_transformation				     always favor use of vector transformation
_vector_aggregation_max_size				     max size of vector aggregation space
_optimizer_key_vector_aggr_factor			     the required aggregation between IJK and DGK
_optimizer_vector_cost_adj				     cost adjustment for vector aggregation processing estimates
_crash_domain_on_exception				     allow domain to exit for exceptions in any thread
_odci_aggregate_save_space				     trade speed for space in user-defined aggregation
_cell_storidx_minmax_enabled				     enable Storage Index Min/Max optimization on the cells
_cell_offload_complex_processing			     enable complex SQL processing offload to cells
_optimizer_partial_join_eval				     partial join evaluation parameter
_optimizer_unnest_scalar_sq				     enables unnesting of of scalar subquery
_px_object_sampling					     parallel query sampling for base objects (100000 = 100%)
_utlmmig_table_stats_gathering				     enable/disable utlmmig table stats gathering at upgrade
_remove_exf_component					     enable/disable removing of components EXF and RUL during upgrade
_bloom_filter_size					     bloom filter vector size (in KB)
_bloom_predicate_offload				     enables or disables bloom filter predicate offload to cells
_bloom_rm_filter					     remove bloom predicate in favor of zonemap join pruning predicate
_dbop_enabled						     Any positive number enables automatic DBOP monitoring. 0 is disabled
_optimizer_ansi_join_lateral_enhance			     optimization of left/full ansi-joins and lateral views
_optimizer_multi_table_outerjoin			     allows multiple tables on the left of outerjoin
_optimizer_null_accepting_semijoin			     enables null-accepting semijoin
_optimizer_ansi_rearchitecture				     re-architecture of ANSI left, right, and full outer joins
_optimizer_aggr_groupby_elim				     group-by and aggregation elimination
_optimizer_gather_feedback				     optimizer gather feedback
_part_redef_global_index_update 			     online partition redefinition update global indexes
_optimizer_generate_transitive_pred			     optimizer generate transitive predicates
_optimizer_cube_join_enabled				     enable cube join
max_string_size 					     controls maximum size of VARCHAR2, NVARCHAR2, and RAW types in SQL
_dm_enable_legacy_dmf_output_types			     revert dmf output types to pre-12.1.0.1
_dm_dmf_details_compatibility				     set dm dmf details compatibility version
_optimizer_hybrid_fpwj_enabled				     enable hybrid full partition-wise join when TRUE
_px_message_compression 				     enable compression of control messages for parallel query
_px_object_sampling_enabled				     use base object sampling when possible for range distribution
_px_concurrent						     enables pq with concurrent execution of serial inputs
_px_back_to_parallel					     allow going back to parallel after a serial operation
_scalar_type_lob_storage_threshold			     threshold for VARCHAR2, NVARCHAR2, and RAW storage as BLOB
_px_replication_enabled 				     enables or disables replication of small table scans
_zonemap_use_enabled					     enable the use of zonemaps for IO pruning
_zonemap_staleness_tracking				     control the staleness tracking of zonemaps via trigger
_zonemap_control					     control different uses/algorithms related to zonemaps
_sql_plan_directive_mgmt_control			     controls internal SQL Plan Directive management activities
_px_filter_parallelized 				     enables or disables correlated filter parallelization
_px_filter_skew_handling				     enable correlated filter parallelization to handle skew
_px_groupby_pushdown					     perform group-by pushdown for parallel query
_partition_advisor_srs_active				     enables sampling based partitioning validation
_px_parallelize_expression				     enables or disables expression evaluation parallelization
_fast_index_maintenance 				     fast global index maintenance during PMOPs
_optimizer_gather_stats_on_load 			     enable/disable online statistics gathering
_multi_transaction_optimization_enabled 		     reduce SGA memory use during create of a partitioned table
_optimizer_batch_table_access_by_rowid			     enable table access by ROWID IO batching
optimizer_adaptive_reporting_only			     use reporting-only mode for adaptive optimizations
_optimizer_ads_result_cache_life			     result cache shelf life for ADS queries
_px_wif_dfo_declumping					     NDV-aware DFO clumping of multiple window sorts
_px_wif_extend_distribution_keys			     extend TQ data redistribution keys for window functions
_px_wif_min_ndv_per_slave				     mininum NDV of TQ keys needed per slave for scalable WiF PX
_px_join_skew_handling					     enables skew handling for parallel joins
_px_join_skew_ratio					     sets skew ratio for parallel joins
_px_join_skew_minfreq					     sets minimum frequency(%) for skewed value for parallel joins
_px_adaptive_dist_method				     determines the behavior of adaptive distribution methods
_px_adaptive_dist_method_threshold			     Buffering / decision threshold for adaptive distribution methods
_parallel_fault_tolerance_enabled			     enables or disables fault-tolerance for parallel statement
_parallel_fault_tolerance_threshold			     total number of faults fault-tolerance will handle
_px_partial_rollup_pushdown				     perform partial rollup pushdown for parallel execution
_sql_diag_repo_retain					     retain sql diag repository to cursor or not
_sql_diag_repo_origin					     duarations where sql diag repository are retained
_optimizer_dsdir_usage_control				     controls optimizer usage of dynamic sampling directives
_px_cpu_autodop_enabled 				     enables or disables auto dop cpu computation
parallel_degree_level					     adjust the computed degree in percentage
_px_cpu_process_bandwidth				     CPU process bandwidth in MB/sec for DOP computation
_px_cpu_operator_bandwidth				     CPU operator bandwidth in MB/sec for DOP computation
_px_single_server_enabled				     allow single-slave dfo in parallel query
_optimizer_use_gtt_session_stats			     use GTT session private statistics
_optimizer_adaptive_plans				     enable adaptive plans
_optimizer_adaptive_plan_control			     internal controls for adaptive plans
_optimizer_adaptive_random_seed 			     random seed for adaptive plans
_optimizer_strans_adaptive_pruning			     allow adaptive pruning of star transformation bitmap trees
_optimizer_proc_rate_level				     control the level of processing rates
_px_hybrid_TSM_HWMB_load				     Enable Hybrid Temp Segment Merge/High Water Mark Brokered load method
_optimizer_use_histograms				     enable/disable the usage of histograms by the optimizer
_disable_directory_link_check				     Disable directory link checking
_add_nullable_column_with_default_optim 		     Allows add of a nullable column with default optimization
_emx_max_sessions					     Maximum number of sessions in the EM Express cache
_emx_session_timeout					     Session timeout (sec) in the EM Express cache
_emx_control						     EM Express control (internal use only)
_parallel_blackbox_sga					     true if blackbox will be allocated in SGA, false if PGA
_rowsets_enabled					     enable/disable rowsets
_rowsets_target_maxsize 				     target size in bytes for space reserved in the frame for a rowset
_rowsets_max_rows					     maximum number of rows in a rowset
_use_hidden_partitions					     use hidden partitions
_px_load_monitor_threshold				     threshold for pushing information to load slave workload monitor
_px_monitor_load					     enable consumer load slave workload monitoring
_px_adaptive_offload_percentage 			     percentage for PQ adaptive offloading of granules
_modify_column_index_unusable				     allow ALTER TABLE MODIFY(column) to violate index key length limit
_adaptive_window_consolidator_enabled			     enable/disable adaptive window consolidator PX plan
_sql_hvshare_threshold					     threshold to control hash value sharing across operators
_px_tq_rowhvs						     turn on intra-row hash valueing sharing in TQ
_sql_hvshare_debug					     control hash value sharing debug level
_sql_show_expreval					     show expression evalution as shared hash producer in plan
_parallel_ctas_enabled					     enable/disable parallel CTAS operation
_optimizer_performance_feedback 			     controls the performance feedback
_optimizer_proc_rate_source				     control the source of processing rates
_hashops_prefetch_size					     maximum no of rows whose relevant memory locations are prefetched
_stat_aggs_one_pass_algorithm				     enable one pass algorithm for variance-related functions
_px_onepass_slave_acquisition				     enable/disable one pass slave acquisition for parallel execution
_online_ctas_diag					     controls dumping diagnostic information for online ctas
_upddel_dba_hash_mask_bits				     controls masking of lower order bits in DBA
_px_pwmr_enabled					     parallel partition wise match recognize enabled
_px_cdb_view_enabled					     parallel cdb view evaluation enabled
optimizer_adaptive_features				     controls adaptive features
_partition_cdb_view_enabled				     partitioned cdb view evaluation enabled
_common_data_view_enabled				     common objects returned through dictionary views
_pred_push_cdb_view_enabled				     predicate pushdown enabled for CDB views
_rowsets_cdb_view_enabled				     rowsets enabled for CDB views
_distinct_agg_optimization_gsets			     Use Distinct Aggregate Optimization for Grouping Sets
_array_cdb_view_enabled 				     array mode enabled for CDB views
_mv_refresh_truncate_log				     materialized view refresh truncate MV log
_rc_sys_obj_enabled					     result cache enabled for Sys Objects
_px_scalable_invdist					     enable/disable px scalable plan for inverse distribution functions
_indexable_con_id					     indexing of CON_ID column enabled for X$ tables
_optimizer_reduce_groupby_key				     group-by key reduction
_optimizer_cluster_by_rowid_batched			     enable/disable the cluster by rowid batching feature
_optimizer_cluster_by_rowid_batch_size			     Sorting batch size for cluster by rowid feature
_object_link_fixed_enabled				     object linked views evaluated using fixed table
_optimizer_synopsis_min_size				     minimal synopsis size (kb)
_merge_monitor_threshold				     threshold for pushing information to MERGE monitoring
optimizer_inmemory_aware				     optimizer in-memory columnar awareness
_optimizer_inmemory_table_expansion			     optimizer in-memory awareness for table expansion
_optimizer_inmemory_gen_pushable_preds			     optimizer generate pushable predicates for in-memory
_optimizer_inmemory_autodop				     optimizer autoDOP costing for in-memory
_optimizer_inmemory_access_path 			     optimizer access path costing for in-memory
_optimizer_inmemory_quotient				     in-memory quotient (% of rows in in-memory format)
_optimizer_inmemory_pruning_ratio_rows			     in-memory pruning ratio for # rows (% of rows remaining after pruning)
_parallel_inmemory_min_time_threshold			     threshold above which a plan is a candidate for parallelization for in-memory ta
							     bles (in seconds)

_parallel_inmemory_time_unit				     unit of work used to derive the degree of parallelism for in-memory tables (in s
							     econds)

_px_external_table_default_stats			     the external table default stats collection enable/disable
_optimizer_nlj_hj_adaptive_join 			     allow adaptive NL Hash joins
_px_autodop_pq_overhead 				     adjust auto dop calculation using pq overhead
_px_overhead_init_slavealloc				     pq overhead on allocating per slave during initialization (in microseconds)
_px_overhead_init_endpoints				     pq overhead on setting up one end point during initialization (in microseconds)
_px_overhead_exec_ctrlmesg				     pq overhead on sending one control message during execution (in microseconds)
_px_overhead_teardown					     pq overhead on setting up one end point during initialization (in microseconds)
_grant_read_instead_of_select				     grant read privilege instead of select wherever applicable
_optimizer_inmemory_bloom_filter			     controls serial bloom filter for in-memory tables
_optimizer_inmemory_cluster_aware_dop			     Affinitize DOP for inmemory objects
_cdb_cross_container					     Debug flag for cross container operations
_cdb_view_parallel_degree				     Parallel degree for a CDB view query
_optimizer_hll_entry					     number of entries in hll hash table
_cross_con_row_count					     use actual row count for cross container views
_cdb_view_prefetch_batch_size				     Batch Size for Prefetch for a CDB view query
_cdb_view_rc_shelflife					     Result Cache Shelflife for a CDB view query
_approx_cnt_distinct_gby_pushdown			     perform group-by pushdown for approximate distinct count query
_approx_cnt_distinct_optimization			     settings for approx_count_distinct optimizations
_px_cdb_view_join_enabled				     disable parallelism cap on CDB view
_external_table_smart_scan				     External Table Smart Scan
_optimizer_inmemory_minmax_pruning			     controls use of min/max pruning for costing in-memory tables
_query_execution_time_limit				     Query execution time limit in seconds
_optimizer_ads_use_partial_results			     Use partial results of ADS queries
_alter_upgrade_signature_only				     alter table upgrade only sets signature
_max_clients_per_emon					     maximum number of clients per emon
_emon_pool_inc						     increment in EMON slaves per pool type
_emon_pool_min						     minimum number of EMON slaves per pool type
_emon_pool_max						     maximum number of EMON slaves per pool type
_aq_streaming_threshold 				     large payload threshold size
_re_fast_sql_operator					     enables fast boxable sql operator
_re_result_cache_keysiz 				     defines max number key for result cache hash table
_re_result_cache_size					     defines max number of cached elements for result cache
_re_independent_expression_cache_size			     defines max number of compiled cached expressions for iee
_enable_iee_stats					     enables IEE stats gathering
_re_num_complex_operator				     defines max number of compiled complex operator per ruleset-iee
_re_num_rowcache_load					     defines max number of complex operators loaded with row cache
_aqsharded_cache_limit					     Limit for cached enqueue/dequeue operations
_aq_Txn_ht_sz						     Message cache Txn Hash table size
_aq_shard_bitmap_child_latches				     Bitmap child latches
_aq_shard_retry_child_latches				     Retry child latches
_aq_shard_txn_child_latches				     Txn child latches
_aq_shard_sub_child_latches				     Subscriber child latches
_aq_shard_sub_child_Elem_latches			     Subscriber Element child latches
_aq_shard_child_latches 				     Shard child latches
_aq_shard_prty_latches					     Shard priority child latches
_aq_init_shards 					     Minimum enqueue shards per queue at an instance
_aq_disable_x						     AQ - Disable new cross processes at an instance
_aq_latency_relative_threshold				     Relative threshold of average latency
_aq_latency_absolute_threshold				     Absolute threshold greater than average latency
_aq_x_msg_size						     AQ cross single message buffer size
_aq_stop_backgrounds					     Stop all AQ background processes
_aq_lb_cycle						     Time(seconds) between consecutive AQ load balancing efforts
_aq_lb_stats_collect_cycle				     Time(seconds) between consecutive AQ load statistics collection
_aq_pt_processes					     Partition background processes
_aq_subshard_Size					     Sub Shard Size
_aq_subshards_per_qpartition				     SubShards Per Q Partition
_aq_subshards_per_dqpartition				     SubShards Per Deq Partition
_aq_lookback_size					     AQ PT Look Back Size
_aq_qt_prefetch_Size					     AQ PT QT prefech Size
_aq_dq_prefetch_Siz					     AQ PT DQ prefech Size
_aq_pt_statistics_window				     PT statistics sample window Size
_aq_pt_shrink_frequency 				     PT shrink window Size
_aq_addpt_batch_size					     Add PT batch Size
_aq_truncpt_batch_size					     Trunc PT batch Size
_aq_droppt_batch_size					     Drop PT batch Size
_shrd_que_tm_processes					     number of sharded queue Time Managers to start
_shrd_que_tm_statistics_duration			     Shaded queue statistics collection window duration
_aq_ipc_max_slave					     maximum number of slaves for knlpipcm
_ctx_doc_policy_stems					     enable ctx_doc.policy_stems api
_olap_row_load_time_precision				     OLAP Row Load Time Precision
_olap_disable_loop_optimized				     Disable LOOP OPTIMIZED directive in OLAP_TABLE
_remote_asm						     remote ASM configuration
_asm_relocation_trace					     enable extent relocation tracing
_asm_relocation_ignore_hard_failure			     ignore HARD for relocation
_asm_max_parallelios					     Maximum simultaneous outstanding IOs
_kffmlk_hash_size					     size of kffmlk_hash table
_asm_diskgroups2					     disk groups to mount automatically set 2
_asm_diskgroups3					     disk groups to mount automatically set 3
_asm_diskgroups4					     disk groups to mount automatically set 4
_asm_disable_dangerous_failgroup_checking		     Disable checking for dubious failgroup configurations
_asm_diskerr_traces					     Number of read/write errors per disk a process can trace
_asm_procs_trace_diskerr				     Number of processes allowed to trace a disk failure
_asm_trace_limit_timeout				     Time-out in milliseconds to reset the number of traces per disk and the number o
							     f processes allowed to trace

_asm_skip_dbfile_ios					     Skip I/Os to database files (do only ASM metadata I/O)
_asm_offload_all					     Offload all write operations to Exadata cells, when supported
_asm_read_cancel					     Read cancel timeout in milliseconds
_asm_read_cancel_back_out				     Time period in milliseconds when no reads are issued to a disk after a read is c
							     ancelled

_asm_write_cancel					     Write timeout in milliseconds
_afd_disable_fence					     Disable AFD fencing
_asm_network_timeout					     Keepalive timeout for ASM network connections
_asm_skip_diskval_check 				     skip client side discovery for disk revalidate
_asm_remote_client_timeout				     timeout before killing disconnected remote clients
_asm_allow_unsafe_reconnect				     attempt unsafe reconnect to ASM
_asm_disable_ufgmemberkill				     disable ufg member kill
_asm_nodekill_escalate_time				     secs until escalating to nodekill if fence incomplete
_asm_healthcheck_timeout				     seconds until health check takes action
_asm_resyncCkpt 					     number of extents to resync before flushing checkpoint
_asm_noevenread_diskgroups				     List of disk groups having even read disabled
_asm_networks						     ASM network subnet addresses
_asm_allowdegeneratemounts				     Allow force-mounts of DGs w/o proper quorum
_asm_proxy_startwait					     Maximum time to wait for ASM proxy connection
_asm_allow_dangerous_unprotected_volumes		     Disable checking for unprotected volumes in mirrored disk groups
_asm_appliance_ignore_oak				     Ignore OAK appliance library
_dirty_appliance_mode					     Enable appliance mode even on non-appliance
_asm_appliance_slot_from_path				     Get appliance disk slot from disk path
_asm_scrub_limit					     ASM disk scrubbing power
_asm_scrub_unmatched_dba				     Scrub maximum number of blocks with unmatched DBA
_asm_enable_xrov					     Enable XROV capability
_asm_xrov_single					     Enable single issues of IOs
_asm_xrov_rsnmod					     Specify 'reason' mode
_asm_xrov_nvios 					     Specify number of VIO processes
_asm_xrov_nstats					     Specify number of IOs before stats
_skip_acfs_checks					     Override checking if on an ACFS file system
_asm_force_vam						     force VAM for external redundancy
_usd_recent_read					     Allow to scan recent USD blocks
_usd_preload_blks					     USD preload block count for prefetch
_remote_awr_enabled					     Enable/disable Remote AWR Mode
_awr_disabled_purge_tables				     Disable purging of specified AWR tables
_awr_snapshot_level					     Set Default AWR snapshot level
_awr_remote_target_dblink				     AWR Remote Target DBLink for Flushing
_awr_pdb_registration_enabled				     Parameter to enable/disable AWR PDB Registration
_awr_cdbperf_threshold					     Setting for AWR CDBPERF Threshold
_awr_partition_interval 				     Setting for AWR Partition Interval
_kewm_simulate_oer4031					     Simulate OER(4031) for one or more Metric Groups
_enable_metrics_allpdb					     Enable/Disable Metrics for Root and all PDBs if applicable
_enable_metrics_pdb					     Enable/Disable Metrics for this Non-Root PDB
_autotask_test_name					     Name of current Autotask Test (or test step)
_max_queued_report_requests				     Maximum number of report requests that can be queued in a list
_report_capture_cycle_time				     Time (in sec) between two cycles of report capture daemon
_report_capture_dbtime_percent_cutoff			     100X Percent of system db time daemon is allowed over 10 cycles
_report_capture_timeband_length 			     Length of time band (in hours) in the reports time bands table
_report_capture_recharge_window 			     No of report capture cycles after which db time is recharged
_max_report_flushes_percycle				     Max no of report requests that can be flushed per cycle
_report_request_ageout_minutes				     Time (in min) after which a report request is deleted from queue
_kecap_cache_size					     Workload Replay INTERNAL parameter used to set memory usage in  Application Repl
							     ay

_rtaddm_trigger_enabled 				     To enable or disable Real-Time ADDM automatic trigger
_rtaddm_trigger_args					     comma-separated list of numeric arguments for RT addm trigger
spatial_vector_acceleration				     enable spatial vector acceleration
_diag_adr_trace_dest					     diagnosability trace directory path
_diag_patch_cap_enabled 				     Parameter to enable/disable Diag Patch Configuration Capture
_log_segment_dump_parameter				     Dump KSP on Log Segmentation
_log_segment_dump_patch 				     Dump Patchinfo on Log Segmentation
_max_incident_file_size 				     Maximum size (in KB, MB, GB, Blocks) of incident dump file
_uts_trace_segment_size 				     Maximum size (in bytes) of a trace segment
_uts_trace_segments					     Maximum number of trace segments
_uts_first_segment_size 				     Maximum size (in bytes) of first segments
_uts_first_segment_retain				     Should we retain the first trace segment
_uts_trace_disk_threshold				     Trace disk threshold parameter
_diag_test_seg_reinc_mode				     Sets trace segmentation to be in reincarnation mode
_kxdbio_ctx_init_count					     initial count of KXDBIO state object
_kxdbio_disable_offload_opcode				     KXDBIO Disable offload for the set opcodes.  Value is a Bitmap of	  0x00000001
							     - disable cell to cell data copy offload	 0x00000002 - disable disk scrubbing
							     offload to cell	0x00000004 - disable offloaded writes to cell

_kxdbio_enable_ds_opcode				     KXDBIO Enable Dumb storage simulation for the set opcodes.
_enable_offloaded_writes				     Enable offloaded writes for Unit Test
_block_level_offload_high_lat_thresh			     High Latency Threshold for Block Level Offload operations
_kxdbio_hca_loadavg_thresh				     HCA loadavg threshold at which writes need to get offloaded
_kxdbio_ut_ctl						     kxdbio unit test controls
_cell_offload_backup_compression			     enable offload of backup compression to cells
_enable_pluggable_database				     Enable Pluggable Database
enable_pluggable_database				     Enable Pluggable Database
_oracle_script						     Running an Oracle-supplied script
_discard_cmn_ddl_in_pdb_err				     Discard error when Common DDL is attempted in PDB
pdb_os_credential					     pluggable database OS credential to bind
pdb_lockdown						     pluggable database lockdown profile
pdb_file_name_convert					     PDB file name convert patterns and strings for create cdb/pdb
_pluggable_database_debug				     Debug flag for pluggable database related operations
noncdb_compatible					     Non-CDB Compatible
_cdb_compatible 					     CDB Compatible
_deferred_seg_in_seed					     Enable Deferred Segment Creation in Seed
common_user_prefix					     Enforce restriction on a prefix of a Common User/Role/Profile name
_common_user_prefix					     Enforce restriction on a prefix of a Common User/Role/Profile name
_relocate_pdb						     Relocate PDB to another RAC instance after it is closed in the current instance
_cdb_rac_affinity					     rac affinity for parallel cdb operations
_set_container_service					     set container service
_multiple_char_set_cdb					     Multiple character sets enabled in CDB
_cdb_spfile_inherit					     Inherit CDB Spfile enabled/disabled in a PDB
_enable_pdb_close_abort 				     Enable PDB shutdown abort (close abort)
_max_pdbs						     Parameter is a hint to adjust certain attributes of the CDB
_pdb_cluster_database					     This parameter can be turned-off when cluster_database is TRUE
_pdb_mask_cdb_info					     Enable masking CDB information within a PDB
exclude_seed_cdb_view					     exclude PDB$SEED from CDB View Result
_disable_cdb_view_rc_invalidation			     disable Result Cache invalidation for CDB View results
_gsm							     GSM descriptions
_gsm_region_list					     List of GSM Regions
_cloud_name						     gsm cloud name
_dbpool_name						     gsm database pool name
_region_name						     gsm region name
_db_num_gsm						     database number in gsm dbpool
_gsm_config_vers					     version of gsm config
_gsm_max_instances_per_db				     maximum number of instances per database in gsm cloud
_gsm_max_num_regions					     maximum number of regions in gsm cloud
_gsm_drv_interval					     metric derived values interval
_gsm_srlat_thresh					     Single block read latency threshold
_gsm_cpu_thresh 					     CPU busy threshold
_gsm_thresh_zone					     threshold zone
_gsm_thresh_respct					     threshold resource percentage
_gwm_spare1						     gsm spare 1
_gwm_spare2						     gsm spare 2
_gwm_spare3						     gsm spare 3
_rq_shm_max_size					     maximum size of an RQuery shared memory segement (in KB)

1106 rows selected.

SQL> 

E ae, já decorou todos :)

Instalação Oracle RAC 10g com VirtualBox – Parte 9
outubro 25, 2011

Parte 1 - Introdução
Parte 2 - Criação e configuração da VM
Parte 3 - Criação do Oracle Linux
Parte 4 - Configuração do Oracle Linux I
Parte 5 - Configuração do Oracle Linux II
Parte 6 - Clonagem da VM e criação dos disk image
Parte 7 - Configuração dos discos ASM e OCFS2
Parte 8 - Instalação do Oracle Clusterware
Parte 9 – Aplicação do Patch 10.2.0.5 no Oracle Clusterware
Parte 10 - Instalação Oracle Database 10g
Parte 11 - Aplicação do Patch 10.2.0.5 no Oracle Database
Parte 12 - Criação do Listener e ASM em modo cluster
Parte 13 - Criação do banco de dados

A parte 8 da nossa série de artigos, foi mostrado a instalação do Oracle Clusterware 10g. Hoje veremos como evoluirmos a versão do produto instalado de 10.2.0.1 para 10.2.0.5, que é feito através de uma aplicação de patch, este que é disponibilizado pela Oracle. Para baixar o patch é necessário uma conta (usuário/senha) de acesso ao suporte da Oracle no endereço: https://support.oracle.com,

Caso você não tenha CSI para conectar e assim baixar o patch não se preocupe, você poderá utilizar normalmente o seu Oracle RAC na versão 10.2.0.1, ou sejá sem a aplicação do patch 10.2.0.5, apenas pule as essa parte. Quando ainda não era um profissional na área, aprendi muito utilizando apenas a versão 10.2.0.1, não faça dessa uma desculpa para não estudar :)

O Patch ID do patch 10.2.0.5 é o 8202632, você será capaz de encontrar o patch na sessão Patchs and Updates apenas digitando o número do patch no campo de pesquisa. Lembre-se de baixar para Linux x86 (versão utilizada no tutorial).

p8202632_10205_Linux-x86.zip

 

Pré-requisitos do Patch 10.2.0.5

Será necessário a alteração de dois parâmetros de kernel para conseguirmos que a aplicação do patch seja feita. Esses parâmetros já foram alterados na parte 4 em que alteramos o arquivos /etc/sysctl.conf. Veja abaixo que os parâmetros em azul é os necessário a mudança, deixei conforme abaixo:

[root@rac1 ~]# vi /etc/sysctl.conf
kernel.sem = 250 32000 100 128
fs.file-max = 524288
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 1048576
net.core.rmem_max = 2097152
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

Para ativar a mudança:

[root@rac1 ~]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.sem = 250 32000 100 128
fs.file-max = 524288
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 1048576
net.core.rmem_max = 2097152
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

 

Aplicação do Patch 10.2.0.5 no Oracle Clusterware

Abaixo eu mostro a aplicação do Patch passo-a-passo:

Descompactando o patch 10.2.0.5, o meu arquivo está localizado na minha ORACLE_BASE.

 

Após descompactado o zip do patch, ele irá criar uma pasta chamada Disk1, entre nessa pasta e execute o arquivo runInstaller como oracle:

[oracle@rac1 Disk1]$ ./runInstaller

Selecione o HOME do Oracle Clusterware instalado, que no nosso casso é o OraCrs10g_home

 

O instalador irá reclamar sobre a falta de memória existente na nossa VM (512MB), não tem problema para o nosso ambiente de teste, ignore a mensagem como abaixo:

 

Aqui será pedido para que execute o arquivo root102.sh no Oracle Clusterware instalado. O procedimento deve ser feito primeiro na máquina 1 e depois na máquina 2, uma de cada vez. Faça o passo 1 depois o passo 2.



RAC 1 – Executando os scripts no PRIMEIRO nó.

[root@rac1 ~]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.

[root@rac1 ~]# /u01/app/oracle/product/10.2.0/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
  This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node : 

node 1: rac1 rac1-priv rac1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/u01/app/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u01/app/oracle/product/10.2.0/crs/install/paramfile.crs

RAC 2 – Executando os scripts no SEGUNDO nó.

[root@rac2 ~]# /u01/app/oracle/product/10.2.0/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@rac2 ~]# /u01/app/oracle/product/10.2.0/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /u01/app/oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
  This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node : 

node 2: rac2 rac2-priv rac2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/u01/app/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /u01/app/oracle/product/10.2.0/crs/install/paramfile.crs

Com todos os scripts executados como acima, voltamos a tela de instalação e concluímos a instalação do Patch.


Instalação Oracle RAC 10g com VirtualBox – Parte 4
setembro 9, 2011

Parte 1 – Introdução
Parte 2 - Criação e configuração da VM
Parte 3 – Criação do Oracle Linux
Parte 4 - Configuração do Oracle Linux I
Parte 5 - Configuração do Oracle Linux II
Parte 6 - Clonagem da VM e criação dos disk image
Parte 7 - Configuração dos discos ASM e OCFS2
Parte 8 - Instalação do Oracle Clusterware
Parte 9 - Aplicação do Patch 10.2.0.5 no Oracle Clusterware
Parte 10 - Instalação Oracle Database 10g
Parte 11 - Aplicação do Patch 10.2.0.5 no Oracle Database
Parte 12 - Criação do Listener e ASM em modo cluster
Parte 13 - Criação do banco de dados

No ultimo post finalizamos a instalação do Oracle Linux Enterprise 5.1, já nesse artigo vamos dar inicio a configuração do sistema operacional.

Gostaria de citar que esse artigo está inteiramente baseada na própria documentação Oracle:

Como exigido pela Oracle, temos que instalar os seguintes pacotes (RPM’s) como sendo um pré-requisito de instalação:

binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125
gcc-4.1.1-52
gcc-c++-4.1.1-52
glibc-2.5-12
glibc-common-2.5-12
glibc-devel-2.5-12
glibc-headers-2.5-12
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.1-52
libstdc++-4.1.1
libstdc++-devel-4.1.1-52.e15
make-3.81-1.1
sysstat-7.0.0
unixODBC-2.2.11
unixODBC-devel-2.2.11
libXp-1.0.0-8

Esses pacotes RPM’s se encontram todos no próprio CD de instalação Oracle Enterprise Linux 5.1, no nosso caso a ISO baixada no site da Oracle. Vamos montar a ISO como uma mídia dentro da nosso VM criada.

Com a máquina virtual funcionando, siga os passos abaixo:

 

 

Caso os passos acimas foram realizados, observe que a mídia é automaticamente montada na máquina virtual:

Com a mídia de instalação do Oracle Linux 5.1 montada, vamos conectar na VM através do SSH. Como utilizo Ubuntu eu faço diretamente de um terminal, caso você esteja usando qualquer versão do Windows recomendo utilizar o putty para suas conexões SSH.

flavio@note:~$ ssh root@10.0.0.10
The authenticity of host '10.0.0.10 (10.0.0.10)' can't be established.
RSA key fingerprint is 86:5a:97:20:00:13:34:97:16:95:f1:4d:b5:ec:49:a4.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '10.0.0.10' (RSA) to the list of known hosts.
root@10.0.0.10's password:
Last login: Wed Sep  7 13:34:48 2011 from shadowy.lan
[root@rac1 ~]#
[root@rac1 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1              14G  2.0G   11G  15% /
tmpfs                 252M     0  252M   0% /dev/shm
/dev/hdc              2.9G  2.9G     0 100% /media/Enterprise Linux dvd 20100405
[root@rac1 ~]# cd /media/Enterprise\ Linux\ dvd\ 20100405/Server/
[root@rac1 Server]#

Vamos a instalação dos RPM já que estamos no diretório deles. Para instalar o pacote rpm é realmente algo muito simples basta utilizar o comando:
rpm -ivh "Nome do RPM"
e para verificar se eles já estão instalados utilize a expressão:
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep "nome do rpm"
No nosso caso, alguns RPM já estão instalados e outros ainda não, faça a instalação de cada um deles e não esqueça de nenhum.

 

Instalação dos RPM

Vou seguir a sequencia de instalação na lista de RPM passada acima. Vamos começar  no RPM compat-libstdc++, observe que ele já está instalado e não temos que fazer nada.

[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep compat-libstdc++
compat-libstdc++-296-2.96-138 (i386)
compat-libstdc++-33-3.2.3-61 (i386)

Assim como o compat-libstdc++, o pacote elfutils-libelf também já está instalado

[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep elfutils-libelf
elfutils-libelf-0.137-3.el5 (i386)

Diferentemente dos dois primeiros pacotes, o elfutils-libelf-devel não está instalado, veja que nenhuma linha retornou quando procuramos o RPM através do rpm -qa. Alguns pacotes rpm como no caso do elfutils-libelf-devel, precisa de outros rpm para funcionar  por isso quando é realizado a sua instalação um processo de checagem de dependência de pacotes RPM é feita. Abaixo, quanto faço a instalação através do comando rpm -ivh o instalador retorna um erro “error: Failed dependencies“ e informa que somente poderá instalar o elfutils-libelf-devel se o pacote elfutils-libelf-devel-static estiver instalado. Para resolvermos isso, basta colocar o nome dos dois pacotes ao mesmo tempo no momento da instalação, observe abaixo:

[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep elfutils-libelf-devel
[root@rac1 Server]# rpm -ivh elfutils-libelf-devel-0.137-3.el5.i386.rpm
warning: elfutils-libelf-devel-0.137-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
error: Failed dependencies:
elfutils-libelf-devel-static-i386 = 0.137-3.el5 is needed by elfutils-libelf-devel-0.137-3.el5.i386
[root@rac1 Server]# rpm -ivh elfutils-libelf-devel-0.137-3.el5.i386.rpm elfutils-libelf-devel-static-0.137-3.el5.i386.rpm
warning: elfutils-libelf-devel-0.137-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
1:elfutils-libelf-devel-s   ########################################### [ 50%]
2:elfutils-libelf-devel     ########################################### [100%]

Com o pacote RPM gcc para compiladores C também não vem instalado. Veja abaixo que já realizei as dependências dos RPM’s:

[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep gcc
compat-libgcc-296-2.96-138 (i386)
libgcc-4.1.2-48.el5 (i386)
[root@rac1 Server]# rpm -ivh gcc-4.1.2-48.el5.i386.rpm glibc-devel-2.5-49.i386.rpm glibc-headers-2.5-49.i386.rpm kernel-headers-2.6.18-194.el5.i386.rpm libgomp-4.4.0-6.el5.i386.rpm
warning: gcc-4.1.2-48.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                    ########################################### [100%]
1:kernel-headers                ########################################### [ 20%]
2:libgomp                       ########################################### [ 40%]
3:glibc-headers                 ########################################### [ 60%]
4:glibc-devel                   ########################################### [ 80%]
5:gcc                           ########################################### [100%]

O pacote gcc++ também precisa ser instalado. As dependências de RPM já deixei realizadas:

[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep gcc-c++
[root@rac1 Server]# rpm -ivh gcc-c++-4.1.2-48.el5.i386.rpm libstdc++-devel-4.1.2-48.el5.i386.rpm
warning: gcc-c++-4.1.2-48.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
1:libstdc++-devel           ########################################### [ 50%]
2:gcc-c++                   ########################################### [100%]

Os RPM’s glibc já estão todas instaladas glibc-2.5-12glibc-common-2.5-12glibc-devel-2.5-12glibc-headers-2.5-12

[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep glibc
glibc-2.5-49 (i686)
glibc-devel-2.5-49 (i386)
glibc-common-2.5-49 (i386)
glibc-headers-2.5-49 (i386)

O pacote libaio também já está instalado, porém o libaio-devel ainda não.

[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libaio 
libaio-0.3.106-5 (i386)
[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libaio-devel
[root@rac1 Server]# rpm -ivh libaio-devel-0.3.106-5.i386.rpm
warning: libaio-devel-0.3.106-5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
1:libaio-devel              ########################################### [100%]

Os pacotes RPM libgcc,  libstdc++ e make também já estão instalados

[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libgcc
libgcc-4.1.2-48.el5 (i386) 
libstdc++-4.1.1
libstdc++-devel-4.1.1-52.e15
[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libstdc++-
compat-libstdc++-296-2.96-138 (i386)
libstdc++-4.1.2-48.el5 (i386)
compat-libstdc++-33-3.2.3-61 (i386)
libstdc++-devel-4.1.2-48.el5 (i386)
[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep make
make-3.81-3.el5 (i386)

Os RPM’s restantes são sysstat, unixODBC, unixODBC-devel e libXp que ainda não estão instalados.

[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep sysstat
[root@rac1 Server]# rpm -ivh sysstat-7.0.2-3.el5.i386.rpm
warning: sysstat-7.0.2-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
1:sysstat                   ########################################### [100%]
[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep unixODBC
[root@rac1 Server]# rpm -ivh unixODBC-2.2.11-7.1.i386.rpm
warning: unixODBC-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
1:unixODBC                  ########################################### [100%]
[root@rac1 Server]# rpm -ivh unixODBC-devel-2.2.11-7.1.i386.rpm
warning: unixODBC-devel-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
1:unixODBC-devel            ########################################### [100%]
[root@rac1 Server]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep libXp
libXpm-3.5.5-3 (i386)
[root@rac1 Server]# rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm
warning: libXp-1.0.0-8.1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing...                ########################################### [100%]
1:libXp                     ########################################### [100%]

Parâmetros de kernel e Usuários/Permissões

Com os pacotes rpm todos instalados vamos agora para configuração dos parâmetros de kernel do Linux. Vamos começar pelo arquivo /etc/sysctl.conf, abra o arquivo e adicione as seguintes linhas:

kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 2097152
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

Para que as alterações feitas no arquivo entre em vigor execute o comando:

[root@rac1 ~]# sysctl -p

Agora vamos alterar os limites padrões para o usuário “oracle”. Edite o arquivo /etc/security/limits.conf e adicione as seguintes linhas:

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Mude também o arquivo /etc/pam.d/login adicionando a seguinte linha:

session required pam_limits.so

Com o kernel e os parâmetros do sistema alterados vamos a criação do usuário oracle

[root@rac1 ~]# groupadd oinstall
[root@rac1 ~]# groupadd dba
[root@rac1 ~]# useradd -g oinstall -G dba oracle
[root@rac1 ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

Com o usuário oracle criado e com os grupos necessários feitos, vamos agora a criação dos diretórios padrões do Oracle:

[root@rac1 ~]# mkdir -p /u01/app/oracle/oraInventory
[root@rac1 ~]# mkdir -p /u01/app/oracle/product/10.2.0/crs
[root@rac1 ~]# mkdir -p /u01/app/oracle/product/10.2.0/db_1
[root@rac1 ~]# chown -R oracle:oinstall /u01

Adicione também as linhas abaixo no arquivo /etc/profile

if [ $USER = "oracle" ]; then
         ulimit -u 16384
         ulimit -n 65536
fi

 

Hangcheck

Para executarmos o Oracle RAC uma recomendação fortissima da Oracle é utilizar o hangcheck. O hangcheck é um modulo que periodicamente checa o sistema para determinar a saúde dele mesmo. Caso por qualquer motivo o sistema operacional tenha alguma pausa ou uma trava o modulo automaticamente reinicia o servidor.

Abaixo demonstro como ativar o modulo hangcheck-timer no Linux

[root@rac1 ~]# /sbin/insmod /lib/modules/2.6.18-194.el5/kernel/drivers/char/hangcheck-timer.ko hangcheck_tick=1 hangcheck_margin=10 hangcheck_reboot=1
[root@rac1 ~]# /etc/rc.d/rc.local

Para verificar se o modulo está rodando basta verificar através do lsmod

[root@rac1 ~]# lsmod |grep hangcheck
hangcheck_timer         8025  0 etc hosts

 

NTPDate

Ntpdate é um utilitário para poder manter a hora do servidor sincronizada. No nosso caso vamos utilizar os ntpdate free disponíveis no site http://ntp.br/. Muitas empresas já tem o seu proprio ntpdate, caso tenha algum somente altere o endereço.

Para configurar é extremamente simples, basta você ter uma conexão com a internet e configurar através do comando ntpdate.

Teste de conexão com a internet.

[root@rac1 ~]# ping www.google.com.br
PING www.l.google.com (74.125.113.99) 56(84) bytes of data.
64 bytes from vw-in-f99.1e100.net (74.125.113.99): icmp_seq=1 ttl=48 time=199 ms
64 bytes from vw-in-f99.1e100.net (74.125.113.99): icmp_seq=2 ttl=50 time=196 ms

--- www.l.google.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1001ms
rtt min/avg/max/mdev = 196.655/198.094/199.533/1.439 ms

Sincronizando o horário com o ntpdate disponível

[root@rac1 ~]# ntpdate c.st1.ntp.br
 8 Sep 23:46:22 ntpdate[3009]: step time server 200.186.125.195 offset 1.201157 sec

Para sempre manter sua hora sincronizada basta adicionar o comando assim no agendado Linux através do comando crontab -e e adicione as seguintes linhas:

* * * * * /usr/sbin/ntpdate ntp.cais.rnp.br

Por hoje é isso, no próximo artigos vamos configurar o Guest Additions na VM, vamos aprender como configurar o ASMLIB e o OCFS2 para manter os arquivos OCR e VOTING do RAC.

Até mais, dúvida deixem comentários …

Instalação Oracle RAC 10g com VirtualBox – Parte 3
agosto 11, 2011

Parte 1 – Introdução
Parte 2 - Criação e configuração da VM
Parte 3 - Criação do Oracle Linux
Parte 4 - Configuração do Oracle Linux
Parte 5 - Configuração do Oracle Linux II
Parte 6 - Clonagem da VM e criação dos disk image
Parte 7 - Configuração dos discos ASM e OCFS2
Parte 8 - Instalação do Oracle Clusterware
Parte 9 - Aplicação do Patch 10.2.0.5 no Oracle Clusterware
Parte 10 - Instalação Oracle Database 10g
Parte 11 - Aplicação do Patch 10.2.0.5 no Oracle Database
Parte 12 - Criação do Listener e ASM em modo cluster
Parte 13 - Criação do banco de dados

Estaremos hoje iniciando a Parte 3 da “Instalação Oracle RAC 10g com VirtualBox”. Nessa etapa vamos instalar e configurar o Oracle Linux 5 para a instalação do Oracle clusterware. Caso você tenha o RedHat 5 ou o CentOs 5, pode utilizar sem problemas. A minha versão exata do Oracle Linux é a 5.5.

Vamos iniciar o passo a passo da criação do Linux, caso tenha alguma dúvida post um comentário.

 

Instalação do Linux

Como já temos nossa máquina virtual criada e configurada pronta para iniciar a instalação, podemos dar prosseguimento.

Clicando na ícone seta verde no topo do VirtualBox, podemos iniciar a VM, como mostra a figura abaixo:

figura 1

 

Quando a VM é iniciada, vemos a seguinte tela (figura2). Basta entrar e clicar dentro da máquina e pressionar  um “Enter”, para tirar o cursor do mouse de dentro da VM basta pressionar o botão “Ctrl” do lado direito do teclado.

figura 2

figura 3

 

Nesse momento o instalador fornece um teste de midia no disco que iremos utilizar para gravar a máquina. Como não quero utilizar a checagem de disco, pressione o botão SKIP.

figura 4

 

figura 5

 

Hora de escolher a linguagem que seguirá no instalador, escolha a opção que preferir:

figura 6

 

Aqui definimos a linguagem do teclado:

figura 7

 

Quando clicamos em NEXT, um alerta é disparado mostrando todos os discos disponíveis do ambiente e que temos consciência de que podemos apagar todos os dados contidos no disco. Como mostra a figura abaixo clicamos em YES para confirmar a mensagem, assim o Wizard nos levará a uma outra tela.

figura 8

 

Apenas selecione a opção Create custom layout e clique em Next.

figura 9

 

Será apresentado aqui o nosso virtual hard disk criado na parte 2. Vamos definir as partições do disco local do Linux e  também a área de swap da máquina. Para iniciar esses procedimentos clique no ícone NEW para iniciar a criação da primeira partição.

figura 10

 

A primeira partição que iremos criar será a partição destinada ao swap do Linux, vamos definir 1G (1024 M) para ela. Deixe as alterações conforme a imagem abaixo e clique em OK.

figura 11

figura 12

 

Vamos definir agora o tamanho da partição “/”. Apenas escolha a opção “Fill to maximum allowable size”

figura 13

 

Após realizadas esses processos o disco deve conter 2 partição, uma de 1G de swap e o restante para dados no formato ext3 na partição “/” onde o sistema operacional Linux será instalado. Caso esteja tudo certo, basta clicar em NEXT.

figura 14

 

Não necessitamos de nenhuma configuração nessa tela, apenas NEXT.

figura 15

 

Agora é um momento importante, onde vamos estar definindo os IP’s publico e privado do cluster. Estarei mais a frente falando sobre a diferença e á importância de cada um deles. O que importante saber agora é que o nosso adaptador de rede eth0 é onde terá o IP publico e o adaptador eth1 será IP privado. Os IP’s oferecidos aqui são feitos de acordo com a minha rede, caso deseja alterar o endereço de cada um dos IP’s abaixo fique a vontade, porém preste a atenção nas configurações futuras, para combinar com o seu modelo de IP criado, isso vale também para as configurações de gateway e DNS que estarei fazendo mais a frente.

Vamos as configurações, primeiro selecione o adaptador (device) eth0 e clique em Edit.

figura 16

 

Será aberta a tela de configuração de dispositivos de rede, nele definiremos o IP 10.0.0.10 com a sub-mascara (Netmask) 255.0.0.0, como feito abaixo:

figura 17

 

Faça o mesmo procedimento, só que agora no adaptador de reder (device) eth1. Selecione e clique em edit

figura 18

 

Defina o IP 192.168.1.10 com a sub-mascara 255.255.255.0 para o dispositivo eth1, como abaixo:

figura 19

figura 20

 

Com os IP’s definidos vamos alterar agora o hostname, gateway e o DNS.

figura 21

 

Configurações de TimeZone no Linux

figura 22

 

Forneça aqui, as senha de root e depois NEXT.

figura 23

 

Nesse ponto, vamos definir os pacotes de instalação do Linux. Clique no Customize Now depois em Next.

figura 24

figura 25

 

No item Applications desmarque as opções

  • Games and Enterrainment
  • Graphics
  • Office/Productivity
  • Sound and Video
  • Text-based Internet

figura 26

 

No item Server, desmarque a opção Printing Support e clique em Next.

figura 27

figura 28

 

Todas as configurações realizadas, hora de iniciar a instalação, pressione Next.

figura 29

figura 30

figura 31

 

Instalação concluída com sucesso, vamos reiniciar a máquina e fazer as últimas configurações.

figura 32

figura 33

 

Com o reboot feito, um Wizard de configurações finais será aberto, clique em Forward.

figura 34

 

Aceite a licença e depois Forward.

figura 35

 

Desabilite o firewall da máquina.

figura 36

figura 37

figura 38

figura 39

figura 40

 

Caso o horário não esteja correto, arrume e siga em frente.

figura 41

 

Não vamos precisar criar nenhum usuário agora por isso não faça nada, apenas clique em Forward.

figura 42

figura 43

figura 44

figura 45

 

Com todas as configurações finais realizadas, um novo reboot será necessário, apenas clique em ok para terminarmos as configurações.

figura 46

 

Reboot em processo.

figura 47

 

Aqui está nosso Oracle Linux 5.5 instalado e pré-configurado.

figura 48

figura 49

 

Depois dessa intensa lista de atividades feita hoje, temos nossa máquina RAC1 criada. No próximo artigo da série, vamos terminar de configurar o Linux e aprender como clonar nossa máquina virtual RAC1 para criarmos a RAC2.

Até o próximo


 

Instalação Oracle RAC 10g com VirtualBox – Parte 2
julho 27, 2011

Parte 1 - Introdução
Parte 2 - Criação e configuração da VM
Parte 3 - Criação do Oracle Linux
Parte 4 - Configuração do Oracle Linux
Parte 5 - Configuração do Oracle Linux II
Parte 6 - Clonagem da VM e criação dos disk image
Parte 7 - Configuração dos discos ASM e OCFS2
Parte 8 - Instalação do Oracle Clusterware
Parte 9 - Aplicação do Patch 10.2.0.5 no Oracle Clusterware
Parte 10 - Instalação Oracle Database 10g
Parte 11 - Aplicação do Patch 10.2.0.5 no Oracle Database
Parte 12 - Criação do Listener e ASM em modo cluster
Parte 13 - Criação do banco de dados

Dando inicio hoje a criação do nosso ambiente de teste Oracle RAC 10g utilizando VirtualBox tanto para criar as máquinas virtuais como os discos compartilhados entre as instâncias.

Não colocarei aqui o passo a passo para instalar o VirtualBox, visto que é extremamente simples, basta alguns “NEXT” e o seu VirtualBox estará instalado, até mesmo no Linux (no meu caso o Ubuntu) a utilização do VirtualBox é muito simples e amigável.

 

Criando a máquina virtual

A parte 2, está destinada a criação e configuração da VM. Estarei aqui demonstrando de forma mais detalhada possível a criação da máquina 1 do cluster que depois será clonada para a máquina 2.

Sem mais rodeios, vamos ao trabalho …

Quando se abre o VirtualBox é listado todas as máquinas virtuais instaladas no seu lado esquerdo (ver figura 1), caso você tenha instalado agora o seu VirtualBox, você será essa listagem vázia.

 

figura 1


Vamos iniciar a criação de uma nova VM, ela será criada do zero. Para isso clique no botão azul New no canto superior esquerdo.

figura2

 

Será aberto o Wizard da criação da VM, basta clicar em Next.

figura 3


Nessa parte é necessário atribuir um nome para a máquina, no meu caso coloquei de Oracle RAC 10g – 1, fique a vontade para colocar o nome que preferir. Escolhemos nesse ponto também o Sistema Operacional e a Versão dele. Como nesse exemplo estarei utilizando o Oracle Linux escolhi a opção Linux para SO e Oracle para a versão.
figura 4


Definimos aqui a quantidade de memória utilizada pela VM, 512 MB é um número bom para termos um ambiente de teste, coloque o valor que desejar.
figura 5


Quando se cria uma VM no VirtualBox, temos a opção de criar um novo Virtual Hard Disk ou utilizar um existente. Como estamos criando do zero nossa máquina virtual, devemos escolher a opção Create new hard disk. Esse é o disco que iremos instalar os binários Oracle, é o disco local da máquina. Escolha as opções abaixo e clique em Next para abrir o Wizard da criação do disco virtual.
figura 6


Aqui, já estamos no Wizard para criarmos nosso disco virtual. Apenas clique em Next.
figura 7


Um Virtual Hard Disk pode ser dinâmico ou fixo. Para melhor utilização do espaço do meu HD, estarei utilizando o disco virtual em modo dinâmico.
figura 8


Nesse ponto é onde definimos o caminho e o tamanho do nosso disco. O caminho fica a seu critério, porém o tamanho não recomendo colocar menor do que 15G, já que pode não ser suficiente para instalar os binários do cluster e do oracle.
figura 9


Observe o resumo de toda as configurações do Virtual Hard Disk e caso esteja de acordo clique em Finish para criar o disco.
figura 10


Com o hard disk criado, o Wizard de criação de disco será finalizada e voltará para o Wizard da máquina virtual. Nesse momento, observe atentamente o nome, quantidade de memória, localização de disco etc … Caso tudo esteja conformo você deseja basta clicar em Finish para concluir a criação da VM.
figura 11

figura 12


Configuração da máquina virtual

Iremos iniciar agora, a configuração da máquina virtual recém criada. Para iniciar o Wizard de configuração da VM, basta selecionar a máquina desejada e clicar em Settings, como exibido na figura 13.

figura 13

A primeira aba de configuração é a General. Nela não temos que realizar nenhuma configuração, por isso pule para a aba System.
figura 14

Na aba System, desmarque o Floppy (disquete) no boot order, fazendo com que no momento do boot, o VirtualBox não utilize o floppy.
figura 15

A próxima aba de configuração é a Storage. Devemos remover a unidade de CD/DVD-ROM vazia e adicionar uma nova apontando para a ISO Oracle Linux 5. Veja os passos  nas figuras 16, 17, 18, 19, 20 e 21.
figura 16

Confirme a remoção da unidade de CD/DVD-ROM vazia.
figura 17

Adicione um novo dispositivo de CD/DVD-ROM clicando no primeiro ícone do IDE Controller
figura 18

Escolha a opção Choose disk(Escolher disco).
figura 19

Selecione a ISO correspondente do Oracle Linux 5 e clique em Open.
figura 20

figura 21


Desabilite o Audio na máquina virtual através da aba Audio. Após desabilitar feito isso, vá até a aba Network.
figura 22


Aqui é onde se define os adaptadores de rede. Temos que habilitar 2 adaptadores de rede em modo Bridged. As figuras 23,  24 demonstra como realizar essa configuração
figura 23

figura 24

Por fim, basta desabilitar a USB da máquina na aba USB, como na figura 25.
figura 25

Com todos os passos acimas realizados, temos uma máquina virtual criada e pronta para iniciar a instalação do Linux, que será nossa próxima etapa. Caso ficou alguma dúvida em algum processo poste seu comentário que terei prazer no que puder ajudar.
Até a próxima etapa

Certificação Oracle RAC 10g
julho 12, 2011

Olá Pessoal.

Andei sumido para responder os comentários e e-mails … mais foi por uma boa causa.

Depois de um tempo estudando pra valer Oracle RAC … hoje prestei a prova 1z0-048 (Oracle Database 10g: RAC Administrator Certified Expert) e passei. Muito bom ver o PASS na tela …

Agora apertem o cinto … vamos ver muitos posts sobre RAC a partir de hoje : )

Até mais