From: wrong@mail.com   
      
   Haximus wrote:   
   > "Martin Solveig" wrote in message   
   > news:d9s8j4$i38$2@ss405.t-com.hr...   
   >   
   >>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   
   >   
   >   
   > Have a look at the alert log and install log for further clues, there are a   
   > lot of causes for ORA-03113   
   >   
   >   
      
    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   
      
      
   Ivan Kartik   
      
   Posts: 707   
   OTN Member Since: Oct, 2003   
      
       
   Re: 10.1.0.4 on SLES 9 SP1 ora-03113 ( In Reply To : 10.1.0.4 on SLES 9   
   SP1 ora-03113 ) Jun 28, 2005 8:20 PM   
       
   [Reply to this message] Reply   
   Check alert log for reason of failure.   
      
   Toni antonio Lazarin   
      
   Posts: 8   
   OTN Member Since: Jun, 2004   
      
       
   Re: 10.1.0.4 on SLES 9 SP1 ora-03113 ( In Reply To : Re: 10.1.0.4 on   
   SLES 9 SP1 ora-03113 ) Jun 29, 2005 10:16 AM   
       
   [Reply to this message] Reply   
   HERE ARE MY ALERT LOGS 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    
   Oracle process number: 7   
   Unix process pid: 5880, image: oracle@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] [] []   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|