Juarez, concordo com o Marcos, acho que a saída é mais ou menos por ai mesmo. O parâmetro "db_block_buffers" é incompatível com o "sga_target". O db_block_buffers em conjunto com o db_block_size definem o tamanho do database buffer cache, então surgio que você defina um db_cache_size como 0 (zero), remova o parâmetro "db_block_buffers" e defina uma sga_target adequeada ao trabalho realizado no banco. A sga_target é dinâmica, entao sugiro que coloque um valor razoavelmente pequeno e conforme necessário vá aumentando. Diminuir ela com o banco aberto é meio arriscado, porém aumentar ela á tranquilo.
-- Fernando Martins "God grant us the serenity to accept the things we cannot change, courage to change the things we can, and wisdom to know the difference." 2009/4/29 Marcos Braga <braga.mar...@gmail.com> > > > Oi Juarez, > > Analisando o alert, parece que você não pode configurar o sga_target se > estiver usando o db_block_buffer. > > Verifiquei no metalink ref. ao erro que está ocorrendo e achei o seguinte > documento: *3463540.8* > > Esse documento informa sobre um bug, que na teoria, não deveria existir na > sua versão... (mistérios oracle). > > Uma solução que é informada no próprio documento é a substituição do > parâmetro db_block_buffer para db_cache_size. > > "Use db_cache_size to set the buffer cache size instead of > DB_BLOCK_BUFFERS" > > Não sei se essa é a solução, mas pode começar por aí. > > Se não tiver acesso ao metalink, me avise que encaminho o docid em pvt. > > []s > Braga > > 2009/4/29 Juarez <jub...@gmail.com <jubawv%40gmail.com>> > > > > > > > > Quando vou dar start no banco está dando erro: > > SQL> startup nomount > > ORA-00824: cannot set sga_target due to existing internal settings, see > > alert log for more information > > > > Segue o Log... Alguém poderia dar um help? grato. > > > > Dump file c:\oracle\product\10.2.0\db_1\rdbms\trace\alert_corpore.log > > Thu Apr 23 19:02:17 2009 > > ORACLE V10.2.0.1.0 - Production vsnsta=0 > > vsnsql=14 vsnxtr=3 > > Windows NT Version V5.2 Service Pack 2 > > CPU : 8 - type 586, 2 Physical Cores > > Process Affinity : 0x00000000 > > Memory (Avail/Total): Ph:3744M/4095M, Ph+PgF:5794M/5976M, VA:1939M/2047M > > Thu Apr 23 19:02:17 2009 > > Cannot set sga_target with db_block_buffers set > > Thu Apr 23 19:04:17 2009 > > Cannot set sga_target with db_block_buffers set > > Thu Apr 23 19:04:54 2009 > > Cannot set sga_target with db_block_buffers set > > Thu Apr 23 19:07:06 2009 > > Cannot set sga_target with db_block_buffers set > > Thu Apr 23 19:09:49 2009 > > Cannot set sga_target with db_block_buffers set > > Dump file c:\oracle\product\10.2.0\db_1\rdbms\trace\alert_corpore.log > > Fri Apr 24 09:53:42 2009 > > ORACLE V10.2.0.1.0 - Production vsnsta=0 > > vsnsql=14 vsnxtr=3 > > Windows NT Version V5.2 Service Pack 2 > > CPU : 8 - type 586, 2 Physical Cores > > Process Affinity : 0x00000000 > > Memory (Avail/Total): Ph:3819M/4095M, Ph+PgF:5857M/5976M, VA:1939M/2047M > > Fri Apr 24 09:53:42 2009 > > Cannot set sga_target with db_block_buffers set > > Fri Apr 24 09:58:21 2009 > > Cannot set sga_target with db_block_buffers set > > Fri Apr 24 10:00:27 2009 > > Cannot set sga_target with db_block_buffers set > > Fri Apr 24 10:18:21 2009 > > Cannot set sga_target with db_block_buffers set > > Fri Apr 24 10:23:54 2009 > > Cannot set sga_target with db_block_buffers set > > Fri Apr 24 10:32:36 2009 > > Starting ORACLE instance (normal) > > Fri Apr 24 10:32:52 2009 > > Cannot set sga_target with db_block_buffers set > > Fri Apr 24 10:38:06 2009 > > Cannot set sga_target with db_block_buffers set > > Fri Apr 24 10:38:08 2009 > > Cannot set sga_target with db_block_buffers set > > Fri Apr 24 10:43:53 2009 > > Starting ORACLE instance (normal) > > LICENSE_MAX_SESSION = 0 > > LICENSE_SESSIONS_WARNING = 0 > > Picked latch-free SCN scheme 2 > > 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 > > Dump file c:\oracle\product\10.2.0\db_1\rdbms\trace\alert_corpore.log > > Fri Apr 24 11:40:56 2009 > > ORACLE V10.2.0.1.0 - Production vsnsta=0 > > vsnsql=14 vsnxtr=3 > > Windows NT Version V5.2 Service Pack 2 > > CPU : 8 - type 586, 2 Physical Cores > > Process Affinity : 0x00000000 > > Memory (Avail/Total): Ph:3675M/4095M, Ph+PgF:5716M/5976M, VA:1939M/2047M > > Fri Apr 24 11:40:56 2009 > > Cannot set sga_target with db_block_buffers set > > Dump file c:\oracle\product\10.2.0\db_1\rdbms\trace\alert_corpore.log > > Fri Apr 24 10:45:01 2009 > > ORACLE V10.2.0.1.0 - Production vsnsta=0 > > vsnsql=14 vsnxtr=3 > > Windows NT Version V5.2 Service Pack 2 > > CPU : 8 - type 586, 2 Physical Cores > > Process Affinity : 0x00000000 > > Memory (Avail/Total): Ph:3737M/4095M, Ph+PgF:5792M/5976M, VA:1939M/2047M > > Fri Apr 24 10:45:01 2009 > > Cannot set sga_target with db_block_buffers set > > Fri Apr 24 10:46:49 2009 > > Cannot set sga_target with db_block_buffers set > > Fri Apr 24 10:52:08 2009 > > Starting ORACLE instance (normal) > > Fri Apr 24 11:00:23 2009 > > Starting ORACLE instance (normal) > > LICENSE_MAX_SESSION = 0 > > LICENSE_SESSIONS_WARNING = 0 > > Picked latch-free SCN scheme 2 > > 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 > > Dump file c:\oracle\product\10.2.0\db_1\rdbms\trace\alert_corpore.log > > Wed Apr 29 08:33:16 2009 > > ORACLE V10.2.0.1.0 - Production vsnsta=0 > > vsnsql=14 vsnxtr=3 > > Windows NT Version V5.2 Service Pack 2 > > CPU : 8 - type 586, 2 Physical Cores > > Process Affinity : 0x00000000 > > Memory (Avail/Total): Ph:3735M/4095M, Ph+PgF:5790M/5976M, VA:1939M/2047M > > Wed Apr 29 08:33:16 2009 > > Cannot set sga_target with db_block_buffers set > > Wed Apr 29 08:38:44 2009 > > Cannot set sga_target with db_block_buffers set > > Wed Apr 29 08:41:52 2009 > > Cannot set sga_target with db_block_buffers set > > Wed Apr 29 08:43:57 2009 > > Starting ORACLE instance (normal) > > LICENSE_MAX_SESSION = 0 > > LICENSE_SESSIONS_WARNING = 0 > > Picked latch-free SCN scheme 2 > > 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 > > Dump file c:\oracle\product\10.2.0\db_1\rdbms\trace\alert_corpore.log > > Wed Apr 29 09:28:36 2009 > > ORACLE V10.2.0.1.0 - Production vsnsta=0 > > vsnsql=14 vsnxtr=3 > > Windows NT Version V5.2 Service Pack 2 > > CPU : 8 - type 586, 2 Physical Cores > > Process Affinity : 0x00000000 > > Memory (Avail/Total): Ph:3736M/4095M, Ph+PgF:5791M/5976M, VA:1939M/2047M > > Wed Apr 29 09:28:36 2009 > > Cannot set sga_target with db_block_buffers set > > Wed Apr 29 09:32:11 2009 > > Cannot set sga_target with db_block_buffers set > > > > [As partes desta mensagem que não continham texto foram removidas] > > > [As partes desta mensagem que não continham texto foram removidas]
