Version imprimable
bonjour
j'ai fais un shutdwon immediate
et maintenat,je veux relancer ma base de donnees, pour cela jveux faire un d'abord un
mais ca me reponds :Code:
2
jsuis sous windows 2003 server et ma base est oracle 10gCitation:
- ora-01034 : oraclenot available
-ora-27101 shred memory realm does not exist.
que faire?
tu as oublié :
Code:SET ORACLE_SID=tabase
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
version de base et alert_log tu crois pas que ça pourrait nous aider ? ;)
base = ORACLE 10g
Os = Windows 2003
alert log file : (c'est a partir de la que tout a mal commence)
Citation:
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
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 ;)
quelle valeur dois-je attriber a DB_BLOCK_BUFFER ?
et ou dois-je le faire?
Pourquoi tu veux l'utiliser ?
http://download.oracle.com/docs/cd/B....htm#sthref169
http://download.oracle.com/docs/cd/B....htm#sthref403
Citation:
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.