License high water mark = 3
Geeting above error during restart of database...sqlplus gets just hangs after issuing startup force command...
Attached are alert_logs..from startup time..
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 0
control_files = /orahome/oracle/oradata/testdb/control01.ctl, /orahome/oracle/oradata/testdb/control02.ctl, /orahome/oracle/oradata/testdb/control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
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 = world
instance_name = testdb
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /orahome/oracle/admin/testdb/bdump
user_dump_dest = /orahome/oracle/admin/testdb/udump
core_dump_dest = /orahome/oracle/admin/testdb/cdump
sort_area_size = 524288
db_name = testdb
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
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Jan 27 11:38:38 2006
ALTER DATABASE MOUNT
Fri Jan 27 11:38:42 2006
Successful mount of redo thread 1, with mount id 2364153406
Fri Jan 27 11:38:42 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Fri Jan 27 11:38:42 2006
ALTER DATABASE OPEN
Fri Jan 27 11:38:42 2006
Thread 1 opened at log sequence 23
Current log# 2 seq# 23 mem# 0: /orahome/oracle/oradata/testdb/redo02.log
Successful open of redo thread 1
Fri Jan 27 11:38:42 2006
SMON: enabling cache recovery
Fri Jan 27 11:38:42 2006
Successfully onlined Undo Tablespace 1.
Fri Jan 27 11:38:42 2006
SMON: enabling tx recovery
Fri Jan 27 11:38:42 2006
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Tue Jan 31 16:09:37 2006
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.6.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 0
control_files = /orahome/oracle/oradata/testdb/control01.ctl, /orahome/oracle/oradata/testdb/control02.ctl, /orahome/oracle/oradata/testdb/control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
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 = world
instance_name = testdb
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /orahome/oracle/admin/testdb/bdump
user_dump_dest = /orahome/oracle/admin/testdb/udump
core_dump_dest = /orahome/oracle/admin/testdb/cdump
sort_area_size = 524288
db_name = testdb
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
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Jan 31 16:09:37 2006
ALTER DATABASE MOUNT
Tue Jan 31 16:09:42 2006
Successful mount of redo thread 1, with mount id 2364546241
Tue Jan 31 16:09:42 2006
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Tue Jan 31 16:09:42 2006
ALTER DATABASE OPEN
Tue Jan 31 16:09:42 2006
Beginning crash recovery of 1 threads
Tue Jan 31 16:09:42 2006
Started redo scan
Tue Jan 31 16:09:42 2006
Completed redo scan
405 redo blocks read, 24 data blocks need recovery
Tue Jan 31 16:09:42 2006
Started recovery at
Thread 1: logseq 23, block 84262, scn 0.0
Tue Jan 31 16:09:42 2006
Recovery of Online Redo Log: Thread 1 Group 2 Seq 23 Reading mem 0
Mem# 0 errs 0: /orahome/oracle/oradata/testdb/redo02.log
Tue Jan 31 16:09:42 2006
Completed redo application
Tue Jan 31 16:09:42 2006
Ended recovery at
Thread 1: logseq 23, block 84667, scn 0.8166159
24 data blocks read, 24 data blocks written, 405 redo blocks read
Crash recovery completed successfully
Tue Jan 31 16:09:42 2006
Thread 1 advanced to log sequence 24
Thread 1 opened at log sequence 24
Current log# 3 seq# 24 mem# 0: /orahome/oracle/oradata/testdb/redo03.log
Successful open of redo thread 1
Tue Jan 31 16:09:42 2006
SMON: enabling cache recovery
Tue Jan 31 16:09:43 2006
Successfully onlined Undo Tablespace 1.
Tue Jan 31 16:09:43 2006
SMON: enabling tx recovery
Tue Jan 31 16:09:43 2006
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Starting ORACLE instance (force)
License high water mark = 3
Instance terminated by USER, pid = 8354
