Ora-27102 Out Of Memory

SQL.RU client/server technologies Главная | Документация | Статьи | Книги | Форум | Опросы | Рассылка | Работа | Поиск | FAQ |

Добро пожаловать в форум, Guest >> Войти | Регистрация | Поиск | Правила |

В избранное | Подписаться

Все форумы / Oracle VLM - что за трабла? [new]

Vladimirgs Member

Win2003 Enterprise /pae /3gb 8гигов RAM AWE_WINDOW_MEMORY = 1073741824

Откуда: Казань Сообщений: 610

в инишнике USE_INDIRECT_DATA_BUFFERS=TRUE db_block_buffers=70360 суммарно весь инишник на 1.5 гига при старте

SQL> startup ORA-27102: out of memory OSD-00034: Message 34 not found; facility=SOSD

product=RDBMS;

O/S-Error: (OS 8) Not enough storage is available to process this command. алерт

Dump file d:\database\bdump\alert_farm.log Sat Nov 15 10:49:49 2008 ORACLE V9.2.0.8.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.2 Service Pack 1, CPU type 586 Sat Nov 15 10:49:49 2008 Starting ORACLE instance (normal) Disable cache advisory with old cache parameters Sat Nov 15 10:49:50 2008 Window memory size 576454656 Sat Nov 15 10:49:50 2008 Minimum working set window size : 4096 Что за хня... вроде все видится... чего мешает то ему.. восьмерка прекрасно работает на этом ж сервере. 15 ноя 08, 11:14

[6444752] Ответить | Цитировать

Сообщить модератору

Re: VLM - что за трабла? [new]

Проходил Guest

Привет. Дай пользователя под которым стартует Оракл привелегию Lock Page in Memmory

15 ноя 08, 12:04

[6444796] Ответить | Цитировать

Сообщить модератору

Re: VLM - что за трабла? [new]

Vladimirgs Member

Да была такая привелегия... Дело было не в бабине... Пока металинк не пошарил, не догадалсяб.

Откуда: Казань Сообщений: 610

автор

Note:225349.1 ORA-27102 out of memory OSD-00034 Message 34 not found; Product=RDBMS;facility =SOSD O/S Error: (OS 8) Not enough storage is available to process this command If you receive these errors when trying to start the database under 9.2 or 10g, this may be because the AWE_WINDOW_MEMORY value in the registry is set too low for the calculated minimum value. If you cannot increase the value for AWE_WINDOW_MEMORY, then you can explicitly set _DB_BLOCK_LRU_LATCHES to a value lower than the calculated value, and retry the startup.

Printable Version of Topic Click here to view this topic in its original format

Oracle DBA Forums _ Oracle Forum _ ORA-27102 error; Can not start oracle database Posted by: Asad Mar 22 2006, 06:07 PM My OS is windows xp oracle version 9.2.0.5 I have NOT set LOCK_SGA in init.ora file. how i can start my database. my database was previously working. I have a LOT of storage on my machine. the change we make is only that uninstall oracle completely and used the machine for some other purpose. database was already there on machine. then re-install oracle(9201) upgraded to 9205 but now i can not open open it !! please help thanks

C:\Oracle\ora92\bin>SQLPLUS /NOLOG SQL*Plus: Release 9.2.0.5.0 - Production on Wed Mar 22 15:59:00 2006 Copyright © 1982, 2002, Oracle Corporation. All rights reserved. SQL> conn / as sysdba Connected to an idle instance. SQL> startup pfile=H:\Oracle\Database\pfile\initGOLDMINE.ORA ORA-27102: out of memory OSD-00029: Message 29 not found; product=RDBMS; facility=SOSD O/S-Error: (OS 8) Not enough storage is available to process this command.

Posted by: dave Mar 22 2006, 06:25 PM looks like you environment isnt set properly, check ORACLE_HOME and your kernel parameters

Posted by: Asad Mar 22 2006, 07:18 PM first, many thanks for your reponse sir. oracle_home is set. it can reach sqlplus and can connect to idle instance. Kernal parameters! please help me to identify those... I'll be grateful

regards

Posted by: dave Mar 23 2006, 12:15 PM I dount environment is fully set up as you get errors like this OSD-00029: Message 29 not found; product=RDBMS; facility=SOSD as for kernel parameters, jusat saw your OS is XP so forget about that - do you have (derogatory word removed) values for the SGA?

Posted by: Asad Mar 23 2006, 07:47 PM Got it! reduced sga_max_size from 1.8g to 1g. restarted db and it is open now. perhapes system admin forgot to set fastdetect /3g in boot.ini file. asked to check system configuration again and re-instate old configurations. can we have sga more than 2g in windows xp ? what is os limitation? many thanks again regards, asad

Posted by: Steve Mar 24 2006, 10:24 PM The 32 bit maximum is 4GB, but windows breaks this into 2GB chunks. Looks like you know about the switch in your boot.ini that allows 3GB, and there's also a system called AWE (address windows extension) which allows the 2GB to RAM max to map out to up to 64GB RAM. Even though you can only have 2GB in USE at a time, it can "map" to more. Don mentions it on an older page here: http://www.dba-oracle.com/oracle_tips_awe.htm

Powered by Invision Power Board (http://www.invisionboard.com) © Invision Power Services (http://www.invisionpower.com)