Different editions of Oracle database



What is OracleOracle database is a relational database management system. It is known as Oracle database, OracleDB or simply Oracle. It is produced and marketed by Oracle Corporation.Oracle database is the first database designed for enterprise grid computing. The enterprise grid computing provides the most flexible and cost effective way to manage information and applications.Different editions of Oracle databaseFollowing are the four editions of the Oracle database.Enterprise Edition:?It is the most robust and secure edition. It offers all features, including superior performance and security.Standard Edition:?It provides the base functionality for users that do not require Enterprise Edition's robust package.Express Edition (XE):?It is the lightweight, free and limited Windows and Linux edition.Oracle Lite:?It is designed for mobile devices.The Oracle CorporationOracle Corporation is the largest software company in the field of database business. Its relational database was the first to support SQL which has since become the industry standard.History of OracleOracle was originally developed by Lawrence Ellison (Larry Ellision) and his two friends and former co-worker in 1977. Oracle DB runs on the most major platforms like Windows, UNIX, Linux and Mac OS.Download And InstallationDownload Oracle 11gOracle?allows you to freely download. You can access the home page of?Oracle?to download this software. check whether your operating system is?32bit?bit or?64bit?to download exactly.After finishing downloading, you have 2 zip files. Decompress them in the same folder.Installing Oracle 11g on WindowsFirst, we need to understand the structure of?Oracle?a bit:?The structure of?Oracle?includes:Oracle softwareAnd DatabaseEach Database contains many?SCHEMA, and the name of?Schema?is simultaneously the User name to log in that?Schema. A Schema contains a system of tables, views, functions, procedures, packages, etc.?That means that after installing the??Oracle?software is complete, we can create one or more Database.?Usually you only need 1.As illustrated below, we install?Oracle?software, and create two database named?Db11g?and?ORCL?respectively. The name of the database is also known as SID.Setup Oracle:If you decompress two installing zip files of Oracles in two folders, and begin installing the setup file in the folder 1. During the installment, it will require you to indicate the position of folder 2 for continuing to install.We will install?Oracle?software and immediately create a Database named as??db11g?(or?SID = db11g).For the studying purpose or for small companies, select:Desktop classTo store many kinds of language (including Vietnamese), you should select:?Unicode (?AL32UTF8)Character Set: Unicode (AL32UTF8)Global database name: db11g (You can select another name, this is the name of database, known as?SID)And wait until the installation is complete.Now the installment of?Oracle?is successful. Parameters relating to database will be synthesized, and you should remember this information.In the next step, the installer will create Database named as db11g like the previous step where we named.This is the summary information after a successful installation:If?Windows?shows a warning of blocking the activity of?Oracle, you click on??"Allow access"?for allowing?Oracle?to work.Check the installation and install the expansionAfter the successful installation, services of Oracle are automatically started. We can access to Service of Windows to check.There are 7 services of?Oracle, but usually three services are enough for the operation:OracleDBConsole<sid>OracleOra<Sid>_home1TNSListenerOracleService<SID> ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download