Skip to contentSkip to conversation

ORACLE and 2.4-test10

DISCUSSION dalecki 6 participants 9 messages Nov 17, 2000 – Nov 18, 2000

lore
Share & tools
lore

dalecki

author
#0 lore raw

Can anybody on tell me whatever there are still serious pitfalls in running Oracle-8.1.6.1R2 on the current testing version of the 2.4 kernel series? If I rememeber correctly there where some problems with SHM handling still left to resolve...

Thank's in advance for any response!
-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to [email protected]
Please read the FAQ at http://www.tux.org/lkml/

#2 lore raw
In reply to dalecki
Quoted 2 lines

Can anybody on tell me whatever there are still serious pitfalls in running Oracle-8.1.6.1R2 on the

Yes.

Quoted 2 lines

If I rememeber correctly there where some problems with SHM handling still left to resolve...

SHM is resolved but O_SYNC is not yet fixed. You could therefore easily lose your entire database

-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to [email protected]
Please read the FAQ at http://www.tux.org/lkml/

#3 lore raw

Alan,

When we ported Oracle to NetWare, we found that making changes to the core file systems in NetWare that Oracle needed would tank FS performance, so we came up with something called direct FS, a separate File System interface just for Oracle. The SOSD layer inside of Oracle allows them, via simple config statements, to redirect to different file systems, even specialized ones, so this is trivial for them to instrument. The whole O_SYNC thing accross the entire OS could be problematic to support.

In NetWare, directFS was little more than a "raw" interface that bypassed the file cache. It would be like having an API to a direct physical file system that never cached data in the buffer cache. In Linux, this may be tough to pull off, but Al Viro could instrument a raw_read, raw_write function table entry that would do something similiar that would allow Oracle to detect if an FS had a raw mode, since this is what they actually need.

My 2 cents anyway.

8)

Jeff

Quoted 9 lines · Alan Cox
Quoted 3 lines

Can anybody on tell me whatever there are still serious pitfalls in running Oracle-8.1.6.1R2 on the

Yes.

Quoted 2 lines

If I rememeber correctly there where some problems with SHM handling still left to resolve...

Quoted 7 lines

SHM is resolved but O_SYNC is not yet fixed. You could therefore easily lose your entire database

-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to [email protected]
Please read the FAQ at http://www.tux.org/lkml/

-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to [email protected]
Please read the FAQ at http://www.tux.org/lkml/

#4 lore raw
Quoted 2 lines

performance, so we came up with something called direct FS, a separate File System interface just for Oracle. The SOSD layer inside of Oracle

Yeah but you see thats ugly

Quoted 3 lines

In NetWare, directFS was little more than a "raw" interface that bypassed the file cache. It would be like having an API to a direct physical file system that never cached data in the buffer cache. In

Its called O_DIRECT and kiovecs. Its already there. Much more generic than an 'oraclefs'

Alan

-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to [email protected]
Please read the FAQ at http://www.tux.org/lkml/

#5 lore raw
Quoted 4 lines · Alan Cox
Quoted 3 lines

performance, so we came up with something called direct FS, a separate File System interface just for Oracle. The SOSD layer inside of Oracle

Quoted 8 lines

Yeah but you see thats ugly

Quoted 3 lines

In NetWare, directFS was little more than a "raw" interface that bypassed the file cache. It would be like having an API to a direct physical file system that never cached data in the buffer cache. In

Its called O_DIRECT and kiovecs. Its already there. Much more generic than an 'oraclefs'

Then they should have what they need. If they have an SOSD plugin, no reason
it shouldn't run.

8)

Jeff

Quoted 7 lines

Alan

-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to [email protected]
Please read the FAQ at http://www.tux.org/lkml/

-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to [email protected]
Please read the FAQ at http://www.tux.org/lkml/

#6 lore raw
In reply to dalecki
Quoted 2 lines · Alan Cox

SHM is resolved but O_SYNC is not yet fixed. You could therefore easily lose your entire database

I assume 2.2.18-pre-latest is ok?
Some oracle doc still refers to 2.0.34

Signature · 5 lines
Frank
-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
the body of a message to [email protected]
Please read the FAQ at http://www.tux.org/lkml/
#7 lore raw
Quoted 5 lines · Alan Cox
Quoted 2 lines

SHM is resolved but O_SYNC is not yet fixed. You could therefore easily lose your entire database

I assume 2.2.18-pre-latest is ok?

I certainly hope so 8)

Alan

-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to [email protected]
Please read the FAQ at http://www.tux.org/lkml/

#8 lore raw
In reply to dalecki

Frank,

You must be looking at Oracle 8.0 docs. If you are looking to update a production system we only support stable kernels. Pre kernels are not yet really stable and therefore not supported. (We had to draw the line somewhere.)

That said, we will look into O_DIRECT and kiovects. We may be able to do some performance testing on that.

Regards,

Quoted 7 lines · Frank van Maarseveen
Quoted 2 lines · Alan Cox

SHM is resolved but O_SYNC is not yet fixed. You could therefore easily lose your entire database

I assume 2.2.18-pre-latest is ok?
Some oracle doc still refers to 2.0.34

Quoted 6 lines

--
Frank
-
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to [email protected]
Please read the FAQ at http://www.tux.org/lkml/

--
=======================================================================

  Josue Emmanuel Amaro                         [email protected]
  Linux Products Manager                       Phone:   650.506.1239
  Intel and Linux Technologies Group           Fax:     650.413.0167

=======================================================================

begin:vcard
n:Amaro;Josue Emmanuel
tel;cell:650-245-5131
tel;fax:650-413-0167
tel;work:650-506-1239
x-mozilla-html:FALSE
url:http://www.oracle.com
org:Intel and Linux Technologies
version:2.1
email;internet:[email protected]
title:Sr.Product Manager - Linux
adr;quoted-printable:;;500 Oracle Parkway=0D=0AMS1ip4;Redwood Shores;CA;94065;United States fn:Josue Emmanuel Amaro
end:vcard