dbTalk Databases Forums  

ORACLE 10G R1 on SLES 9SP1

Go Back dbTalk Databases Forums Databases comp.databases.oracle ORACLE 10G R1 on SLES 9SP1

comp.databases.oracle comp.databases.oracle


Discuss ORACLE 10G R1 on SLES 9SP1 in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Solveig
 
Posts: n/a

Default ORACLE 10G R1 on SLES 9SP1 - 06-28-2005 , 02:31 PM





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

Reply With Quote
  #2  
Old   
HansF
 
Posts: n/a

Default Re: ORACLE 10G R1 on SLES 9SP1 - 06-28-2005 , 04:51 PM





On Tue, 28 Jun 2005 21:31:49 +0200, Martin Solveig interested us by writing:

Quote:
error ORA-03113
Usually an indication that some memory related parasmeter is out of whack.

Have you looked at Werner Puschitz' site? (http://www.puschitz.com)
He's added SLES 8 & 9, Oracle9i DB and Oracle DB 10g to his set up guides.

/Hans

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***


Reply With Quote
  #3  
Old   
Martin Solveig
 
Posts: n/a

Default Re: ORACLE 10G R1 on SLES 9SP1 - 06-28-2005 , 05:31 PM


HansF wrote:
Quote:
On Tue, 28 Jun 2005 21:31:49 +0200, Martin Solveig interested us by writing:


error ORA-03113


Usually an indication that some memory related parasmeter is out of whack.

Have you looked at Werner Puschitz' site? (http://www.puschitz.com)
He's added SLES 8 & 9, Oracle9i DB and Oracle DB 10g to his set up guides.

/Hans
Thanks Hans, I'll check

Reply With Quote
  #4  
Old   
Haximus
 
Posts: n/a

Default Re: ORACLE 10G R1 on SLES 9SP1 - 07-10-2005 , 07:04 PM


"Martin Solveig" <wrong (AT) mail (DOT) com> wrote

Quote:
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




Reply With Quote
  #5  
Old   
Mater
 
Posts: n/a

Default Re: ORACLE 10G R1 on SLES 9SP1 - 07-11-2005 , 05:40 PM


Haximus wrote:
Quote:
"Martin Solveig" <wrong (AT) mail (DOT) com> wrote in message
news:d9s8j4$i38$2 (AT) ss405 (DOT) 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 <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 ID33.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 With Quote
  #6  
Old   
Mater
 
Posts: n/a

Default Re: ORACLE 10G R1 on SLES 9SP1 - 07-11-2005 , 05:41 PM


Haximus wrote:
Quote:
"Martin Solveig" <wrong (AT) mail (DOT) com> wrote in message
news:d9s8j4$i38$2 (AT) ss405 (DOT) 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 <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 ID33.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 With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top