我手动创建了数据库
参数文件 创建成功
密码文件 创建成功
connect sys/sky123 as sysdba ------成功
startup nomount ------实例打开成功运行create.sql脚本失败create database sky
datafile 'g:\oracle\product\10.2.0\oradata\sky\system01.dbf' size 100m
autoextend on next 10240k maxsize unlimited
sysaux datafile 'g:\oracle\product\10.2.0\oradata\sky\sysaux01.dbf' size 100m
autoextend on next 10240k maxsize unlimited
extent management local
default temporary tablespace temp tempfile 'g:\oracle\product\10.2.0\oradata\sky\temp01.dbf' size 20m
autoextend on next 10240k maxsize unlimited
undo tablespace undotbs1 datafile 'g:\oracle\product\10.2.0\oradata\sky\undotbs1.dbf' size 50m
autoextend on next 10240k maxsize unlimited
logfile group 1('h:\logfile1\disk\disk1\redo01a.log',
'h:\logfile1\disk\disk2\redo01b.log',
'h:\logfile1\disk\disk3\redo01c.log') size 10m,
group 2('h:\logfile1\disk\disk1\redo02a.log',
'h:\logfile1\disk\disk2\redo02b.log',
'h:\logfile1\disk\disk3\redo02c.log') size 10m,
group 3('h:\logfile1\disk\disk1\redo03a.log',
'h:\logfile\disk\disk2\redo03b.log',
'h:\logfile1\disk\disk3\redo03c.log') size 10m;------运行失败
第一行出现错误
ora-01501:create database ??
ora-01100:??????
怎么解决??google 了一下说
ORA-01501: CREATE DATABASE failed
The create database command failed.
Normally this error is followed by an accompanied error message indicating the real problem.
Causes can be:• A directory you want to create files into does not exist
• A datafile, controlfile or redolog file already exist at the specified location
• You were not connected
• The database was not startup in nomount mode
• You specified an invalid character set
• ...Solution: Check the appropriate logfile or error message and fix the problem.我创建的目录没有问题 该目录下也没有文件 实例也打开了(在NOMOUNT模式下) 字符没有制定 不是默认么??
参数文件 创建成功
密码文件 创建成功
connect sys/sky123 as sysdba ------成功
startup nomount ------实例打开成功运行create.sql脚本失败create database sky
datafile 'g:\oracle\product\10.2.0\oradata\sky\system01.dbf' size 100m
autoextend on next 10240k maxsize unlimited
sysaux datafile 'g:\oracle\product\10.2.0\oradata\sky\sysaux01.dbf' size 100m
autoextend on next 10240k maxsize unlimited
extent management local
default temporary tablespace temp tempfile 'g:\oracle\product\10.2.0\oradata\sky\temp01.dbf' size 20m
autoextend on next 10240k maxsize unlimited
undo tablespace undotbs1 datafile 'g:\oracle\product\10.2.0\oradata\sky\undotbs1.dbf' size 50m
autoextend on next 10240k maxsize unlimited
logfile group 1('h:\logfile1\disk\disk1\redo01a.log',
'h:\logfile1\disk\disk2\redo01b.log',
'h:\logfile1\disk\disk3\redo01c.log') size 10m,
group 2('h:\logfile1\disk\disk1\redo02a.log',
'h:\logfile1\disk\disk2\redo02b.log',
'h:\logfile1\disk\disk3\redo02c.log') size 10m,
group 3('h:\logfile1\disk\disk1\redo03a.log',
'h:\logfile\disk\disk2\redo03b.log',
'h:\logfile1\disk\disk3\redo03c.log') size 10m;------运行失败
第一行出现错误
ora-01501:create database ??
ora-01100:??????
怎么解决??google 了一下说
ORA-01501: CREATE DATABASE failed
The create database command failed.
Normally this error is followed by an accompanied error message indicating the real problem.
Causes can be:• A directory you want to create files into does not exist
• A datafile, controlfile or redolog file already exist at the specified location
• You were not connected
• The database was not startup in nomount mode
• You specified an invalid character set
• ...Solution: Check the appropriate logfile or error message and fix the problem.我创建的目录没有问题 该目录下也没有文件 实例也打开了(在NOMOUNT模式下) 字符没有制定 不是默认么??
解决方案 »
- oracle里面怎么实现类似事件探测器的功能,我想查询某句SQL是否执行
- oracle9i导出的数据库文件怎么导入oracle10g中
- 关于rownum与group by 合用出现的问题...
- 请教 Oracle存储过程处理大对象clob问题!!~!
- 求救!
- oracle数据库怎么导出,是不是一定得在oms下
- 我认为变态的一个问题,哪位帮帮我啊。
- Oracle数据库的备份与恢复,请高手按实际情指点一二。
- 请教:怎样将多行的同一个字段合并为查询结果中的一个字符串?
- oracle数据倒入问题??
- oracle text 全文检索、 Luene 全文检索, sql server 全文检索 方案选择,谢谢。
- 提示missing set keyword
只是修改了 db_name 还有几个文件的路径 其他都没有变过.
alter session set nls_language=american;
database name sky does not match parameter db_name moon 我机子上有orcl moon数据库 orcl 数据库服务都关闭了 建立sky数据库时 moon 数据库也关闭了oradim -new -sid sky -startup manual -pfile g:\oracle\product\10.2.0\db_1\database\initsky.ora
创建实例成功了
复制过来的initsky.ora中的db_name 也改为了 sky了 为什么??显示这样!!!
http://blog.csdn.net/robinson_0612/archive/2010/04/29/5542983.aspx请问楼主,你的帐户对这些目录具有写的权限吗?