oracle如何手工输入,手工创建Oracle数据库

**************************/ 具体参考联机文档 /*****************************

第一步 设置环境变量   vi liuyang.env   输入

ORACLE_SID=liuyang

PATH=$ORACLE_HOME/bin:$PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH

使环境变量生效

chmod +x liuyang.env

. ./liuyang.env

第二步

创建目录

cd /u01/oradata

mkdir liuyang

创建pfile

vi initliuyang.ora

输入初始化参数(可拷贝，可查联机文档，可手写)

eg:  db_name='liuyang' (最简单的)

第三步  启动Oracle数据库实例

sqlplus /nolog

conn /as sysdba

create spfile from pfile; (创建spfile)

startup nomount  (没有数据库，仅能启动到nomount)

第四步  正是创建数据库

CREATE DATABASE liuyang

user sys IDENTIFIED BY oracle

user system IDENTIFIED BY oracle

logfile

GROUP 1 ('/u01/oradata/liuyang/redolog01.log') SIZE 100M,

GROUP 2 ('/u01/oradata/liuyang/redolog02.log') SIZE 100M,

GROUP 3 ('/u01/oradata/liuyang/redolog03.log') SIZE 100M

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

CHARACTER SET US7ASCII

NATIONAL CHARACTER SET AL16UTF16

EXTENT MANAGEMENT LOCAL

DATAFILE '/u01/oradata/liuyang/system01.dbf' SIZE 325M REUSE

SYSAUX DATAFILE '/u01/oradata/liuyang/sysaux01.dbf' SIZE 325M REUSE

DEFAULT TABLESPACE users

DATAFILE '/u01/oradata/liuyang/user01.dbf'

SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE '/u01/oradata/liuyang/temp01.dbf'

SIZE 20M REUSE

UNDO TABLESPACE undotbs

DATAFILE '/u01/oradata/liuyang/undotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE unlimited;

第五步  创建自己的表空间，上面已创建

eg    create tablespace mytbs

datafile '/u01/oradata/liuyang/mytbs01.dbf' size 200M reuse autoextend on maxsize unlimited;

第六步  执行脚本

catalog.sql ---  Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views. Grants PUBLIC access to the synonyms.

catproc.sql ---  Runs all scripts required for or used with PL/SQL.

pupbld.sql  ---  Required for SQL*Plus. Enables SQL*Plus to disable commands by user.

**************************/ 具体参考联机文档 /*****************************