Installing Oracle Database XE on a Linux Platform

In this fourth part of a five-part article series, we pick up where we left off from the last part, installing Oracle Database XE on a Linux platform. This article is excerpted from chapter 27 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

Swap File Space

Depending on the amount of RAM in your workstation, you must have additional swap file space allocated for both the installation process and for Oracle Database XE while it runs. Table 27-2 shows the memory range and the corresponding minimum swap file space requirements.

Table 27-2. Minimum Linux Swap Space Requirements   

Memory Range 128MB–256MB

Minimum Swap Space Required 3X RAM size

256MB–512MB

2X RAM size

More than 512MB

1GB

Use the free command to see the current amount of allocated swap file space. To allocate a new swap file using either a disk partition or a regular file, see the Linux Code Inline pages for the mkswap and swapon commands. Be sure to allocate enough swap space to accommodate the needs of the other applications you run on your workstation.

System Privileges

Finally, you must install Oracle Database XE logged in as root . Access to the root account (or equivalent) is required to adjust system parameters and swap file space as well.

Downloading the Installation Files

Navigate to the Oracle Web site download area for Oracle Database XE,  http://www.oracle.com/ technology/software/products/database/xe/ index.html , and follow the links to download the Linux version of Oracle Database XE. Registration for OTN is required and gives you access to many other resources on http://otn.oracle.com . The Linux version will run fine on the distributions mentioned earlier in this chapter. The installation may work on other Linux distributions, but proceed at your own risk.

There are two installation files available, oracle-xe-10.2.0.1-1.0.i386.rpm and oracle-xe_ 10.2.0.1-1.0_i386.deb . As you might expect, the first one works with all Linux distributions except for Debian; and the second one is specifically for the Debian package manager. (The Debian package manager is similar in many ways to the Red Hat package manager.) If you are going to access Oracle Database XE on the same computer where you installed it, you do not need to install the client files.

{mospagebreak title=Performing the Installation} 

To begin the installation process, locate the rpm file you downloaded in the previous section and run the rpm command as follows:

[root@phpxe tmp]# rpm -ivh oracle-xe-10.2.0.1-1.0.i386.rpm

——————————————–
Preparing… ########################################### [100%]
   1:oracle-xe ########################################### [100%]
Executing Post-install steps…

You must run ‘/etc/init.d/oracle-xe configure’ as the root user to
configure the database.

[root@phpxe tmp]#

——————————————–

As the output of this installation step implies, you need to run /etc/init.d/oracle-xe configure next. The dialog in Listing 27-2 prompts you for the administrative interface port number, the Oracle listener port number, the password for the SYS and SYSTEM accounts, and whether you want to start Oracle automatically when your workstation boots.

Listing 27-2.Oracle Database XE Installation Dialog on Linux

[root@phpxe tmp]# /etc/init.d/oracle-xe configure

——————————————–

Oracle Database 10g Express Edition Configuration
———————————–
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that will be used for database accounts. Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of different passwords for each database account. This can be done after
initial configuration: *********
Confirm the password: *********

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener…
Done
Configuring Database…
Done
Starting Oracle Database 10g Express Edition Instance…Done
Installation Completed Successfully.
To access the Database Home Page go to http://127.0.0.1:8080/apex
[root@phpxe tmp]#

——————————————–

In this example, you accept the defaults for port numbers and startup options. The installer starts the listener, configures the database, and starts the administrative Web interface service. To access the Oracle Database XE administrative interface, navigate to the URL you see at the end of the installation dialog:

http://127.0.0.1:8080/apex

You should see the Oracle Database XE administrative interface you saw in Chapter 25. If you are using Debian Linux, the previous steps are the same except that you initiate the installation process using the Debian package manager as follows:

dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb

Please check back next week for the conclusion to this article.

[gp-comments width="770" linklove="off" ]

chat sex hikayeleri Ensest hikaye