Oracle 10g Express Edition

Wprowadzenie

mgr inż. Dariusz Jankowski

Informacje

mgr inż. Dariusz Jankowski

Katedra Systemów i Sieci Komputerowych Wydział Elektroniki

Politechnika Wrocławska

Wybrzeże Wyspiańskiego 27, 50-370

Wrocław, Polska

email: [e-mail]

tel:[phone], fax:[phone]

2

Oracle Database 10g

Express Edition

Free to develop, deploy, and distribute 3

What is Oracle 10g XE?

Greate starter for:

„ Developers working on PHP, Java, .NET, XML, and Open Source applications

„ DBAs who need a free, starter database for training and deployment

„ Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge

„ Educational institutions and students who need a free database for their curriculum 4

Oracle 10 g XE Development

Environments

„ Oracle Call Interface for C and C++

„ Oracle Application Express

„ PHP

„ ODBC

„ Oracle Data Provider for .NET

„ OLE DB

„ JDBC

5

The Limitations Oracle 10gXE

„ Supports up to 4GB of user data (in addition to Oracle system data)

„ Single instance only of Oracle Database XE on any server

„ May be installed on a multiple CPU server, but only executes on one processor in any server

„ May be installed on a server with any amount of memory, but will only use up to 1GB RAM

of available memory

6

Supported Operating Systems

„ Linux x86

„ Debian

„ Mandriva

„ Red Hat

„ Ubuntu

„ Novell

„ Microsoft Windows x86

7

How To Download Database?

„ Visit

http://www.oracle.com/technology/software/products/database/xe/

„ Available downloads

„ Oracle Database 10g Express Edition (Western European) - Single-byte LATIN1 database for Western European language storage

„ Oracle Database 10g Express Edition (Universal) -

Multi-byte Unicode database for all language deployment

„ Oracle Database 10g Express Client

8

How To Install Database

„ To install 10g universal edition, double click, OracleXEUniv.exe, the install wizard starts.

„ You should take notes about:

„ The SYSTEM password you selecte: f.e. oracle

„ Database server port: 1521

„ Database HTTP port: 8080

„ The directory where 10g XE is installed: \oraclexe\

„ Hard disk space taken: 1655MB

9

How To Check Your

Oracle 10g XE Installation?

„ Use a Web browser with this address http://localhost:8080/apex/

„ You will see the login page. Enter SYSTEM as the user name, and the password (oracle), you selected during the installation to log into the server.

„ You can also get to your 10g XE server home page by going through the start menu.

„ Select All Programs, then Oracle Database 10g Express Edition, and then Go To Database Home Page.

10

How To Unlock the Sample

User Account?

„ Sample database user account is called HR. But this account is locked. You must unlock it before you can use it:

„ Log into the server home page as SYSTEM.

„ Click the Administration icon, and then click Database Users.

„ Click the HR schema icon to display the user information for HR.

„ Enter a new password (hr) for HR, and change the status to Unlocked.

„ Click Alter User to save the changes.

„ Now user account HR is ready to use.

11

Where can I get more information

about Oracle Database XE?

„ Visit home page

„

http://www.oracle.com/technology/products/database/xe/index.html

„ Community

„

Register for Discussion Forum

12

Where to start

„ Tutorial

„

http://st-curriculum.oracle.com/tutorial/DBXETutorial/index.htm

„ Getting Started Guide

„

http://download-uk.oracle.com/docs/cd/B25329_01/doc/admin.102/b25610/toc.htm

„ Creating an Application

„

http://www.oracle.com/technology/obe/xe/getstarted/getstarted.htm

„ Documentation

„

http://www.oracle.com/pls/xe102/homepage

13