如果条件允许,可用图形化界面创建更方便快捷
以root用户登录,敲./dbca,如果跳不出图形化界面,就用下面的手动创建
一、以oracle用户登录
二、获取oracle安装路径
[oracle@linux] echo $ORACLE_HOME
[oracle@linux] cd $ORACLE_HOME
[oracle@linuxoracle/product/11g/db] cd dbs
三、创建新实例的参数文件
[oracle@10.14.54.199 dbs]$ ls
hc_orcl2.dat initdw.ora initorcl.ora lkORCL2 orapworcl2 spfileorcl.ora
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl2.ora
[oracle@10.14.54.199 dbs]$ pwd
/oracle/inst1/product/10.2.0/db_1/dbs
[oracle@10.14.54.199 dbs]$ cp initorcl.ora initorcl3.ora
注:这里我们通过拷贝原实例参数文件的方法进行创建,然后再进行修改。
修改新实例的参数文件
orcl.__db_cache_size=184549376
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=88080384
orcl.__streams_pool_size=0
*.audit_file_dest='/oracle/inst1/admin/orcl3/adump'
*.background_dump_dest='/oracle/inst1/admin/orcl3/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/oracle/inst1/oradata/orcl3/control01.ctl','/oracle/inst1/oradata/orcl3/control02.ctl','/oracle/inst1/oradata/orcl3/control03.ctl'
*.core_dump_dest='/oracle/inst1/admin/orcl3/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl3'