Linux下Oracle 10g手工建库全过程

2014-11-24 18:13:36 · 作者: · 浏览: 0


1.建立所需的目录

1.$oracle_home/admin

2.$oracle_home/admin/oracle_sid/adump

3.$oracle_home/admin/oracle_sid/bdump ----alter_SID.log在这个目录中

4.$oracle_home/admin/oracle_sid/cdump

5.$oracle_home/admin/oracle_sid/dpdump

6.$oracle_home/admin/oracle_sid/pfile

7.$oracle_home/admin/oracle_sid/script

8.$oracle_home/oradata/oracle_sid/



2.创建相关文件

1.建pfile既数据库初始化文件($oracle_home/oracle_sid/dbs目录下)

2.建口令文件

3.准备建库脚本

4.运行catalog,catproc,pupbld



3.PFILE数据库初始化文件(initSID.ora)(本次实验中oracle实验中sid=wjtest)

wjtest.__db_cache_size=188743680

wjtest.__java_pool_size=4194304

wjtest.__large_pool_size=4194304

wjtest.__shared_pool_size=83886080

wjtest.__streams_pool_size=0

*.audit_file_dest='/u01/oracle/admin/wjtest/adump'

*.background_dump_dest='/u01/oracle/admin/wjtest/bdump'

*.compatible='10.2.0.1.0'

*.control_files='/u01/oracle/oradata/wjtest/control01.ctl','/u01/oracle/oradata/wjtest/control02.ctl','/u01/oracle/oradata/wjtest/control03.ctl'

*.core_dump_dest='/u01/oracle/admin/wjtest/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='wjtest'

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

*.db_recovery_file_dest_size=2147483648

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

*.job_queue_processes=10

*.log_archive_format='%t_%s_%r.dbf'

*.open_cursors=300

*.pga_aggregate_target=94371840

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=285212672

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/u01/oracle/admin/wjtest/udump'