Oracle® Database Express Edition Installation Guide 10g Release 2 (10.2) for Microsoft Windows Part Number B25143-03 |
|
View PDF |
Installation Guide
10g Release 2 (10.2) for Microsoft Windows
B25143-03
June 2007
Welcome to Oracle Database Express Edition Installation Guide for Microsoft Windows. This guide covers the following topics:
Note:
The most up-to-date version of this installation guide is available from the Oracle Database Express Edition (Oracle Database XE) download page on Oracle Technology Network:Oracle Database XE is easy to install. The installation has the following components:
Oracle Database XE Server: The Oracle Database XE Server component provides both an Oracle database and tools for managing this database. It also includes the client component of Oracle Database XE, so that you can connect to the database from the same computer on which you installed the server component, and then administer the database and develop Java, .NET, PHP, and Oracle Application Express applications.
Oracle Database XE Client: You install the Oracle Database XE client component on remote computers from which you want to connect to Oracle Database XE. Oracle Database Client provides drivers, networking components, and tools that enable you to remotely administer the database and to develop Java, .NET, PHP, and Oracle Application Express applications. Use this installation executable only on remote computers—that is, only on computers on which you do not install Oracle Database XE Server.
You can use the following tools in your Oracle Database XE development environment.
PHP: Open-source server-side embedded scripting language designed for Web development and can be embedded into HTML. You can use either of the following PHP products:
PHP: Download and install from:
You can install PHP on either Oracle Database XE Server or Oracle Database XE Client.
Zend Core for Oracle: Download and install from:
http://www.oracle.com/technology/tech/php/zendcore/index.html
Install Zend Core for Oracle on the same computer on which you installed Oracle Database XE Server. Zend Core for Oracle is not supported on remote computers that use Oracle Database XE Client.
Oracle Developer Tools for Visual Studio .NET: Tightly integrated "Add-in" for Visual Studio .NET that .NET developers can use to design database applications and deploy .NET stored procedures. For more information, including downloads, visit:
http://www.oracle.com/technology/tech/dotnet/tools/index.html
Install Oracle Developer Tools for Visual Studio .NET onto the computer where you install Oracle Database XE Client.
After you install Oracle Database XE, you can manage it by using the Oracle Database XE graphical user interface management console, described in Oracle Database Express Edition 2 Day DBA.
For more information on Oracle Database XE, visit the following Web sites:
Oracle Database XE home page on Oracle Technology Network
Oracle Database XE Documentation Library
Discussion forum
http://www.oracle.com/technology/xe/forum
Before you can use the discussion forum, you need to register Oracle Database XE.
This section covers the following topics:
This section covers the following topics:
Table 1 provides system requirements for both Oracle Database XE Server and Oracle Database XE Client.
Table 1 Oracle Database XE Requirements
Requirement | Value |
---|---|
System architecture |
Intel (x86) |
Operating system |
One of the following 32-bit Windows operating systems:
|
Network protocol |
TCP/IP |
Disk space |
Server component: Total: 1.6 gigabytes minimum Client component: 75 megabytes |
RAM |
256 megabytes minimum, 512 megabytes recommended |
Microsoft Windows Installer (MSI) |
MSI version 2.0 or later You can download MSI from Microsoft at: |
If you plan to install Oracle Database XE Server onto a computer running Windows XP Service Pack 2 or Windows Server 2003 Service Pack 1 and then connect to it from another computer, check that the firewall has not been configured to block communication from the following incoming ports. These ports are the default ports that Oracle Database XE uses.
1521: Oracle database listener
2030: Oracle Services for Microsoft Transaction Server
8080: HTTP port for Oracle XML DB and the Oracle Database XE graphical user interface
If you plan to use Oracle Database Extensions for .NET for Oracle Database XE, then you must install the following software onto your server and client computers:
On the computer where you plan to install Oracle Database XE Server, install .NET Framework 1.x. Be sure to install .NET Framework 1.x before you install Oracle Database XE Server.
Note:
This requirement is for design-time development, deployment, and run-time.On the computer where you plan to develop .NET stored procedures, you need the following software:
Oracle Database XE Server or Oracle Database XE Client
Visual Studio .NET 2003, which includes .NET Framework 1.x
Install Visual Studio .NET 2003 onto the client computer before you install Oracle Database XE Client or Oracle Developer Tools for Visual Studio .NET.
Oracle Developer Tools for Visual Studio .NET
Note:
These requirements are for design-time development and deployment. They are not required for run-time. For run-time, you only need to have .NET Framework 1.x installed on the database server. Visual Studio .NET 2003 is not necessary for run-time.See Also:
http://www.oracle.com/technology/tech/dotnet/ode/
for more information on Oracle Database Extensions for .NET, including download and installation instructionsYou can install Oracle Developer Tools on the same computer on which you installed Oracle Database XE Server or Oracle Database XE Client. Oracle Database Express Edition 2 Day Plus .NET Developer Guide provides instructions for installing Oracle Developer Tools.
Note:
These requirements are for design-time development and deployment. They are not required for run-time. For run-time, you only need to have .NET Framework 1.x installed on the database server. Visual Studio .NET 2003 is not necessary for run-time.See Also:
http://www.oracle.com/technology/tech/dotnet/ode/
for more information on Oracle Developer Tools for Visual Studio .NETYou must be part of the Administrators group on Windows to install Oracle Database XE. If you are logged in as a domain user, ensure sure that you are connected to the network before you install Oracle Database XE Server.
For both the server and client components of Oracle Database XE, ensure that the Web browsers you plan to use support JavaScript and the HTML 4.0 and CSS 1.0 standards. Ensure also that cookies are enabled. The following browsers meet this requirement:
Microsoft Internet Explorer 6.0 or later
Netscape Navigator 7.2 or later
Mozilla 1.7 or later
Firefox 1.0 or later
Oracle Application Express does not support the Corel SVG Viewer.
Before you can run Oracle Database XE, you need to configure your Web browser so that it can connect to the Oracle Database XE Database Home Page.
To configure Microsoft Internet Explorer to connect to the Oracle Database XE Database Home Page:
From the Start menu, select Control Panel, then Internet Options.
In the Internet Options dialog box, click the Security tab.
Under Security, select Local Intranet and then select Sites.
In the Local Intranet dialog box, select Advanced.
Under Add this Web site to the zone, enter the following site:
127.0.0.1
Click OK.
To configure Netscape Navigator or Mozilla to connect to the Oracle Database XE Database Home Page:
From the Edit menu, select Preferences.
Under Category, click the Advanced category to expand it, and then select Proxies.
If you are using a proxy server, add the following setting to the No Proxy For setting:
127.0.0.1
Click OK.
To configure Firefox to connect to the Oracle Database XE Database Home Page:
Under the Tools menu, select Options.
From the General tab, select Connection Settings.
If you are using a proxy server, add the following setting to the No Proxy For setting:
127.0.0.1
Click OK.
Oracle recommends that you perform the following security-related tasks before installing Oracle Database XE Server on Windows:
If you are installing on Windows XP, consider disabling simple file sharing on the computer where you plan to install Oracle Database XE. If simple file sharing is enabled, there is risk of unauthorized access to the data in your database.
To disable simple file sharing, go to the Microsoft Knowledge Base (http://support.microsoft.com
) and search for article 307874.
Warning:
It is not possible to disable simple file sharing on Microsoft Windows XP Home. Oracle strongly recommends that you upgrade to one of the required operating systems identified in "System Requirements". However, if you cannot upgrade, then Oracle recommends that you enable the firewall and ensure that port 1521 (or the Oracle listener port you configured during installation) is blocked. Note that blocking port 1521 blocks remote access to the database over TCP/IP.To enable the firewall (or check that the firewall is enabled) on Microsoft Windows XP, see Microsoft Knowledge Base article number 283673, "How to turn on or turn off the firewall in Windows XP."
Note that enabling the firewall prevents all remote connections to your system by default. If you want to open specific ports, see Microsoft Knowledge Base article number 875357, "Troubleshooting Windows Firewall settings in Windows XP Service Pack 2" or article number 308127, "How to manually open ports in Internet Connection Firewall in Windows XP" for earlier Windows XP releases.
Install Oracle Database XE Server on a file system that supports access controls (for example, NTFS). If you install Oracle Database XE Server on a file system that does not support access controls, such as FAT, there is significant risk of unauthorized access to the data in your database. If necessary, you can convert a FAT partition to an NTFS partition.
See Also:
Microsoft Support site (http://support.microsoft.com
) for more information on FAT and NTFS file systems and how to convert from FAT to NTFSThis section covers the following topics:
If Oracle Database XE Server is installed on a computer with more than one CPU (including dual-core CPUs), then it will consume, at most, processing resources equivalent to one CPU. For example, on a computer with two CPUs, if two Oracle database clients try to simultaneously execute CPU-intensive queries, then Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition will use both CPUs to efficiently process the queries. However, with Oracle Database XE Server, the Oracle database will process the queries at the rate of a single CPU even if concurrent processing on two CPUs would be faster. To use the full processing resources of your computer, upgrade to Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition.
On a single computer, only one installation of the Oracle Database XE software can be performed. This does not affect any existing installation or new installations of Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition. In addition, users can run only one instance of the Oracle Database XE Server database on each individual computer. To run more than one Oracle Database server instance or install more than one copy of the database software, upgrade to Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition.
The maximum amount of user data in an Oracle Database XE Server database cannot exceed 4 gigabytes. If the user data grows beyond this limit, then an ORA-12592
error will appear. To use more than 4 gigabytes of user data, upgrade to Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition.
The maximum amount of RAM that an Oracle Database XE Server database uses cannot exceed 1 gigabyte, even if more is available. Table 1, "Oracle Database XE Requirements" provides the minimum and recommended RAM that you should use. The exact amount of RAM that Oracle Database XE uses is the sum of the System Global Area (SGA) and the aggregate Program Global Area (PGA). To find this value, follow these steps after you have installed Oracle Database XE:
From the Start menu, select Programs (or All Programs), then Oracle Database 10g Express Edition, and then Go to Database Home Page.
In the Database Home Page, log in as SYSTEM
.
Under Usage Monitor, click the Memory link.
Check the Current Configuration (SGA + PGA) setting:
For more information about managing memory, refer to Oracle Database Express Edition 2 Day DBA.
To use more than 1 gigabyte of RAM, upgrade to Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition.
HTTPS is not supported natively with the HTTP listener built into Oracle Database XE. If you want HTTPS support, use an alternative Web listener, such as Apache, that does provide HTTPS support, and provide proxies for the URLs provided by Oracle Database XE.
For information how you can manage security in Oracle Database XE, refer to Oracle Database Express Edition 2 Day DBA.
The Oracle Database XE Server installer creates both server and client components in one installation. If you plan to use Oracle Database XE as a standalone product, you only need to install this server component, not the client component that is described under "Installing Oracle Database XE Client".
See also "Installation and Configuration Issues".
This section covers the following topics:
Performing a Graphical User Interface Installation of the Server
Making Oracle Database XE Server Available to Remote Clients
Most users will install Oracle Database XE by downloading the installation executable, double-clicking it, and answering graphical user interface prompts as needed.
If you have an existing version of Oracle Database XE, you can save your data by exporting it to data files. After you install the new version of Oracle Database XE, you can import this data into the new database. For more information, see Oracle Database Express Edition 2 Day DBA.
To perform a graphical user interface installation:
Log on to Windows with Administrative privileges.
You must be part of the Administrators group on Windows to install Oracle Database XE. If you are logged in as a domain user, ensure that you are connected to the network.
If the ORACLE_HOME
environment variable has been set, then use System in the Control Panel to delete it.
Go to the following Web site:
Click Free Download and follow the instructions to select and download the Microsoft Windows version of Oracle Database XE Server.
After downloading the Oracle Database XE installation executable, OracleXE.exe
(for the Western European character set) or OracleXEUniv.exe
(for the Universal character set), double-click it.
"Oracle Database XE Character and Language Configurations" describes these character sets in detail.
If you are installing over an existing Oracle Database XE installation, then click Repair and then select Next.
The Repair option appears only if you are reinstalling the same version of Oracle Database XE. If you are installing a newer version of Oracle Database XE, you must first deinstall the earlier version before installing the new version. In this case, the deinstallation removes the database of the earlier version. If you want to save its data before proceeding, refer to Oracle Database Express Edition 2 Day DBA for information on backing up the database.
In the Oracle Database 10g Express Edition - Install Wizard welcome window, click Next.
In the License Agreement window, select I accept and then click Next.
In the Choose Destination Location window, either accept the default or click Browse to select a different installation directory. (Do not select a directory that has spaces in its name.) Then click Next.
If you are prompted for a port number, then specify one.
The following port numbers are the default values:
1521: Oracle database listener
2030: Oracle Services for Microsoft Transaction Server
8080: HTTP port for the Oracle Database XE graphical user interface
If these port numbers are not currently used, then the installation uses them automatically without prompting you. If they are in use, then you will be prompted to enter an available port number.
In the Specify Database Passwords window, enter and confirm the password to use for the SYS
and SYSTEM
database accounts. Then click Next.
In the Summary window, review the installation settings, and if you are satisfied, click Install. Otherwise, click Back and modify the settings as necessary.
In the InstallShield Wizard Complete window, to display the Database Home Page, click Launch the Database homepage. Then click Finish.
Note:
Logs for the server component installation are in theOracleDatabaseXEServerInstall
.log
file, located in the system root directory, which is typically c:\WINDOWS.
You can find the database creation logs in the install_directory
\app\oracle\product\10.2.0\server\config\log
directory. (install_directory
is typically c:\oraclexe
.)If you plan to install Oracle Database XE on multiple computers or bundle it with a third-party application, then you may want to perform a silent installation, in which you download the installation executable and run it at a command line using the provided response files.
If you have an existing version of Oracle Database XE, you can save your data by exporting it to data files. After you install the new version of Oracle Database XE, you can import this data into the new database. For more information, see Oracle Database Express Edition 2 Day DBA.
To perform a silent installation of Oracle Database XE:
Log on to Windows with Administrative privileges.
You must be part of the Administrators group on Windows to install Oracle Database XE. If you are logged in as a domain user, ensure that you are connected to the network.
Go to the following Web site:
Click Free Download and follow the instructions to select and download the Microsoft Windows version of Oracle Database XE.
You have the choice of downloading either OracleXE.exe
(for the Western European character set) or OracleXEUniv.exe
(for the Universal character set). "Oracle Database XE Character and Language Configurations" describes these character sets in detail.
Under Silent Install Response File Templates, select the OracleXE
response files that you want to use. These files allow you to perform silent installations, repairs (upgrades), and deinstallations.
Check the response files and modify the settings if necessary.
The response files set the following:
Installation directory location (do not specify a directory that has spaces in its name)
TNS, Microsoft Transaction Server, and HTTP ports
Password for SYS
and SYSTEM
If the ORACLE_HOME
environment variable has been set, then use System in the Control Panel to delete it.
Run the installation executable with the appropriate response file.
For example, if you downloaded the OracleXE.exe
executable and its response files to a directory called xe_temp
, you would enter the following command:
c:\xe_temp> OracleXE.exe /s /f1"c:\xe_temp\response\OracleXE-Install.iss" /f2"c:\xe_temp\setup.log"
If you wanted to repair the Oracle Database XE installation, you would enter the following command:
c:\xe_temp> OracleXE.exe /s /f1"c:\xe_temp\response\OracleXE-repair.iss" /f2"c:\xe_temp\setup.log"
After the installation is complete, Oracle Database XE starts and displays the Database Home Page.
Note:
Thesetup.log
file indicates the success of the installation. A result code of 0 means the installation succeeded. Logs for the server component installation are in the \OracleDatabaseXEServerInstall
.log
file, located in the system root directory, which is typically c:\WINDOWS
. You can find the database creation logs in the install_directory
\app\oracle\product\10.2.0\server\config\log
directory. (install_directory
is typically c:\oraclexe
.)If you plan to use .NET stored procedures or Oracle Services for Microsoft Transaction Server (OraMTS), you need to enable their services on the computer where you installed Oracle Database XE, if you want them to start automatically. .NET stored procedures are installed on Oracle Database XE Server, and OraMTS can be installed on both Oracle Database XE Server and Client. Immediately after you install Oracle Database XE, their services are set to Manual.
To enable the .NET stored procedures and MTS services:
Select Start, then Control Panel.
In the Control Panel, double-click Administrative Tools, and then Services.
Right-click each of the following services, and then select Properties from the menu. Then set the service's start-up type to Automatic.
OracleXEClrAgnt (for .NET stored procedures)
OracleMTSRecoveryService (Oracle Services for Microsoft Transaction Server)
Click OK.
Start each service by right-clicking its name and selecting Start from the menu.
See Also:
Oracle Database Express Edition 2 Day Plus .NET Developer Guide for more information on .NET stored procedures
Oracle Services for Microsoft Transaction Server Developer's Guide
After you install Oracle Database XE Server, its graphical user interface is only available from the local server, not remotely.
Security Note:
With remote HTTP access to Oracle Database XE, all information exchanged between the browser and the database is in clear text—that is, unencrypted—including database user names and passwords. If this is cause for concern, do not enable remote HTTP connection to the database.If you want to use a Web browser, follow these steps:
Start Oracle Database XE.
From the Start menu, select All Programs, then Oracle Database 10g Express Edition, and then Go To Database Home Page.
In the Database Login page, log in as SYSTEM
, enter the password, and then click Login.
In the Oracle Database XE home page, click Administration.
Under Tasks, click Manage HTTP Access.
Under Manage HTTP Access, select Available from local server and remove clients.
Click Apply Changes.
If you prefer to use the SQL Command Line, follow these steps:
Start SQL*Plus and log in as SYSTEM
:
SYSTEM_DRIVE:\> sqlplus system Enter password: SYSTEM_password
Or, if you are logging in remotely:
SYSTEM_DRIVE:\> sqlplus system@xe_server_host_name Enter password: SYSTEM_password
At the SQL prompt, enter the following command:
SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
For more information on enabling a remote connection to the Oracle Database XE database, see Oracle Database Express Edition 2 Day DBA.
If you want to enable remote access to Oracle Database XE Server, install Oracle Database XE Client onto each client computer. You do not need to install Oracle Database XE Client onto the same computer as Oracle Database XE Server.
This section covers the following topics:
Performing a Graphical User Interface Installation of the Client
Enabling the Control Panel Services for Oracle Microsoft Transaction Server
After you have installed Oracle Database XE Server, and if you want to have one or more remote client connections to it, you can install Oracle Database XE Client onto each client computer.
To install Oracle Database XE Client:
Log on to Windows with Administrative privileges.
You must be part of the Administrators group on Windows to install Oracle Database XE.
Ensure that you have followed the instructions under "Installing Oracle Database XE Server" to install Oracle Database XE Server, which contains an Oracle database to which the client can connect.
Go to the following Web site:
Click Downloads and follow the instructions to make sure that you have selected the correct Oracle Database XE Client OracleXEClient.exe
installation executable.
After downloading the Oracle Database XE Client installation executable, double-click it.
In the Welcome to the InstallShield Wizard for Oracle Client Oracle Database 10g Express Edition window, click Next.
In the License Agreement window, select Accept and then click Next.
In the Choose Destination Location window, either accept the default or click Browse to select a different installation directory. (Do not select a directory that has spaces in its name.) Then click Next.
In the Summary window, click Install.
In the InstallShield Wizard Complete window, click Finish.
Note:
Thesetup.log
file indicates the success of the installation. A result code of 0 means the installation succeeded. Logs for the client component installation are in the OracleDatabaseXEClientInstall
.log
file, located in the system root directory, which is typically c:\WINDOWS
.To perform a silent installation of Oracle Database XE Client:
Log on to Windows with Administrative privileges.
You must be part of the Administrators group on Windows to install Oracle Database XE.
Go to the following Web site:
Click Free Download and follow the instructions to select and download the Microsoft Windows version of Oracle Database XE.
The installation executable for Oracle Database XE Client is OracleXEClient.exe
. Under Silent Install Response File Templates, select the OracleXEClient
response files that you want to use. These files allow you to perform silent installations, repairs (upgrades), and deinstallations.
Check the response files and modify the port number for Oracle Services for Microsoft Transaction Server, if necessary.
Run the OracleXEClient.exe
executable with the appropriate response file.
For example, if you downloaded the OracleXEClient.exe
executable and its response files to a directory called xe_temp
, you would enter the following command:
c:\xe_temp> OracleXE.exe /s /f1"c:\OracleXEClient-Install.iss" /f2"c:\setup.log"
If you wanted to reinstall the same version of Oracle Database XE, you would enter the following command:
c:\xe_temp> OracleXE.exe /s /f1"c:\OracleXEClient-Repair.iss" /f2"c:\setup.log"
After the installation is complete, Oracle Database XE starts and displays the Database Home Page.
Note:
Thesetup.log
file indicates the success of the installation. A result code of 0 means the installation succeeded. Logs for the client component installation are in the OracleDatabaseXEClientInstall
.log
file, located in the system root directory, which is typically c:\WINDOWS.
If you plan to use Oracle Services for Microsoft Transaction Server (OraMTS), you need to enable its services on the computer where you installed Oracle Database XE Client if you want it to start automatically. Immediately after you install Oracle Database XE, its service are set to Manual.
To enable the OraMTS service:
Select Start, then Control Panel.
In the Control Panel, double-click Administrative Tools, and then Services.
Right-click the OracleMTSRecoveryService service, select Properties from the menu, and then set the start-up type to Automatic.
Click OK.
Start the OracleMTSRecoverService service by right-clicking its name and selecting Start from the menu.
For more information on Oracle Makeshift Transaction Server, see Oracle Services for Microsoft Transaction Server Developer's Guide.
To configure the connection to Oracle Database XE Server, refer to Oracle Database Express Edition 2 Day DBA.
After you have installed Oracle Database XE, the database is up and running and you can begin using it right away. To start using Oracle Database XE, you can go to the Database Home Page in the Oracle Database XE graphical user interface.
Immediately after you install Oracle Database XE using the graphical user interface installation method, if you selected the Launch the Oracle Database 10g Express Edition homepage checkbox when the installation completed, the Database Home Page appears. To get started using Oracle Database XE, click Getting Started to learn how to log on and create a simple application.
If you did not select the Launch the Oracle Database 10g Express Edition homepage checkbox, or if you want to access Oracle Database XE from another computer, then follow these steps:
To access the Database Home Page, from the Start menu, select Programs (or All Programs), then Oracle Database 10g Express Edition, and then Go to Database Home Page.
If Oracle Database XE Server is installed on another computer, then you can access it from the following URL:
http://host:port/apex/
In this URL:
host
is the host name or IP address of the computer where Oracle Database XE Server is installed. If Oracle Database XE Server is on your local computer, then you can enter localhost
as the host name.
Note that the URL in the browser by default points to the localhost IP address 127.0.0.1. If you want another user to access your Oracle Database XE installation, then provide the host name or IP address of your computer.
port
is the TCP port that the Oracle Database XE HTTP listener is listening on. You set this port number during installation. Normally it is set to 8080.
For example, if Oracle Database XE Server was installed on a computer with the host name shobeen
with the default port number 8080, you would access the Database Home Page at this URL:
http://shobeen:8080/apex/
Log in to the database using the user name SYSTEM
, and supply the password that you created during installation.
To begin learning about Oracle Database XE, use the following documents:
Oracle Database Express Edition Getting Started Guide is a quick tutorial that gets you up and running using Oracle Database XE. You learn how to start Oracle Database XE and create a small application. To access this tutorial, click Getting Started on the Database Home Page.
Oracle Database Express Edition 2 Day DBA provides more detailed information on the best way to start using Oracle Database XE. To access this manual and the rest of the documentation set, click Documentation under External Links on the Database Home Page.
When you deinstall Oracle Database XE, all components, including data files, the database, and the software, are removed. If you want to save your data files but remove the Oracle Database XE software and database, then first export the data by using one of the methods described in Oracle Database Express Edition 2 Day DBA before you deinstall.
Because the deinstallation process removes all files from the directory in which Oracle Database XE is installed, back up any files from the directory (if needed) before you deinstall.
This section covers the following topics:
To deinstall Oracle Database XE by using Add or Remove Programs:
In the Windows Control Panel, select Add or Remove Programs.
Select Oracle Database 10g Express Edition.
Click Change/Remove.
In the Oracle Database 10g Express Edition - Install Wizard, select Remove, click Next, and then click Yes in the confirmation window. When the deinstallation completes, click Finish.
To perform a silent deinstallation of Oracle Database XE:
Log on to Windows with Windows administrative privileges.
Go to the following Web site:
Click Free Download and follow the instructions to select and download the Microsoft Windows version of Oracle Database XE.
The installation executable, OracleXE.exe
, comes with a set of response files that you can use to perform silent installations, repairs (upgrades), and deinstallations.
Run the OracleXE.exe
executable with the OracleXERemove.iss response file.
For example, if you downloaded the OracleXE.exe
executable and its response files to a directory called xe_temp
, you would enter the following command to deinstall Oracle Database XE Server:
c:\xe_temp> OracleXE.exe /s /f1"c:\xe_temp\response\OracleXE-Remove.iss" /f2"c:\xe_temp\setup.log"
To deinstall Oracle Database XE Client, you would enter:
c:\xe_temp> OracleXE.exe /s /f1"c:\xe_temp\response\OracleXEClient-Remove.iss" /f2"c:\xe_temp\setup.log"
The setup.log
file indicates whether the deinstallation was successful. A result code of 0
means the deinstallation succeeded.
If the deinstallation is interrupted, follow these steps to manually remove Oracle Database XE from your computer:
Step 2: Remove the Oracle Database XE Registry Editor Settings
Step 4: Remove Oracle Database XE from the Start Menu and Desktop
Step 6: Install and Run the Windows Installer CleanUp Utility
Follow these steps:
Open the Windows Services utility: From the Start menu, select All Programs, then Administrative Tools, and then Services.
If any of the following Oracle services exist and have the status Started, then select each of the services, and click Stop:
OracleXE
OracleXETNSListener
OracleJobSchedulerXE
OracleXEClrAgent
OracleMTSRecoveryService
Exit Services.
See also the Microsoft online help for more information on stopping services.
Follow these steps:
Log on to Windows with Windows administrative privileges.
Ensure that you followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop the Oracle Database XE services.
Start the Registry Editor at a command prompt:
SYSTEM_DRIVE:\> regedit
Go to HKEY_CLASSES_ROOT
.
Delete the following keys:
NEED TO CONFIRM THE XE-SPECIFIC ONES.
Go to HKEY_CURRENT_USER\Software
.
Under Microsoft\Windows\CurrentVersion\Explorer\MenuOrder\Start Menu\Programs
, delete the Oracle Database 10g Express Edition
key.
Go to HKEY_LOCAL_MACHINE\SOFTWARE
and search for the ORACLE
group key.
Expand the ORACLE
group key and then delete the KEY_XE
and OracleMTSRecoveryService
keys.
Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
.
Expand the ODBCINST.INI
key and remove the Oracle in XE
key.
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
.
Delete the following keys:
OracleServiceXE
OracleXEClrAgent
OracleXETNSListener
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application
.
Delete the Oracle.xe
key.
Exit the Registry Editor.
Restart your computer.
Follow these steps:
Open System from the Control Panel.
In the System Properties dialog box, click the Advanced tab, then click the Environment Variables button.
Select the system variable Path and edit the Path variable to remove the Oracle Database XE entry. For example:
C:\oraclexe\app\oracle\product\10.2.0\server\bin;
Save your changes and then exit the Control Panel.
Follow these steps:
Select Start, then All Programs, and then Oracle Database 10g Express Edtion.
Right-click Oracle Database 10g Express Edtion and from the menu, select Delete.
On the desktop, right-click the Get Started with Oracle Database 10g Express Edition icon and from the menu, select Cut.
Follow these steps:
Ensure that you have followed the instructions under "Step 1: Stop the Oracle Database XE Services" to stop all Oracle Database XE services.
From the Windows Explorer, navigate to the directory where you installed Oracle Database XE, for example, c:\oraclexe.
Right-click the Oracle Database XE installation directory and from the menu, select Delete.
Run the Windows Installer CleanUp utility to remove the Windows Installation configuration information for the Oracle Database XE installation. You can download it from Microsoft at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;290301
The following steps provide a method of preserving your database data when you deinstall and then reinstall the same release of Oracle Database XE Server. Refer to Oracle Database Express Edition 2 Day DBA for step details.
Create a directory in a location that is outside the standard Oracle Database XE directory structure. This directory will be the new location for the flash recovery area.
For example, create the directory outside the default installation location, which is typically c:\oraclexe
directory.
Move the flash recovery area to this new directory.
See "Setting the Flash Recovery Area Location," in Chapter 6, for instructions.
Perform a complete backup of the database to the new flash recovery area by running the Backup Database command from the desktop.
See "Backing Up the Database," in Chapter 11, for instructions. Ensure that you see the message Backup of the database succeeded before proceeding.
Deinstall Oracle Database XE, as explained in "Deinstalling Oracle Database XE".
Install Oracle Database XE, as explained in "Installing Oracle Database XE Server".
Do not perform any backups until you complete the remaining steps in this procedure.
Run the Restore Database command from the desktop.
See "Restoring and Recovering the Database," in Chapter 11, for instructions.
When the restore script prompts you for the flash recovery area location, enter the full path to the directory that you created in Step 1.
The restore script restores the database from backup.
If you find any security vulnerabilities with Oracle Database XE, then send a description of the problem to Oracle at the following e-mail address:
Include the following information in your e-mail:
A complete description of the problem you encountered
The version of Oracle Database XE you were using
The platform on which you were running Oracle Database XE
Any scripts or examples that may be helpful in tracking down the security problem
For more information on how Oracle handles security issues, visit:
Oracle Database XE is available in two character set and language configurations:
Western European
The database created using a single-byte Latin1 (WE8MSWIN1252
) character set, which is suitable for storing Western European language data.
The Oracle Application Express user interface is available in English only.
Database error messages are available in Brazilian Portuguese, English, French, German, Italian, and Spanish.
Universal
The database is created using a multibyte (AL32UTF8
) character set, which is suitable for global data in any language.
The Oracle Application Express user interface and database error messages are available in Brazilian Portuguese, Chinese (Simplified and Traditional), English, French, German, Italian, Japanese, Korean, and Spanish.
"Globalization Support: Configuring Locale and Character Sets with the NLS_LANG Parameter" provides additional character and language information.
This section explains how to configure globalization settings for both the server and client components of Oracle Database XE. It covers the following topics:
Oracle provides globalization support that enables users to interact with a database in their preferred locale and character set settings, as defined by the NLS_LANG
parameter. When you install Oracle Database XE, the installation process sets the NLS_LANG
parameter in the registry. The NLS_LANG
parameter is stored in the registry under the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\key_XE\NLS_LANG
subkey.
The locale setting of your operating system determines the value of the NLS_LANG
parameter at installation. Table 2 lists the operating system locale and NLS_LANG
value mappings.
The NLS_LANG
parameter uses the following format:
NLS_LANG
=
LANGUAGE_TERRITORY
.
CHARACTER_SET
This format is explained in the following table:
Parameter | Description |
---|---|
LANGUAGE |
Specifies the language for displaying product messages, day names, and month names in SQL.
Oracle Database Globalization Support Guide provides more information about languages. |
TERRITORY |
Specifies the cultural-specific conventions for date, number, time, and monetary formatting.
Oracle Database Globalization Support Guide provides more information about territory conventions. |
CHARACTER_SET |
Specifies the encoding used by the client application, which is usually the character set of the source data being processed, and the character set used in displaying the output.
"Supported Character Sets" provides a list of supported character sets. |
Oracle Database Globalization Support Guide provides information about the NLS_LANG
parameter and Globalization Support initialization parameters.
Table 2 lists the default NLS_LANG
values for various Windows locales.
Table 2 NLS_LANG Parameter Values for Windows Locales
Operating System Locale | NLS_LANG Value |
---|---|
Chinese (PRC) |
|
Chinese (Taiwan) |
|
English (United Kingdom) |
|
English (United States) |
|
French (Canada) |
|
French (France) |
|
German (Germany) |
|
Italian (Italy) |
|
Japanese |
|
Korean |
|
Portuguese (Brazil) |
|
Portuguese (Portugal) |
|
Spanish (Spain) |
|
Spanish (Mexico) |
|
Table 3 lists the supported character sets in Oracle Database XE. The list is ordered alphabetically in each language group.
The character set AL16UTF16
can be used only as an NCHAR
character set, and not as a database character set.
Table 3 Supported Character Sets
Name | Description |
---|---|
Asian |
|
|
EUC 24-bit Japanese |
|
The same as JA16EUC except for the way that the wave dash and the tilde are mapped to and from Unicode |
|
Shift-JIS 16-bit Japanese. The same as JA16SJISTILDE except for the way that the wave dash and the tilde are mapped to and from Unicode |
|
Microsoft Windows Code Page 932 Japanese |
|
KSC5601 16-bit Korean |
|
Microsoft Windows Code Page 949 Korean |
|
Thai Industrial Standard 620-2533 - ASCII 8-bit |
|
Microsoft Windows Code Page 1258 8-bit Vietnamese |
|
CGB2312-80 16-bit Simplified Chinese |
|
GBK 16-bit Simplified Chinese |
|
GB18030-2000 |
|
BIG5 16-bit Traditional Chinese |
|
Microsoft Windows Code Page 950 with Hong Kong Supplementary Character Set HKSCS-2001 (character set conversion to and from Unicode is based on Unicode 3.0) |
|
Microsoft Windows Code Page 950 Traditional Chinese |
|
EUC 32-bit Traditional Chinese |
European |
|
|
Latvian Standard LVS8-92(1) Windows/UNIX 8-bit Baltic |
|
ISO 8859-13 Baltic |
|
Microsoft Windows Code Page 1257 8-bit Baltic |
|
IBM-PC Code Page 775 8-bit Baltic |
|
ISO 8859-13 Celtic |
|
ISO 8859-5 Latin/Cyrillic |
|
RELCOM Internet Standard 8-bit Latin/Cyrillic |
|
KOI8 Ukrainian Cyrillic |
|
Microsoft Windows Code Page 1251 8-bit Latin/Cyrillic |
|
ISO 8859-2 East European |
|
ISO 8859-7 Latin/Greek |
|
Microsoft Windows Code Page 923 8-bit Estonian |
|
Microsoft Windows Code Page 1250 8-bit East European |
|
Microsoft Windows Code Page 1253 8-bit Latin/Greek |
|
IBM-PC Code Page 737 8-bit Greek/Latin |
|
IBM-PC Code Page 852 8-bit East European |
|
Microsoft Windows Code Page 921 8-bit Lithuanian |
|
ISO 8859-10 North European |
|
ISO 8859-4 North and North-East European |
|
IBM-PC Code Page 866 8-bit Latin/Cyrillic |
|
ISO 8859-3 South European |
|
ASCII 7-bit American |
|
IBM-PC Code Page 437 8-bit American |
|
ISO 8859-1 West European |
|
ISO 8859-15 West European |
|
Microsoft Windows Code Page 1252 8-bit West European |
|
IBM-PC Code Page 850 8-bit West European |
|
IBM-PC Code Page 858 8-bit West European |
Middle Eastern |
|
|
Arabic MS-DOS 720 Server 8-bit Latin/Arabic |
|
ASMO Extended 708 8-bit Latin/Arabic |
|
ISO 8859-6 Latin/Arabic |
|
Microsoft Windows Code Page 1256 8-Bit Latin/Arabic |
|
ISO 8859-9 Latin Azerbaijani |
|
ISO 8859-8 Latin/Hebrew |
|
Microsoft Windows Code Page 1255 8-bit Latin/Hebrew |
|
Microsoft Windows Code Page 1254 8-bit Turkish |
|
IBM-PC Code Page 857 8-bit Turkish |
|
ISO 8859-9 West European & Turkish |
Universal |
|
|
Unicode 4.0 UTF-16 Universal character set |
|
Unicode 4.0 UTF-8 Universal character set |
|
Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant |
The installation process sets the client character set in the NLS_LANG
parameter to the appropriate Windows code page, and this is the correct setting for running applications on Windows. However, this NLS_LANG
setting may not operate correctly when running command-line utilities such as SQL*Plus and SQL*Loader in MS-DOS mode. This is because MS-DOS, with a few exceptions, uses a different character set (or code page) than Windows. It is important that you set the character set in the NLS_LANG
parameter for the MS-DOS session correctly. Setting it incorrectly can lead to invalid character conversion, which can corrupt error messages and data.
Similarly, in batch mode, set the correct character set value of NLS_LANG
by inserting a SET
NLS_LANG
command at the start of the batch procedure, according to the character set of the files to be processed in the procedure.
Table 4 lists the Oracle character sets that correspond to the MS-DOS mode for various operating system locales.
Table 4 Oracle Character Sets for Windows Locales
Operating System Locale | Character Set |
---|---|
Chinese (PRC) |
|
Chinese (Taiwan) |
|
English (United Kingdom) |
|
English (United States) |
|
French |
|
German |
|
Italian |
|
Japanese |
|
Korean |
|
Portuguese |
|
Spanish |
|
This section covers the following topics:
For the latest known issues and workarounds, as well as current Oracle Database XE documentation, visit
http://www.oracle.com/technology/products/database/xe
This section lists the following installation and configuration issues:
Oracle C++ Call Interface (OCCI) libraries for developing applications with Microsoft Visual C++ version 7.1 (.NET 2003) and version 7.0 (.NET 2002) are available in Oracle Database 10g Release 2 (10.2). Microsoft Visual C++ version 6.0 is no longer supported.
Microsoft Visual C++ version 7.1 libraries are now installed in the default location: oraocci10.dll
under ORACLE_BASE
\
ORACLE_HOME
\bin
and oraocci10.lib
under ORACLE_BASE
\
ORACLE_HOME
\oci\lib\msvc
. Copies of these two files are also installed under ORACLE_BASE
\
ORACLE_HOME
\oci\lib\msvc\vc71
. The Microsoft Visual C++ version 7.0 version libraries are installed under ORACLE_BASE
\
ORACLE_HOME
\oci\lib\msvc\vc7
.
You should link applications required to link with MSVCRTD.DLL
(debug version of Microsoft C-Runtime, /MDd
compiler flag) with the specific OCCI libraries for this purpose: oraocci10d.lib
and oraocci10d.dll
.
All Instant Client packages (from Oracle Database Client) contain the Microsoft Visual C++ version 7.1 compatible version of the OCCI dynamic link library (DLL).
Applications should link with the appropriate OCCI library and ensure that the corresponding DLL is located first in the Windows system PATH
.
This section covers the following open bugs and known issues:
The Oracle Text English and French Supplied Knowledge Bases are not included in Oracle Database XE. As a result, the following functions are not available:
Index creation using a BASIC_LEXER
preference where INDEX_THEMES
=YES
SYNCing an index where INDEX_THEMES=YES
CTX_DOC.THEME
CTX_DOC.POLICY_THEME
CTX_DOC.GIST
CTX_DOC.POLICY_GIST
CTX_QUERY.HFEEDBACK
CTX_QUERY.EXPLAIN
, if using ABOUT
or THEMES
with TRANSFORM
CTX_DOC.SNIPPET
(if using the ABOUT
operator)
CTX_DOC.POLICY_SNIPPET
(if using the ABOUT
operator)
CONTAINS
queries that use ABOUT
or THEMES
with TRANSFORM
The Knowledge Base Extension Compiler, ctxkbtc
Clustering and classification services, if themes are specified
If you try to use these functions, then the following error appears:
11446,0, "supplied knowledge base file %(1)s not installed"
Workaround: Upgrade to Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition.
The following errors may appear when you try to access the Oracle Database XE home page:
403 Forbidden Error Message when accessing the Oracle Database Express Edition home page 403 Forbidden - The following error occured: Access denied by access control list.
There may be a problem with the default profile your browser is using.
Workaround: Configure your Web browser by following the instructions under "Configuring Your Web Browser".
The Manage HTTP Access page, available by selecting the Manage HTTP Access option on the Administration page, lets you control HTTP access to the database by selecting one of the following options:
Available only from local server
Available from local server and remote client
If you select either of these options and then click Apply Changes, one of the following may occur:
An error saying that the page cannot be displayed (or a 404 error, depending on your browser)
A delay, followed by a 500 server error or a blank page
You can disregard these occurrences. The option that you selected will be successfully applied.
Workaround: To avoid these occurrences, use SQL*Plus to enable or disable remote access. You can start SQL*Plus by selecting Run SQL Command Line from the Oracle Database 10g Express Edition menu. Then enter the following commands:
SQL> CONNECT SYS/AS SYSDBA (Or enter CONNECT SYSTEM) Enter password: password SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); (To enable remote access) SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(TRUE); (To disable remote access)
If other Oracle client software is installed on the same computer as Oracle Database XE, ensure that you use the appropriate connect syntax for these clients when trying to connect to Oracle Database XE. If you do not specify the appropriate connect syntax, then an "ORA-12560: TNS: protocol adapter error" message may appear.
If you are logged in as a domain user, ensure sure that you are connected to the network before you install Oracle Database XE Server. Because domain authentication is used during installation, the installation could fail you are not authenticated during installation. You will not be able to access the Database Home page at the end of installation and you will see the error "ORA-12638: Credential retrieval failed" in database creation log files.
Workaround: Log in as a local user on the system and retry the installation.
This section describes bugs and known issues for Oracle Application Express:
If you import spreadsheet data by copying and pasting and a column value contains a double quotation mark, then the data will not import correctly (for example, 54" Plasma Flat Screen
). To avoid this problem, you have two options:
Option 1:
Save the data in a delimited format (such as comma-delimited (.csv
) or tab-delimited).
Use the Import Text Data Wizard to upload and import the saved file.
Option 2:
Replace the quotation mark with two double quotation marks as shown in the following example:
54"" Plasma Flat Screen
Use the Import Spreadsheet Data Wizard to import the file.
The number or date format select dialog on the Column Attribute of a Page Definition in Application Builder displays the following message in the dialog box:
'backslash'+ 5,234.10
The yen symbol should appear accurately in a Japanese environment.
Note that backslash and yen are the same character code point, but vary in appearance depending on the selected font. The backslash character is also displayed when you apply the data format on the page in the application.
If you use a wizard to create a form on a table or view based on an included column whose name is in Japanese, then the name of the new item will be included in Japanese.
Workaround: To correct this problem, when you create new items, on the Page Definition use alphanumeric characters A to Z, 0 to 9 and '_' for the item names. You may also need to change item names to alphanumeric before you apply changes to the item.
If you download a trigger with a multibyte name from the Object Details view in Object Browser, then the file name becomes corrupt.
Workaround: Download triggers with multibyte names from the Code view.
In character sets in non-UTF8 databases, multibyte table and column names are corrupted when you generate DDL. For example, if you want to generate DDL for objects that have non-ASCII characters (for example, ä or â) and the database character set was distributed with the Western European edition (WE8MSIN1252
), these characters will be garbled in the generated script.
Database character sets of AL32UTF8
do not have this bug.
Workaround: Choose the output type of Display Inline instead of Save As Script File.
Page items of display type "Textarea with Spell Checker" or "Textarea w/Character Counter & Spellcheck" can be used as ordinary Textarea items only. The pop-up page that presents the spell checking features does not function properly.
In Application Express Application Builder, the authentication schemes defined in the current application are not displayed if you view them in Icons View mode. To view the authentication schemes, choose Details in the View select list and then click Go.
This section covers documentation corrections and additions for the following manuals:
Oracle Database Express Edition 2 Day Plus Application Express Developer Guide Updates
Oracle Database Express Edition 2 Day Developer Guide Updates
Oracle Database Express Edition 2 Day DBA has the following updates:
On Linux, before initiating a local database connection or remote database connection with SQL Command Line (SQL*Plus) or another Oracle command-line utility, you must set environment variables. (There is no need to set environment variables on the Windows platform.) See "Setting Environment Variables," in Chapter 3 of Oracle Database Express Edition 2 Day DBA for details.
When changing the location of the flash recovery area, you must run a supplied PL/SQL script to move the online redo logs to the new location. See "Setting Flash Recovery Area Location and Size," in Chapter 6 of Oracle Database Express Edition 2 Day DBA for instructions.
If you enable redo log archiving (ARCHIVELOG
mode), it is recommended that you increase the size of the flash recovery area to at least 15 gigabytes to allow for the extra space required for the archived log files. In addition, when in ARCHIVELOG
mode, you must remember to perform regular backups of the database to avoid completely filling the flash recovery area. A filled flash recovery area can lead to database failure. See "Enabling ARCHIVELOG Mode for Media Failure Protection," in Chapter 11 of Oracle Database Express Edition 2 Day DBA for more information.
If the flash recovery area is approaching 100% full (for example, 85% full or more) and log archiving is enabled (the database is in ARCHIVELOG
mode), it may be time to back up the database. Backing up the database deletes archived log files and frees space in the flash recovery area. If the flash recovery area is frequently close to 100% full after several recent backups, consider allocating more space for your flash recovery area, or, if in ARCHIVELOG
mode, taking backups more frequently to reduce the size of the retained archived log files. See "Monitoring Space in the Flash Recovery Area," in Chapter 6 of Oracle Database Express Edition 2 Day DBA for more information.
A database for which log archiving is not enabled---that is, a NOARCHIVELOG
mode database---can be backed up only while it is in the mounted (but not open) state after a successful SHUTDOWN
or SHUTDOWN IMMEDIATE
operation. The supplied backup script, which is run by the Backup Database command on the desktop, automatically puts the database in the proper state for offline backup. See "About Backing Up and Restoring the Database," in Chapter 11 of Oracle Database Express Edition 2 Day DBA for more information.
Oracle Database Express Edition 2 Day Plus Application Express Developer Guide has the following additional information:
Determining When a User Has Not Yet Authenticated to an Application
After a user logs in to an Application Express application, the APP_USER
item contains the authenticated user name and can be accessed using the bind variable :APP_USER
, or by using the function call v('APP_USER')
, or in a pure HTML context, by using the following substitution string:
&APP_USER.
Note that the trailing period in the substitution string is required.
Before a user authenticates, the value of APP_USER
depends on the type of authentication scheme used by the application. When the developer uses any of the built-in authentication schemes, this value varies slightly depending on Oracle database edition and the authentication scheme in use.
In Oracle Database XE, APP_USER
will be ANONYMOUS
when database authentication is used. This is achieved by using the built-in authentication scheme named DATABASE
. Note that if you set the application's Public User attribute to some other value, that new attribute value is used to set APP_USER
. Also, if you use any built-in authentication scheme other than DATABASE
, APP_USER
is set to 'nobody' before the user logs in.
When developing applications, be sure to plan ahead for possible upgrades to other database editions such as Oracle Database 10g Standard Edition, Oracle Database 10g Standard Edition One, or Oracle Database 10g Enterprise Edition, or for the possibility that the application might be installed in an Application Express environment installed into one of those database editions. In these editions, the same rules as explained previously apply, but with one difference. While ANONYMOUS
is used in Oracle Database Express Edition, HTMLDB_PUBLIC_USER
is used in other editions. Remember that these rules determine the setting of APP_USER
before a user has authenticated. Two examples of when this situation exists include:
When the login page itself is being rendered
During the rendering or after-submit processing of a "public" page requested before the user logs in
Sometimes it may be necessary for a block of PL/SQL code within an application to determine whether authentication has taken place. For example, this may be a requirement of an authorization scheme that requires that APP_USER
contain the authenticated username. Another use is in application processes or application computations that are intended to run only once per session, but only after login.
Consider the following PL/SQL example:
if v('APP_USER') in ('ANONYMOUS', 'HTMLDB_PUBLIC_USER', 'nobody') then -- authentication has not occurred
This code sample is written to allow for the pre-authentication APP_USER
values used in any edition of Oracle Database in which the Application Express application is run.
The following sections have been added to the book version of Oracle Database Express Edition 2 Day Developer Guide after the online help version of this manual was finalized:
New section to Chapter 4, "Using PL/SQL": "Cursor Variables (REF CURSORs)"
New section to Chapter 5, "Using Procedures, Functions, and Packages": "Accessing Types in Packages"
New sections to Chapter 6, "Using Triggers": "Firing Triggers With the INSTEAD OF Option" and "Creating a Trigger With the INSTEAD OF Option"
New appendixes: Appendix C, "Using a PL/SQL Procedure With PHP" and Appendix D, "Using a PL/SQL Procedure With JDBC"
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at
http://www.oracle.com/accessibility/
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
Oracle Database Express Edition Installation Guide, 10g Release 2 (10.2) for Microsoft Windows
B25143-03
Copyright © 2005, 2007, Oracle. All rights reserved.
The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.
If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.
Oracle, JD Edwards, and PeopleSoft are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.