Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-27101 RH linux 9 Oracle 9.2.0.3
512Mb RAM
2Gb Swap space
386908k actv, 39520k in_d, 9728k in_c Swap: 2097136k av, 22708k used, 2074428k free 257980kcached
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.
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
Node name: Linux Release: 2.4.20-18.9 Version: #1 Thu May 29 07:08:16 EDT 2003 Machine: i686
[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
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