Moment For Technology

Install and configure an Oracle 11g database

Posted on Oct. 14, 2023, 11:56 p.m. by 李冠廷
Category: The back-end Tag: The back-end oracle

Oracle products are available in multiple versions, each offering different functions.

Standard edition 1: The most basic version, including basic database capabilities, licensed only on servers with a maximum capacity of two processors.

Standard edition: In addition to incorporating the ease of use, capabilities, and performance of Standard Edition 1, it utilizes RAC (true Application clustering) to provide support for larger machines and service clusters. Server clusters of up to 4 processors are supported.

Enterprise edition: Provides efficient, reliable, and secure data management for mission-critical applications. Enterprise Edition runs on Windows, Linux, and UNIX clustered servers or a single server and contains all components of the Oracle database.

Personal version: only provides Oracle as a DBMS basic data management services, suitable for single-user development environment, the system configuration requirements are low, mainly for development technical personnel.

Currently, Oracle can be downloaded for free directly from its official website. Its products are sold through a License licensing mechanism. The free software provided by Oracle is mainly aimed at students and small and medium-sized enterprises, with the aim of familiarizing them with Oracle to capture potential future markets. Different from the free download version, after the purchase of the official version of Oracle, users will be given a product service code, which can be used to get Oracle online upgrade and other services. The services of Oracle are divided into several levels, and different levels provide corresponding online or on-site services.

Oracle licenses can be purchased in two ways: by number of users and number of cpus (that is, wireless user edition). What is the number of users when buying Oracle? The number of users authorized by the Oracle database refers to the number of users connected to the Oracle database. It can only be used on a single system based on the number of users and cannot be installed on multiple machines. Each User accessing the Oracle database, whether natural or device, is counted as a User (Named User). In the case of B/S architecture, this is the number of users connected to the middleware. A site with a lot of traffic, thousands of users a day, how many users? In this case, buy by CPU number.

As can be seen from the download license agreement on the official website of Oracle, the downloaded software products can only be used for learning and training, and shall not be used for commercial purposes. Users who use unauthorized software cannot get technical support from Oracle, and if found out, the cost can be far greater than the cost of buying the legitimate software. Therefore, enterprises should use legitimate Oracle software.

1. Before installing Oracle Database, you must identify the conditions required for the system installation

In the above requirements, processor speed and memory size directly affect the speed of Oracle operation. Therefore, the higher the hardware configuration, the better. In general, the server configuration should be higher than the client configuration, and the higher the configuration, the faster the installation

2. Install the Oracle Database using the GUI

2.1 Installation Preparations

Go to to download the software. On the homepage of the Oracle database, click on the Downloads page to view the download link.

Click Oracle Database. On the page that is displayed, select Accept License Agereement to Accept the License agreement.

Slide the mouse to the bottom of the page to find the appropriate version of Oracle installation.

Tip: both 32-bit and x86 are suitable for 32-bit systems, while 64-bit refers to 64-bit systems.

Below, we need to check whether our environment can meet the installation requirements of Oracle. The main points need to be noted are as follows:

Read the online documentation carefully to ensure that the current installation environment meets the installation requirements. If the Oracle database has been installed, uninstall the Oracle_Home environment variable. If an Oracle is currently installed and you want to reinstall it, stop all Oracle services. The procedure is as follows: Go to [Control Panel] → [Administrative Tools] → [Services] in the Windows operating system, and stop all services starting with Oracle. Otherwise, an error message will appear during the installation. To ensure smooth system installation, you are advised to copy the Oracle Database 11G installation CD-ROM to a directory on the hard disk.

2. Installation procedure: This section uses Oracle 11G enterprise edition as an example.

Step 1 ☞

Open the directory where the Oracle 11g installation package is stored, and decompress the two packages to the same folder. The following figure shows the decompressed folder.

Step 2 Double-click the setup.exe file to start the Oracle Universal Installer installation tool. The following information is displayed.

Step 3 After the Oracle Universal Installer installation tool has checked the software and hardware environment of the current system, the Configure Security Update page is displayed, as shown in Figure 2-10. Unmark the "I wish to receive security updates through My Oracle Support" check box, empty the "Email" text box, and click the "Next" button.

Step 4☞ The unspecified email address dialog box is displayed, as shown in Figure 2-11. Select Yes.

Step 5 On the displayed installation options screen, select Create and Configure database (see Figure 2-12), and click Next.

Step 6 The System page is displayed, select Desktop, and click Next.

Step 7 ☞

The Typical Installation window is displayed, as shown in Figure 2-14. Select the installation disk, set file directory, select the database version of Enterprise Edition, enter global database name and Login password, and click Next.

Step 8 If a warning dialog box is displayed, click Yes. The Perform Prerequisite Check page is displayed to check the minimum configuration required to install the product, as shown in the figure below.

Step 9 ☞

After the check is complete, the check found that some system configurations do not meet the minimum requirements for Oracle installation is displayed. Select the Ignore all check box and click Next.

Step 10 ☞

On the Summary page that is displayed, click Finish.

SID is a unique identifier of a database. Both SID and the database name are unique identifiers of a database, but there are significant differences in their functions. SID is used to perform certain DBA operations and interact with the operating system. To access an instance name from the operating system perspective, you must pass ORACLE_SID, and it also exists in the registry. Database names are used when installing databases, creating new databases, creating database control files, modifying data structures, and backing up and restoring databases.

Step 11☞ The Install Product page is displayed, showing the installation progress

Step 12 ☞

When the progress bar on the Install Product screen reaches 100%, the Database Configuration Assistant screen is displayed.

Step 13 ☞

When the progress bar on the Database Configuration Assistant reaches 100%, the files required for Oracle 11G database installation have been copied. The Installation Information dialog box is displayed.

Step 14 ☞

Click the "OK" button in the figure above to open the "Finish" interface. Click the "Close" button in the figure to complete the installation of Oracle 11G database.

About (Moment For Technology) is a global community with thousands techies from across the global hang out!Passionate technologists, be it gadget freaks, tech enthusiasts, coders, technopreneurs, or CIOs, you would find them all here.