Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-27101 RH linux 9 Oracle 9.2.0.3

RE: ORA-27101 RH linux 9 Oracle 9.2.0.3

From: Jack van Zanen <JACK_at_QUANTSYSTEMS.NL>
Date: Wed, 30 Jul 2003 01:39:30 -0800
Message-ID: <F001.005C7C17.20030730013930@fatcity.com>


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-----
Sent: Wednesday, July 30, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L

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-----
Sent: Wednesday, 30 July 2003 6:44 PM
To: Multiple recipients of list ORACLE-L

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)

[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

-- 
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 services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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 Wed Jul 30 2003 - 04:39:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US