DB Link gives ORA-600

[Database Administrator]

"Michael" wrote in message news:<1100588438.054684.79070@f14g2000cwb.googlegroups.c om>...
> Hi,
>
> in case you have Metalink access you can use the ORA-600 Argument
> Lookup Page there to search your specific problem in future ... and
> yes, the folks are right here ... it seems to be a bug:
>
> Bug# 2884469 See [NOTE:2884469.8]
> OERI[729] possible using literal replacement
> Fixed: 9.2.0.4, 10.1.0.2
>
> just that they wrote it might be fixed in 9.2.0.4
>
> It's really not necessary to always open a tar ... you better learn to
> use your tools :-)
>
> Greetings,
> Michael

To be more precise the reported message is telling us that this guy
encountered a very small memory leak in UGA. Nothing more, nothing
less. It could be the mentioned bug, it could be something else. There
is several of these and without Oracle support is almost impossible to
discover the exact reason of this behaviour. So he have two
possibilites either ignore it and live with it or contact Oracle
support with all steps mentioned by Danniel.

--
Dusan Bolek
http://www.db-support.com

Email: spambin@seznam.cz
Pls add "Not Guilty" to the subject, otherwise your email will face an
unpleasant end as SPAM.

[Database Administrator]

theodorath@yahoo.com (Theodor Papadopoulos) wrote in message news:...
> I have a 9.2.0.4 database which is connected to another through db
> link.
> Every day at specific time i'm receiving the following error in the
> alert file:
> "ORA-00600: internal error code, arguments: [729], [104], [space
> leak], [], [], [], [], []
> ORA-02068: following severe error from
> ORA-03113: end-of-file on communication channel"
>
> The trace file that accompanies the error does not include any other
> details.
> The second db is up and running,neither is backed up at that time and
> the time is such that hardly anybody of the users is connected to the
> database.
>
> Has anybody faced anything like this before?
> Any ideas will be appreciated.
>
> Thanks in advance,
> Theodore P.

Thanks everybody for your quick response
but I don't think that the bugs mentioned to Note 31056.1 ORA-600
[729] "UGA Space Leak" apply to my situation and specially Bug#
2782196 ORA-3106 / OERI:729 after CTRL-C of INSERT..SELECT via a
DBLINK
Since nobody is connected at that time.

Regards,
Theodore

[Database Administrator]

theodorath@yahoo.com (Theodor Papadopoulos) wrote in message news:...
> I have a 9.2.0.4 database which is connected to another through db
> link.
> Every day at specific time i'm receiving the following error in the
> alert file:
> "ORA-00600: internal error code, arguments: [729], [104], [space
> leak], [], [], [], [], []
> ORA-02068: following severe error from
> ORA-03113: end-of-file on communication channel"
>
> The trace file that accompanies the error does not include any other
> details.
> The second db is up and running,neither is backed up at that time and
> the time is such that hardly anybody of the users is connected to the
> database.
>
> Has anybody faced anything like this before?
> Any ideas will be appreciated.
>
> Thanks in advance,
> Theodore P.

Thanks everybody for your quick response
but I don't think that the bugs mentioned to Note 31056.1 ORA-600
[729] "UGA Space Leak" apply to my situation and specially Bug#
2782196 ORA-3106 / OERI:729 after CTRL-C of INSERT..SELECT via a
DBLINK
Since nobody is connected at that time.

Regards,
Theodore

[Database Administrator]

theodorath@yahoo.com (Theodor Papadopoulos) wrote in message news:...
> I have a 9.2.0.4 database which is connected to another through db
> link.
> Every day at specific time i'm receiving the following error in the
> alert file:
> "ORA-00600: internal error code, arguments: [729], [104], [space
> leak], [], [], [], [], []
> ORA-02068: following severe error from
> ORA-03113: end-of-file on communication channel"
>
> The trace file that accompanies the error does not include any other
> details.
> The second db is up and running,neither is backed up at that time and
> the time is such that hardly anybody of the users is connected to the
> database.
>
> Has anybody faced anything like this before?
> Any ideas will be appreciated.
>
> Thanks in advance,
> Theodore P.

Thanks everybody for your quick response
but I don't think that the bugs mentioned to Note 31056.1 ORA-600
[729] "UGA Space Leak" apply to my situation and specially Bug#
2782196 ORA-3106 / OERI:729 after CTRL-C of INSERT..SELECT via a
DBLINK
Since nobody is connected at that time.

Regards,
Theodore

[Database Administrator]

theodorath@yahoo.com (Theodor Papadopoulos) wrote in message news:...
> I have a 9.2.0.4 database which is connected to another through db
> link.
> Every day at specific time i'm receiving the following error in the
> alert file:
> "ORA-00600: internal error code, arguments: [729], [104], [space
> leak], [], [], [], [], []
> ORA-02068: following severe error from
> ORA-03113: end-of-file on communication channel"
>
> The trace file that accompanies the error does not include any other
> details.
> The second db is up and running,neither is backed up at that time and
> the time is such that hardly anybody of the users is connected to the
> database.
>
> Has anybody faced anything like this before?
> Any ideas will be appreciated.
>
> Thanks in advance,
> Theodore P.

Thanks everybody for your quick response
but I don't think that the bugs mentioned to Note 31056.1 ORA-600
[729] "UGA Space Leak" apply to my situation and specially Bug#
2782196 ORA-3106 / OERI:729 after CTRL-C of INSERT..SELECT via a
DBLINK
Since nobody is connected at that time.

Regards,
Theodore

[Database Administrator]

theodorath@yahoo.com (Theodor Papadopoulos) wrote in message news:...
> I have a 9.2.0.4 database which is connected to another through db
> link.
> Every day at specific time i'm receiving the following error in the
> alert file:
> "ORA-00600: internal error code, arguments: [729], [104], [space
> leak], [], [], [], [], []
> ORA-02068: following severe error from
> ORA-03113: end-of-file on communication channel"
>
> The trace file that accompanies the error does not include any other
> details.
> The second db is up and running,neither is backed up at that time and
> the time is such that hardly anybody of the users is connected to the
> database.
>
> Has anybody faced anything like this before?
> Any ideas will be appreciated.
>
> Thanks in advance,
> Theodore P.

Thanks everybody for your quick response
but I don't think that the bugs mentioned to Note 31056.1 ORA-600
[729] "UGA Space Leak" apply to my situation and specially Bug#
2782196 ORA-3106 / OERI:729 after CTRL-C of INSERT..SELECT via a
DBLINK
Since nobody is connected at that time.

Regards,
Theodore

[Database Administrator]

theodorath@yahoo.com (Theodor Papadopoulos) wrote in message news:...
> I have a 9.2.0.4 database which is connected to another through db
> link.
> Every day at specific time i'm receiving the following error in the
> alert file:
> "ORA-00600: internal error code, arguments: [729], [104], [space
> leak], [], [], [], [], []
> ORA-02068: following severe error from
> ORA-03113: end-of-file on communication channel"
>
> The trace file that accompanies the error does not include any other
> details.
> The second db is up and running,neither is backed up at that time and
> the time is such that hardly anybody of the users is connected to the
> database.
>
> Has anybody faced anything like this before?
> Any ideas will be appreciated.
>
> Thanks in advance,
> Theodore P.

Thanks everybody for your quick response
but I don't think that the bugs mentioned to Note 31056.1 ORA-600
[729] "UGA Space Leak" apply to my situation and specially Bug#
2782196 ORA-3106 / OERI:729 after CTRL-C of INSERT..SELECT via a
DBLINK
Since nobody is connected at that time.

Regards,
Theodore

[vikkibhar]

This may even occur on UNIX platforms when the kernel parameters are not properly set in the /etc/system file. Please check them