刚学ORACLE,手工创建数据库时老出错,不知道为什么,还请高手帮忙!

taoger 2004-11-21 03:19:55
已连接到空闲例程。
SQL> create database myoracle
2 logfile
3 group 1('D:\oracle\oradata\myoracle\redo1a.log','D:\oracle\oradata\myoracle
\redo1b.log')size 1024k,
4 group 2('D:\oracle\oradata\myoracle\redo2a.log','D:\oracle\oradata\myoracle
\redo2b.log')size 1024k,
5 group 3('D:\oracle\oradata\myoracle\redo3a.log','D:\oracle\oradata\myoracle
\redo3b.log')size 1024k
6 maxlogfiles 32
7 maxlogmembers 5
8 maxloghistory 653534
9 datafile 'D:\oracle\oradata\myoracle\system01.dbf'size 158m
10 autoextend on next 640k maxsize unlimited
11 maxdatafiles 254
12 maxinstances 2
13 character set zhs16gbk
14 national charater set zhs16gbk;
create database myoracle
*
ERROR 位于第 1 行:
ORA-01034: ORACLE not available

...全文
116 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
aweihz 2004-11-22
  • 打赏
  • 举报
回复
先startup nomount啊,然后再执行你的脚本
xbm2008 2004-11-21
  • 打赏
  • 举报
回复
ORA-01034: ORACLE not available
Cause: Oracle was not started up. Possible causes include the following:
- The SGA requires more space than was allocated for it.

- The operating-system variable pointing to the instance is improperly defined.

Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.

17,377

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧