Showing posts with label About Oracle. Show all posts
Showing posts with label About Oracle. Show all posts

Wednesday, January 6, 2010

How to know whether patches applied to database

One of my brother asked me how he will know whether he applied a certain patch into database. Because somehow he forgot whether he applied a patch to one database as he had to monitor many databases as a time.

There are several ways to identify whether a patch applied to database. I am describing some of them.

1)By invoking $ opatch lsinventory.
Note that before invoking opatch you have to set or export ORACLE_HOME and then change the directory to opatch.
oracle:/home/oracle APPS> $ opatch lsinventory
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.


Oracle Home : /APPS/app/oracle/product/10.2.0/db
Central Inventory : /APPS/app/oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /APPS/app/oracle/product/10.2.0/db/oui
Log file location : /APPS/app/oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch2010-01-07_00-19-28AM.log

Lsinventory Output file location : /APPS/app/oracle/product/10.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2010-01- 07_00-19-28AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------

OPatch succeeded.
2)By invoking $ opatch lsinventory -details
oracle:/APPS/app/oracle/product/10.2.0/db/OPatch AHDP> $ opatch lsinventory -details
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation.  All rights reserved.


Oracle Home       : /APPS/app/oracle/product/10.2.0/db
Central Inventory : /APPS/app/oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 10.2.0.4.3
OUI version       : 10.2.0.4.0
OUI location      : /APPS/app/oracle/product/10.2.0/db/oui
Log file location : /APPS/app/oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch2010-01-07_00-26-17AM.log

Lsinventory Output file location : /APPS/app/oracle/product/10.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2010-01-07_00-26-17AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2):

Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3                            10.2.0.4.0
There are 2 products installed in this Oracle Home.


Installed Products (160):

Agent Required Support Files                                         10.2.0.1.0
Agent Required Support Files Patch                                   10.2.0.4.0
Assistant Common Files                                               10.2.0.1.0
Assistant Common Files Patch                                         10.2.0.4.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              10.2.0.1.0
Character Set Migration Utility                                      10.2.0.1.0
Character Set Migration Utility Patch                                10.2.0.4.0
Database Configuration and Upgrade Assistants                        10.2.0.1.0
Database Configuration and Upgrade Assistants Patch                  10.2.0.4.0
Database SQL Scripts                                                 10.2.0.1.0
Database SQL Scripts Patch                                           10.2.0.4.0
Database Workspace Manager                                           10.2.0.1.0
Database Workspace Manager                                           10.2.0.4.0
DBJAVA Required Support Files                                        10.2.0.1.0
DBJAVA Required Support Files Patch                                  10.2.0.4.0
Enterprise Manager Baseline                                          10.2.0.1.0
Enterprise Manager Baseline                                          10.2.0.4.0
Enterprise Manager Minimal Integration                               10.2.0.1.0
Enterprise Manager plugin Common Files                               10.2.0.1.0
Generic Connectivity Common Files                                    10.2.0.1.0
Generic Connectivity Common Files Patch                              10.2.0.4.0
HAS Common Files                                                     10.2.0.1.0
HAS Common Files Patch                                               10.2.0.4.0
HAS Files for DB                                                     10.2.0.1.0
HAS Files for DB Patch                                               10.2.0.4.0
Installation Common Files                                            10.2.0.1.0
Installation Common Files Patch                                      10.2.0.4.0
Installer SDK Component                                              10.2.0.4.0
Java Runtime Environment                                             1.4.2.14.0
JDBC Common Files                                                    10.2.0.1.0
JDBC Common Files                                                    10.2.0.4.0
LDAP Required Support Files                                          10.2.0.1.0
LDAP Required Support Files Patch                                    10.2.0.4.0
OLAP SQL Scripts                                                     10.2.0.1.0
OLAP SQL Scripts Patch                                               10.2.0.4.0
Oracle Call Interface (OCI)                                          10.2.0.1.0
Oracle Call Interface (OCI) Patch                                    10.2.0.4.0
Oracle Clusterware RDBMS Files                                       10.2.0.1.0
Oracle Clusterware RDBMS Files Patch                                 10.2.0.4.0
Oracle Code Editor                                                   1.2.1.0.0I
Oracle Configuration Manager                                         10.2.7.1.0
Oracle Containers for Java                                           10.2.0.1.0
Oracle Containers for Java                                           10.2.0.4.0
Oracle Core Required Support Files                                   10.2.0.1.0
Oracle Core Required Support Files Patch                             10.2.0.4.0
Oracle Data Mining RDBMS Files                                       10.2.0.1.0
Oracle Data Mining RDBMS Files Patch                                 10.2.0.4.0
Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10G 32 bit                                           10.1.0.2.0
Oracle Database 10g interMedia Files                                 10.2.0.1.0
Oracle Database 10g interMedia Files Patch                           10.2.0.4.0
Oracle Database 10g Patch                                            10.2.0.4.0
Oracle Database 10g Patch                                            10.2.0.4.0
Oracle Database 10g Release 2 Patch Set 3                            10.2.0.4.0
Oracle Database User Interface                                       2.2.13.0.0
Oracle Database Utilities                                            10.2.0.1.0
Oracle Database Utilities Patch                                      10.2.0.4.0
Oracle Display Fonts                                                  9.0.2.0.0
Oracle Extended Windowing Toolkit                                    3.4.38.0.0
Oracle Globalization Support                                         10.2.0.1.0
Oracle Globalization Support Patch                                   10.2.0.4.0
Oracle Help For Java                                                  4.2.6.1.0
Oracle Ice Browser                                                    5.2.3.6.0
Oracle interMedia                                                    10.2.0.1.0
Oracle interMedia Annotator                                          10.2.0.1.0
Oracle interMedia Client Option                                      10.2.0.1.0
Oracle interMedia Client Option Patch                                10.2.0.4.0
Oracle interMedia Java Advanced Imaging                              10.2.0.1.0
Oracle interMedia Java Advanced Imaging Patch                        10.2.0.4.0
Oracle interMedia Locator                                            10.2.0.1.0
Oracle interMedia Locator Patch                                      10.2.0.4.0
Oracle interMedia Locator RDBMS Files                                10.2.0.1.0
Oracle interMedia Locator RDBMS Files Patch                          10.2.0.4.0
Oracle interMedia Patch                                              10.2.0.4.0
Oracle Internet Directory Client                                     10.2.0.1.0
Oracle Internet Directory Client Patch                               10.2.0.4.0
Oracle Java Client                                                   10.2.0.1.0
Oracle Java Client Patch                                             10.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.2                                  10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.2 Patch                            10.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.4                                  10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.4 Patch                            10.2.0.4.0
Oracle JDBC/OCI Instant Client                                       10.2.0.1.0
Oracle JDBC/OCI Instant Client Patch                                 10.2.0.4.0
Oracle JFC Extended Windowing Toolkit                                4.2.33.0.0
Oracle JVM                                                           10.2.0.1.0
Oracle JVM Patch                                                     10.2.0.4.0
Oracle LDAP administration                                           10.2.0.1.0
Oracle LDAP administration patch                                     10.2.0.4.0
Oracle Locale Builder                                                10.2.0.1.0
Oracle Message Gateway Common Files                                  10.2.0.1.0
Oracle Message Gateway Common Files Patch                            10.2.0.4.0
Oracle Net                                                           10.2.0.1.0
Oracle Net Listener                                                  10.2.0.1.0
Oracle Net Listener Patch                                            10.2.0.4.0
Oracle Net Patch                                                     10.2.0.4.0
Oracle Net Required Support Files                                    10.2.0.1.0
Oracle Net Required Support Files Patch                              10.2.0.4.0
Oracle Net Services                                                  10.2.0.1.0
Oracle Notification Service                                          10.1.0.3.0
Oracle Notification Service Patch                                    10.2.0.4.0
Oracle One-Off Patch Installer                                       10.2.0.4.0
Oracle Programmer                                                    10.2.0.1.0
Oracle RAC Required Support Files-HAS                                10.2.0.1.0
Oracle RAC Required Support Files-HAS Patch                          10.2.0.4.0
Oracle Real Application Testing                                      10.2.0.4.0
Oracle Recovery Manager                                              10.2.0.1.0
Oracle Recovery Manager Patch                                        10.2.0.4.0
Oracle Required Support Files 32 bit                                 10.2.0.0.0
Oracle Required Support Files 32 bit Patch                           10.2.0.4.0
Oracle Starter Database                                              10.2.0.1.0
Oracle Starter Database Patch                                        10.2.0.4.0
Oracle Text                                                          10.2.0.1.0
Oracle Text Patch                                                    10.2.0.4.0
Oracle UIX                                                           2.1.22.0.0
Oracle Universal Installer                                           10.2.0.4.0
Oracle Wallet Manager                                                10.2.0.1.0
Oracle Wallet Manager Patch                                          10.2.0.4.0
Oracle XML Development Kit                                           10.2.0.1.0
Oracle XML Development Kit Patch                                     10.2.0.4.0
Parser Generator Required Support Files                              10.2.0.1.0
Perl Interpreter                                                      5.8.3.0.1
PL/SQL                                                               10.2.0.1.0
PL/SQL                                                               10.2.0.4.0
PL/SQL Embedded Gateway                                              10.2.0.1.0
PL/SQL Embedded Gateway Patch                                        10.2.0.4.0
Platform Required Support Files                                      10.2.0.1.0
Platform Required Support Files                                      10.2.0.4.0
Precompiler Common Files                                             10.2.0.1.0
Precompiler Common Files Patch                                       10.2.0.4.0
Precompiler Required Support Files                                   10.2.0.1.0
Precompiler Required Support Files Patch                             10.2.0.4.0
RDBMS Required Support Files                                         10.2.0.1.0
RDBMS Required Support Files for Instant Client                      10.2.0.1.0
RDBMS Required Support Files for Instant Client Patch                10.2.0.4.0
RDBMS Required Support Files Patch                                   10.2.0.4.0
regexp                                                                2.1.9.0.0
Required Support Files                                               10.2.0.1.0
Sample Schema Data                                                   10.2.0.1.0
Sample Schema Data Patch                                             10.2.0.4.0
Secure Socket Layer                                                  10.2.0.1.0
Secure Socket Layer Patch                                            10.2.0.4.0
SQL*Plus                                                             10.2.0.1.0
SQL*Plus                                                             10.2.0.4.0
SQL*Plus Required Support Files                                      10.2.0.1.0
SQL*Plus Required Support Files Patch                                10.2.0.4.0
SQLJ Runtime                                                         10.2.0.1.0
SQLJ Runtime Patch                                                   10.2.0.4.0
SSL Required Support Files for InstantClient                         10.2.0.1.0
SSL Required Support Files for InstantClient Patch                   10.2.0.4.0
Sun JDK                                                              1.4.2.13.0
Sun JDK extensions                                                    9.0.4.0.0
XDK Required Support Files                                           10.2.0.1.0
XDK Required Support Files Patch                                     10.2.0.4.0
XML Parser for Java                                                  10.2.0.1.0
XML Parser for Java Patch                                            10.2.0.4.0
XML Parser for Oracle JVM                                            10.2.0.1.0
XML Parser for Oracle JVM Patch                                      10.2.0.4.0
There are 160 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------

OPatch succeeded.
3)Login to oracle as sys user and invoke select * from sys.registry$history;
SQL> select * from sys.registry$history;
ACTION_TIME ACTION NAMESPACE
------------------------------- ------------------------------ ------------------------------
VERSION ID COMMENTS BUNDLE_SERIES
------------------------------ ---------- ------------------------------------ ------------------------------
30-JUL-08 05.43.41.290171 PM CPU
6452863 view recompilation

08-SEP-08 08.22.59.110066 PM CPU SERVER
10.2.0.3.0 6864068 CPUApr2008

05-AUG-09 07.08.18.158451 AM UPGRADE SERVER
10.2.0.4.0 Upgraded from 10.2.0.3.0

05-AUG-09 07.42.03.040347 AM CPU
6452863 view recompilation
4)Various OS Commands.
$ showrev -p
$ owhat bin/oracle

From all the ways described above we can get idea whether patches are applied to database.
Related Documents
http://arjudba.blogspot.com/2008/04/list-of-oracle-database-version-release.html
http://arjudba.blogspot.com/2008/04/oracle-database-editions.html
http://arjudba.blogspot.com/2008/04/oracle-products.html
http://arjudba.blogspot.com/2008/04/timeline-of-oracle-rdbms-major-release.html
http://arjudba.blogspot.com/2008/04/history-of-oracle-corporation.html
http://arjudba.blogspot.com/2008/10/list-of-patchset-number-in-metalink.html
Posted by at No comments:
Labels: ,

Sunday, April 13, 2008

List of Oracle Database Version Release.

From Oracle1 to Oracle6 there was no release numbering.
Since version 7, Oracle's RDBMS release numbering has used the following codes:

Oracle7: 7.0.16 — 7.3.4
Oracle8 Database: 8.0.3 — 8.0.6
Oracle8i Database Release 1: 8.1.5.0 — 8.1.5.1
Oracle8i Database Release 2: 8.1.6.0 — 8.1.6.3
Oracle8i Database Release 3: 8.1.7.0 — 8.1.7.4
Oracle9i Database Release 1: 9.0.1.0 — 9.0.1.5
Oracle9i Database Release 2: 9.2.0.1 — 9.2.0.8
Oracle Database 10g Release 1: 10.1.0.2 — 10.1.0.5
Oracle Database 10g Release 2: 10.2.0.1 — 10.2.0.4
Oracle Database 11g Release 1: 11.1.0.6
Posted by at No comments:
Labels:

Oracle Database Editions

Oracle Corporation subdivides its product into varying "editions" - apparently for marketing and license-tracking reasons. In approximate order of decreasing scale, the editions are listed below.


1)Enterprise Edition (EE): Includes more features than the 'Standard Edition', especially in the areas of performance and security. Oracle Corporation licenses this product on the basis of users or of processors, typically for servers running 4 or more CPUs. EE has no memory limits, and can utilize clustering using Oracle RAC software.

2)Standard Edition (SE): Contains base database functionality. Oracle Corporation licenses this product on the basis of users or of processors, typically for servers running from one to four CPUs. If the number of CPUs exceeds 4 CPUs, the user must convert to an Enterprise license. SE has no memory limits, and can utilize clustering with Oracle RAC at no additional charge.

3)Standard Edition One: Introduced with Oracle 10g, has some additional feature-restrictions. Oracle Corporation markets it for use on systems with one or two CPUs. It has no memory limitations.

4)Express Edition: ('Oracle Database XE'), introduced in 2005, offers Oracle 10g free to distribute on Windows and Linux platforms (with a footprint of only 150 MB and restricted to the use of a single CPU, a maximum of 4 GB of user data and 1 GB of memory). Support for this version comes exclusively through on-line forums and not through Oracle support.

5)Oracle Personal Edition: Provides the functionality of the "high end" Enterprise Edition but marketed to (and licensed for) single-user developers working on personal workstations.

6)Oracle Database Lite: Intended to run on mobile devices. The database, partially located on the mobile device, can synchronize with a server-based installation.
Posted by at No comments:
Labels:

Oracle Services

In addition to software development, Oracle also offers a variety of technical support and consulting services.

Technical support is delivered primarily through Oracle’s MetaLink website and is available to all customers with current maintenance agreements.

In addition to this support, Oracle Services also offers consulting services to help customers select, install, and configure the Oracle technologies that best meet their needs.
List of Services:
Oracle Consulting
Oracle University
Oracle On Demand
Oracle Support
Oracle Financing
Posted by at No comments:
Labels:

Oracle Products

A)Technology products:
1)Oracle Databases:
The relational database management system (RDBMS) officially called Oracle Database.

2)Oracle Fusion Middleware:Oracle Fusion Middleware (OFM) is a portfolio of software products, produced by Oracle, that spans multiple services, including J2EE and developer tools, integration services, business intelligence, collaboration, and content management.

3)Oracle Enterprise Manager:Oracle Enterprise Manager (OEM) used by database administrators (DBAs) to manage the DBMS, and recently in version 10g, a web-based rewrite of OEM called "Oracle Enterprise Manager Database Control".

4)Oracle Secure Enterprise Search:

B)Application products:
1)Oracle eBusiness Suite:Oracle Corporation's E-Business Suite ("EB-Suite" or "EBS") consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications developed by Oracle.

2)PeopleSoft Enterprise:PeopleSoft, Inc. was a company that provided Human resource management systems (HRMS), customer relationship management, Manufacturing, Financials, Enterprise Performance Management, and Student Administration software solutions to large corporations, governments, and organizations.

3)Siebel:Siebel Systems, Inc. began in sales force automation software, then expanded into marketing and customer service applications, including customer relationship management (CRM).

4)JD Edwards EnterpriseOne:

5)JD Edwards World:

Related Documents
Posted by at No comments:
Labels:

Timeline of Oracle RDBMS Major Release Version.

Year: Release Version.
-----------------------------------
1978: Oracle version 1
1979: Oracle version 2
1982: Oracle version 3
1984: Oracle version 4
1986: Oracle version 5
1989: Oracle version 6
1993: Oracle version 7
1997: Oracle version 8
1999: Oracle version 8i
2001: Oracle version 9i
2003: Oracle version 10g
2007: Oracle version 11g
Posted by at No comments:
Labels:

History of Oracle Corporation.

1)June 16, 1977: Oracle Corporation was incorporated in Redwood Shores, California as Software Development Laboratories (SDL) by Larry Ellison, Bob Miner and Ed Oates.

2)June 1979: SDL is renamed to Relational Software Inc. (RSI), and relocates to Sand Hill Road, Menlo Park, California. Oracle 2, the first version of the Oracle database software runs on PDP-11 and is sold to Wright-Patterson Air Force Base. The company decides to name the first version of its flagship product version 2 rather than version 1 because it believes companies may hesitate to buy the initial release of its product (and, or IBM would not divulge to render the original take).

3)October 1979: RSI actively promotes Oracle on the VAX platform (the software runs on the VAX in PDP-11 emulator mode)

4)1981 Umang Gupta joined Oracle Corporation where he wrote the first business plan for the company, and served as Vice President and General Manager of the Microcomputer Products.

5)February 1981: RSI begins developing tools for Oracle, including the Interactive Application Facility (IAF), a predecessor to Oracle*Forms.

6)Bruce Scott was one of the first employees at Oracle (then Software Development Laboratories). He co-founded Gupta Technologies (which later became Centura Software) in 1984 with Umang Gupta, and later became CEO and founder of PointBase, Inc. Bruce was co-author and co-architect of Oracle V1, V2 and V3. He created the sample schema "SCOTT" (containing tables like EMP and DEPT) with the password defaulted to TIGER (apparently named after his cat).

7)March 1983: RSI rewrites Oracle in C for portability and Oracle version 3 is released. RSI is renamed to Oracle to more closely align with its primary product. The word Oracle was the code name of a CIA project which the founders had all worked on while at the Ampex Corporation.

8)April 1984: Received additional funding from Sequoia Capital.

9)October 1984: Oracle version 4 released, introducing read consistency.

10)November 1984: Oracle ports the database software to the PC platform. The MS-DOS version (4.1.4) of Oracle runs in only 512K of memory. Oracle for MSDOS version 5 was released in 1986 running in Protected Mode on 286 machines using a technique invented by Mike Roberts, among the first products to do so.

11)April 1985: Oracle version 5 released. It is one of the first RDBMSs to operate in client-server mode.

12)1986: Oracle version 5.1 released with support for distributed queries. Investigations into clustering begin.

13)March 12, 1986: Oracle goes public with revenues of $55 million USD.

14)August 1987: Oracle founds its Applications division, building business management software closely integrated with its database software. Oracle acquires TCI for its project management software.

15)1988: Oracle version 6 is released with support for row-level locking and hot backups. The PL/SQL procedural language engine was embedded in the database but no provision was made to store program blocks such as procedures and triggers in the database - this capability was added in v7. PL/SQL blocks could be submitted for immediate execution in the server from an environment such as SQL*Plus, or via SQL statements embedded in a host program. Separate PL/SQL engines were included in various client tools (SQL*Forms, Reports).

16)1989: Oracle moves world headquarters to Redwood Shores, California. Revenues reach US$584 million.

17)1990: In the third quarter, Oracle reports its first ever loss, hundreds of employees are laid off. Ellison hires Jeffrey O. Henley as CFO and Raymond Lane as COO.

18)June 1992: Oracle 7 released with performance enhancements, administrative utilities, application development tools, security features, the ability to persist PL/SQL program units in the database as stored procedures and triggers, and support for declarative referential integrity.

19)1993: Releases Oracle's Cooperative Development Environment (CDE) which bundles Oracle Forms, Reports, Graphics, Book.

20)1994: Oracle acquired the database-product DEC Rdb (now called Oracle Rdb) from Digital Equipment Corporation (DEC) and development is still going on. Oracle Rdb is only available on the OpenVMS platform (also a former product of DEC).

21)June 21, 1995: Oracle announces new data warehousing facilities, including parallel queries.

22)November 1995: Oracle is one of the first large software companies to announce an internet strategy when Ellison introduces the network computer concept at an IDC conference in Paris.

23)April 1997: Oracle releases the first version of Discoverer, an ad-hoc query tool for business intelligence.

24)June 1997: Oracle 8 is released with SQL object technology, internet technology and support for terabytes of data.

25)September 1997: Oracle announces its commitment to the Java platform, and introduces Oracle's Java integrated development environment, which will come to be known as Oracle JDeveloper.

26)January 1998: Oracle releases Oracle Applications 10.7 NCA. All the applications in the business software now run across the web in a standard web browser.

27)May 1998: Oracle Applications 11 is released.

28)April 1998: Oracle announces that it will integrate a Java virtual machine with Oracle Database.

29)September 1998: Oracle 8i is released.

30)October 1998: Oracle 8 and Oracle Application Server 4.0 are released on the Linux platform.

31)May 1999: Oracle releases JDeveloper 2.0, showcasing Business Components for Java (BC4J), a set of libraries and development tools for building database aware applications.

32)2000: OracleMobile subsidiary founded. Oracle 9i released.

33)May 2000: Oracle announces the Internet File System (iFS), later rebranded as Oracle Content Management SDK.

34)June 2000: Oracle9i Application Server released with support for building portals.

35)2001: Ellison announces that Oracle saved $1 billion implementing and using its own business applications.

36)2004: Oracle 10g released.

37)December 13, 2004: After a long battle over the control of PeopleSoft, Oracle announces that it has signed an agreement to acquire PeopleSoft for $26.50 per share (approximately $10.3 billion).

38)January 14, 2005: Oracle announces that it will reduce its combined workforce to 50,000, a reduction of approximately 5,000 following the PeopleSoft take over. 90% of PeopleSoft product development and product support staff will be retained.

39)March, 2005: Oracle extends its Middle East operations by opening a regional office in Amman, Jordan.

40)September 2005: Oracles announces that it has agreed to acquire Global Logistics Technologies, Inc. (private company), a global provider of logistics and transportation managements software (TMS) solutions through a cash offer.

41)September 12, 2005: Oracle announces it had agreed to buy Siebel Systems, the global leader in CRM technologies and a key player in the BI realm, for $5.8 billion.

42)October 25, 2006: Oracle announces Unbreakable Linux.

43)November 2, 2006: Oracles announces that it has agreed to acquire Stellent, Inc. (NASDAQ: STEL), a global provider of enterprise content management (ECM) software solutions, through a cash tender offer for $13.50 per share, or approximately $440 million.

44)December 15, 2006, a majority of MetaSolv stockholders approved Oracle’s acquisition of MetaSolv Software, a Leading Provider of Operations Support Systems (OSS) Software for the Communications Industry.

45)March 1, 2007: Oracle announced that it has agreed to buy Hyperion Solutions Corporation (Nasdaq: HYSL), a leading global provider of performance management software solutions, through a cash tender offer for $52.00 per share, or approximately $3.3 billion. The transaction is subject to customary conditions and is expected to close in April 2007.

46)March 22, 2007: Oracle filed a court case against its major competitor SAP AG in the Californian courts for malpractice and unfair competition. The full text of the filing can be found on the claimants web site under the heading newsroom.

47)October 12, 2007: Oracle announced that it had made a bid to buy BEA Systems for a price of $17/share, an offer that was rejected by the BEA board who felt that the company was worth more than that.

48)October 16, 2007: Oracle confirms impending departure of John Wookey, senior vice president for application development and head of its applications strategy, raising questions in the planned release and future of Oracle's Fusion Applications strategy.

49)January 16, 2008: Oracle announces it is buying BEA Systems for $19.375/Share in cash for a total of '$7.2 billion net of cash.'



H.Tonguç Yılmaz - Oracle Blog
History of Oracle
Posted in Oracle Other by H.Tonguç Yılmaz on December 27th, 2006

1978 -> Oracle V1; first commercial SQL relational database management system (RDBMS), Main architect Bob Miner, ran on pdp-11 under rsx; 128Kb memory, written in assembly, separated oracle and user codesto overcome the memory limitations

1979 -> Oracle V2; written in pdp-11 assembly language, ran on vax/vms in compatibility mode

1980 -> Oracle V3; written in C, soptable source code, introduced Transactions

1984 -> Oracle V4; introduced read consistency, ported to many plathforms, first interopability between PC and server

1986 -> Oracle V5; true client-sever, vax cluster support, distributed queries

1989 -> Oracle V6; OLTP performance enhancements, online backup/recovery, row level locking, plsql language, parallel server

1993 -> Oracle V7; declarative referential integrity, stored procedures and triggers, shared SQL, parallel execution, Advanced replication

1997 -> Oracle V8; Object-relational database, three-tier architecture, partitioning

1999 -> Oracle V8i; Java in database and native java support, XML support, Oracle Internet Directory, Summary management interMedia, Data warehousing enhancements, ported to Linux, Business components for java(BC4J), WebDB introduced(eventually mature into Portal and ApEx)

2001 -> Oracle V9i; Automatic segment space management, Real Apllication Clusters, Internet security enhancements, Data Guard, Advanced globalization support, record-breaking TPC-C benchmark results, 1st to complete 3 terabyte TPC-H world record

2003 -> Oracle V10g; Enterprise Grid Computing, 64-bit Linux with IPF

2005 -> Oracle VXE; free Oracle 10gR2 database

2007 -> Oracle V11g; as announced at Openworld 2006

In a nutshell, Version Date Release Name

Oracle
Release Date
2 June 1979
3 March 1983
4 October 1984
5.0 April 1985
6.0 July 1988
7.0 June 1992
7.1 May 1994
7.2 May 1995
7.3 February 1996
8.0 June 1997 Oracle 8
8.1.5 February 1999 Oracle 8i Release 1
8.1.6 November 1999 Oracle 8i Release 2
8.1.7 August 2000 Oracle 8i Release 3
9.0.1 June 2001 Oracle 9i Release 1
9.2 May 2002 Oracle 9i Release 2
10.1 January 2004 Oracle 10g Release 1
10.2 July 2005 Oracle 10g Release 2
Posted by at 2 comments:
Labels:
Subscribe to: Posts (Atom)