指定参数文件来启动oracle,设置Oracle来自spfile启动文件的参数

alter system set open_cursors=50 scope=both;

－－－processes小于了30个将不能启动oracle

alter system set processes=50 scope=spfile;

－－－分配共享池

alter system set shared_pool_size=15M scope=both;

----分配sga

alter system set sga_target=15M scope=both;

alter system set pga_aggregate_target=20M scope=both;

---－设置内存850M

alter system set memory_target=891289600 scope=both;

-----?

alter system set streams_pool_size=5M scope=both;

alter system set db_cache_size=10M scope=both;

alter system set java_pool_size=10M scope=both;

alter system set large_pool_size=10M scope=both;

----指定恢复目录及分配空间

alter system set db_recovery_file_dest='/mnt/d/linux_oradata/backupSet/flash_recovery_area' scope=both;

alter system set db_recovery_file_dest_size=8G scope=both;

增加oracle控制文件：

alter system

set control_files='/mnt/d/linux_oradata/orcl/control01.ctl',

'/mnt/d/linux_oradata/orcl/control02.ctl',

'/mnt/d/linux_oradata/orcl/control03.ctl',

'/mnt/d/linux_oradata/iso_file/controlfile/control04.ctl'                           scope=spfile;