10gR2 EBS database init.ora

*.service_names = PROD,PROD1,PROD2,PROD.POWELLIND.COM
PROD1.local_listener = 'PROD1_LOCAL'
PROD1.remote_listener = 'PROD_REMOTE'
PROD2.local_listener = 'PROD2_LOCAL'
PROD2.remote_listener = 'PROD_REMOTE'
*.cluster_database = TRUE
*.cluster_database_instances = 2
*.undo_retention=28800
PROD1.undo_tablespace = APPS_UNDOTS1
PROD1.instance_name = PROD1
PROD1.instance_number = 1
PROD1.thread = 1
PROD2.undo_tablespace = APPS_UNDOTS2
PROD2.instance_name = PROD2
PROD2.instance_number = 2
PROD2.thread = 2
*.db_recovery_file_dest='/backup'
*.db_recovery_file_dest_size=1500G
*.recovery_parallelism=4
*.DB_CREATE_FILE_DEST = '+DSKGRP1'
*.DB_CREATE_ONLINE_LOG_DEST_1 = '+DSKGRP1'
*.DB_CREATE_ONLINE_LOG_DEST_2 = '+DSKGRP1'
*.db_name = PROD
*.control_files = '+DSKGRP1/PROD/CONTROLFILE/Current.275.682690593','+DSKGRP1/prod/controlfile/current.259.711532731'
*.control_file_record_keep_time = 30
*.db_block_size = 8192
*.compatible = 10.2.0
*._system_trig_enabled = TRUE # set FALSE for upgrades/migrations
*.O7_DICTIONARY_ACCESSIBILITY = FALSE
*.nls_language = AMERICAN
*.nls_territory = AMERICA
*.nls_date_format = DD-MON-RR
*.nls_numeric_characters = ".,"
*.nls_sort = binary # Required 11i setting
*.nls_comp = binary # Required 11i setting
*.nls_length_semantics = BYTE # Required 11i setting
*.audit_trail = false # if you want auditing
PROD2.user_dump_dest = /opt/oracle/product/10.2.0/PROD/admin/PROD2_pind42/udump
PROD2.background_dump_dest = /opt/oracle/product/10.2.0/PROD/admin/PROD2_pind42/bdump
PROD2.core_dump_dest = /opt/oracle/product/10.2.0/PROD/admin/PROD2_pind42/cdump
PROD1.user_dump_dest = /opt/oracle/product/10.2.0/PROD/admin/PROD1_pind41/udump
PROD1.background_dump_dest = /opt/oracle/product/10.2.0/PROD/admin/PROD1_pind41/bdump
PROD1.core_dump_dest = /opt/oracle/product/10.2.0/PROD/admin/PROD1_pind41/cdump
*.max_dump_file_size = 20480 # trace file size
*.timed_statistics = true
*._trace_files_public = TRUE
*.processes = 1000 # Max. no. of users x 2
*.sessions = 2000 # 2 X processes
*.db_files = 512 # Max. no. of database files
*.dml_locks = 10000
*.cursor_sharing = EXACT # Required 11i settting
*.open_cursors = 600 # Consumes process memory, unless using MTS.
*.session_cached_cursors = 500
*.archive_lag_target = 1800
*.db_block_checking = FALSE
*.db_block_checksum = TRUE
#*.log_checkpoint_timeout = 1200 # Checkpoint at least every 20 mins.
#*.log_checkpoint_interval = 100000
*.fast_start_mttr_target = 60 #in seconds
*.log_checkpoints_to_alert = TRUE
*.log_buffer = 10485760
*.undo_management=AUTO # Required 11i setting
*.workarea_size_policy=AUTO # Required 11i setting
*.olap_page_pool_size = 4194304
*.shared_pool_size = 900M
*.shared_pool_reserved_size = 90M
*.streams_pool_size = 50331648
*.session_max_open_files = 25
*.java_pool_size = 250M
*.remote_login_passwordfile = exclusive
*.large_pool_size =200M
*.pga_aggregate_target = 8G
*.plsql_optimize_level = 2 # Required 11i setting
*.plsql_code_type = INTERPRETED # Required 11i setting
# *.plsql_code_type = NATIVE # Required 11i setting
# *.plsql_native_library_dir = /opt/oracle/product/10.2.0/PROD/plsql/nativelib
# *.plsql_native_library_subdir_count = 1000
PROD1.utl_file_dir = /pcp/applprod/common/temp,/pcp/applprod/common/xx_custom/outbound/gl,/pcp/applprod/common/xx_custom/inbound/gl,/pcp/applprod/common/EDI/inholding,/pcp/applprod/common/EDI/outholding,/pcp/applprod/common/xx_custom/outbound/acsis,/opt/oracle/product/10.2.0/PROD/appsutil/outbound/PROD1_pind41,/pcp/applprod/common/xx_custom/outbound/ceridian,/usr/tmp
PROD2.utl_file_dir = /pcp/applprod/common/temp,/pcp/applprod/common/xx_custom/outbound/gl,/pcp/applprod/common/xx_custom/inbound/gl,/pcp/applprod/common/EDI/inholding,/pcp/applprod/common/EDI/outholding,/pcp/applprod/common/xx_custom/outbound/acsis,/opt/oracle/product/10.2.0/PROD/appsutil/outbound/PROD2_pind42,/pcp/applprod/common/xx_custom/outbound/ceridian,/usr/tmp
*.job_queue_processes = 10
*.parallel_max_servers = 16
*.parallel_min_servers = 0
*._like_with_bind_as_equality = TRUE
*._sort_elimination_cost_ratio=5
*._fast_full_scan_enabled = FALSE
*._sqlexec_progression_cost=2147483647
*._b_tree_bitmap_plans = FALSE
*._immediate_commit_propagation = TRUE
*._lm_global_posts = TRUE
*._optimizer_cost_based_transformation=off
*.optimizer_secure_view_merging = FALSE
*._kks_use_mutex_pin = TRUE
*.sga_target = 32G
*.pre_page_sga = TRUE
*.smtp_out_server = 'it-cy1-smtp.powellind.pri'
*_fix_control='8544722:ON'