1 4 5 6 7 8 Previous Next 112 Replies Latest reply: Jan 10, 2007 8:44 PM by 439268 Go to original post RSS
      • 90. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
        Hi ,

        Thanks for your help i was able to successfully install database on Powerbook
        In case if i want to start and stop the database any idea how can i do it.Incase if i shut down machine database services gonna stop.Ho do i restart it.
        Let me know.

        • 91. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
          Ronald Rood
          I have an example of an autostart script on my site. Pick it and see what you can do with it.

          • 92. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
            I'm not an oracle expert but this works for me.

            Make sure ORACLE_HOME is set, then run:

            $ORACLE_HOME/bin/lsnrctl start
            $ORACLE_HOME/bin/sqlplus "connect / as sysdba"
            SQL> startup
            SQL> quit

            $ORACLE_HOME/bin/sqlplus "connect / as sysdba"
            SQL> shutdown
            SQL> quit
            $ORACLE_HOME/bin/lsnrctl stop
            • 93. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
              Did you find a solution to this problem? I think I am experiencing the exact same issue (see thread: ORA-03113 error when running the Java stored proc demos
              • 94. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                Gee. This working fine for so long. So Installed the latest developer tools, then 10.4.3 upgrade, but now Oracle is crashing on startup with this in the crash log:


                Host Name: jeffsmachine-2
                Date/Time: 2005-11-29 08:13:43.965 -0800
                OS Version: 10.4.3 (Build 8F46)
                Report Version: 3

                Command: oracle
                Path: /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/bin/oracle
                Parent: sqlplus [245]

                Version: ??? (???)

                PID: 338
                Thread: 0

                Exception: EXC_BAD_ACCESS (0x0001)
                Codes: KERN_PROTECTION_FAILURE (0x0002) at 0x00000000

                Thread 0 Crashed:
                0 oracle      0x02815614 slrac + 236 (crt.c:355)
                1 oracle      0x000dc92c ksedst + 1016 (crt.c:355)
                2 oracle      0x000db1ec ksedmp + 764 (crt.c:355)
                3 oracle      0x0046e124 ksfdmp + 28 (crt.c:355)
                4 oracle      0x026f8a20 kgeriv + 224 (crt.c:355)
                5 oracle      0x000d9b18 ksesic2 + 120 (crt.c:355)
                6 oracle      0x0142f5a0 kturdb + 1144 (crt.c:355)
                7 oracle      0x006470a4 kcoapl + 3000 (crt.c:355)
                8 oracle      0x001cb3e4 kcbapl + 160 (crt.c:355)
                9 oracle      0x0025edd4 kcrfw_redo_gen + 9612 (crt.c:355)
                10 oracle      0x001c9968 kcbchg1 + 8216 (crt.c:355)
                11 oracle      0x006bed80 ktuchg + 5372 (crt.c:355)
                12 oracle      0x00687994 ktbchg2 + 236 (crt.c:355)
                13 oracle      0x01d488a8 kdu_array_flush + 3264 (crt.c:355)
                14 oracle      0x01d3a960 kdusru + 1208 (crt.c:355)
                15 oracle      0x01698d1c kauupd + 540 (crt.c:355)
                16 oracle      0x00ef8ca8 updrow + 3652 (crt.c:355)
                17 oracle      0x0220a180 qerupRowProcedure + 104 (crt.c:355)
                18 oracle      0x022096b0 qerupFetch + 1236 (crt.c:355)
                19 oracle      0x00efc950 updaul + 4076 (crt.c:355)
                20 oracle      0x00efe2e8 updThreePhaseExe + 268 (crt.c:355)
                21 oracle      0x00efd93c updexe + 1100 (crt.c:355)
                22 oracle      0x010350a0 opiexe + 9220 (crt.c:355)
                23 oracle      0x0175cad8 opiall0 + 3760 (crt.c:355)
                24 oracle      0x0176b9dc opikpr + 652 (crt.c:355)
                25 oracle      0x001465c4 opiodr + 2332 (crt.c:355)
                26 oracle      0x0014e6b0 rpidrus + 228 (crt.c:355)
                27 oracle      0x027a2444 skgmstack + 320 (crt.c:355)
                28 oracle      0x0014b888 rpidru + 148 (crt.c:355)
                29 oracle      0x0014b2a8 rpiswu2 + 880 (crt.c:355)
                30 oracle      0x00c66018 kprball + 1692 (crt.c:355)
                31 oracle      0x01b2a990 kkblobu + 1200 (crt.c:355)
                32 oracle      0x00e90f2c kdltnfy + 204 (crt.c:355)
                33 oracle      0x004dab10 kscnfy + 292 (crt.c:355)
                34 oracle      0x00afa2f8 adbdrv + 20332 (crt.c:355)
                35 oracle      0x010357a4 opiexe + 11016 (crt.c:355)
                36 oracle      0x0177134c opiosq0 + 7016 (crt.c:355)
                37 oracle      0x01241ccc kpooprx + 272 (crt.c:355)
                38 oracle      0x0123fd58 kpoal8 + 776 (crt.c:355)
                39 oracle      0x001465c4 opiodr + 2332 (crt.c:355)
                40 oracle      0x028bb4e8 ttcpip + 4796 (crt.c:355)
                41 oracle      0x00149320 opitsk + 2776 (crt.c:355)
                42 oracle      0x007a6bd4 opiino + 1660 (crt.c:355)
                43 oracle      0x001465c4 opiodr + 2332 (crt.c:355)
                44 oracle      0x00006588 opidrv + 1028 (crt.c:355)
                45 oracle      0x00007f40 sou2o + 144 (crt.c:355)
                46 oracle      0x000024b8 main + 228 (crt.c:355)
                47 oracle      0x00001c30 _start + 340 (crt.c:272)
                48 oracle      0x00001ad8 start + 60

                Thread 0 crashed with PPC Thread State 64:
                srr0: 0x0000000002815614 srr1: 0x000000000000f030 vrsave: 0x0000000000000000
                cr: 0x22442288 xer: 0x0000000000000004 lr: 0x00000000028155fc ctr: 0x0000000090001b80
                r0: 0x0000000000000000 r1: 0x00000000bffe6930 r2: 0x0000000000000000 r3: 0x0000000000000000
                r4: 0x0000000000000000 r5: 0x00000000028155fc r6: 0x0000000004a89aa8 r7: 0x00000000000000ff
                r8: 0x0000000004a89a94 r9: 0x0000000000002000 r10: 0x00000000bffe9ef0 r11: 0x0000000004acfa44
                r12: 0x0000000090001b80 r13: 0x0000000000000000 r14: 0x0000000000000000 r15: 0x0000000000000100
                r16: 0x00000000bffe7730 r17: 0x0000000000000000 r18: 0x0000000000000000 r19: 0x00000000bffe7770
                r20: 0x00000000bffe6ee0 r21: 0x00000000bffe7750 r22: 0x0000000000000000 r23: 0x0000000000000000
                r24: 0x00000000bffe7770 r25: 0x00000000bffe9e60 r26: 0x0000000000000001 r27: 0x0000000000000033
                r28: 0x0000000000000006 r29: 0x0000000000000000 r30: 0x0000000000000000 r31: 0x0000000002815534

                Binary Images Description:
                0x1000 - 0x4a76fff oracle      /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/bin/oracle
                0x4eb3000 - 0x4eb3fff libodmd10.dylib      /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/lib/libodmd10.dylib
                0x4eb6000 - 0x4eb7fff libskgxp10.dylib      /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/lib/libskgxp10.dylib
                0x4eba000 - 0x4ebafff libskgxn2.dylib      /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/lib/libskgxn2.dylib
                0x4ebd000 - 0x4eeafff libocr10.dylib      /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/lib/libocr10.dylib
                0x4ef1000 - 0x4f12fff libocrb10.dylib      /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/lib/libocrb10.dylib
                0x4f18000 - 0x4f1cfff libocrutl10.dylib      /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/lib/libocrutl10.dylib
                0x4f2c000 - 0x4f35fff libdbcfg10.dylib      /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/lib/libdbcfg10.dylib
                0x5a05000 - 0x5ac2fff libhasgen10.dylib      /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/lib/libhasgen10.dylib
                0x5b81000 - 0x61c0fff libjox10.dylib      /Volumes/JAL_Drive/app/oracle/product/10.1.0/db_1/lib/libjox10.dylib
                0x8fe00000 - 0x8fe54fff dyld 44.2     /usr/lib/dyld
                0x90000000 - 0x901b3fff libSystem.B.dylib      /usr/lib/libSystem.B.dylib
                0x9020b000 - 0x9020ffff libmathCommon.A.dylib      /usr/lib/system/libmathCommon.A.dylib

                Now, this is the same message I received way back before someone figured out the relinking problem. So, I switched to gcc 3.3 and relinked everything but it hasn't helped. Does anyone have any suggestions?

                I am running into the OC4J problem, but that is less a concern at this point as getting the database actually running.
                • 95. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                  Hadn't checked my alert log. I hosed another database. It was time for a cleanout anyways. I needed to get rid of one tablespace as I didn't need it anymore.

                  Need to setup RMAN stuff soon :)
                  • 96. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                    amit:/Volumes/u01/app/oracle/product/10.1.0/db_7/bin oracle$ $ORACLE_HOME/bin/lsnrctl start

                    LSNRCTL for MacOS X Server: Version - Production on 21-DEC-2005 12:31:07

                    Copyright (c) 1991, 2004, Oracle. All rights reserved.

                    Starting /Volumes/u01/app/oracle/product/10.1.0/db_7/bin/tnslsnr: please wait...

                    TNS-12537: TNS:connection closed
                    TNS-12560: TNS:protocol adapter error
                    TNS-00507: Connection closed
                    MacOS X Server Error: 29: Illegal seek

                    I keep getting following error message.
                    Anyidea how can i start db. DB is succesfully installed but not sure why i can't start it.
                    • 97. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                      Has any found a solution for this problem.... missing kumainglobals on Tiger. I'm an online student in database apps at CPCC and need to install Oracle on my Mac. I have installed 9i (recommended by non-Mac professor) and get the same error msg. when I try to log into the database. Any help suggestions would be appreciated.

                      this is my sequence....

                      john-minters-computer:~ oracle$ sqlplus "/ as sysdba"
                      SQL*Plus: Release - Developer's Release on Fri Jan 20 14:45:44 2006

                      Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

                      dyld: Symbol not found: kumainglobals
                      Referenced from: /Users/oracle/9iR2/orahome/lib/libcommon9.dylib
                      Expected in: flat namespace

                      ORA-12547: TNS:lost contact
                      • 98. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                        Ronald Rood
                        Forget about 9i on tiger.
                        10gR1 works but after installation of the software you have some extra work. Just follow the instructions <http://ronr.blogspot.com/2005/05/how-to-run-oracle-10gr1-on-tiger.html>

                        • 99. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                          Thanks that fix work (moving the lib).

                          Just about to try a RAC Install has anyone had any luck on a tiger RAC ?
                          • 100. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                            Ronald Rood
                            All RAC's on mac I know about are on 10.3.9. You can always try to play with it but supported is only macos 10.3.6.

                            • 101. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                              ... and no hint for oracle on Mac OS X "Tiger" (PPC) nor Mac OS X "Tiger" (Intel) ... Oracle 10iR2 ist projected and planned, but ...
                              • 102. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                                Ronald Rood
                                Yes, I really wonder what oracle is going to do. Since 10gR1 a few details changed
                                1) 10.3 -> 10.4 : lots of API changes
                                2) PPC -> Intel
                                3) Big Endian -> Little Endian
                                4) renewed Sun/Oracle aliance

                                Also some questions like will the servers also be included in the intel transition ?
                                If so, when ?

                                Given the quality of the 10gR1 on such a new platform I certainly hope it gets a follow-up. Oracle did a very good job in the porting effort. It would be a pity if they throw that away. As always it is the money that rules. If there are enough licences sold the mac will stay. Question is: are there enough oracle users on mac. Oracle has stopped development on more platforms in the past ...

                                • 103. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                                  OK I know it is supported but installed RAC( on 10.4(tiger)
                                  all seems OK until I use ASM.

                                  When shutting down I get

                                  Connected to:
                                  Oracle Database 10g Enterprise Edition Release - Production
                                  With the Partitioning, Real Application Clusters, OLAP and Data Mining options

                                  SQL> shutdown

                                  dyld: lazy symbol binding failed: Symbol not found: _lxldfcb
                                  Referenced from: /oracle/app/product/
                                  Expected in: flat namespace

                                  dyld: Symbol not found: _lxldfcb
                                  Referenced from: /oracle/app/product/
                                  Expected in: flat namespace

                                  ORA-03113: end-of-file on communication channel

                                  and on start-up

                                  SQL> startup
                                  ORA-24324: service handle not initialized
                                  ORA-01041: internal error. hostdef extension doesn't exist

                                  Not a biggie as not supported just trying to get ahead of the game .
                                  • 104. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
                                    There is one vital peace of information missing.
                                    Before you cd to $ORACLE_HOME/lib, do:

                                    . /usr/local/bin/oraenv
                                    ORACLE_SID = [] ? <the name you entered in the database field during installation>
                                    Cannot locate ORACLE_HOME. # You can ignore this but, you'll get the next question
                                    ORACLE_HOME = [] ? <enter the location were you installed oracle, the bin and lib directories are here>

                                    You may get some more messages, but the point is that this will set your ORACLE_HOME and PATH environment correctly.
                                    1 4 5 6 7 8 Previous Next