Oracle Study Notes: Basic initialization parameters

Initialize parameters required for a single oracle instance

*. Control_files = 'd: \ Oracle10g \ app \ oracle \ product \ 10.2.0/oradata/usercent/\ control01.ctl'
*. Db_name = 'usercent'
*. Compatible = '10. 2.0.1.0'
*. Undo_management = 'auto'

Notes:

1. for Oracle files, the directory target settings must already exist. Therefore, the % RDBMS % \ [trace or log] and audit, and% RDBMS % \ DBS

2. Some parameter databases must be consistent with each other during restoration.

Basic parameters recommended by Oracle (many of them are related to performance, cluster, and Oracle Management Mode)

Cluster_database
Compatible
Control_files
Db_block_size
Db_create_file_dest
Db_create_online_log_dest_n
Db_domain
Db_name
Db_recovery_file_dest
Db_recovery_file_dest_size
Db_unique_name
Instance_number
Job_queue_processes
Log_archive_dest_n
Log_archive_dest_state_n
Nls_language
Nls_territory
Open_cursors
Pga_aggregate_target
Processes
Remote_listener
Remote_login_passwordfile
Rollback_segments
Sessions
Sga_target
Shared_servers
Star_transformation_enabled
Undo_management
Undo_tablespace