Oracle学习笔记:基本初始化参数

Oracle单实例必须要设置的初始化参数

*.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'

几个注意点:

  1.oracle对于文件,目录目标的设置必须是已经存在的。所以几个转储缺省的目标路径必须设置%rdbms%\[trace或log]和audit,和%rdbms%\dbs

  2.某些参数数据库还原时必须和保持一致


Oracle建议的基本参数(其中很多是和性能、群集、oracle管理模式相关的参数)

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

原文地址:https://www.cnblogs.com/jinzhenshui/p/1388302.html