| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: ORA-27101 RH linux 9 Oracle 9.2.0.3
Hi,
Ilooked at metalink for bugs on ORA-27101 and did not find anything. Possibly because I'm on 9i and looked for that as well.
These are my Oracle settings.
The only thing odd may be that the lkORA92 file is all capitals whereas everything else is initCap for the sid.
Only 1 Oracle is installed on this box.
oracle 3581 1 0 Jul31 ? 00:00:00 ora_pmon_Ora92 oracle 3583 1 0 Jul31 ? 00:00:00 ora_dbw0_Ora92 oracle 3585 1 0 Jul31 ? 00:00:00 ora_lgwr_Ora92 oracle 3587 1 0 Jul31 ? 00:00:00 ora_ckpt_Ora92 oracle 3589 1 0 Jul31 ? 00:00:03 ora_smon_Ora92 oracle 3591 1 0 Jul31 ? 00:00:00 ora_reco_Ora92 oracle 3600 1 0 Jul31 ? 00:00:36 oracleOra92 (LOCAL=NO) norad 4644 2610 0 Jul31 ? 00:00:00 dbgsvr -toracle 5583 5538 0 09:28 pts/2 00:00:00 ps -ef oracle 5584 5538 0 09:28 pts/2 00:00:00 grep oracle [oracle_at_Linux dbs]$ env |grep ORA
-i/norad/dbcontrol/oracle -O/oracle/app/product/9.2.0
oracle 4668 1 0 Jul31 ? 00:00:16 oracleOra92 (LOCAL=NO) norad 4719 2610 0 Jul31 ? 00:00:00 dbgsvr -t
-i/norad/dbcontrol/oracle -O/oracle/app/product/9.2.0
oracle 4743 1 0 Jul31 ? 00:00:00 oracleOra92 (LOCAL=NO) root 5537 5497 0 09:25 pts/2 00:00:00 su - oracle oracle 5538 5537 0 09:25 pts/2 00:00:00 -bash
ORACLE_OWNER=oracle ORACLE_SID=Ora92 ORACLE_BASE=/oracle/oradata ORACLE_HOME=/oracle/app/product/9.2.0[oracle_at_Linux dbs]$ ll
THX
-----Original Message-----
Sent: Thursday, July 31, 2003 10:03 PM
To: JACK_at_quantsystems.nl
METALINK is your friend!
Why did I find this & you did not?
(Embedded image moved
(Embedded image
to file: pic19246.gif)
moved to file:
pic12836.gif)
Bookmark
Fixed font
Go to End
Doc ID:
Note:122183.1
Subject:
ORA-27101 "Shared Memory
Realm Does Not
Exist"
Connecting Via
Net8
Type:
PROBLEM Status:
PUBLISHED Content
Type:
TEXT/PLAIN Creation
Date:
17-OCT-2000 Last
Revision
Date:
20-MAR-2003 Problem Description
You are attempting to
connect to an Oracle8i
database from a client
using
sqlplus and receive the
following errors:
ERROR: ORA-01034: ORACLE not
available
ORA-27101: shared
memory realm does not
exist
SVR4 Error: 2: No
such file or directory
You have installed
8.1.7 on the same
server in a seperate
ORACLE_HOME. Solution Description
connections:
Verify that the
ORACLE_SID environment
variable is set and
points to a valid
8.1.7 database that
is up and running.
% echo $ORACLE_SID
junk
% ps -ef |grep smon
oracle 24603 1
0 15:22:51 ?
0:02 ora_smon_JUNK
In this scenario,
because the ORACLE_SID
value is case-sensitive
on Unix
platforms, a
database called 'junk'
is not running as it
does not exist - it
should be 'JUNK'
i.e. upper case.
To fix the issue,
set the ORACLE_SID
value correctly or to a
valid instance.
% setenv ORACLE_SID
JUNK (for csh)
%
ORACLE_SID=JUNK;export
ORACLE_SID (for ksh,
sh)
2) For remote
(TCP/listener)
connections:
Review the
listener.ora currently
used to startup the
listener and verify
the ORACLE_HOME
value is correct for
all listed Oracle8i
databases.
If the ORACLE_HOME
points to the 8.1.7
software, however the
database was
created using a
different version (e.g.
8.1.6 or 8.1.5), then
this error can
occur.
Explanation
Previously, when the
ORACLE_HOME or
ORACLE_SID were set
incorrectly, in the
'oracle' or client
user's environment,
only ora-1034 was
reported e.g.:
ORA-01034 "ORACLE not
available"
With 8.1.7, error
ORA-27101 reports that
the shared memory key
generated by the
client does not match
any currently existing
keys. This is to be
expected if
the ORACLE_HOME used by
the client is not the
same as that used to
startup the
database or when the
ORACLE_SID value is not
correctly referencing
the right
instance.
Additional Search Words
listener, tnslsnr,
parameter, hashing
algorithm, attach, SGA
.
(Embedded image moved Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices (Embedded image to file: pic32095.gif) and Terms of Use. moved to file:
pic06932.gif)
Jack van Zanen
<JACK_at_quantsystem To: Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>
s.nl> cc:
Sent by: Subject: RE: ORA-27101 RH
linux 9 Oracle 9.2.0.3
ml-errors_at_fatcity
.com
07/31/2003 08:54
AM
Please respond to
ORACLE-L
I set the value to 2147483648 and it still does the same thing.
Oracle database is open but when trying to connect through sqlnet I get ORA-27101. I do shutdown immediate and startup and the problem is gone for a while.
I now stopped the archiver again and see if that gives me problems.
BTW: Is it normal 9i behaviour to write logswitches to trace????
TIA Jack
-----Original Message-----
From: Jack van Zanen [mailto:JACK_at_quantsystems.nl]
Sent: Wednesday, July 30, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3
Damn your right,
I need new glasses :-)
Thx
-----Original Message-----
From: SSILVA9_at_BKB.com.br [mailto:SSILVA9_at_BKB.com.br]
Sent: Wednesday, July 30, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3
The parameter shmmax (Shared Memory) is lower than the
sugested. Please check:
Yours: 536870912
Sugested: 2147483648
Sandro Augusto da Silva
Technology Services & Support
NLA Technology Services
Phone: +55 11 3398-8438
Fax: +55 11 3398-7522
-----Mensagem original-----
De: Jack van Zanen [mailto:JACK_at_QUANTSYSTEMS.NL]
Enviada em: quarta-feira, 30 de julho de 2003 09:59
Para: Multiple recipients of list ORACLE-L
Assunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3
Hi,
Have tried to reconnect and get the error message 27101
(when using @sid logon)
**********************************************************
[root_at_Linux admin]# cd /proc/sys/kernel
[root_at_Linux kernel]# cat sem
250 32000 100 128
[root_at_Linux kernel]# cat shmmax
536870912
[root_at_Linux kernel]# cat shmmni
4096
[root_at_Linux kernel]# cat shmall
2097152
[root_at_Linux kernel]# ulimit -u
4095
[root_at_Linux kernel]# cat
/proc/sys/net/ipv4/ip_local_port_range
1024 65000
[root_at_Linux kernel]# cat /proc/sys/fs/file-max
65536
[root_at_Linux kernel]#
************************************************************
Only difference is that I set my semaphores higher than
recommended (cat sem, cat shmmax)
Thx
-----Original Message-----
From: SSILVA9_at_BKB.com.br
[mailto:SSILVA9_at_BKB.com.br]
Sent: Wednesday, July 30, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RES: ORA-27101 RH linux 9 Oracle 9.2.0.3
Have you tried to reconnect to the instance? Does
the instance shuts down or your connection?
Try changing the following parameters:
Oracle9i
Installation Guide
Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based
Systems, Compaq Tru64 UNIX, HP
9000 Series HP-UX, Linux Intel, and Sun Solaris
2-20 Installation Guide
Perform the following steps to modify the kernel
parameters by using the /proc
file system.
1. Log in as the root user.
2. Change to the /proc/sys/kernel directory.
3. Review the current semaphore parameter values in
the sem file by using the
cat or more utility. For example, using the cat
utility, enter the following
command:
# cat sem
The output lists, in order, the values for the
SEMMSL, SEMMNS, SEMOPM,
and SEMMNI parameters. The following example shows
how the output
appears:
250 32000 32 128
In the preceding output example, 250 is the value
of the SEMMSL parameter,
32000 is the value of the SEMMNS parameter, 32 is
the value of the SEMOPM
parameter, and 128 is the value of the SEMMNI
parameter.
4. Modify the parameter values by using the
following command syntax:
# echo SEMMSL_value SEMMNS_value SEMOPM_value
SEMMNI_value > sem
Replace the parameter variables with the values for
your system in the order
that they are entered in the preceding example. For
example:
# echo 100 32000 100 100 > sem
5. Review the current shared memory parameters by
using the cat or more
utility. For example, using the cat utility, enter
the following command:
# cat shared_memory_parameter
In the preceding example, the variable
shared_memory_parameter is either the
SHMMAX or SHMMNI parameter. The parameter name must
be entered in
lowercase letters.
6. Modify the shared memory parameter by using the
echo utility. For example,
to modify the SHMMAX parameter, enter the following
command:
# echo 2147483648 > shmmax
7. Modify the shared memory parameter by using the
echo utility. For example,
to modify the SHMMNI parameter, enter the following
command:
Setup Tasks to Perform as root User
# echo 4096 > shmmni
8. Modify the shared memory parameter by using the
echo utility. For example,
to modify the SHMALL parameter, enter the following
command:
# echo 2097152 > shmall
9. Write a script to initialize these values during
system startup, and include the
script in your system init files.
10. Set the File Handles by using ulimit -n and
/proc/sys/fs/file-max.
# echo 65536 > /proc/sys/fs/file-max
ulimit -n 65536
11. Set the Sockets to
/proc/sys/net/ipv4/ip_local_port_range
# echo 1024 65000 >
/proc/sys/net/ipv4/ip_local_port_change
12. Set the Process limit by using ulimit -u. This
will give you the number of
processes per user.
ulimit -u 16384
The parameters in the following table are the
minimum values required to run
Oracle9i with a single-database instance on Linux.
See Also: Your system vendor's documentation for
more
information on script files and init files.
Sandro Augusto da Silva
Technology Services & Support
NLA Technology Services
Phone: +55 11 3398-8438
Fax: +55 11 3398-7522
-----Mensagem original-----
De: Jack van Zanen
[mailto:JACK_at_QUANTSYSTEMS.NL]
Enviada em: quarta-feira, 30 de julho de 2003
06:39
Para: Multiple recipients of list ORACLE-L
Assunto: RE: ORA-27101 RH linux 9 Oracle
9.2.0.3
512Mb RAM
2Gb Swap space
****************************************************************
10:44:37 up 2 days, 21:15, 4 users, load
average: 0.00, 0.05, 0.03
119 processes: 115 sleeping, 4 running, 0
zombie, 0 stopped
CPU states: 0.3% user 0.0% system 0.0%
nice 0.0% iowait 99.6% idle
Mem: 513788k av, 506088k used, 7700k
free, 0k shrd, 117192k buff
386908k actv, 39520k
in_d, 9728k in_c
Swap: 2097136k av, 22708k used, 2074428k
free 257980k cached
PID USER PRI NI SIZE RSS SHARE STAT
%CPU %MEM TIME CPU COMMAND
15439 root 15 0 1164 1164 864 R
0.3 0.2 0:00 0 top
1 root 15 0 104 88 52 S
0.0 0.0 0:06 0 init
2 root 15 0 0 0 0 SW
0.0 0.0 0:00 0 keventd
3 root 15 0 0 0 0 SW
0.0 0.0 0:00 0 kapmd
4 root 34 19 0 0 0 SWN
0.0 0.0 0:00 0 ksoftirqd_CPU
9 root 15 0 0 0 0 SW
0.0 0.0 0:00 0 bdflush
5 root 15 0 0 0 0 SW
0.0 0.0 0:00 0 kswapd
6 root 15 0 0 0 0 SW
0.0 0.0 0:00 0 kscand/DMA
7 root 15 0 0 0 0 SW
0.0 0.0 5:18 0 kscand/Normal
8 root 15 0 0 0 0 SW
0.0 0.0 0:00 0 kscand/HighMe
10 root 15 0 0 0 0 SW
0.0 0.0 0:00 0 kupdated
11 root 25 0 0 0 0 SW
0.0 0.0 0:00 0 mdrecoveryd
15 root 15 0 0 0 0 SW
0.0 0.0 0:00 0 kjournald
**************************************************************
Strange indeed.
Jack
----Original Message-----
From: Suhen Pather
[mailto:suhen.pather_at_marcglobal.com.au]
Sent: Wednesday, July 30, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-27101 RH linux 9 Oracle
9.2.0.3
Jack,
ORA-27101: shared memory realm does not
exist
Oracle probably been aborted for some
reason.
Strange how you can do a select * from
v$database.
How much memory and swap space you have
configured.
Regards
Suhen
-----Original Message-----
From: Jack van Zanen
[mailto:JACK_at_QUANTSYSTEMS.NL]
Sent: Wednesday, 30 July 2003
6:44 PM
To: Multiple recipients of list
ORACLE-L
Subject: ORA-27101 RH linux 9
Oracle 9.2.0.3
Hi,
I have above setup on my homebox.
Every now and then I get Oracle
error 27101, and have to restart
the database. I can connect / as
sysdba and select * from
v$database though.
Has anybody seen this happen
before and may be able to help me
with this.??
The only thing that I can see is
a trace file (I don't know if
this is from the same time as
when the database stopped serving
requests) from the archiver.
There is nothing in the alert log
whatsoever.
Is it normal behaviour that
logswitches are recorded to trace
files??
I have stopped the archiver
process to see if that makes the
problem go away.
*************************************************************
[oracle_at_Linux bdump]$ ls
alert_Ora92.log
ora92_arc0_2583.trc
ora92_arc0_2674.trc
ora92_arc0_10031.trc
ora92_arc0_2597.trc
ora92_arc0_2710.trc
ora92_arc0_10498.trc
ora92_arc0_2629.trc
ora92_arc0_2842.trc
ora92_arc0_10533.trc
ora92_arc0_2634.trc
ora92_arc0_5115.trc
ora92_arc0_10557.trc
ora92_arc0_2651.trc
ora92_arc0_8432.trc
ora92_arc0_14874.trc
ora92_arc0_2657.trc
ora92_arc0_8607.trc
[oracle_at_Linux bdump]$ cat *14874*
/oracle/oradata/admin/Ora92/bdump/ora92_arc0_14874.trc
Oracle9i Enterprise Edition
Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and
Oracle Data Mining options
JServer Release 9.2.0.3.0 -
Production
ORACLE_HOME =
/oracle/app/product/9.2.0
System name: Linux
Node name: Linux
Release: 2.4.20-18.9
Version: #1 Thu May 29
07:08:16 EDT 2003
Machine: i686
Instance name: Ora92
Redo thread mounted by this
instance: 1
Oracle process number: 8
Unix process pid: 14874, image:
oracle_at_Linux (ARC0)
*** SESSION ID:(7.1) 2003-07-30
09:24:33.995
- Created archivelog as
'/data/oradata/Ora92/archive/1_57.dbf'
[oracle_at_Linux bdump]$ df -k
Filesystem 1K-blocks
Used Available Use% Mounted on
/dev/hdc2 10078852
7872268 1694596 83% /
/dev/hdc1 99043
14310 79619 16% /boot
none 256892
0 256892 0% /dev/shm
/dev/hdc4 66542832
6880604 56282028 11% /data
[oracle_at_Linux bdump]$ ls -l
/data//oradata/Ora92/archive/
total 8124
-rw-r----- 1 oracle dba
452096 Jul 27 13:33 1_55.dbf
-rw-r----- 1 oracle dba
1085952 Jul 28 08:56 1_56.dbf
-rw-r----- 1 oracle dba
6752256 Jul 30 09:24 1_57.dbf
[oracle_at_Linux bdump]$
PARAMETER SETTINGS:
*.background_dump_dest
='/oracle/oradata/admin/Ora92/bdump'
*.compatible='9.2.0.0.0'
*.control_files
='/oracle/oradata/Ora92/control01.ctl','/oracle/oradata/Ora92/control02.ctl' ,'/oracle/oradata/Ora92/control03.ctl'
*.core_dump_dest
='/oracle/oradata/admin/Ora92/cdump'
*.db_block_size=8192
*.db_cache_size=8388608
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='Ora92'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='Ora92'
*.java_pool_size=0
*.large_pool_size=8388608
*.log_archive_dest_1
='LOCATION=/data/oradata/Ora92/archive'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.nls_date_language='DUTCH'
*.nls_language='DUTCH'
*.nls_numeric_characters=',.'
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile
='EXCLUSIVE'
*.shared_pool_reserved_size=4194304
*.shared_pool_size=8388608
*.sort_area_size=2097152
*.star_transformation_enabled
='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest
='/oracle/oradata/admin/Ora92/udump'
TIA Jack
Esta mensagem, incluindo seus anexos, pode conter
informação confidencial e/ou privilegiada. Se você
recebeu este e-mail por engano, não utilize, copie
ou divulgue as informações nele contidas. E, por
favor, avise imediatamente o remetente, respondendo
ao e-mail, e em seguida apague-o. Este e-mail
possui conteúdo informativo e não transacional.
Caso necessite de atendimento imediato,
recomendamos utilizar um dos canais disponíveis:
Internet Banking , BankBoston por telefone ou
agência/representante de atendimento de sua
conveniência. Agradecemos sua colaboração.
This message, including its attachments, may
contain confidential and/or privileged information.
If you received this email by mistake, do not use,
copy or disseminate any information herein
contained. Please notify us immediately by replying
to the sender and then delete it. This email is for
information purposes only, not for transactions. In
case you need immediate assistance, please use one
of the following channels: Internet Banking ,
BankBoston by phone or branch/relationship manager
at your convenience. Thank you for your
cooperation.
Esta mensagem, incluindo seus anexos, pode conter informação
confidencial e/ou privilegiada. Se você recebeu este e-mail por
engano, não utilize, copie ou divulgue as informações nele
contidas. E, por favor, avise imediatamente o remetente,
respondendo ao e-mail, e em seguida apague-o. Este e-mail
possui conteúdo informativo e não transacional. Caso necessite
de atendimento imediato, recomendamos utilizar um dos canais
disponíveis: Internet Banking , BankBoston por telefone ou
agência/representante de atendimento de sua conveniência.
Agradecemos sua colaboração.
This message, including its attachments, may contain
confidential and/or privileged information. If you received
this email by mistake, do not use, copy or disseminate any
information herein contained. Please notify us immediately by
replying to the sender and then delete it. This email is for
information purposes only, not for transactions. In case you
need immediate assistance, please use one of the following
channels: Internet Banking , BankBoston by phone or
branch/relationship manager at your convenience. Thank you for
your cooperation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jack van Zanen
INET: JACK_at_QUANTSYSTEMS.NL
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Aug 01 2003 - 03:44:23 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |