That is your problem.
From the doc in metalink:
Oracle client version 9.2.x is not certified and cannot
connect toOracle RDBMS version 7.3.x.
Yechiel AdarMehish
- Original Message -
From:
John
To: Multiple recipients of list ORACLE-L
Sent: Sunday, November 30, 2003
Hi all,
Oracle Forms Reports patch 15 is certified with Oracle 9.2 (according
to Metalink).
Does that mean that Forms are certified against RAC too?
Can anyone confirm that, having/knowing any working RAC9.2+Forms6i
environments?
Thanks,
Bruno Vanters
Junior Oracle DBA
--
Please see the
Hi All,
I am running a big batch reporting program that does way
too much SQL (but that's another story)
and when I profile the trace file apart from one pice of
SQL all the others are only doing 1 block reads.
As you can see from the example below it did 63,209
physical IO calls and they
Hi,
RAC is just a database option. If RDBMS 9.2 is certified against a
product means, 9.2 RAC is also certifid on that product. But all the
RAC features may not work with the certified option.. (Is it too
confusing?!(
Okay.. The TAF feature in RAC (okay... it is not a RAC feature!!) will
not
Actually I am having a problem connecting from Forms or even from
sqlplus 8.0.6 to RAC. Connection to RAC database or to single instance
from RAC ends with generic windows error. Oracle trace shows succesful
connection, folloved by errors 12560 and 12203. Oracle 9.2 clients are
working with no
Sami, Yes. It is my purpose.but the xmlspy (in home version) says
that the file is invalid.something wrong ?
- Mensagem Original De:
"Sami" [EMAIL PROTECTED]Para: "Multiple recipients of
list ORACLE-L" [EMAIL PROTECTED]Assunto: RE: XML
SctructureData: 30/11/03 11:24More than one
Title: Message
I got an e-mail from developer with more details.
Hope this information is useful
Full description of the exception being thrown
is included below:
java.lang.ClassFormatError: __Proxy0 (Illegal UTF8
string in constant pool)at java.lang.ClassLoader.defineClass0(Native
I would like to thank Jared for allowing me to post this on the list.
We have an opening for a Software Engineer/DBA in southwest Ohio. Our
software can use Oracle or SQL Server for the database engine. Front end
is MS tools (Visual Basic, VBC++, C, C++ and .NET.) Basic information
from HR is
im assuming this means you want a software engineer who knows a little oracle right?
you cnat be an expert in both.
Ive seen more and more jobs like this and less and less oracle specialist positions.
Its troubling.
From: Dave Phillips [EMAIL PROTECTED]
Date: 2003/12/01 Mon AM 08:59:25 EST
I've used Apps 11.5.8 on RAC, so I know the 8.0.6 stack will connect just
fine to 9.2.0, RAC or no RAC.
For your debugging, you are going to have to work your way into it, starting
from the most basic level. Start from tnsping then sqlplus and work
your way up to the Forms and stuff, not the
Ian,
Index Range Scans are single block i/o (fast full scans use multiblock
i/o). This is why you are seeing the high number of single block reads.
If you want to use multiblock reads, use full table scans or fast full
index scans. Be warned, response time could drop dramatically (along with
CURSOR_SPACE_FOR_TIME is FALSE.
This is an Oracle Apps R11 install.
Hemant
At 05:29 AM 30-11-03 -0800, you wrote:
What's
the value for your cursor_space_for_time parameter?
Tanel.
- Original Message -
From: Hemant K
Chitale
To: Multiple recipients of
list ORACLE-L
Sent: Sunday,
Hi John,
In Metalink , Note
207319.1,"Connections from Oracle 9.2 to Oracle 7 are not supported
anymore"
This includes any form of oracle 9.2 client such as
* clients statically linked
* clientsdinamically linked
* db links.
Mariano.
- Original Message -
From:
John
Hi all,
we upgrade 8.1.7 to 9.2.0.4 on RAC with 4
node
we live performance problem. and to take ora-01652
temporary extent error.
there is one temporary 25 GB before as default
temporary tablespace.
now new create temporary tablespace 25 GB on rawdevice
and all user seting new temporary
hey guys
-
Working on some
replication efforts.. And I haven't used EMC Timefinder to push data from one DB
to another.. Are there any documents with the details available? I'm working on
getting thru the EMC web site as well as metalink, but wanted to throw this out
on the list since
YES. Do you have specific questions???
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Loughmiller, Greg
[mailto:[EMAIL PROTECTED]Sent: Monday, December 01,
2003 1:54 PMTo: Multiple recipients of list
ORACLE-LSubject: Anyone used EMC Timefinder
--_=_NextPart_001_01C3B825.DE0C531A
Content-Type: text/plain
you may want to raise a call with Oracle support about this. We have an call
open with them at present and they have raised a bug for us. We were
noticing the same thing as you experienced on AIX 5L 9i RAC 9.2.0.3.
Apparently
Its
simply a hotbackup snapshot... so just lookup the cloning proceedure from
Hotbackup and you are done.
Brian
Spears
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Loughmiller, GregSent:
Monday, December 01, 2003 1:54 PMTo: Multiple
Anybody know what the blocks in x$bh are that don't map to rows in
DBA_OBJECTS? I have 172 objects in x$bh that I can't account for.
SQL SELECT count(obj), count(object_id)
2 FROM (SELECT DISTINCT bh.obj, ob.object_id
3FROM sys.x_$bh bh,
4 dba_objects ob
5
Steve,
I am not sure about all of the objects, so this is a partial answer.
x$bh.obj = 0 seems to be an unused(?) block. Undo segments have an
extremely high value (4294967295) in my test db.
Have you tried associating the block/file info in these phantom cache
objects to block/file info in
Definition of the DBA_OBJECTS is:
select u.name, o.name, o.subname, o.obj#, o.dataobj#,
decode(o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE',
7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE',
Here is what oracle can give you about type=3:
SQL select name from sys.obj$ where type#=3;
C_FILE#_BLOCK#
C_TS#
C_USER#
C_COBJ#
C_OBJ#
C_MLOG#
C_RG#
C_OBJ#_INTCOL#
C_TOID_VERSION#
SMON_SCN_TO_TIME
On 12/01/2003 04:29:36 PM, Steve Rospo wrote:
Anybody know what the blocks in x$bh are that
Environment: Oracle 8.1.7.4 on RedHat AS2.1
I'm in the process of preparing to convert a 90M row table from
heap-organized to index organized. I think I've pretty well got a
formula for doing the actual table conversion. It's a very basic
table, four NUMBER columns, with a PK on the first
There are two possibilities:
1) You are hitting a well known bug which doesn't allow you to turn
on 10046 by using set_ev or alter session. The only way to actually do
it is to use oradebug.
2) Your trace files are with Saddam Hussein.
On 12/01/2003 05:04:25 PM, Thomas A. La Porte wrote:
You should be joining the obj column
to the dataobj# column of obj$.
(that's data_object_id in dba_objects
rather than object_id). Unfortunately it
is a non-indexed join, so can be a little
inefficient.
This is also going to give you some funny
numbers because logical objects (obj#) can
Here's something that may or may not be happening. It's something I ran into when
working with traces. Have you mv'd or rm'd any of your trace files? The reason I ask,
is because while doing some tracing of a certain session on Solaris recently, I began
the tracing, turned it off, and then mv'd
Though I'm intrigued by (2), I'm humbled by the missing (3)
option which you did not consider. That is that *I* had one too
many 0's in my trace event: it's 10046, not 100046! Your post
pointed out my typo, many thanks.
Serves me right for cutting and pasting into different sessions,
so that
You
can generate DTD based on below XML (kind of reverse engineering).
Then
see the diff between the generated DTD and your original
DTD.
?xml
version="1.0"?!-- Exemplo de XML
Endereco--lista_enderecoenderecotitulo
rodolfo do Carmo
List ,
I would like to know whether my database is running on
shared server (MTS) or dedicated server mode ?
How do i find it out ?
it's oracle 9.2.0.3 on Win2k.
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL
Your database is not running on either share or dedicated session mode. Your
sessions are connecting to either a dedicated server or a shared server. You can
have a mix as well. Some sessions may be connecting to dedicated servers while
others may be utilizing shared servers. It doesn't sound
hey guys -
Working on some replication efforts.. And I haven't used EMC Timefinder
to push data from one DB to another.. Are there any documents with the
details available? I'm working on getting thru the EMC web site as well
as metalink, but wanted to throw this out on the list since
Another possiblity is that file has once generated a trace file and you accidently rm
that file.
As the file is still opened by this session, the session still write the trace
content to that rmed tracefile, so you are unable to read that file.
You can use lsof -p $SPID to identify
Hi, list friends:
We are using partition to archive history data in our production OLTP database. We
get great performance gains(Far less disk io), but we also hit performance trouble
sometimes. So I am here ask for your experience.
We used local index on all partitioned tables.We
Other reasons why the obj# and dataobj#
may differ are - truncation or moving of tables,
and probably some of the maintenance operations
on partitioned tables.
Just one small addition, when rebuilding an index, its dataobj# is changed
as well..
Tanel.
--
Please see the official ORACLE-L
34 matches
Mail list logo