Re: ORACLE 10r1 on SLES 9 SP1

From: Martin Solveig <wrong_at_mail.com>
Date: Wed, 29 Jun 2005 18:38:45 +0200
Message-ID: <d9uiqk$5m6$1@ss405.t-com.hr>

Martin Solveig wrote:
> Hello,
> SLES9 SP1 is on PIII with two 800MHz procesors and 2GB RAM,
> on four SATA 156GBhard disks are created two RAID1 arays,
> on one RAID is OS with 1GB swap and Oracle 10.1.0.4 enterprise edition,
> on second RAID are two raw partitions each 70GB ....
>
> I start DBCA custom database and configure one ASM disk group by using
> two raw partitions (/dev/sdb1, /dev/sdb2),then I add
> 4 new tablespaces with datafiles of 2GB each autoextend on 10MB, change
> character set,
> deselect spatial & data mining....
> Instalation starts but stops betwen 13&14% while creating data
> dictionary with error ORA-03113
> end-of-file on comunication chanell
> Any suggestion is extra welcome.....
> Thanks 4 Your time

THESE ARE MY LOG AND TRACE FILES: /admin/+ASM/bdump>cat alert_+ASM.log
Tue Jun 28 16:22:50 2005
SUCCESS: diskgroup DISKOVI was mounted
Tue Jun 28 16:22:51 2005
NOTE: recovering COD for group 1/0xac774a8b (DISKOVI) SUCCESS: completed COD recovery for group 1/0xac774a8b (DISKOVI) Tue Jun 28 16:29:19 2005
Errors in file /opt/oracle/admin/+ASM/bdump/+asm_smon_5880.trc: ORA-29702: error occurred in Cluster Group Service operation ORA-29702: error occurred in Cluster Group Service operation Tue Jun 28 16:29:19 2005
SMON: terminating instance due to error 29702 Instance terminated by SMON, pid = 5880
Tue Jun 28 16:34:18 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0 /admin/+ASM/bdump> cat +asm_smon_5880.trc /opt/oracle/admin/+ASM/bdump/+asm_smon_5880.trc Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options ORACLE_HOME = /opt/oracle/product/10g
System name: Linux
Node name: zeus

Release: 2.6.5-7.139-smp
Version: #1 SMP Fri Jan 14 15:41:33 UTC 2005
Machine: i686

Instance name: +ASM
Redo thread mounted by this instance: 0 <none> Oracle process number: 7
Unix process pid: 5880, image: oracle_at_zeus (SMON)

*** 2005-06-28 16:29:19.298
*** SERVICE NAME:() 2005-06-28 16:29:19.298
*** SESSION ID:(33.1) 2005-06-28 16:29:19.298

clssgsGroupGetStatus: clsssRecvMsg failed 3 0) clssgsGroupGetStatus: returning 8
kgxgnpstat: received ABORT event from CLSS Group services Error [NM abort event ] @ 28019:715 error 29702 detected in background process ORA-29702: error occurred in Cluster Group Service operation ORA-29702: error occurred in Cluster Group Service operation

/admin/twrh/bdump>cat alert_twrh.log
ORA-15064: Message 15064 not found; No message file for product=RDBMS, facility=ORA
ORA-01089: Message 1089 not found; No message file for product=RDBMS, facility=ORA
ORA-07445: exception encountered: core dump [kksParseCursor()+9] [SIGSEGV] [Address not mapped to object] [0x0] [] [] Received on Wed Jun 29 2005 - 11:38:45 CDT