手动新建数库在执行create database 时发生的错误:
error位于第一行:
ora-01092:oracle 例程终止.强行断开连接
删除过,再建仍为这个提示,请教如何能解决这个问题???
查看alert日志有如下提示:
Tue Jun 01 18:04:39 2010
CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'd:\oracle\oradata\MYNEWDB\undotbs.dbf' size 20m
autoextend on next 5120k maxsize unlimitedORA-406 signalled during: CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'd:\oracl...
Tue Jun 01 18:04:41 2010
Errors in file d:\oracle\ora92\rdbms\trace\mynewdb_ora_2220.trc:
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???Tue Jun 01 18:04:41 2010
Errors in file d:\oracle\ora92\rdbms\trace\mynewdb_ora_2220.trc:
ORA-01501: CREATE DATABASE ??
ORA-01519: ?????'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ'????5161???
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 2220
ORA-1092 signalled during: create database MYNEWDB
maxinstances 1
maxloghisto...
##############################
数据库的创建过程如下所示:
C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on 星期二 6月 1 17:42:30 2010Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> conn sys/mynewdb as sysdba
已连接到空闲例程。
SQL> create spfile='D:\oracle\ora92\database\spfilemynewdb.ora' from pfile='D:\o
racle\ora92\database\initMYNEWDB.ora';文件已创建。SQL> create database MYNEWDB
2 maxinstances 1
3 maxloghistory 1
4 maxlogfiles 5
5 maxlogmembers 5
6 maxdatafiles 100
7 datafile 'd:\oracle\oradata\MYNEWDB\system.dbf' size 50M
8 undo tablespace undotbs datafile 'd:\oracle\oradata\MYNEWDB\undotbs.dbf' si
ze 20m
9 autoextend on next 5120k maxsize unlimited
10 default temporary tablespace tempts
11 character set us7ASCII
12 national character set al16utf16
13 logfile group 1('d:\oracle\oradata\MYNEWDB\redo01.log') size 10M,
14 group 2('d:\oracle\oradata\MYNEWDB\redo02.log') size 10m,
15 group 3('d:\oracle\oradata\MYNEWDB\redo03.log') size 10m;
create database MYNEWDB
*
ERROR 位于第 1 行:
ORA-01034: ORACLE not available
error位于第一行:
ora-01092:oracle 例程终止.强行断开连接
删除过,再建仍为这个提示,请教如何能解决这个问题???
查看alert日志有如下提示:
Tue Jun 01 18:04:39 2010
CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'd:\oracle\oradata\MYNEWDB\undotbs.dbf' size 20m
autoextend on next 5120k maxsize unlimitedORA-406 signalled during: CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'd:\oracl...
Tue Jun 01 18:04:41 2010
Errors in file d:\oracle\ora92\rdbms\trace\mynewdb_ora_2220.trc:
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???Tue Jun 01 18:04:41 2010
Errors in file d:\oracle\ora92\rdbms\trace\mynewdb_ora_2220.trc:
ORA-01501: CREATE DATABASE ??
ORA-01519: ?????'%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ'????5161???
ORA-00604: ?? SQL ? 1 ????
ORA-00406: COMPATIBLE ????? 9.0.0.0.0 ???Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 2220
ORA-1092 signalled during: create database MYNEWDB
maxinstances 1
maxloghisto...
##############################
数据库的创建过程如下所示:
C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on 星期二 6月 1 17:42:30 2010Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> conn sys/mynewdb as sysdba
已连接到空闲例程。
SQL> create spfile='D:\oracle\ora92\database\spfilemynewdb.ora' from pfile='D:\o
racle\ora92\database\initMYNEWDB.ora';文件已创建。SQL> create database MYNEWDB
2 maxinstances 1
3 maxloghistory 1
4 maxlogfiles 5
5 maxlogmembers 5
6 maxdatafiles 100
7 datafile 'd:\oracle\oradata\MYNEWDB\system.dbf' size 50M
8 undo tablespace undotbs datafile 'd:\oracle\oradata\MYNEWDB\undotbs.dbf' si
ze 20m
9 autoextend on next 5120k maxsize unlimited
10 default temporary tablespace tempts
11 character set us7ASCII
12 national character set al16utf16
13 logfile group 1('d:\oracle\oradata\MYNEWDB\redo01.log') size 10M,
14 group 2('d:\oracle\oradata\MYNEWDB\redo02.log') size 10m,
15 group 3('d:\oracle\oradata\MYNEWDB\redo03.log') size 10m;
create database MYNEWDB
*
ERROR 位于第 1 行:
ORA-01034: ORACLE not available
这个错误 我不清楚 呵呵
你的spfile或者pfile里头的compatible值是多少?似乎不匹配。
racle\ora92\database\initMYNEWDB.ora'的内容贴出来供大家看看,也许有些启发
# Copyright (c) 2010-5-9 by R
##############################################################################
###########################################
# 共享服务器设置
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=MYNEWDBXDB)"
###########################################
# 数据库实例名 Instance Identification
###########################################
instance_name=MYNEWDB
###########################################
# 安全与审计设置 Security and Auditing
###########################################
remote_login_passwordfile=EXCLUSIVE
###########################################
# 排序大小设置 Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=25165824
sort_area_size=524288
###########################################
# 全局数据库名设置 Database Identification
###########################################
db_domain=" "
db_name=MYNEWDB
###########################################
# 控制文件设置 File Configuration
###########################################
control_files=("D:\oracle\oradata\MYNEWDB\CONTROL01.CTL", "D:\oracle\oradata\MYNEWDB\CONTROL02.CTL", "D:\oracle\oradata\MYNEWDB\CONTROL03.CTL")
###########################################
# SGA区设置 Pools
###########################################
java_pool_size=33554432
large_pool_size=8388608
shared_pool_size=50331648
###########################################
# 游标与库缓存设置 Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# 回推段或撤销表空间设置 System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS
###########################################
# 诊断与跟踪信息设置 Diagnostics and Statistics
###########################################
background_dump_dest=D:\oracle\admin\MYNEWDB\bdump
core_dump_dest=D:\oracle\admin\MYNEWDB\cdump
timed_statistics=TRUE
user_dump_dest=D:\oracle\admin\MYNEWDB\udump
###########################################
#用户进程设置 Processes and Sessions
###########################################
processes=150
###########################################
# 缓冲区与数据库大小设置 Cache and I/O
###########################################
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_count=16
这是所有的内容
compatible=9.2.0.1.0
补上去,重新生成spfile再试试看。估计还有别的问题。