SGA et oracle not starting

[noumian]

bonjour
j'ai fais un shutdwon immediate
et maintenat,je veux relancer ma base de donnees, pour cela jveux faire un d'abord un

Code :

1
2
sqlplus /nolog
SQL>connect /

mais ca me reponds :

- ora-01034 : oraclenot available
-ora-27101 shred memory realm does not exist.

jsuis sous windows 2003 server et ma base est oracle 10g
que faire?

[orafrance]

tu as oublié :

Code :

SET ORACLE_SID=tabase

[noumian]

je ne pense pas que ca soit le oracle_sid le probleme car je n'ai qu'une base.
de toutes facon j'ai essaye en placant le oracle_sid = mabase
et j'ai obtenu :

sqlplus "/ as sysdba"
startup

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

[orafrance]

version de base et alert_log tu crois pas que ça pourrait nous aider ?

[noumian]

base = ORACLE 10g
Os = Windows 2003

alert log file : (c'est a partir de la que tout a mal commence)

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

[orafrance]

merci de penser aux balises QUOTE... et sinon, il suffit de lire

Cannot set sga_target with db_block_buffers set

la paramètre DB_BLOCK_BUFFER ça fait un moment qu'on ne le set plus normalement

[noumian]

quelle valeur dois-je attriber a DB_BLOCK_BUFFER ?
et ou dois-je le faire?

[orafrance]

Pourquoi tu veux l'utiliser ?

http://download.oracle.com/docs/cd/B....htm#sthref169

http://download.oracle.com/docs/cd/B....htm#sthref403

ORA-00825: cannot set db_block_buffers if sga_target set
Cause: sga_target set with db_block_buffers set.
Action: Do not set sga_target or use new cache parameters and do not use db_block_buffers which is a old cache parameter.