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: dariusz.jankowski@pwr.wroc.pl
tel:(+48) 713202106, fax:(+48) 713202902
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
Document Outline
- Oracle 10g Express EditionWprowadzenie
- Informacje
- Oracle Database 10g Express Edition
- What is Oracle 10g XE?
- Oracle 10 g XE Development Environments
- The Limitations Oracle 10gXE
- Supported Operating Systems
- How To Download Database?
- How To Install Database
- How To Check Your Oracle 10g XE Installation?
- How To Unlock the Sample User Account?
- Where can I get more information about Oracle Database XE?
- Where to start