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
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
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
Jack,ORA-27101: shared memory realm does not existOracle 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.RegardsSuhen-----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.3Hi,
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
