- 论坛徽章:
- 0
|
菜鸟问题___创建数据库
在D:\Orant\admin\mytest\create里面有两个文件:createdb.log and mytestrun.sql
createdb.log 内容如下:
回送 ON
SVRMGR>; connect INTERNAL
连接成功。
SVRMGR>; startup nomount pfile="D:\orant\admin\mytest\pfile\initmytest.ora"
ORA-00439: feature not enabled: Managed Standby
SVRMGR>; CREATE DATABASE mytest
2>; LOGFILE 'D:\orant\oradata\mytest\redo01.log' SIZE 1024K,
3>; 'D:\orant\oradata\mytest\redo02.log' SIZE 1024K,
4>; 'D:\orant\oradata\mytest\redo03.log' SIZE 1024K
5>; MAXLOGFILES 32
6>; MAXLOGMEMBERS 2
7>; MAXLOGHISTORY 1
8>; DATAFILE 'D:\orant\oradata\mytest\system01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 10240K
9>; MAXDATAFILES 254
10>; MAXINSTANCES 1
11>; CHARACTER SET ZHS16GBK
12>; NATIONAL CHARACTER SET ZHS16GBK;
CREATE DATABASE mytest
*
ORA-01034: ORACLE not available
SVRMGR>; spool off
mytestrun.sql内容如下:
spool D:\orant\admin\mytest\create\createdb
set echo on
connect INTERNAL
startup nomount pfile="D:\orant\admin\mytest\pfile\initmytest.ora"
CREATE DATABASE mytest
LOGFILE 'D:\orant\oradata\mytest\redo01.log' SIZE 1024K,
'D:\orant\oradata\mytest\redo02.log' SIZE 1024K,
'D:\orant\oradata\mytest\redo03.log' SIZE 1024K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'D:\orant\oradata\mytest\system01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 10240K
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET ZHS16GBK;
spool off
各位大哥,帮忙看看! |
|