Professional Web Applications Themes

ORA-00600 ... more exactly (from a newbee) - Oracle Server

"yaya" <yayatototiscali.fr> wrote in message news:newscache$969u7h$gf$1news.tiscali.fr... > Hello, > > Is there no location on the net (or book) to find the Oracle error codes ? > > Thanks ! > > yaya > You can look up any error code in the online docs at [url]http://tahiti.oracle.com[/url]. But what I usually do is start up Google and search for the error code (just type 'ora-0600' in the search field). A lot of the hits from Google are simply universities that have put the same doentation online ... but sometimes it's from real-world users who supply a real-world solution....

  1. #1

    Default Re: ORA-00600 ... more exactly (from a newbee)

    "yaya" <yayatototiscali.fr> wrote in message
    news:newscache$969u7h$gf$1news.tiscali.fr...
    > Hello,
    >
    > Is there no location on the net (or book) to find the Oracle error codes ?
    >
    > Thanks !
    >
    > yaya
    >
    You can look up any error code in the online docs at
    [url]http://tahiti.oracle.com[/url]. But what I usually do is start up Google and
    search for the error code (just type 'ora-0600' in the search field). A lot
    of the hits from Google are simply universities that have put the same
    doentation online ... but sometimes it's from real-world users who supply
    a real-world solution.


    Karsten Farrell Guest

  2. #2

    Default Re: ORA-00600 ... more exactly (from a newbee)

    yaya wrote:
    > Hello,
    >
    > Is there no location on the net (or book) to find the Oracle error codes ?
    >
    > Thanks !
    >
    > yaya
    >
    >
    As posted -but the infamous 600 is something like
    "well, we're having a serious problem for which we haven't
    assigned a proper error code yet".

    The extra codes (up to 5, or 6?) may give some info, but
    the general consensus is: Call Oracle Support.

    Grtz, Frank

    Frank Guest

  3. #3

    Default Re: ORA-00600 ... more exactly (from a newbee)

    Frank <fbortelhome.nl> wrote in message news:<3E0DDA81.5040204home.nl>...
    > As posted -but the infamous 600 is something like
    > "well, we're having a serious problem for which we haven't
    > assigned a proper error code yet".
    I think that it's more like "well, we're having problem for which we
    forgot to create error message". ORA-0600 may not be serious at all,
    especially in 8i there is a lot of really dump errors generating
    ORA-0600 errors just because someone forgot to name them.
    It seems to me that much of those were corrected in 9i (9.2), where a
    lot of famous ORA-0600s are generating correct error code now. That's
    a good message, because, especially for beginners, getting ORA-0600
    was very puzzling and I can imagine a lot of senseless calls to Oracle
    support.

    --
    _________________________________________

    Dusan Bolek, Ing.
    Oracle team leader

    Note: [email]pagesflamesusa.net[/email] has been cancelled due to changes (maybe we
    can call it an overture to bankruptcy) on that server. I'm still using
    this email to prevent SPAM. Maybe one day I will change it and have a
    proper mail even for news, but right now I can be reached by this
    email.
    Dusan Bolek Guest

  4. #4

    Default Re: ORA-00600 ... more exactly (from a newbee)

    "yaya" <yayatototiscali.fr> wrote in message news:<newscache$969u7h$gf$1news.tiscali.fr>...
    > Hello,
    >
    > Is there no location on the net (or book) to find the Oracle error codes ?
    >
    > Thanks !
    >
    > yaya

    Metalink,tahiti,google and other web resources could be helpful
    Sometimes ORA-600 has proven to be dreadful and other times as good as
    a typo.On several occasions depending on what you are doing the cause
    of the error could be discerned, one of the obvious reasons the error
    could be recreated .In doubtful situations call Oracle World Wide
    Support and be safe than sorry.
    One very interesting one is typing oracle at the command prompt in HP
    and you will recieve
    ORA-00600: internal error code, arguments: [12235], [], [], [], [],
    [], [], []

    Michael Tubuo Ngong(DBA)
    michael ngong Guest

  5. #5

    Default Re: ORA-00600 ... more exactly (from a newbee)

    Dusan Bolek wrote:
    > Frank <fbortelhome.nl> wrote in message news:<3E0DDA81.5040204home.nl>...
    >
    >>As posted -but the infamous 600 is something like
    >>"well, we're having a serious problem for which we haven't
    >>assigned a proper error code yet".
    >
    >
    > I think that it's more like "well, we're having problem for which we
    > forgot to create error message". ORA-0600 may not be serious at all,
    > especially in 8i there is a lot of really dump errors generating
    > ORA-0600 errors just because someone forgot to name them.
    > It seems to me that much of those were corrected in 9i (9.2), where a
    > lot of famous ORA-0600s are generating correct error code now. That's
    > a good message, because, especially for beginners, getting ORA-0600
    > was very puzzling and I can imagine a lot of senseless calls to Oracle
    > support.
    >

    I did not say, nor intended "we (oracle) forgot to assign...".
    I said, for which no proper code is assigned yet. I have seen
    the odd bug report or two stating a particular 600 [] [] []
    error should have another, properly doented error code.
    And yes, a lot of senseless calls would be made to support, as
    the support personnel does not know what to do about it, either,
    unless doented in WebIV.
    And yes - over time and versions, ORA-00600's move to proper
    messages.

    This still leaves the original comment valid:
    "Something seriously wrong - call support".
    Dump errors don't occur just like that, afaik.

    my 2c, Frank

    Frank Guest

  6. #6

    Default Re: ORA-00600 ... more exactly (from a newbee)

    > One very interesting one is typing oracle at the command prompt in HP
    > and you will recieve
    > ORA-00600: internal error code, arguments: [12235], [], [], [], [],
    > [], [], []
    You'll get this same error in just about any other Unix as well. It means
    "shadow process could not find client process to service" or something
    very similar to this. :)

    --
    Vladimir Zakharychev (bobdpsp-yes.com) [url]http://www.dpsp-yes.com[/url]
    Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
    All opinions are mine and do not necessarily go in line with those of my employer.


    Vladimir M. Zakharychev Guest

Similar Threads

  1. newbee question
    By Charlies Angel in forum Macromedia Flash Flashcom
    Replies: 7
    Last Post: February 11th, 06:42 PM
  2. A newbee in the world of PERL
    By Abhijit in forum PERL Modules
    Replies: 3
    Last Post: July 11th, 01:22 PM
  3. Newbee on Fonts; converting from Mac to PC
    By Jim_Strzyzewski@adobeforums.com in forum Adobe Indesign Windows
    Replies: 6
    Last Post: May 3rd, 04:41 PM
  4. Help needed - mod_perl -Newbee
    By star night in forum PERL Modules
    Replies: 2
    Last Post: April 20th, 11:16 AM
  5. newbee help with php please
    By erik in forum PHP Development
    Replies: 0
    Last Post: September 13th, 01:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139