10.1.0.4 SUSE9 SP1 ASM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin Solveig - 29 Jun 2005 20:10 GMT

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@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] [] []

Reply to this Message

Fabrizio - 29 Jun 2005 23:20 GMT

> Martin Solveig wrote:
>
[quoted text clipped - 67 lines]
> 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

Signature

Fabrizio Magni

fabrizio.magni@mycontinent.com

replace mycontinent with europe

Reply to this Message

Martin Solveig - 30 Jun 2005 17:12 GMT

>
>
[quoted text clipped - 13 lines]
>
> Regards

Fabrizio thanks very much for your sugestions & time.
I'll post again when I'll have access to that server

Reply to this Message