RE: ORA-27101 RH linux 9 Oracle 9.2.0.3

[Suhen Pather]

Title: 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:[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