alter_bbk.log里面的内容:
Tue Dec 8 15:52:46 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
large_pool_size = 83886080
java_pool_size = 83886080
control_files = /u01/oradata/bbk/control01.ctl, /u01/oradata/bbk/control02.ctl, /u01/oradata/bbk/control03.ctl
db_block_size = 8192
db_cache_size = 33554432
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = LOCATION=/u01/oradata/bbk/archive
log_archive_format = %t_%s.dbf
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = bbk
dispatchers = (PROTOCOL=TCP) (SERVICE=bbkXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /u01/admin/bbk/bdump
user_dump_dest = /u01/admin/bbk/udump
core_dump_dest = /u01/admin/bbk/cdump
sort_area_size = 524288
db_name = bbk
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
SMON started with pid=6
CJQ0 started with pid=8
RECO started with pid=7
CKPT started with pid=5
Tue Dec 8 15:52:48 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
QMN0 started with pid=9
Tue Dec 8 15:52:48 2009
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue Dec 8 15:52:48 2009
ARC0: Thread not mounted
ARC1 started with pid=13
ARC1: Archival started
ARC1: Thread not mounted
Tue Dec 8 15:53:42 2009
CREATE DATABASE "bbk"
MAXDATAFILES 500
MAXINSTANCES 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
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 100MTue Dec 8 15:53:42 2009
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Dec 8 15:53:43 2009
Database mounted in Exclusive Mode.
Tue Dec 8 15:53:53 2009
Successful mount of redo thread 1, with mount id 887204294.
LGWR: Primary database is in CLUSTER CONSISTENT mode
Assigning activation ID 887204294 (0x34e1a9c6)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/oradata/bbk/redo01a.rdo
Current log# 1 seq# 1 mem# 1: /u01/oradata/bbk/redo01b.rdo
Successful open of redo thread 1.
Tue Dec 8 15:53:53 2009
SMON: enabling cache recovery
Tue Dec 8 15:53:53 2009
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Tue Dec 8 15:53:54 2009
create tablespace SYSTEM datafile '/u01/oradata/bbk/system01.dbf' size 300M
EXTENT MANAGEMENT LOCAL online
ORA-19502 signalled during: create tablespace SYSTEM datafile '/u01/oradata/b...
Tue Dec 8 15:53:56 2009
Errors in file /u01/admin/bbk/udump/bbk_ora_3836.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-19502: write error on file "/u01/oradata/bbk/system01.dbf", blockno 25729 (blocksize=8192)
ORA-27072: skgfdisp: I/O error
Linux Error: 2: No such file or directory
Additional information: 25728
Tue Dec 8 15:53:56 2009
Errors in file /u01/admin/bbk/udump/bbk_ora_3836.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 644
ORA-00604: error occurred at recursive SQL level 1
ORA-19502: write error on file "/u01/oradata/bbk/system01.dbf", blockno 25729 (blocksize=8192)
ORA-27072: skgfdisp: I/O error
Linux Error: 2: No such file or directory
Additional information: 25728
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 3836
ORA-1092 signalled during: CREATE DATABASE "bbk"
MAXDATAFILES 500
MAXINSTANCE...其他环境变量都设了,目录也建了就是要出现这些错误,网上收了,也有类似的错误但没有答案,我是初学者,请各位前辈指点指点。不胜感激!
Tue Dec 8 15:52:46 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
large_pool_size = 83886080
java_pool_size = 83886080
control_files = /u01/oradata/bbk/control01.ctl, /u01/oradata/bbk/control02.ctl, /u01/oradata/bbk/control03.ctl
db_block_size = 8192
db_cache_size = 33554432
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = LOCATION=/u01/oradata/bbk/archive
log_archive_format = %t_%s.dbf
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = bbk
dispatchers = (PROTOCOL=TCP) (SERVICE=bbkXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /u01/admin/bbk/bdump
user_dump_dest = /u01/admin/bbk/udump
core_dump_dest = /u01/admin/bbk/cdump
sort_area_size = 524288
db_name = bbk
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
SMON started with pid=6
CJQ0 started with pid=8
RECO started with pid=7
CKPT started with pid=5
Tue Dec 8 15:52:48 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
QMN0 started with pid=9
Tue Dec 8 15:52:48 2009
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue Dec 8 15:52:48 2009
ARC0: Thread not mounted
ARC1 started with pid=13
ARC1: Archival started
ARC1: Thread not mounted
Tue Dec 8 15:53:42 2009
CREATE DATABASE "bbk"
MAXDATAFILES 500
MAXINSTANCES 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
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 100MTue Dec 8 15:53:42 2009
Restarting dead background process QMN0
QMN0 started with pid=9
Tue Dec 8 15:53:43 2009
Database mounted in Exclusive Mode.
Tue Dec 8 15:53:53 2009
Successful mount of redo thread 1, with mount id 887204294.
LGWR: Primary database is in CLUSTER CONSISTENT mode
Assigning activation ID 887204294 (0x34e1a9c6)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/oradata/bbk/redo01a.rdo
Current log# 1 seq# 1 mem# 1: /u01/oradata/bbk/redo01b.rdo
Successful open of redo thread 1.
Tue Dec 8 15:53:53 2009
SMON: enabling cache recovery
Tue Dec 8 15:53:53 2009
WARNING: Default passwords for SYS and SYSTEM will be used.
Please change the passwords.
Tue Dec 8 15:53:54 2009
create tablespace SYSTEM datafile '/u01/oradata/bbk/system01.dbf' size 300M
EXTENT MANAGEMENT LOCAL online
ORA-19502 signalled during: create tablespace SYSTEM datafile '/u01/oradata/b...
Tue Dec 8 15:53:56 2009
Errors in file /u01/admin/bbk/udump/bbk_ora_3836.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-19502: write error on file "/u01/oradata/bbk/system01.dbf", blockno 25729 (blocksize=8192)
ORA-27072: skgfdisp: I/O error
Linux Error: 2: No such file or directory
Additional information: 25728
Tue Dec 8 15:53:56 2009
Errors in file /u01/admin/bbk/udump/bbk_ora_3836.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 644
ORA-00604: error occurred at recursive SQL level 1
ORA-19502: write error on file "/u01/oradata/bbk/system01.dbf", blockno 25729 (blocksize=8192)
ORA-27072: skgfdisp: I/O error
Linux Error: 2: No such file or directory
Additional information: 25728
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 3836
ORA-1092 signalled during: CREATE DATABASE "bbk"
MAXDATAFILES 500
MAXINSTANCE...其他环境变量都设了,目录也建了就是要出现这些错误,网上收了,也有类似的错误但没有答案,我是初学者,请各位前辈指点指点。不胜感激!
http://www.ixdba.net/article/08/1264.html
你检查一下你的/etc/fstab里面mount的是这个吗?