We are thinking about switching to this version on windows OS.
We use:
Rman
Advance replication
OID
Partitioning
Bit map indexes
Any pro / cons about this version?
The other option is 9.2.0.1.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
Hi
Anyone has used Oracle under Solaris/Sun C++ compiler . If yes please mail me how and on whichversion.
Sunil AroraSunil AroraVichara TechnologiesDo you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Brings to mind some of the great hammer quotes:
When all you have is a hammer, everything tends to
look like a nail
When all you have is a hammer, maybe brain surgery is
not for you
:-)
Connor
--- Tim Gorman [EMAIL PROTECTED] wrote: Tales Of
Big Hammer #10046 (AKA event
10046)Generally
Title: Tales Of Big Hammer #10046 (AKA event 10046)
Tim,
I don't see that ... I know this sql caused the problem
...
===
PARSING IN CURSOR #54 len=238 dep=1 uid=44 oct=3 lid=44
Hi DBAs,
Oracle Server 8.1.6 Win 2000 Oracle Names
I have the following Oracle clients installed locally. I connect to the
server using the same USER. When I describe
a package and procedure with package I get different results depending on
the client.
Any ideas what is going on here
8.0.5
Title: Tales Of Big Hammer #10046 (AKA event 10046)
Raj,
Thanks for sharing this with us. In your original
post you mentioned that you saw a "rollback" right after the "SQL*Net
break/reset to client" and that was how you figured out the 1403 error. I don't
see that in this excerpt from the
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
Title: Tales Of Big Hammer #10046 (AKA event 10046)
Arup,
Since I didn't see a line reporting error 1403, I was puzzled for a bit.
But here is the application knowledge came handy. I should have see a commit for
a successful operation. I didn't and instead saw a ROLLBACK. Immediately before
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
Raj,
The application may have interpreted this as ORA-01403, but
I've no clue as to why the SQL*Net break/reset to client
occurred. You can see about 7 seconds of wait for response
from the client, after which a rollback occurs...
The FETCH shows r=1 indicating that at least one row was
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
see, now that answers my question! I haven't done any work at all with
object tables so I haven't seen any of this
thanks Arup!
--- Arup Nanda [EMAIL PROTECTED] wrote:
In case of object tables, the constraints are defined on the most
primitive
of the objects. For instance, you have a table
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 of ESPN Inc.
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
Title: Message
So
they figured out the memory/personality transfer too?
John P WeathermanOracle Database
AdministratorReplacements, Ltd.
-Original Message-From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 9:59
AMTo: Multiple recipients of
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: RE: Tales Of Big Hammer #10046 (AKA event 10046)
Hmmm Tim, you really got me thinking ...
1. Support person ran the form.
2. Hit the error
3. Exited the form.
Now point 3, will issue a rollback (Oracle Forms) so is that why we see two rollbacks in the trace file? The SQL is
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 in
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:
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 a
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
Jared what exactly U use Veritas Netbackup fr in Ur
backup strategy. I use rman to take backup on disk.
Please describe the role of veritas NB in detail and
if u can send me example script to perform what tasks,
that would be gr8.
OraCop
Jared
--- Jared Still [EMAIL PROTECTED] wrote:
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?
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
You must purchase the NBU for Oracle option to use
RMAN with NBU.
Nothing special from the RMAN side. The SBT_TAPE
device is now routed to NBU.
Not quite that simple in reality, as the backups now become
part of the NBU environment, and you must setup NBU
policies, schedules, etc.
Jared
Rick -
Are all of the sqlnet.ora files resolving hostnames in the same order
i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)? I'd also
check for a rogue tnsnames.ora file in the same path as the executable.
Brian
--
| Brian McGraw /* DBA */
Question for the group;
If there are no listservers/mail lists specific to 9iAS/'managing Oracle
from a System Admin POV' ... would there be an interest in subscribing to
such a list?
I've learned a LOT from this list, but I'd estimate 60% - 70% of the content
is of no interest to me at all, as
I'm spending some time today experimenting with buffer pools in 8.1.7. I have two
tables that I have assigned to the RECYCLE pool. I have been running various queries
that perform full table scans, then checking the buffers to see what gets aged out.
During my testing, it seems like the first
OraCop
If you invest in the option, you might consider purchasing the book
Oracle9i RMAN Backup Recovery by Robert Freeman
It has a chapter on configuring VERITAS NetBackup.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday,
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 that the
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
Brian,
Yes I have checked all of this. Three other co-workers are having same
problem except they just have the one Oracle client 8.1.7. It
appears to be client related.
Thanks
Rick
Hi All,
the following function gives invalid lob locator specified.
b has been initialized to empty_clob()
begin
dbms_lob.copy(a,b,DBMS_LOB.GETLENGTH(b),1,1)
exception
when others then
dbms_output.put_line('error');
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
Veritas has a central tape system for open systems.
You use the product to backup all your data into this tape system, not to
disk or local tape.
Veritas NetBackup has an agent that allows RMAN to open channels to this
tape system and backup the database to it.
We backup all our systems to it and
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
All,
Yesterday we increased db_files from 200 to 500 and
recieved following message in alert log.
Oracle instance running on a system with low open
filedescriptor limit. Tune your system to increase thislimit to avoid
severe performance degradation.
Our file descriptors is set to 1024.
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, 2002
Found following on metalink but this does not
explain why we never saw the message when we were running on 64 descriptors and
200 files
From: Oracle, Giridhar Tatavarty
02-Jan-02 08:29 Subject: Re : Get msg 'Oracle instance running on
a system with low open file descriptor limit. Tune your
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
I've recently inherited an Oracle 8.1.6 system and was just trying to
setup a database link between two instances. I've granted the create
database link priv to the user account and can successfully create the
link but when I try to do a select from table_name@linked_db; I get
the following
Did u do any migration recently .
"Koivu, Lisa" [EMAIL PROTECTED] wrote:
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
Looks like are trying to resolve service name using LDAP naming .
David Mitchell [EMAIL PROTECTED] wrote:
I've recently inherited an Oracle 8.1.6 system and was just trying tosetup a database link between two instances. I've granted the "createdatabase link" priv to the user account and can
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
Brian and Michael,
Try some of the ODTUG list-servers at ODTUG
(http://www.odtug.com/subscrib.htm). 9iAS is discussed quite frequently (and
not always fondly ;)) on the DEV2K list as well as some of the others such
as the WEB and JAVA lists.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
Which u all a very very
happy new year
Anand
KumarDBA
ITW Signode India
Ltd
53 matches
Mail list logo