| Oralce-shutting down automatically [message #369476] |
Fri, 29 September 2000 06:04 |
Reddy
Messages: 11
Registered: September 2000
|
Junior Member |
|
|
we have hp-ux/oracle,cold backup every nite, 2'o clock shutdowns the database and start up 5 'o clock,the proble since last monday onwards our database shutting down two three times a day. when i trace alert filei found there are some thing which are changed on monday
i am pasting them here as it is :
Current log# 3 seq# 5247 mem# 0: /spare/oradata/TIBS_DEV/redoTIBS_DEV03.dbf
Successful open of redo thread 1.
Sat Sep 23 05:00:20 2000
SMON: enabling cache recovery
SMON: enabling tx recovery
Sat Sep 23 05:00:22 2000
Completed: alter database open
Mon Sep 25 13:18:54 2000
ORA-1652: unable to extend temp segment by 5 in tablespace IS_STAFF
Mon Sep 25 16:22:49 2000
alter tablespace is_staff add datafile
'/spare3/oradata/TIBS_DEV/is_staff02.dbf' size 300m
Mon Sep 25 16:22:49 2000
ORA-1119 signalled during: alter tablespace is_staff add datafile
'/spare3/or...
Mon Sep 25 16:23:32 2000
alter tablespace is_staff add datafile
'/spare3/oradata/TIBS_DEV/is_staff02.dbf' size 300m
Mon Sep 25 16:24:04 2000
Completed: alter tablespace is_staff add datafile
'/spare3/or
Tue Sep 26 02:00:01 2000
Shutting down instance (immediate)
License high water mark = 11
Tue Sep 26 02:05:04 2000
Waiting for dispatcher 'D000' to shutdown
Tue Sep 26 05:00:02 2000
Starting ORACLE instance (normal)
Tue Sep 26 08:23:09 2000
ALTER DATABASE CLOSE NORMAL
Tue Sep 26 08:23:09 2000
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Sep 26 08:23:10 2000
Thread 1 closed at log sequence 5247
Tue Sep 26 08:23:10 2000
Completed: ALTER DATABASE CLOSE NORMAL
Tue Sep 26 08:23:10 2000
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
Tue Sep 26 09:19:10 2000
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.3.2.0.
System parameters with non-default values:
_trace_files_public = TRUE
processes = 90
sessions = 80
shared_pool_size = 78643200
enqueue_resources = 6000
nls_language = american
nls_territory = america
nls_sort = binary
nls_date_format = DD-MON-RR
nls_numeric_characters = .,
control_files = /spare/oradata/TIBS_DEV/ctlTIBS_DEV01.dbf, /spare/oradata/TIBS_DEV/ctlTIBS_DEV02.dbf, /spare/oradata/TIBS_DEV/ctlTIBS_DEV03.dbf
db_block_buffers = 3000
db_block_size = 8192
log_buffer = 163840
log_checkpoint_interval = 10000
db_files = 150
db_file_multiblock_read_count= 32
dml_locks = 500
row_locking = always
rollback_segments = rbsspc01, rbsspc02, rbsspc03, rbsspc04
sequence_cache_entries = 100
sequence_cache_hash_buckets= 89
global_names = FALSE
distributed_lock_timeout = 500
mts_service = TIBS_DEV
mts_dispatchers = (ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp))(DIS=1)(SES=254)(CON=254)(TIC=15)(POO=NO)(MUL=NO)(LIS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=TIBS_DEV))(ADDRESS=(PROTOCOL=tcp)(HOST=TIBS_DEV)(PORT=1521)))),
mts_servers = 3
mts_max_servers = 10
mts_max_dispatchers = 10
mts_listener_address = (ADDRESS=(PROTOCOL=ipc)(KEY=TIBS_DEV)), (ADDRESS=(PROTOCOL=tcp)(HOST=TIBS_DEV)(PORT=1521))
sort_area_size = 512000
db_name = TIBS_DEV
open_cursors = 3000
_optimizer_undo_changes = TRUE
optimizer_mode = rule
utl_file_dir = /spare2/ora8/outdir
background_dump_dest = /spare/oradata/TIBS_DEV/bdump
user_dump_dest = /spare/oradata/TIBS_DEV/udump
max_dump_file_size = 10240
core_dump_dest = /spare/oradata/TIBS_DEV/cdump
PMON started
DBWR started
LGWR started
CKPT started
RECO started
Tue Sep 26 09:19:11 2000
starting up 3 shared server(s) ...
starting up 1 dispatcher(s) for network protocol '(ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp))'...
Tue Sep 26 09:19:11 2000
alter database mount exclusive
Tue Sep 26 09:19:11 2000
Successful mount of redo thread 1.
Tue Sep 26 09:19:11 2000
Completed: alter database mount exclusive
Tue Sep 26 09:19:11 2000
alter database open
Tue Sep 26 09:19:12 2000
Thread 1 opened at log sequence 5247
Current log# 3 seq# 5247 mem# 0: /spare/oradata/TIBS_DEV/redoTIBS_DEV03.dbf
Successful open of redo thread 1.
Tue Sep 26 09:19:12 2000
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Sep 26 09:19:14 2000
Completed: alter database open
Tue Sep 26 16:27:27 2000
Thread 1 advanced to log sequence 5248
Current log# 1 seq# 5248 mem# 0: /spare/oradata/TIBS_DEV/redoTIBS_DEV01.dbf
Wed Sep 27 02:00:01 2000
Shutting down instance (immediate)
License high water mark = 18
Wed Sep 27 02:05:03 2000
Waiting for dispatcher 'D000' to shutdown
Wed Sep 27 05:00:02 2000
Starting ORACLE instance (normal)
Wed Sep 27 09:52:47 2000
ALTER DATABASE CLOSE NORMAL
Wed Sep 27 09:52:47 2000
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Sep 27 09:52:48 2000
Thread 1 closed at log sequence 5248
Wed Sep 27 09:52:48 2000
Completed: ALTER DATABASE CLOSE NORMAL
Wed Sep 27 09:52:48 2000
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
Wed Sep 27 10:09:20 2000
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.3.2.0.
System parameters with non-default values:
_trace_files_public = TRUE
processes = 90
sessions = 80
shared_pool_size = 78643200
enqueue_resources = 6000
nls_language = american
nls_territory = america
nls_sort = binary
nls_date_format = DD-MON-RR
nls_numeric_characters = .,
control_files = /spare/oradata/TIBS_DEV/ctlTIBS_DEV01.dbf, /spare/oradata/TIBS_DEV/ctlTIBS_DEV02.dbf, /spare/oradata/TIBS_DEV/ctlTIBS_DEV03.dbf
db_block_buffers = 3000
db_block_size = 8192
log_buffer = 163840
log_checkpoint_interval = 10000
db_files = 150
db_file_multiblock_read_count= 32
dml_locks = 500
row_locking = always
rollback_segments = rbsspc01, rbsspc02, rbsspc03, rbsspc04
sequence_cache_entries = 100
sequence_cache_hash_buckets= 89
global_names = FALSE
distributed_lock_timeout = 500
mts_service = TIBS_DEV
mts_dispatchers = (ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp))(DIS=1)(SES=254)(CON=254)(TIC=15)(POO=NO)(MUL=NO)(LIS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=TIBS_DEV))(ADDRESS=(PROTOCOL=tcp)(HOST=TIBS_DEV)(PORT=1521)))),
mts_servers = 3
mts_max_servers = 10
mts_max_dispatchers = 10
mts_listener_address = (ADDRESS=(PROTOCOL=ipc)(KEY=TIBS_DEV)), (ADDRESS=(PROTOCOL=tcp)(HOST=TIBS_DEV)(PORT=1521))
sort_area_size = 512000
db_name = TIBS_DEV
open_cursors = 3000
_optimizer_undo_changes = TRUE
optimizer_mode = rule
utl_file_dir = /spare2/ora8/outdir
background_dump_dest = /spare/oradata/TIBS_DEV/bdump
user_dump_dest = /spare/oradata/TIBS_DEV/udump
max_dump_file_size = 10240
core_dump_dest = /spare/oradata/TIBS_DEV/cdump
PMON started
DBWR started
LGWR started
CKPT started
Wed Sep 27 10:09:20 2000
starting up 3 shared server(s) ...
RECO started
Wed Sep 27 10:09:20 2000
starting up 1 dispatcher(s) for network protocol '(ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp))'...
Wed Sep 27 10:09:21 2000
alter database mount exclusive
Wed Sep 27 10:09:21 2000
Successful mount of redo thread 1.
Wed Sep 27 10:09:21 2000
Completed: alter database mount exclusive
Wed Sep 27 10:09:21 2000
alter database open
Wed Sep 27 10:09:22 2000
Thread 1 opened at log sequence 5248
Current log# 1 seq# 5248 mem# 0: /spare/oradata/TIBS_DEV/redoTIBS_DEV01.dbf
Successful open of redo thread 1.
Wed Sep 27 10:09:22 2000
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Sep 27 10:09:23 2000
Completed: alter database open
please help if u can what may be the proble and what is the solution
regards.,
Reddy.,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
