Oracle-L: ORA-27101 RH linux 9 Oracle 9.2.0.3

From: Jack van Zanen <JACK_at_QUANTSYSTEMS.NL>
Date: Wed, 30 Jul 2003 00:44:23 -0800
Message-ID: <F001.005C7C04.20030730004423@fatcity.com>

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)

SESSION ID:(7.1) 2003-07-30 09:24:33.995 - Created archivelog as '/data/oradata/Ora92/archive/1_57.dbf'

[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 - 03:44:23 CDT