Welcome! Wikis are websites that everyone can build together. It's easy!

Database

Oracle11g DatabaseOracle10g DatabaseOracle9i Database

Oracle provides a number of useful links on OTN for people wishing to get started with the Database.

Notably the database homepage with links to download the Oracle Database, which may be freely used for self-education, and the online and downloadable Oracle Database documentation set.If you have a valid license for Oracle you can also download the software from Edelivery.oracle.com for production purposes.

The latest version of the Oracle database is 11g (homepage on this wiki here), released in August 2007 for the Linux 32bit platform and in October 2007 for Windows 32bit and Linux 64bit, now available also for Solaris, AIX and HP-UX. This is scheduled to become available for other Operating Systems by the end of 2007. The latest version that has been fully released is 10gR2 (homepage on this wiki here).

Release 9iR2 (homepage on this wiki here) is the oldest supported version (patchset 9.2.0.8), though older versions (Oracle 8i, Oracle8 and Oracle7) are still being actively used. Starting with 9.2.0.8, Oracle offers
Lifetime support

Oracle's full documentation set can be found at Tahiti.oracle.com


Latest page update: made by nlitchfield , Jan 2 2008, 6:48 AM EST (about this update About This Update nlitchfield Removed duplication and link to specific community site. Moved the edelivery link to sit with the other download links. - nlitchfield

19 words added
38 words deleted

view changes

- complete history)
Keyword tags: 10g 11g 7 8 8i 9i database sql
More Info: links to this page

Anonymous  (Get credit for your thread)


(Showing the last 5 of 21 - view all)
Started By Thread Subject Replies Last Post
Airborne_Ranger Best Practices for troubleshooting ORA-01591,ORA-02049 errors 1 Tuesday, 9:07 AM EDT by chemacomes
Airborne_Ranger
Thread started: Mar 21 2008, 3:22 PM EDT  Watch
The error description seem to indicate that at least the deadlock error is the result of a frozen two-phase commit. I get this error message when trying to run these transactions through WLS 8.1SP5 with JDBC connection pools set up and pointing to a single Oracle DBMS 9.2.1 instance. I'm not sure if the origin of the problem is the Oracle init or WebLogic JDBC Connection Pool settings or both.

Any help would be great.
1  out of 2 found this valuable. Do you?    
Keyword tags: 10g 11g 7 8 8i 9i database sql
Show Last Reply
TonyR_NZ Oracle Roles and Privileges 8 Sunday, 10:12 PM EDT by TonyR_NZ
TonyR_NZ
Thread started: May 5 2008, 10:42 PM EDT  Watch
I have created a database in Oracle 9i that has numerous application packages, tables and views that reside on separate schema.
The development staff require access to multiple schema objects on the db but I am loathed to assign the 'ALL' to the DDL privileges as I would like to
restrict access to a specific schema without limiting the developers to their own schema.
Does anyone have any detail on a good model for this level of security?
Regards
2  out of 2 found this valuable. Do you?    
Keyword tags: 10g 11g 7 8 8i 9i database sql
Show Last Reply
jcmoaz I can use any version for educational purporse? 8 Apr 12 2008, 3:32 AM EDT by porushh
Thread started: Mar 8 2008, 1:39 PM EST  Watch
I'am teacher and i want use Oracle Standard Edition in my class. This is possible? Or my unique solution is Express Edition?.
Thank you.
0  out of 1 found this valuable. Do you?    
Keyword tags: 10g 11g 7 8 8i 9i database sql
Show Last Reply
jeegar Inactive sessions 9 Apr 2 2008, 10:20 AM EDT by rogermiller2006@yaho
Thread started: Feb 7 2008, 5:02 AM EST  Watch
Dear Experts,

We are using EMC SQUARE documentum application , and oracle 10g R2 database in sun solaris on seperate servers.

Apps connects database unsing oracle client .

In peak hours , oracle's inactive sessions are very high.

How to overcome this issue ? I am looking for solution , which automatically disconnects after some time.

I have one solution that is sqlnet.expiray_time

wil it help me ?/
0  out of 4 found this valuable. Do you?    
Keyword tags: 10g 11g 7 8 8i 9i database sql
Show Last Reply
NotHenryPorter 11g versions 10 Mar 31 2008, 8:42 AM EDT by roy_hayrosa
NotHenryPorter
Thread started: Oct 15 2007, 1:04 PM EDT  Watch
What's the rationale for only having 11g available as 32bit Linux. Doesn't that somewhat contradict the ubiquity that Oracle would like to portray?
1  out of 12 found this valuable. Do you?    
Keyword tags: None
Show Last Reply
(Showing the last 5 of 21 - view all)
Web Page drf.html (Web Page - 5k)
posted by psmith@epx.com   Dec 17 2007, 3:46 PM EST
So common the answer is in the alert log....