oracle数据库报错:ORA-01147: ORA-01110: ora-01033,这是alter.log的日志文件,请问是什么错误!急···

mathlpz666 2014-12-27 10:26:24
Tue Dec 23 10:33:11 2014
SMON started with pid=12, OS id=7660
Tue Dec 23 10:33:11 2014
RECO started with pid=13, OS id=3144
Tue Dec 23 10:33:11 2014
MMON started with pid=14, OS id=7328
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Dec 23 10:33:11 2014
MMNL started with pid=15, OS id=3160
starting up 1 shared server(s) ...
ORACLE_BASE from environment = f:\app\thinkpad
Tue Dec 23 10:33:31 2014
Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'f:\app\thinkpad\oradata\orcl\SYSTEM01.DBF',
'f:\app\thinkpad\oradata\orcl\SYSAUX01.DBF',
'f:\app\thinkpad\oradata\orcl\UNDOTBS01.DBF',
'f:\app\thinkpad\oradata\orcl\USERS01.DBF'
LOGFILE GROUP 1 ('f:\app\thinkpad\oradata\orcl\redo01.log') SIZE 51200K,
GROUP 2 ('f:\app\thinkpad\oradata\orcl\redo02.log') SIZE 51200K,
GROUP 3 ('f:\app\thinkpad\oradata\orcl\redo03.log') SIZE 51200K RESETLOGS
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Tue Dec 23 10:33:31 2014
ORA-09341: scumnt: unable to mount database
OSD-04400: 无法获取进程的内部信号
O/S-Error: (OS 183) 当文件已存在时,无法创建该文件。
Errors in file f:\app\thinkpad\diag\rdbms\orcl\oracle\trace\oracle_ora_1592.trc:
ORA-01158: ??? ???
ORA-1503 signalled during: Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'f:\app\thinkpad\oradata\orcl\SYSTEM01.DBF',
'f:\app\thinkpad\oradata\orcl\SYSAUX01.DBF',
'f:\app\thinkpad\oradata\orcl\UNDOTBS01.DBF',
'f:\app\thinkpad\oradata\orcl\USERS01.DBF'
LOGFILE GROUP 1 ('f:\app\thinkpad\oradata\orcl\redo01.log') SIZE 51200K,
GROUP 2 ('f:\app\thinkpad\oradata\orcl\redo02.log') SIZE 51200K,
GROUP 3 ('f:\app\thinkpad\oradata\orcl\redo03.log') SIZE 51200K RESETLOGS...
Tue Dec 23 10:33:35 2014
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 9536): terminating the instance
Instance terminated by USER, pid = 9536
Tue Dec 23 10:33:37 2014
Instance shutdown complete
...全文
1640 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
bw555 2014-12-27
  • 打赏
  • 举报
回复
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command Default Temporary Tablespace will be necessary for a locally managed database in future release 重点是这两行,创建数据库的命令没有指定缺省的临时表空间

17,140

社区成员

发帖
与我相关
我的任务
社区描述
Oracle开发相关技术讨论
社区管理员
  • 开发
  • Lucifer三思而后行
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

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