00073.Oracle手工创建数据库

 

(1)       口令文件

oracle@mdsps1:~/oradata/mdsp> orapwd file=$ORACLE_HOME/dbs/orapwmdsp passwd=admin entries=3

设置参数文件：REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

(2)       变量设置

在oracle用户的shell初始化文件中配置：

$ ORACLE=/u01/oracle/product/10.0.1;

export ORACLE_HOME

$ORACLE_SID=mdsp;

export ORACLE_SID

$ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data;

export ORA_NLS33

$PATH=/usr/bin:/usr/ccs/bin:$ORACLE_HOME/bin;

export PATH

$LD_LIBRARY_PATH=/usr/lib:$ORACLE_HOME/lib;

export LD_LIBRARY_PATH

(3)       配置参数文件

$ cd $ORACLE_HOME/dbs

Cp  init.ora initmdsp.ora

Create spfile from pfile;

(4)       创建数据库

$ sqlplus “/as sysdba”

SQL> startup  nomount pfile=$ORACLE_HOME/dbs/initmdsp.ora

SQL> create database mdsp

  2  user sys identified by sys

  3  user system identified by system

  4  logfile

  5  group 1 ('/home/oracle/oracle/oradata/mdsp/redo01_mdsp.log') size 15m,

  6  group 2 ('/home/oracle/oracle/oradata/mdsp/redo02_mdsp.log') size 15m,

  7  group 3 ('/home/oracle/oracle/oradata/mdsp/redo03_mdsp.log') size 15m,

  8  maxlogfiles 5

  9  maxlogmembers 5

 10  maxloghistory 8

 11  maxdatafiles 368

 12  maxinstances 1

 13  archivelog

 14  force logging

 15  datafile '/home/oracle/oracle/oradata/mdsp/system_01_mdsp.dbf' size 3000m

 16  undo tablespace undotabs

 17  datafile '/home/oracle/oracle/oradata/mdsp/undo_01_mdsp.dbf' size 80m

 18  default temporary tablespace temp

 19  tempfile '/home/oracle/oracle/oradata/temp_01_mdsp.dbf' size 50m

 20  extent management local uniform size 1m

 21  character set AL32UTF8

 22  national character set AL16UTF16

 23  time_zone='Asiz/Shanghai';

(5)       创建数据字典视图、软件包、过程、用户概要文件及过程；

SQL>connect sys/sys@mdsp as sysdba

SQL>@$ORACLE_HOME/rdbms/admin/catalog.sql

SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql

SQL>connect system/system@mdsp

SQL>@$ORACLE_HOME/sqlplus /admin/pupbld.sql

(6)       创建用户表空间、用户等