Re: 10.1.0.4 SUSE9 SP1 ASM

Martin Solveig wrote:
> 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] [] []

Just a shot in the dark...
The error is due to a communication issue between the instance that you are trying to create and the ASM.
Why is it happening?
It could be a bug... or...

...what I can see is that probably you have an env misconfiguration ("No message file for product=RDBMS" shouldn't appear).

In particular check your ORACLE_HOME. Does the variable match the installation path?

If you are using the orarun package review the /etc/profile.d/oracle.sh

Regards

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe