Pular para o conteúdo

Fóruns Banco de dados Oracle Erro ORA-01110 Erro ORA-01110

#101135
mpvargas
Participante

    Fala Rodrigo…
    Também no deu certo… segue abaixo as ultimas linhas do alert.log
    Não encontrei nada de anormal

    starting up 1 shared server(s) …
    Tue Oct 4 15:27:49 2011
    ALTER SYSTEM SET _offline_rollback_segments=’TRUE’ SCOPE=SPFILE;
    Tue Oct 4 15:27:59 2011
    Shutting down instance: further logons disabled
    Tue Oct 4 15:27:59 2011
    Stopping background process MMNL
    Tue Oct 4 15:27:59 2011
    Stopping background process CJQ0
    Tue Oct 4 15:28:00 2011
    Stopping background process MMON
    Tue Oct 4 15:28:01 2011
    Shutting down instance (immediate)
    License high water mark = 1
    Tue Oct 4 15:28:01 2011
    Stopping Job queue slave processes
    Tue Oct 4 15:28:01 2011
    Job queue slave processes stopped
    Waiting for dispatcher ‘D000’ to shutdown
    All dispatchers and shared servers shutdown
    Tue Oct 4 15:28:03 2011
    ALTER DATABASE CLOSE NORMAL
    ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL…
    ARCH: Archival disabled due to shutdown: 1089
    Shutting down archive processes
    Archiving is disabled
    Archive process shutdown avoided: 0 active
    ARCH: Archival disabled due to shutdown: 1089
    Shutting down archive processes
    Archiving is disabled
    Archive process shutdown avoided: 0 active
    Tue Oct 4 15:31:27 2011
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    Picked latch-free SCN scheme 1
    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
    Autotune of undo retention is turned on.
    IMODE=BR
    ILAT =18
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    ksdpec: called for event 13740 prior to event group initialization
    Starting up ORACLE RDBMS Version: 10.2.0.1.0.
    System parameters with non-default values:
    processes = 150
    __shared_pool_size = 113246208
    __large_pool_size = 4194304
    __java_pool_size = 4194304
    __streams_pool_size = 8388608
    nls_language = AMERICAN
    nls_territory = AMERICA
    sga_target = 503316480
    control_files = /u01/app/oracle/oradata/asoec10t/control01.ctl, /u01/app/oracle/oradata/asoec10t/control02.ctl, /u01/app/oracle/oradata/asoec10t/control03.ctl
    db_block_size = 8192
    __db_cache_size = 364904448
    compatible = 10.2.0.1.0
    db_file_multiblock_read_count= 16
    db_recovery_file_dest = /u01/app/oracle/flash_recovery_area
    db_recovery_file_dest_size= 2147483648
    _allow_resetlogs_corruption= TRUE
    _offline_rollback_segments= TRUE
    undo_management = AUTO
    undo_tablespace = UNDOTBS1
    remote_login_passwordfile= EXCLUSIVE
    db_domain =
    dispatchers = (PROTOCOL=TCP) (SERVICE=asoec10tXDB)
    utl_file_dir = /logs/diretorios/utl_leandro
    job_queue_processes = 10
    background_dump_dest = /u01/app/oracle/admin/asoec10t/bdump
    user_dump_dest = /u01/app/oracle/admin/asoec10t/udump
    core_dump_dest = /u01/app/oracle/admin/asoec10t/cdump
    audit_file_dest = /u01/app/oracle/admin/asoec10t/adump
    db_name = asoec10t
    open_cursors = 300
    pga_aggregate_target = 250000000
    PMON started with pid=2, OS id=27687
    PSP0 started with pid=3, OS id=27689
    MMAN started with pid=4, OS id=27691
    DBW0 started with pid=5, OS id=27693
    LGWR started with pid=6, OS id=27695
    CKPT started with pid=7, OS id=27698
    SMON started with pid=8, OS id=27700
    RECO started with pid=9, OS id=27702
    CJQ0 started with pid=10, OS id=27707
    MMON started with pid=11, OS id=27709
    Tue Oct 4 15:31:28 2011
    starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
    MMNL started with pid=12, OS id=27711
    Tue Oct 4 15:31:28 2011
    starting up 1 shared server(s) …
    Tue Oct 4 15:31:28 2011
    ALTER DATABASE MOUNT
    Tue Oct 4 15:31:32 2011
    Setting recovery target incarnation to 1
    Tue Oct 4 15:31:32 2011
    Successful mount of redo thread 1, with mount id 2261589072
    Tue Oct 4 15:31:32 2011
    Database mounted in Exclusive Mode
    Completed: ALTER DATABASE MOUNT
    Tue Oct 4 15:31:32 2011
    ALTER DATABASE OPEN
    ORA-1113 signalled during: ALTER DATABASE OPEN…