473,624 Members | 2,272 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ORACLE 10G R1 on SLES 9SP1

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
Jun 27 '08 #1
5 4150
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

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard _at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***
Jun 27 '08 #2
HansF wrote:
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
Jun 27 '08 #3
"Martin Solveig" <wr***@mail.com wrote in message
news:d9******** **@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
Jun 27 '08 #4
Haximus wrote:
"Martin Solveig" <wr***@mail.com wrote in message
news:d9******** **@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_SES SION = 0
LICENSE_SESSION S_WARNING = 0
/admin/+ASM/bdumpcat +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
clssgsGroupGetS tatus: clsssRecvMsg failed 3 0)
clssgsGroupGetS tatus: 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] [] []
Jun 27 '08 #5
Haximus wrote:
"Martin Solveig" <wr***@mail.com wrote in message
news:d9******** **@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_SES SION = 0
LICENSE_SESSION S_WARNING = 0
/admin/+ASM/bdumpcat +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
clssgsGroupGetS tatus: clsssRecvMsg failed 3 0)
clssgsGroupGetS tatus: 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] [] []
Jun 27 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2739
by: Andy | last post by:
Hopefully just a quickie.. Which version of Red Hat Linux supports Oracle 9 DB? I just want to install it at home to get to grips with it, not run any mission critical apps with it, so i don't want to shell out $1500 for Advanced server if i can help it! Many thanks in advance. Andy Smith
3
5220
by: Jan Bols | last post by:
I've been trying to install Oracle 8.1.7 on a fresh Mandrake 9.1 O.S for days, but I'm still not able to get it running. I've tried several install instructions that I found on the internet but no luck yet. Here is a short description of what I did so far: 1. I installed the jdk118_v3-glibc-2.1.3.tar in the /usr/local/ dir and made a symbolic link from /usr/local/java to this 2. I installed all the necessary groups and users (oracle,...
4
19984
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
0
1164
by: Roger | last post by:
I'm running DB2 UDB V8 on a pseries box with SUSE SLES 8 installed and noticed that IF I put the log files on a raw device , update/delete/insert is 4 times faster than IF I have the log files on a LVM with reiserFS so... the question is why is it 4 times faster ? I'm running the test with the same db and dbm configuration the only thing I changed is the path to the log files so .. IF anyone has some ideas , pls let me know.
63
25608
by: Nick Palmer | last post by:
Hi all, Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two DB2 databases and I need to get access to the tables in one from the other. In Oracle I would just create a DB Link between the two instances. Is such a thing possible between two DB2 databases ? Thanks in advance, Nick
3
23450
by: Jon Ole Hedne | last post by:
My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary Access-tables. I have tried this: conn.Provider = "Microsoft.Jet.OLEDB.4.0" conn.ConnectionString = "data source=" & datafil & ";Jet OLEDB:Database Password=" conn.Open datafil
2
3556
by: Ruslan A Dautkhanov | last post by:
Hello ! I'm about to install O9i on FreeBSD box. uname -a: FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004 rd@stat2.scn.ru:/usr/src/sys/i386/compile/RDSTAT2-ORACLE i386 uname -a under oracle user : Linux stat2.scn.ru 2.4.2 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004 i686 unknown
0
3311
by: Jack | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available. http://a.uuload.com/Oracle-Database.htm Unlock the Value of Your IT System Confio Software's Ignite for Oracle uses wait-event analysis to improve database performance by 65% or more. Gain visibility of every Oracle wait event. Download free...
0
3283
by: Winder | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available. http://a.uuload.com/Oracle-Database.htm Unlock the Value of Your IT System Confio Software's Ignite for Oracle uses wait-event analysis to improve database performance by 65% or more. Gain visibility of every Oracle wait event. Download free...
0
8177
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8681
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8629
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8341
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8488
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7170
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4084
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2611
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1793
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.