手动创建数据库步骤

 

作者 阿九【转载时请务必以超链接形式标明文章原始出处和作者信息】

 

手动创建数据库步骤

 

1、安装软件

2、升级

3、配置监听

不适用netca来创建和配置，手动创建监听参数文件，在TSN_HOME目录下编辑listener.ora文件，加入如下内容

SID_LIST_LISTENER =

    (SID_LIST =

       (SID_DESC =

         (SID_NAME = PLSExtProc)

         (ORACLE_HOME = /oracle/db10g)

         (PROGRAM = extproc)

       )

    )

LISTENER =

 (DESCRIPTION_LIST=

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.21 )(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

 )

4、创建所需的追踪文件存放目录和数据文件存放目录(使用raw的则先配置好raw)

$ORACLE_BASE/admin/orcl/

                     --adump

                     --bdump

                     --cdump

                     --dpdump

                     --pfile

                     --udump

$ORACLE_BASE/oradata/orcl

5、创建所需的pfile文件

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

*.audit_file_dest='/oracle/admin/orcl/adump'

*.background_dump_dest='/oracle/admin/orcl/bdump'

*.core_dump_dest='/oracle/admin/orcl/cdump'

*.user_dump_dest='/oracle/admin/orcl/udump'

*.compatible='10.2.0.5.0'

*.db_block_size=8192

*.db_name='orcl'

*.db_domain=''

*.db_file_multiblock_read_count=16

*.job_queue_processes=10

*.open_cursors=300

*.pga_aggregate_target=104857600

*.sga_target=314572800

*.undo_management&