Home » Non-English Forums » French » sga
icon9.gif  sga [message #284369] Thu, 29 November 2007 08:10 Go to next message
noumian
Messages: 7
Registered: November 2007
Junior Member

bonjour
j'ai fait

SQL>shutdown immediate;


apres cela jveux redemarrer ma base et je fais :

sqlplus "/ as sysdba"
startup


et j'obtiens:

ORA-00824: cannot set sga_target due to exixting internal settings,
see alert log for more information


que faire pour demarrer ma base?
Re: sga [message #284373 is a reply to message #284369] Thu, 29 November 2007 08:14 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

see alert log for more information
post here alert log file entry

Found on net
Cause: If you enable automatic SGA Management by setting SGA_Target >0 and
if you are using db_block_buffers(Obsolete parameter) in your init.ora.
Startup of Database fails with ORA-00824 Error

Remove "db_block_buffers" parameter in your init.ora file and startup your database.

[Updated on: Thu, 29 November 2007 08:16]

Report message to a moderator

Re: sga [message #284374 is a reply to message #284369] Thu, 29 November 2007 08:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Qu'y a-t'il dans le fichier alert.log?

Cordialement,
Michel
Re: sga [message #284375 is a reply to message #284369] Thu, 29 November 2007 08:14 Go to previous messageGo to next message
noumian
Messages: 7
Registered: November 2007
Junior Member

Thu Nov 29 12:59:13 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 2154K exceeds notification threshold (2048K)
Details in trace file c:\oracle\product\10.2.0\admin\sim\bdump\sim_s001_3888.trc
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Thu Nov 29 12:59:14 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 2201K exceeds notification threshold (2048K)
Details in trace file c:\oracle\product\10.2.0\admin\sim\bdump\sim_s001_3888.trc
KGL object name :XDB.XDZynXpO5DTv2jNMI2jLTZZA==

Thu Nov 29 15:48:01 2007
Starting background process EMN0
EMN0 started with pid=118, OS id=3536
Thu Nov 29 15:48:02 2007
Shutting down instance: further logons disabled
Thu Nov 29 15:48:02 2007
Stopping background process CJQ0
Thu Nov 29 15:48:02 2007
Stopping background process QMNC
Thu Nov 29 15:48:04 2007
Stopping background process MMNL
Thu Nov 29 15:48:05 2007
Stopping background process MMON
Thu Nov 29 15:48:06 2007
Shutting down instance (immediate)
License high water mark = 14
Thu Nov 29 15:48:06 2007
Stopping Job queue slave processes
Thu Nov 29 15:48:06 2007
Job queue slave processes stopped
The value of parameter db_block_buffers is below
the required minimum
The new value is ((4MB * the number of cpus)/db_block_size)
Cannot set sga_target with db_block_buffers set
Thu Nov 29 15:52:12 2007
Waiting for dispatcher 'D000' to shutdown
Thu Nov 29 15:54:13 2007
All dispatchers and shared servers shutdown
Thu Nov 29 15:54:14 2007
ALTER DATABASE CLOSE NORMAL
Thu Nov 29 15:54:14 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Nov 29 15:54:15 2007
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 7
Successful close of redo thread 1
Thu Nov 29 15:54:15 2007
Completed: ALTER DATABASE CLOSE NORMAL
Thu Nov 29 15:54:15 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
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
Re: sga [message #284378 is a reply to message #284375] Thu, 29 November 2007 08:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Démarre le contenu du fichier à partir du début du startup et supprime la partie shutdown inintéressante.
Il doit y avoir la même erreur ORA-00824 dans le fichier.

Cordialement,
Michel
Re: sga [message #284382 is a reply to message #284369] Thu, 29 November 2007 08:28 Go to previous messageGo to next message
noumian
Messages: 7
Registered: November 2007
Junior Member

Salut michel
dsl, c'est tout ce que j'ai dans mon alert log file.
j'installe oracle il y a 3 jours
j'etais en train de le configurer
j'ai fait un shutdown immediate
et voila j'arrvie plus a redemarrer du a cet erreur qui s'affiche,
j'ai passe tout le contenu de mn alert log file.
tout a commence quand j'ai voulu l'arreter
Re: sga [message #284385 is a reply to message #284369] Thu, 29 November 2007 08:33 Go to previous messageGo to next message
noumian
Messages: 7
Registered: November 2007
Junior Member

je crois que l'erreur vient de :
Cannot set sga_target with db_block_buffers set

alors question :
quelle valeur dois-je attriber a DB_BLOCK_BUFFER ?
et ou dois-je le faire?
Re: sga [message #284399 is a reply to message #284385] Thu, 29 November 2007 09:20 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Tu ne dois pas mettre ce paramètre.
A la rigueur tu peux mettre le paramètre db_cache_size mais je te le déconseilles, laisse faire Oracle.

Cordialement,
Michel
Previous Topic: Bonjour!
Next Topic: Par défaut rman et le dispatcher
Goto Forum:
  


Current Time: Thu Mar 28 15:01:07 CDT 2024