This discussion is archived
1 4 5 6 7 8 Previous Next 112 Replies Latest reply: Jan 10, 2007 6:44 PM by 439268 Go to original post RSS
  • 90. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
    462055 Newbie
    Currently Being Moderated
    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.

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

    Ronald
    http://homepage.mac.com/ik_zelf/oracle
  • 92. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
    428011 Newbie
    Currently Being Moderated
    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)
    124751 Newbie
    Currently Being Moderated
    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)
    438268 Newbie
    Currently Being Moderated
    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)
    438268 Newbie
    Currently Being Moderated
    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)
    462055 Newbie
    Currently Being Moderated
    amit:/Volumes/u01/app/oracle/product/10.1.0/db_7/bin oracle$ $ORACLE_HOME/bin/lsnrctl start

    LSNRCTL for MacOS X Server: Version 10.1.0.3.0 - 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)
    485433 Newbie
    Currently Being Moderated
    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 9.2.0.1.0 - 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

    ERROR:
    ORA-12547: TNS:lost contact
  • 98. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
    RonaldRood Oracle ACE
    Currently Being Moderated
    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>

    Ronald.
  • 99. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
    485457 Newbie
    Currently Being Moderated
    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)
    RonaldRood Oracle ACE
    Currently Being Moderated
    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.

    regards,
    Ronald
    http://homepage.mac.com/ik_zelf/oracle
  • 101. Re: Oracle 10g DB on Mac OS X 10.4 (Tiger)
    371635 Newbie
    Currently Being Moderated
    ... 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)
    RonaldRood Oracle ACE
    Currently Being Moderated
    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 ...

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

    When shutting down I get

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 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/10.1.0.3/db_1/lib/libhasgen10.dylib
    Expected in: flat namespace

    dyld: Symbol not found: _lxldfcb
    Referenced from: /oracle/app/product/10.1.0.3/db_1/lib/libhasgen10.dylib
    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
    SQL>

    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)
    491839 Newbie
    Currently Being Moderated
    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