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:[EMAIL PROTECTED]
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
****************************************************************
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
**************************************************************
----Original
Message-----
From: Suhen
Pather [mailto:[EMAIL PROTECTED]
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
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.
-----Original
Message-----
From: Jack
van Zanen [mailto:[EMAIL PROTECTED]
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.
*************************************************************
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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: [EMAIL PROTECTED] (ARC0)
*** SESSION ID:(7.1)
2003-07-30 09:24:33.995
- Created archivelog as
'/data/oradata/Ora92/archive/1_57.dbf'
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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
[EMAIL PROTECTED]
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
