A2.2 Initialization parameter file

---

#initPRODDB.ora # Author: Murali Vallath # Date: 10-JUL-2002 # RAC1.instance_number = 1 RAC1.thread = 1 RAC1.instance_name = RAC1 RAC1.service_names = RAC1.SUMMERSKYUS.COM,PRODDB.SUMMERSKYUS.COM RAC1.local_listener =''(ADDRESS=(PROTOCOL=TCP)(HOST   =ora-db1.summerskyus.com)(PORT=1521))'' RAC1.remote_listener =''(ADDRESS=(PROTOCOL=TCP)(HOST=     ora-db2.summerskyus.com)(PORT=1521))'' RAC2.instance_number = 2 RAC2.thread = 2 RAC2.instance_name = RAC2 RAC2.service_names = RAC2.SUMMERSKYUS.COM,   PRODDB.SUMMERSKYUS.COM RAC2.local_listener = ''(ADDRESS=(PROTOCOL=TCP)      (HOST= ora-db2.summerskyus.com)(PORT=1521))'' RAC2.remote_listener =''(ADDRESS=(PROTOCOL=TCP)      (HOST= ora-db1.summerskyus.com)(PORT=1521))'' *.DB_NAME = PRODDB *.DB_BLOCK_SIZE = 8192 *.CONTROL_FILES = (/dev/vx/rdsk/oraracdg/   partition_300m71,           /dev/vx/rdsk/oraracdg/partition_300m72,           /dev/vx/rdsk/oraracdg/partition_300m73) *.DB_FILES = 512 *.DB_DOMAIN = SUMMERSKYUS.COM *.CLUSTER_DATABASE = TRUE *.CLUSTER_DATABASE_INSTANCES = 2 *.dml_locks = 3600 *.optimizer_mode = CHOOSE *.optimizer_index_caching = 90 *.optimizer_index_cost_adj = 5 *.undo_management = AUTO RAC1.undo_tablespace = UNDO_RAC1 RAC2.undo_tablespace = UNDO_RAC2 *.db_file_multiblock_read_count = 8 *.db_cache_size = 1G *.db_writer_processes = 2 *.shared_pool_size = 2G *.sga_max_size = 3G # shared_pool_reserved_size = 0 *.large_pool_size = 1048576 *.java_pool_size = 87643200 *.workarea_size_policy = AUTO *.pga_aggregate_target = 80M *.processes = 300 *.log_buffer = 999424 # RAC1.sql_trace = true # RAC2.sql_trace = true *.timed_statistics = true # This is set at 200000 to force a checkpoint every time a log # switches. # The logs are sized at 100M. *.log_checkpoint_interval = 200000 *.log_checkpoint_timeout = 0 *.max_dump_file_size = 102400 RAC1.log_archive_dest = /archivelogs/arch/ RAC2.log_archive_dest = /archivelogs/arch/ RAC1.log_archive_format = 'RAC1_%T_%S.arc' RAC2.log_archive_format = 'RAC2_%T_%S.arc' *.log_archive_start = true *.job_queue_processes = 2 *.global_names = TRUE *.open_cursors = 1024 *.compatible = 9.2.0.2 *.remote_login_passwordfile = exclusive *.max_enabled_roles = 40 *.nls_date_format = "DD-MON-YYYY HH24:MI:SS" RAC1.background_dump_dest = /apps/admin/PRODDB/RAC1/bdump RAC1.core_dump_dest = /apps/admin/PRODDB/RAC1/cdump RAC1.user_dump_dest = /apps/admin/PRODDB/RAC1/udump RAC2.background_dump_dest = /apps/admin/PRODDB/RAC2/bdump RAC2.core_dump_dest = /apps/admin/PRODDB/RAC2/cdump RAC2.user_dump_dest = /apps/admin/PRODDB/RAC2/udump # Shared SQL is pinned in shared pool *.cursor_space_for_time = true # Moved parsed SQL cursors to session cache *.session_cached_cursors = 150 *.parallel_min_servers = 4 *.parallel_automatic_tuning = TRUE *.audit_trail = DB *.audit_sys_operations = TRUE

---