ORACLE 10G R1 on SLES 9SP1

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Martin Solveig
    #1

    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
    Tags: None
    • HansF
      #2
      Re: ORACLE 10G R1 on SLES 9SP1

      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 ***

        Comment

        • Martin Solveig
          #3
          Re: ORACLE 10G R1 on SLES 9SP1

          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

            Comment

            • Haximus
              #4
              Re: ORACLE 10G R1 on SLES 9SP1

              "Martin Solveig" <wrong@mail.com 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


                Comment

                • Mater
                  #5
                  Re: ORACLE 10G R1 on SLES 9SP1

                  Haximus wrote:
                  "Martin Solveig" <wrong@mail.com 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_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] [] []

                    Comment

                    • Mater
                      #6
                      Re: ORACLE 10G R1 on SLES 9SP1

                      Haximus wrote:
                      "Martin Solveig" <wrong@mail.com 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_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] [] []

                        Comment

                        Previous template Next
                        Working...