Thu Jan 19 11:04:09 2006
Starting ORACLE instance (normal)
Disable cache advisory with old cache parameters
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 = 70
shared_pool_size = 33554432
enqueue_resources = 105
control_files = /home/ka/base_ka/control01.ctl, /home/ka/base_ka/control02.ctl, /home/ka/base_ka/control03.ctl
db_block_buffers = 2500
compatible = 9.2.0.0.0
log_buffer = 32768
log_checkpoint_interval = 10000
db_files = 20
db_file_multiblock_read_count= 8
rollback_segments = r01, r02, r03, r04, r05, r06, r07, r08, r09, r10, r11, r12
max_enabled_roles = 48
db_domain = .WORLD
service_names = ka.WORLD
background_dump_dest = /home/ka/bdump
user_dump_dest = /home/ka/udump
max_dump_file_size = 10240
core_dump_dest = /home/ka/cdump
sort_area_size = 131072
db_name = ka
open_cursors = 500
optimizer_mode = RULE
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Thu Jan 19 11:04:24 2006
create database "ka"
maxlogfiles 5
maxlogmembers 5
maxdatafiles 20
logfile
group 1 '/home/ka/base_ka/redologs/redolog1.log' size 10M,
group 2 '/home/ka/base_ka/redologs/redolog2.log' size 10M
datafile '/home/ka/base_ka/system/ts_system.dbf' size 80M
noarchivelog
character set we8iso8859p1
Thu Jan 19 11:04:24 2006
Database mounted in Exclusive Mode.
Thu Jan 19 11:04:25 2006
Successful mount of redo thread 1, with mount id 1980453368.
Assigning activation ID 1980453368 (0x760b51f8)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /home/ka/base_ka/redologs/redolog1.log
Successful open of redo thread 1.
Thu Jan 19 11:04:25 2006
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jan 19 11:04:25 2006
WARNING: Default passwords for SYS and SYSTEM will be used.
Thu Jan 19 11:04:25 2006
SMON: enabling cache recovery
Please change the passwords.
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Thu Jan 19 11:04:25 2006
create tablespace SYSTEM datafile '/home/ka/base_ka/system/ts_system.dbf' size 80M
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Completed: create tablespace SYSTEM datafile '/home/ka/base_
Thu Jan 19 11:04:28 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Thu Jan 19 11:04:36 2006
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: /home/ka/base_ka/redologs/redolog2.log
Thu Jan 19 11:04:37 2006
SMON: enabling tx recovery
Thu Jan 19 11:04:38 2006
Errors in file /home/ka/udump/harprod9_ora_10967.trc:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component
Thu Jan 19 11:04:38 2006
Error 2084 happened during db open, shutting down database
USER: terminating instance due to error 2084
Instance terminated by USER, pid = 10967
ORA-1092 signalled during: create database "ka"
maxlogfiles 5
maxlogmem...
[harpinst@FALBALA bdump]$ more alert_harprod9.log
Thu Jan 19 11:04:09 2006
Starting ORACLE instance (normal)
Disable cache advisory with old cache parameters
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 = 70
shared_pool_size = 33554432
enqueue_resources = 105
control_files = /home/ka/base_ka/control01.ctl, /home/ka/base_ka/control02.ctl, /home/ka/base_ka/control03.ctl
db_block_buffers = 2500
compatible = 9.2.0.0.0
log_buffer = 32768
log_checkpoint_interval = 10000
db_files = 20
db_file_multiblock_read_count= 8
rollback_segments = r01, r02, r03, r04, r05, r06, r07, r08, r09, r10, r11, r12
max_enabled_roles = 48
db_domain = .WORLD
service_names = ka.WORLD
background_dump_dest = /home/ka/bdump
user_dump_dest = /home/ka/udump
max_dump_file_size = 10240
core_dump_dest = /home/ka/cdump
sort_area_size = 131072
db_name = ka
open_cursors = 500
optimizer_mode = RULE
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Thu Jan 19 11:04:24 2006
create database "ka"
maxlogfiles 5
maxlogmembers 5
maxdatafiles 20
logfile
group 1 '/home/ka/base_ka/redologs/redolog1.log' size 10M,
group 2 '/home/ka/base_ka/redologs/redolog2.log' size 10M
datafile '/home/ka/base_ka/system/ts_system.dbf' size 80M
noarchivelog
character set we8iso8859p1
Thu Jan 19 11:04:24 2006
Database mounted in Exclusive Mode.
Thu Jan 19 11:04:25 2006
Successful mount of redo thread 1, with mount id 1980453368.
Assigning activation ID 1980453368 (0x760b51f8)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /home/ka/base_ka/redologs/redolog1.log
Successful open of redo thread 1.
Thu Jan 19 11:04:25 2006
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jan 19 11:04:25 2006
WARNING: Default passwords for SYS and SYSTEM will be used.
Thu Jan 19 11:04:25 2006
SMON: enabling cache recovery
Please change the passwords.
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Thu Jan 19 11:04:25 2006
create tablespace SYSTEM datafile '/home/ka/base_ka/system/ts_system.dbf' size 80M
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Completed: create tablespace SYSTEM datafile '/home/ka/base_
Thu Jan 19 11:04:28 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Thu Jan 19 11:04:36 2006
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: /home/ka/base_ka/redologs/redolog2.log
Thu Jan 19 11:04:37 2006
SMON: enabling tx recovery
Thu Jan 19 11:04:38 2006
Errors in file /home/ka/udump/harprod9_ora_10967.trc:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component
Thu Jan 19 11:04:38 2006
Error 2084 happened during db open, shutting down database
USER: terminating instance due to error 2084
Instance terminated by USER, pid = 10967
ORA-1092 signalled during: create database "ka"
maxlogfiles 5
maxlogmem...
Partager