Consegui resolver, valeu pela ajuda, mudei o Pfile.ora e deu certo...vlw
Ederson <[EMAIL PROTECTED]> escreveu:David,
Abaixo, um recorte de vários textos que falam sobre o assunto. Espero que
ajude. Senão dê retorno, ok?
Erro 27100
Veja Note:1060677.6
Error: ORA-27100
Text: shared memory realm already exists
--------------------------------------------------------------------------
Cause: Tried to start duplicate instances, or tried to restart an instance
that had not been properly shutdown
Action: Use a different instance name, or cleanup the failed instance's SGA
--------------------------------------------------------------------------
============================================
UNIX:
OK, this isn't a bug but a resource limitation; the information in sysdef
and
IPCS outputs is enough to determine this. What V8 does is attempt to
determine
the number of semaphore operations per semop call (SEMOPM). It does this
after
it has already allocated the necessary semaphore set(s) to provide either
ORANSEMS semaphores or processes (from init.ora) semaphores if ORANSEMS is
unset.
In order to determine SEMOPM, it allocates another temporary semaphore set
(the size of which is either ORANSEMS/processes or the maximum per set if
this is smaller).
In this case, the V8 startup will then be attempting to allocate another 50
semaphores above the 50 we already have. If you've got the other V7
instances
up at 50 each and then the 3 root is using you need a value of SEMMSL >= 203
when it is in fact defined at 200. Solution; edit /etc/system and change
semmsl
to 400 for good measure and reboot.
SVRMGR> startup
ORA-27100: shared memory realm already exists
Digital Unix Error: 17: File exists
I've found that oracle process still running.
# ps -ef |grep pmon
oracle 28894 1 0.0 11:25:11 ?? 0:00.07 ora_pmon_RTXRST
I've found that oracle cannot free up the memory when we shutdown abort.
$ ipcs -ma | grep oracle
Shared Memory:
T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME
CTIME
m 30721 0xf6a32498 --rw-r----- oracle dba oracle dba 28 167772160 1760 11229
17:33:33 17:33:33 12:54:09
m 47106 0x908fb354 --rw-r----- oracle dba oracle dba 22 117440512 28893
10436 17:20:31 17:20:32 11:25:11
Finally, I needed to use command "# ipcrm -m " to clean up the SGA and then
restarted the database:
Ex:
ipcrm -m 30721
ipcrm -m 47106
.
Is any OS parameter value related to shared memory I need to increase to
avoid the problem.
============================================
============================================
============================================
============================================
============================================
NT
Se o seu banco estiver em NT, CUIDADO. Os passos abaixo renomeiam a
INSTÂNCIA. Talvez o erro seja reparado apenas mudando os parâmetros de
cache,sga e shared_pool. Tente startar o banco usando o pfile modificado.
Se não der certo siga para o passo 2 (só faça se vc tiver certeza do que
está fazendo, É ARRISCADO PERDER O BANCO, OK ?????
1º passo:
Criar o pfile:
create pfile='d:\pfile.ora' from spfile
editar o pfile mudando os valores :
db_cache_size = 32M
sga_max_size = 170M
shared_pool_size = 64M
startup pfile='d:\pfile.ora'
2º passo
Parar o Listener
Editar o listener.ora para mudar o SID
oradim -delete -sid orcl
oradim -new -sid orc2 -startmode a -pfile d:\pfile.ora
criar o arquivo de senhas
orapwd file=D:\oracle\ora92\database\pwdorc2.ora password=oracle entries=10
Sol 1:
--------------------------------------------------------
If this is a reocurring problem you may just want to drop and recreate the
OracleServiceSID
to see if that resolves the issue. Another suggestion may be to increase the
virtual memory
on the machine to be between 1 1/2 times to 2 times the amount physical
memory
--------------------------------------------------------
Note:1060677.6
Subject: ORA-27100 ORA-27102 Trying to Start 8.0.4 Database
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 29-OCT-1998
Last Revision Date: 18-DEC-2002
Problem Description:
====================
You are trying to start an Oracle instance when ORA-27100 is reported.
ORA-27100: shared memory realm already exists
Cause: Tried to start duplicate instances, or tried to restart an
instance that had not been properly shutdown
Action: Use a different instance name, or cleanup the failed instance's SGA
The instance does not come up successfully and instance recovery is
required.
However, instance recovery cannot complete because the instance is requiring
too much memory and will not start.
Bringing the database up in stages reveals ORA-27102 during a startup
nomount.
Solution Description:
=====================
The size of the SGA must be reduced so the instance can startup or the new
software must be removed. To determine if the problem is memory related:
1. Start svrmgr30.
SVRMGR> Connect as internal/[EMAIL PROTECTED]
SVRMGR> shutdown immediate
SVRMGR> startup nomount pfile=C:\ORANT\DATABASE\initSID.ora
ORA-27102 will be reported if the problem is memory related.
The instance cannot start.
Proceed to step 2.
2. SVRMGR> shutdown immediate
Reduce one or more of the following initSID.ora parameter values using a
text
editor: shared_pool_size (affects the library and data dictionary
cache)
db_block_buffers (affects the database buffer cache)
log_buffer (affects the redo log buffer area)
3. Return to svrmgr and try to start the instance again.
SVRMGR> startup nomount pfile=C:\ORANT\DATABASE\initSID.ora
If the instance startup still fails with ORA-27102 repeat steps 1-3
until the instance starts. Once it starts proceed to step 4.
4. At the Server Manager prompt:
SVRMGR> alter database mount
SVRMGR> alter database open
If you are on a unix machine, you can clean up from last shutdown.
1) Delete $ORACLE_HOME/dbs/sgadef<sid>.dbf files (only applicable for
versions prior to 8.1.x).
2) Delete $ORACLE_HOME/dbs/lk<sid> files
3) If more than one instance on this box, need to identify only the
semaphores and shared memory associtated with that instance.
a) SVRMGR>connect internal
b) SVRMGR>oradebug ipc
(This will list all shared memory and semaphores
for this instance)
4) Remove shared memory and semaphores for this instance.
a) ipcs (Lists all Interprocesses)
b) ipcrm -m <id> (Removes Shared Memory Processes)
c) ipcrm -s <id> (Removes Semaphores)
After these steps the database should be able to startup without
any errors and without reducing the size of the SGA.
Explanation:
============
ORA-27100 is received as a result of changes made to initSID.ora parameters
affecting the SGA size, or a new software was recently installed on the
database server which requires additional memory.
Reducing the size of the SGA allows the instance to start and recover. The
database can then be mounted and opened successfully.
References:
===========
Oracle8 Administrators Guide
Oracle8 Reference
Oracle8 Concepts
============================================
BOA SORTE
Ederson Elias de Oliveira
DBA Oracle
Setransp - GO
-------------------------------------------------------------------
________________________________________
De: [email protected] [mailto:[EMAIL PROTECTED] Em
nome de davidsmota
Enviada em: quarta-feira, 3 de agosto de 2005 22:09
Para: [email protected]
Assunto: [oracle_br] ORA-27100 shared memory realm already exists
Meu servidor de uma hora pra outra resolveu parar de funcionar e agora
esta dando este erro... o q devo fazer??? Alguem pode me ajudar
______________________________________________________________________
Histórico: http://www.mail-archive.com/[email protected]/
Falar com os Moderadores:([EMAIL PROTECTED])
Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar
______________________________________________________________________
---------------------------------
Links do Yahoo! Grupos
Para visitar o site do seu grupo na web, acesse:
http://br.groups.yahoo.com/group/oracle_br/
Para sair deste grupo, envie um e-mail para:
[EMAIL PROTECTED]
O uso que você faz do Yahoo! Grupos está sujeito aos Termos do Serviço do
Yahoo!.
---------------------------------
Yahoo! Acesso Grátis: Internet rápida e grátis. Instale o discador agora!
[As partes desta mensagem que não continham texto foram removidas]
______________________________________________________________________
Histórico: http://www.mail-archive.com/[email protected]/
Falar com os Moderadores:([EMAIL PROTECTED])
Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar
______________________________________________________________________
Links do Yahoo! Grupos
<*> Para visitar o site do seu grupo na web, acesse:
http://br.groups.yahoo.com/group/oracle_br/
<*> Para sair deste grupo, envie um e-mail para:
[EMAIL PROTECTED]
<*> O uso que você faz do Yahoo! Grupos está sujeito aos:
http://br.yahoo.com/info/utos.html
