自建数据库,执行@?/rdbms/admin/catproc.sql未完全执行完毕,中途我把命令窗口强制给关掉了,第二次启动startup数据库的时候出现如下提示错误
Total System Global Area  422670336 bytes
Fixed Size                  1300352 bytes
Variable Size             339740800 bytes
Database Buffers           75497472 bytes
Redo Buffers                6131712 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 8032
Session ID: 170 Serial number: 5
用startup upgrade命令启动数据库的时候一切正常
Total System Global Area  422670336 bytes
Fixed Size                  1300352 bytes
Variable Size             339740800 bytes
Database Buffers           75497472 bytes
Redo Buffers                6131712 bytes
Database mounted.
Database opened.
以下是我的spfile
bbk.__db_cache_size=75497472
bbk.__java_pool_size=12582912
bbk.__large_pool_size=4194304
bbk.__oracle_base='/u01'#ORACLE_BASE set from environment
bbk.__pga_aggregate_target=180355072
bbk.__sga_target=243269632
bbk.__shared_io_pool_size=0
bbk.__shared_pool_size=142606336
bbk.__streams_pool_size=0
*._disable_logging=FALSE
*.audit_file_dest='/u01/admin/bbk/adump'
*.audit_trail='db'
*.compatible='11.1.0.0.0'
*.control_files='/u01/oradata/bbk/control01.ctl','/u01/oradata/bbk/control02.ct
l','/u01/oradata/bbk/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='bbk'
*.db_recovery_file_dest='/u01/flash_recovery_area'
*.db_recovery_file_dest_size=314572800
*.diagnostic_dest='/u01'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=bbkXDB)'
*.memory_target=422576128
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'这个是我执行的创建数据库的命令
spool dbcreate.log;CREATE DATABASE "bbk"
MAXDATAFILES 500
MAXINSTANCES 8
MAXLOGFILES  8
MAXLOGFILES  32
CHARACTER SET "UTF8"
NATIONAL CHARACTER SET AL16UTF16
ARCHIVELOG
DATAFILE '/u01/oradata/bbk/system01.dbf' size 300M
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/oradata/bbk/tempts01.dbf' SIZE 100M
EXTENT MANAGEMENT LOCAL
SYSAUX datafile '/u01/oradata/bbk/sysaux01.dbf' size 300M
UNDO TABLESPACE "UNDOTBS1"
DATAFILE '/u01/oradata/bbk/undotbs01.dbf' SIZE 200M
LOGFILE
GROUP 1(
'/u01/oradata/bbk/redo01a.rdo',
'/u01/oradata/bbk/redo01b.rdo'
)SIZE 100M,
GROUP 2(
'/u01/oradata/bbk/redo02a.rdo',
'/u01/oradata/bbk/redo02b.rdo'
)SIZE 100M,
GROUP 3(
'/u01/oradata/bbk/redo03a.rdo',
'/u01/oradata/bbk/redo03b.rdo'
)SIZE 100M
;spool off望高手帮忙解答,为什么我starup启动的时候会报错,这个错误如何修改?