Linux Oracle-11g 多实例操作

切换至数据库用户

[root@szorcl~]# su - oracle

[oracle@szorcl~]$

 

创建新实例的参数文件

[oracle@szorcldbs]$  pwd

/database/oracle/product/11.2.0/dbs

[oracle@szorcldbs]$  ls

hc_DBUA0.dat hc_orcl3.dat  hc_szorcl.dat  init.ora initorcl3.ora  lkORCL3  lkSZORCL orapworcl3  orapwszorcl  snapcf_szorcl.f  spfileszorcl.ora

[oracle@szorcldbs]$  cp initorcl.ora initorcl4.ora

 

创建库初始化文件

[oracle@szorcl dbs]$ vim initorcl4.ora

orcl4.__java_pool_size=16777216

orcl4.__large_pool_size=16777216

orcl4.__shared_pool_size=654311424

orcl4.__streams_pool_size=0

*.audit_file_dest='/database/oracle/admin/orcl4/adump'

*.diagnostic_dest='/database/oracle'

*.compatible='11.2.0.0.0'

*.control_files='/database/oracle/oradata/orcl4/control01.ctl','/database/oracle/oradata/orcl4/control02.ctl','/database/oracle/oradata/orcl4/control03.ctl'

*.core_dump_dest='/database/oracle/admin/orcl4/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='orcl4'

*.db_recovery_file_dest='/database/oracle/flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orcl4XDB)'

*.job_queue_processes=0

*.log_archive_dest_1='location=/database/oracle/archlog/orcl4'

*.open_cursors=300

*.pga_aggregate_target=0

*.processes=2000

*.remote