手动创建数据库

手动创建数据库

实验环境 windows xp +oracle 11.2.0.1.0

1．  创建实例

C:\Documents and Settings\wwang>oradim  -NEW -SID wlm

2．  编辑初始化参数

如下：

wlm.__db_cache_size=71303168

wlm.__java_pool_size=4194304

wlm.__large_pool_size=4194304

wlm.__oracle_base='D:\app\wwang'#ORACLE_BASE set from environment

wlm.__pga_aggregate_target=113246208

wlm.__sga_target=213909504

wlm.__shared_io_pool_size=0

wlm.__shared_pool_size=121634816

wlm.__streams_pool_size=4194304

*.audit_file_dest='D:\app\wwang\admin\wlm\adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='D:\app\wwang\oradata\wlm\control01.ctl','D:\app\wwang\flash_recovery_area\wlm\control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='wlm'

*.db_recovery_file_dest='D:\app\wwang\flash_recovery_area'

*.db_recovery_file_dest_size=1073741824

*.diagnostic_dest='D:\app\wwang'

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

*.memory_target=324009984

*.nls_language='SIMPLIFIED CHINESE'

*.nls_territory='CHINA'

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

3．  创建相应的一系列目录 adump bdump cdump,pdfile等

4．  创建口令验证文件

C:\Documents and Settings\wwang>orapwd file=D:\app\wwang\product\11.2.0\dbhome_1\database\pwdwlm.ora entries=2 p

assword=oracle

5．  启动数据库到nomount

SQL> startup nomount pfile=C:\initwlm.ora

ORACLE 例程已经启动。

Total System Global Area  326414336 bytes

Fixed Size                  1374388 bytes

Variable Size             247465804 bytes

Database Buffers           71303168 bytes

Redo Buffers                6270976 bytes

SQL>

6．  执行建库脚本

create database wlm

datafile 'D:\app\wwang\oradata\wlm\SYSTEM01.DBF' size 300M

sysaux datafile 'D:\app\wwang\oradata\wlm\SYSAUX01.DBF' size 20M

default temporary tablespace temp tempfile 'D:\app\wwang\oradata\wlm\TEMP01.DBF' size 120M

undo tablespace UNDOTBS1 datafile 'D:\app\wwang\oradata\wlm\UNDOTBS01.DBF' size 20M

logfile

group 1('D:\app\wwang\oradata\wlm\redo01.log') size 10M,

group 2('D:\app\wwang\oradata\wlm\redo02.log') size 10M

;

SQL> ed

已写入 file afiedt.buf

  1  create database wlm

  2  datafile 'D:\app\wwang\oradata\wlm\SYSTEM01.DBF' size 300M

  3  sysaux datafile 'D:\app\wwang\oradata\wlm\SYSAUX01.DBF' size 20M

  4  default temporary tablespace temp tempfile 'D:\app\wwang\oradata\wlm\TEMP01.DBF' size 120M

  5  undo tablespace UNDOTBS1 datafile 'D:\app\wwang\oradata\wlm\UNDOTBS01.DBF' size 20M

  6  logfile

  7  group 1('D:\app\wwang\oradata\wlm\redo01.log') size 10M,

  8* group 2('D:\app\wwang\oradata\wlm\redo02.log') size 10M

  9

SQL> /

数据库已创建。

SQL>

7. 创建数据字典视图 @?\rdbms\admin\catalog.sql

8. 创建oracle内部包 @?\rdbms\admin\catproc.sql

9. 创建spfile

Create spfile from pfile

SQL> create spfile from pfile;

文件已创建。

SQL>

8.配置监听和服务

LISTENER1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = PC-200910080511)(PORT = 1524))

  )

SID_LIST_LISTENER1 =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = wlm)

      (ORACLE_HOME = D:\app\wwang\product\11.2.0\dbhome_1)

      (SID_NAME = wlm)

    )

  )

WLM =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = PC-200910080511)(PORT = 1524))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = wlm)

    )

  )

启动监听：

C:\Documents and Settings\wwang>lsnrctl start LISTENER1

 

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 03-6月 -2012 22:45:13

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

启动tnslsnr: 请稍候...

Failed to open service <OracleOraDb11g_home1TNSListenerLISTENER1>, error 1060.

TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production

系统参数文件为D:\app\wwang\product\11.2.0\dbhome_1\network\admin\listener.ora

写入d:\app\wwang\product\11.2.0\dbhome_1\log\diag\tnslsnr\PC-200910080511\listener1\alert\log.xml的日志信息

监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PC-200910080511)(PORT=1524)))

 

正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PC-200910080511)(PORT=1524)))

LISTENER 的 STATUS

------------------------

别名                      LISTENER1

版本                      TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production

启动日期                  03-6月 -2012 22:45:18

正常运行时间              0 天 0 小时 0 分 2 秒

跟踪级别                  off

安全性                    ON: Local OS Authentication

SNMP                      OFF

监听程序参数文件          D:\app\wwang\product\11.2.0\dbhome_1\network\admin\listener.ora

监听程序日志文件          d:\app\wwang\product\11.2.0\dbhome_1\log\diag\tnslsnr\PC-200910080511\listener1\alert\

log.xml

监听端点概要...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PC-200910080511)(PORT=1524)))

服务摘要..

服务 "wlm" 包含 1 个实例。

  实例 "wlm", 状态 UNKNOWN, 包含此服务的 1 个处理程序...

命令执行成功

C:\Documents and Settings\wwang>

9. 配置dbconsole

C:\Documents and Settings\wwang>emca -config dbcontrol db -repos create

EMCA 开始于 2012-6-3 22:56:22

EM Configuration Assistant, 11.2.0.0.2 正式版

版权所有 (c) 2003, 2005, Oracle。保留所有权利。

输入以下信息:

数据库 SID: wlm

监听程序端口号: 1524

监听程序 ORACLE_HOME [ D:\app\wwang\product\11.2.0\dbhome_1 ]:

SYS 用户的口令:

DBSNMP 用户的口令:

SYSMAN 用户的口令:

SYSMAN 用户的口令: 通知的电子邮件地址 (可选):

通知的发件 (SMTP) 服务器 (可选):

-----------------------------------------------------------------

已指定以下设置

数据库 ORACLE_HOME ................ D:\app\wwang\product\11.2.0\dbhome_1

本地主机名 ................ PC-200910080511

监听程序 ORACLE_HOME ................ D:\app\wwang\product\11.2.0\dbhome_1

监听程序端口号 ................ 1524

数据库 SID ................ wlm

通知的电子邮件地址 ...............

通知的发件 (SMTP) 服务器 ...............

-----------------------------------------------------------------

是否继续? [是(Y)/否(N)]: Y

2012-6-3 22:57:14 oracle.sysman.emcp.EMConfig perform

信息: 正在将此操作记录到 D:\app\wwang\cfgtoollogs\emca\wlm\emca_2012_06_03_22_56_22.log。