DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: License high water mark = 3

  1. #1
    Join Date
    Jan 2006
    Posts
    1

    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

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    check in the metalink doc 1034330.6 for more details.
    "What is past is PROLOGUE"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width