21, 2003 7:19 AM
Let me try this one more time. We are running Oracle 8.1.7 and I
received an ORA-2289 as indicated below.
Does anyone out there think he/she might be able to help me? Or at
least
point me in the right direction.
Thanks again.
Saira
-Original Message-
Somani
Sent
)
OBDAUSLESEGERAET VARCHAR2(20)
OBDGERAETPRGVERSIONVARCHAR2(20)
When I issue the below command I am getting ORA-00955 error:
SQL alter table feststellung drop column FZALLGEMEINZUSTANDCBXCODE;
alter table feststellung drop column
Hi all,
I'm new at this game and am running into this Oracle error in our
training environment.
I have searched on the web and the archives but I am not sure about a
resolution to this issue. Any comments/insights would be appreciated.
After investigating the issue, I found that there is a
VARCHAR2(20)
PRGVERSION VARCHAR2(20)
OBDAUSLESEGERAET VARCHAR2(20)
OBDGERAETPRGVERSIONVARCHAR2(20)
When I issue the below command I am getting ORA-00955 error:
SQL
DBA's
We are getting an intermittent ORA-11928 in conjunction with ORA-2063
and ORA-4088 during a batch load that runs every 5 minutes. (See below)
It only happens once every few days and at different times. When we
re-run the transaction it loads correctly.
I also get ORA-11928 in an OEM alert
James Howerton wrote:
DBA's
We are getting an intermittent ORA-11928 in conjunction with ORA-2063
and ORA-4088 during a batch load that runs every 5 minutes. (See below)
It only happens once every few days and at different times. When we
re-run the transaction it loads correctly.
I
You will get ORA-12992 if there was FK referencing to column you attempted to drop.
There are bugs related to dropping columns from a table with LOB datatypes.
This is very bizarre in 8i.
I have experienced it while testing this new feature
Here is a reproducible case on all versions
Anybody know thats ORA
ORA-24333?
look:
oerr ora 2433324333, 0, "zero iteration
count"// *Cause: An iteration count of zero was specified for the
statement// *Action: Specify the number of times this statement must be
executed
When thats issue occur?
thanks
Adriano
Adriano Freire wrote:
Anybody know thats ORA
ORA-24333?
look:
oerr ora 24333
24333, 0, zero iteration count
// *Cause: An iteration count of zero was specified for the statement
// *Action: Specify the number of times this statement must be
executed
When thats issue occur
to break this job before the upgrade, but it
did work in test back in September.
Anyway, I filed a TAR, and after re-running the dr0 admin scripts, we
tried to rebuild the indexes online using:
ALTER INDEX my_context_index REBUILD ONLINE;
Alas, the error:
ORA-29863: Warning in the Execution
Interesting idea, Hemant! It's not perfect, but it's a better alternative
than either the ORA-29863 or populating the index on the rebuild.
Thanks! :)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
:
ORA-29863: Warning in the Execution of ODCIINDEXCREATE Routine
reared it's ugly puss. We checked the advice of the Metalink article on the
error, but we didn't have any of those symptoms (out of Temp or Perm TS
space) and ended up dropping and recreating the indexes.
So, has anyone run across
Title: RE: ORA-29702: error occurred in Cluster Group Service operation
I wonder if it has something to do with the Clustered file system based on a couple of error messages...
In the messages-I see reference to the iofence-timer.
Just a thought
greg
-Original Message-
From
kernel.
This is based on the
Oracle Linux+Firewire project:
http://otn.oracle.com/tech/linux/open_source.html
I'm getting the ORA-29702 during database create.
Any ideas?
Sean
-- sqlplus, create database --
SQL onnect / as sysdba;
Connected to an idle instance.
SQL startup nomount
Hello all...
I'm running 9iRAC 9.2.0.2 on Linux 2.4.20 kernel. This is based on the
Oracle Linux+Firewire project:
http://otn.oracle.com/tech/linux/open_source.html
I'm getting the ORA-29702 during database create.
Any ideas?
Sean
-- sqlplus, create database --
SQL onnect / as sysdba
This response from Oracle is not a good one. Kirti is on the right track
regarding the SCN stuff as far as I remember. Other than that, I know
that Peter Gram and Bjorn Engsig (among a lot of other guys) might be
able to suggest something, so I've CC'ed them.
I have my own law on ora-600s
Mogens I do agree that this ora-600 [2662] is in the code that handle
SCN numbers, since SCN handling is used
many places in the code the stack trace that show which path throw the
code you took is necessary if there
is no hits on metalink fits the problem ;-)
Mogens Nørgaard wrote
Ferenc,
There's this new FREE product on the Metalink site. It's called ORA-600
Lookup (I don't bother to bookmark it, just do a search on that and the
first one in the search list is the link to the product). You put in
the version number, the first argument on the ora-600
is on the right track
regarding the SCN stuff as far as I remember. Other than that, I know
that Peter Gram and Bjorn Engsig (among a lot of other guys) might be
able to suggest something, so I've CC'ed them.
I have my own law on ora-600s: If you supply all the required
information (tracefiles
Here is another product that goes after ORA-600:
http://www.ubTools.com/cgi-bin/ib/ikonboard.cgi?act=Pages;page=iorabugfinder
The creator, Danisment Unal, used to be on the list.
- Kirti
-Original Message-
Sent: Tuesday, January 07, 2003 7:34 AM
To: Multiple recipients of list ORACLE
to suggest something, so I've CC'ed them.
I have my own law on ora-600s: If you supply all the required
information (tracefiles, alertlogs, repro-case, etc.) chances are
Support is not gonna need them. If you miss out just one of those
things, chances are Support will tell you they cannot proceed
Usually (if i remember right), it happens when fetching across commits.
joe
Gurelei wrote:
HI.
Does anyone have any info regarding ora-1002 error
fetch out of sequence? All the info I've found on
the MEtalink is referring to a PL/SQL or a select for
update. All I'm doing is select from
HI.
Does anyone have any info regarding ora-1002 error
fetch out of sequence? All the info I've found on
the MEtalink is referring to a PL/SQL or a select for
update. All I'm doing is select from table@dblink
and I'm getting ora-1002. I set autocommit off, but
this didn't help. Does anyone have
and database ??
Kevin
-Original Message-
Sent: Tuesday, January 07, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L
HI.
Does anyone have any info regarding ora-1002 error
fetch out of sequence? All the info I've found on
the MEtalink is referring to a PL/SQL or a select for
update. All
.
Does anyone have any info regarding ora-1002 error
fetch out of sequence? All the info I've found on
the MEtalink is referring to a PL/SQL or a select
for
update. All I'm doing is select from table@dblink
and I'm getting ora-1002. I set autocommit off, but
this didn't help. Does anyone
stuff as far as I remember. Other than that, I know
that Peter Gram and Bjorn Engsig (among a lot of other guys) might be
able to suggest something, so I've CC'ed them.
I have my own law on ora-600s: If you supply all the required
information (tracefiles, alertlogs, repro-case, etc.) chances
Hi all,
I hit by this error
ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0],
[54173017], [16781180], [], []
Can you help me where to find info about this error
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET
Sinardy
ORA-0600 is really an encoded message from Oracle that reads :
'Thank you for helping find yet another bug in our software. You can now
release your sphincter (some herbal tea might help), especially if this has
cropped up in production. We suggest you do not try to solve this one
can open the database. You need to rebuild the database after force
opening.
KG
--- Sinardy Xing [EMAIL PROTECTED] wrote:
Hi all,
I hit by this error
ORA-00600: internal error code, arguments: [2662], [0], [54151123],
[0],
[54173017], [16781180], [], []
Can you help me where
Other than the allow_resetlogs_corruption, _disable_logging also will
greet you with OERI-2662 if the shutdown is not normal.
KG
--- Sinardy Xing [EMAIL PROTECTED] wrote:
Hi all,
I hit by this error
ORA-00600: internal error code, arguments: [2662], [0], [54151123],
[0],
[54173017
Center
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 06, 2003 7:34 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I hit by this error
ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0],
[54173017], [16781180], [], []
Can you help me where
recommended running dbverify on all datafiles tomake sure all files are
clean on disk.
IMPORTANT
==
These parameter may help later determine what cause the ORA-600 [2662] (and it's not
for certain that a cause can be found). They parameters does have some performance
overhead
Title: RE: ORA-1410 Silliness
Vladimir,
Thanks for your reply.
I have tested the cursor. It does not include any bind variables.
There are no broken rowids, as all objects passed analyze ... validate structure cascade.
I also tested the scenario you describe in your code below. The code
Title: ORA-1410 Silliness
Hi
Waleed,
No. This is the name of the package.
Thanks
Lisa
-Original Message-From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 3:04
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
I see
Title: ORA-1410 Silliness
Lisa,
This is probably nottrue ...
Oracle doesn't, has never been able to pinpoint exact line number (in
cases such as these) especially with pl/sql packages. I believe the problems can
be found by executing following query ...
select line, type, source
from
Nope...
-Original Message-From: ora ak
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
Did u do any migration recently .
"Koivu, Lisa" [EMAIL PROTECTED] wrote:
Title: ORA-1410 Silliness
Lisa,
I know
someone else may have suggested this, but I am thinking that maybe you do need
to rebuild the index that was being used by the query. It could be you
have a bad index that still has an entry for a record, but the record does not
exist? Sounds
Title: RE: ORA-1410 Silliness
Amount of data, definately. This table grows by ~2.5GB weekly. Have you ever seen data volume begin to cause problems?
Thanks Rachel
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 5:05 PM
Title: ORA-1410 Silliness
Is the
error reproducible if you replace the bulk insert with regular
insert?
Waleed
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02, 2003
8:14 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: ORA
Title: ORA-1410 Silliness
Lisa
I dont recollect exactly
but I think I have seen this happen when you start getting too close to the
max_open_cursor limit... something like Oracle cant open a cursor as it is at
the max limit and a fetch call might be issued..
Checkyr
max_open_cursor limit
recipients of list ORACLE-LSubject:
RE: ORA-1410 Silliness
Nope...
-Original Message-From: ora ak
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
Did u do any migration
ORA-8103 or ORA-1410. The application should reissue the query if
one of these errors is returned.
Queries that use a partitioned index, and that start with some of
the index partitions marked as INDEX UNUSABLE, return an error when they
actually access one of these partitions for the first time
total speculation since I'm not a PL/SQL expert -- could the amount of
data you are manipulating in the stored procedure somehow blow out
available memory?
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
Amount of data, definately. This table grows by ~2.5GB weekly. Have
you
ever seen data volume
Title: ORA-1410 Silliness
Hi
Raj,
Thanks
for your reply. I always suspected that the line numbers were wrong but
since I couldn't say decisively why I had to rely upon what the gui's told me
(darn gui...) You proved it. That line is actually pointing to my generic
error logging proc
Title: RE: ORA-1410 Silliness
Not at this point. I believe when the pl/sql tables get too big it blows up with ora-4031 or one of the common memory errors, I've seen it happen before. I may have only a stupid windows machine, but I have so much RAM... kudos to the brilliant people who didn't
Title: ORA-1410 Silliness
Lisa,
The answer is very, very simple...Don't take a
day off! No day off...no error...no failed
loads...
Seriously, it sounds like either an index corruption (temporary) or an oracle
bug. Is there anything in the alert log or in trace files? Try setting a trap
Title: RE: ORA-1410 Silliness
I am no pl/sql expert either, but me think that would cause a ORA-4031 ... been there ... done that ... before I learned to code in a better way.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni
Title: RE: ORA-1410 Silliness
Lisa,
try to see if you can (I think you should) use
dbms_session.free_unused_user_memory ... this is very handy for
applications where large pl/sql tables (oops ... arrays) are used
frequently.
Raj
to use
LDAP are welcome.
David
-Original Message-From: ora ak
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 1:59
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
ORA-28030: Server encountered problems accessing LDAP directory
service
Looks like are trying
Title: RE: ORA-28030: Server encountered problems accessing LDAP directory service
Yes. This was indeed the case. I was using
"current_user" to create the link. I just dropped and re-created the link
using an named user account and the link works fine now. Thanks for the
quic
Title: RE: ORA-1410 Silliness
Thanks
again Raj. I will definately look into it.
Lisa
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 02,
2003 11:39 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: ORA-1410 Silliness
Lisa
. I've read some messages of this thread -- there is 100% probability :)
that you incorrectly identified the statement which errors 1410.
PL/SQL engine could not point to the line 1970 -- it's in the middle
of the statement -- something is strange there. Do you handle exceptions
in your
Title: RE: ORA-1410 Silliness
Vladimir, you are 100% right :)
Thanks for your reply.
Lisa
-Original Message-
From: Vladimir Begun [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 1:48 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-1410 Silliness
Lisa
Jamadagni, Rajendra wrote:
Lisa,
This is probably not true ...
Oracle doesn't, has never been able to pinpoint exact line number (in
cases such as these) especially with pl/sql packages. I believe the
problems can be found by executing following query ...
select line, type, source
Jamadagni, Rajendra wrote:
Oracle doesn't, has never been able to pinpoint exact line number (in
Can you please prove it? Do not you think that this statement
contradicts to the sql query you provided below. :) There is
quite some difference with GUI which pulls/[s]pools PL/SQL code
out and
Title: ORA-24370 illegal piecewise operation attempted
In development, we suddenly hit this error today. This is coming from a SQR report that tries to insert a record into a financials database (8.0.5).
From one instance it works fine, from another it returns this error. These two instances
Title: RE: ORA-1410 Silliness
Okay ... I need to be clearer ... this is because editors have no concept of line-of-code that Oracle uses. For Oracle one 3 page insert statement is one statement, whereas an editor will treat it as a bunch of line numbers (when it encounters a linefeed
Title: ORA-1410 Silliness
Hello all,
8.1.7, Windows 2000 SP2
Here's the error:
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at ELVIS.CLEANUP_VEGAS_PK, line 1970
ORA-01410: invalid ROWID
ORA-06512: at line 1
Has anyone seen this error before? I run into this error
Lisa,
Tuesday, December 31, 2002, 7:43:54 AM, you wrote:
KL Usually when this happens I can re-fire the load and it will
KL complete, no problem. It's a big annoyance and it seems like every
KL time I take a day off it happens.
How does it know you are taking a day off? Maybe you shouldn't set
Title: ORA-1410 Silliness
Sounds
like another Elvis sighting!!
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002
7:44 AMTo: Multiple recipients of list ORACLE-LSubject:
ORA-1410 Silliness
Hello all,
8.1.7, Windows 2000 SP2
Title: ORA-1410 Silliness
Is
there a column with a datatype of rowid?
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002
6:44 AMTo: Multiple recipients of list ORACLE-LSubject:
ORA-1410 Silliness
Hello all,
8.1.7, Windows
Title: ORA-1410 Silliness
Elvis? No way. It's got to be a Raelian
clone.
Ken Janusz
- Original Message -
From:
Farnsworth, Dave
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, December 31, 2002 8:34
AM
Subject: RE: ORA-1410 Silliness
Sounds like
Title: ORA-1410 Silliness
Nope... nothing named rowid.
-Original Message-From: Orr, Steve
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:29
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
ORA-1410 Silliness
Is
there a column with a datatype of rowid
Title: RE: ORA-1410 Silliness
Yea, yea, well... my environment here leaves a lot to be desired :) Heck my database isn't even being BACKED UP aside from the backups I scream for. Don't even ask.
As an aside that I forgot to mention: I am not using FOR UPDATE OF in any of my procedures
Title: ORA-1410 Silliness
But "cloned" rows ought to have different rowids ...
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't reflect that o
Title: ORA-1410 Silliness
Lisa,
What is your cursor doing?
Perhapsrow-migration is occuring thus causing the rowid to become
invalid?
Tom Mercadante Oracle Certified Professional
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002
of list ORACLE-LSubject: Re:
ORA-1410 Silliness
Elvis? No way. It's got to be a Raelian
clone.
Ken Janusz
- Original Message -
From:
Farnsworth, Dave
To: Multiple
recipients of list ORACLE-L
Sent: Tuesday, December 31, 2002 8:34
AM
Subject
Title: ORA-1410 Silliness
If I
had a Raelian clone for a sysadmin I would have less problems than I do
now. GRRR
-Original Message-From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 9:59
AMTo: Multiple recipients of list ORACLE-LSubject: Re
Title: ORA-1410 Silliness
Hi
Tom,
Row
movement is disabled on this table. Cursor is only selecting from a raw
data table, formatting/cleaning up data and loading it into a temp table (which
also passed analyze table cascade) and then the temp table is swapped into the
proper partition
Title: ORA-1410 Silliness
How
about posting the table structure and the lines around 1970 in the Elvis
package.
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002
9:04 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: ORA
Title: RE: ORA-1410 Silliness
Actually if you had a clone of your SA, you might have twice as many problems.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
If I had
Title: RE: ORA-1410 Silliness
Anything with a Materialized View??
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't reflect that of ESPN Inc.
QOTD: Any
Title: ORA-1410 Silliness
You
asked for it. Here goes. It is partitioned on julian_run_date.
Please don't hammer me about the design. I wasn't given a chance to
improve on it. It is basically a mainframe file that I have stored history
of.
SQL desc
vegas_martName
Null? Type
Title: RE: ORA-1410 Silliness
Hi
Raj,
No
materialized view. That would be too high-tech for this company. And
it might kill Elvis more than once.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31,
2002 10:49 AMTo: Multiple
Lisa,
I am joining this thread late - so apologies if my suggestion has already
been looked into !
The first error message is ORA-01001 (Invalid Cursor). There is an article
on MetaLink (1007395.6) about the various causes for this error. Have you
read this article and verified
Title: ORA-1410 Silliness
Very
straight forward. and LONG . (Yea, I read to your last
message).
Could
that be the issue here ?? Is the record too long or some buffer
being overwritten in Oracle when there is so long of record and so much data
?? Have you tried (or do you already
dumb question -- did you extract the insert statement and run it in
sqlplus? Does it run there or does it go boom as well?
--- Koivu, Lisa [EMAIL PROTECTED] wrote:
You asked for it. Here goes. It is partitioned on julian_run_date.
Please
don't hammer me about the design. I wasn't given a
Title: ORA-1410 Silliness
Well,
I don't think that's the issue. I'm issuing bulk inserts and using pl/sql
tables in this procedure. That functionality has been in place since
February and these errors only started surfacing in the last couple of months.
I
could decrease the commit
Title: RE: ORA-1410 Silliness
Yes, I do exchange partition but the error happens long before I hit the procedure that does that. It blows up on the load.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 1:44 PM
To: [EMAIL
Title: RE: ORA-1410 Silliness
I just read it and most of these scenarios are specific to OCI. This is straight pl/sql. However I did check max open cursors (I believe that's a different error, I've seen that one before) and that's not the problem.
I may be wrong, but when an error happens I
Title: ORA-1410 Silliness
I see "ELVIS.CLEANUP_VEGAS_PK" in the error message. Is it the primary
key index for a table?
If yes, then it
may need to be rebuilt.
Regards,
waleed
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31,
Title: RE: ORA-1410 Silliness
Hi Rachel,
Just tried it and it works. Thanks for your suggestion.
Lisa
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-1410
Lisa
. Enable SQL tracing
. Launch your code
. Identify (exactly) the cursor which fails
with ORA-01410 and what bind vars are.
. Pull out the statement from your code
. Run it in 'standalone' mode
. If it fails identify rowids which look broken.
Check the phys. entities those rowids point
:
ERROR at line 1:
ORA-28030: Server encountered problems accessing LDAP directory service
Earlier I had a TNS error and found that my tnsnames.ora file was
missing one of my instances. I fixed that problem and tnsping now
responds correctly but I'm still getting the error listed on the subject
ecember 31, 2002 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness
Very straight forward. and LONG . (Yea, I read to your last message).
Could that be the issue here ?? Is the record too long or some buffer being overwritten in Oracle when there is so long
nt and can successfully create thelink but when I try to do a "select from table_name@linked_db;" I getthe following error:ERROR at line 1:ORA-28030: Server encountered problems accessing LDAP directory serviceEarlier I had a TNS error and found that my tnsnames.ora file wasmissing one of m
Okay this means that the statement itself, which is being pointed to by
the error line, is not the real culprit. Unfortunately, I don't know
of a good debugger for PL/SQL that lets you step through line by line.
let me rephrase that, I know of no freeware one :)
since you say this has only
?
$oerr ora 07445
Cause: An OS exception occurred which should result in the creation of a
core file. This is an internal error.
Action: Contact your customer support representative.
and
$oerr ora 1242
Cause: The database is in NOARCHIVELOG mode and a database file was
detected
Shuan,
Can't
tell you what exactly to do, we will need more detailed information than just
two ORA codes.
Your
database can't read one of your data file and that could be because of many
things.
Your
database is in NOARCHIVELOG mode, and this means that you have no protection
against
Dear all DBAs,
What is this error suppose to mean?
$oerr ora 07445
Cause: An OS exception occurred which should
result in the creation of a core file.
This
is an internal error.
Action: Contact your customer support
representative.
and
$oerr ora 1242
Cause: The database is in NOARCHIVELOG
You might want to look at dbms_system.set_ev
Parameters:
sid
serial
event number
level
event name -- leave null in your case
.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see
the database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 20, 2002 8:48 AM
I received ORA-04031 while exporting database. Can someone explain what
causes it and how to fix it?
. exporting post-schema procedural
Title: RE: ORA-04031
Hi David,
I ran into this too. Try the following:
1. flush shared pool, re-execute
2. bounce database.
IN addition if you search on this on Metalink you will find lots of info.
HTH
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut
to
8.1.7.4 where it's supposedly fixed.
This from Metalink (didn't copy the ID of the doc I found this in):
If you are receiving ORA-4031 errors which reference BAMIMA: Bam Buffer,
please apply the 8.1.7.4 patchset. It is possible that you are hitting bug
2104071 which is fixed in that patchset.
Jack C
database at
8.1.6.3). We have been able to generate most of the errors that we want to
monitor for, but have been unable to generate an ORA-600. Does anyone have
a way of doing this?
TIA.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
--
Please see the official ORACLE-L
I am working on figuring out an error in an application caused by
dynamically generated sql. I've set init parameters in the past to
generate a trace file for a specific error and its been very helpful in
finding the source of this sort of error.
Is there a way to run this sort of trace on a
All,
We have been opening our standby database readonly
on alternate hours for reporting but today it suddenly crashed with following
errors and now we can not open it read only. We are runnign 9013 on solaris7.
Has anyone else experienced it?
Per oracle support there is a know bug
We are trying to test out monitoring software (on a test database at
8.1.6.3). We have been able to generate most of the errors that we want to
monitor for, but have been unable to generate an ORA-600. Does anyone have
a way of doing this?
TIA.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
an ORA-600. Does anyone
have
a way of doing this?
TIA.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ball, Terry
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
Title: RE: Faking an ORA-600
dbms_system.ksdwrt(2,'abc2_ora_2269266.trc:ORA-00600: internal error code, arguments: [794], [0x700189CDE40], [0x700189CDF08], [0x700189D0398], [4294967295], [], [], []');
Basically put anything in the string ...
Lather , rinse, repeat.
Raj
601 - 700 of 2137 matches
Mail list logo