How to install oracle command line

Oracle is one of the most popular relational databases. It is widely used in enterprise-level applications and web applications. In this article, we will learn how to install Oracle database on command line interface.

Download of Oracle database installation package

The files that need to be downloaded are provided on the Oracle official website. Just download the corresponding version of the Oracle code installation package directly. It is recommended to choose to install the latest version. Each version has a corresponding download link. The following are some download links:

Oracle 18c (Linux x86-64bit version): https://www.oracle.com/database/technologies/oracle18c-linux-180000-downloads.html

Oracle 12c (Linux x86-64bit version): https://www.oracle.com/database/technologies/oracle12c-linux-12201-downloads.html

Preparation work before installation

Before starting the installation of Oracle, some preparations need to be done. Before installation, please make sure you meet the following conditions:

1. Operating system version
   Oracle supports many operating system versions. Please make sure that the operating system version you are using is compatible with the Oracle version you downloaded.
2. System resource requirements
   Oracle requires certain system resources to run smoothly. Please ensure that your computer's hardware and operating system meet Oracle's requirements.
3. Get root permissions
   On Linux systems, installing Oracle requires root permissions, so you need to obtain root permissions. During the installation of Oracle, please do not close the command line terminal.

Installation steps

The process of installing Oracle database has the following steps:

1. Set environment variables
   Before installing Oracle, please first Set the relevant environment variables. In the "/etc/profile.d" directory of your Linux server, create a new file "oracle.sh" and enter the following content:

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/<version>/dbhome_1
export ORACLE_SID=<SID>
export PATH=$PATH:$ORACLE_HOME/bin

where "" is The Oracle version you want to install, "" is the name of your database instance. Please make changes accordingly based on your own situation.

2. Create the users and groups required for Oracle installation
   Before installing Oracle, you need to create a user named "oracle" and a group named "dba". Run the following command in the terminal:

groupadd dba
useradd -G dba oracle
passwd oracle

This will create a user named "oracle" and add it to the group "dba".

3. Extract the Oracle installation file to the server
   Upload the Oracle installation file to the server and decompress it. Run the following command in the terminal:

unzip oracle.zip

This will unzip the Oracle installation files. Next, enter the unzipped directory.

4. Run the installer
   Enter the unzipped directory, find the file named "runinstaller", and run it. In the command line terminal, run the following command:

./runinstaller

This will open the Oracle installer.

5. Installation Options
   After the installer runs, you will see an installation wizard. Follow the instructions in the installation wizard and set the installation options as required. In the settings, you need to select the installation type of Oracle, such as Enterprise Edition, Standard Edition, Express Edition, etc. You also need to select the installation location, license acceptance, etc. Make sure you set the correct value.
6. Installation Process
   Once you have set all the options, you can start the installation process. It may take some time, depending on the performance of your computer. The installer will automatically perform the necessary tasks and close when the installation is complete.
7. Configuring the Oracle database
   After the installation is complete, you need to configure the Oracle database. Run the following command in the terminal:

$ORACLE_HOME/bin/dbca

This will open the Oracle Database Configuration Assistant. Following the instructions of the configuration assistant, you will need to select the type of database to install (such as single instance, multiple instances, etc.), set the database and instance names, set database configuration parameters, etc. After you complete all necessary settings and save, the Oracle database will start running.

Summary

In this article, we learned how to install Oracle database on Linux command line interface. Oracle installation can be complicated, but as long as you follow these steps, it can be completed smoothly. After installation, please make sure to configure other settings correctly, such as backup, performance optimization, etc., to ensure system stability and optimal performance.

The above is the detailed content of How to install oracle command line. For more information, please follow other related articles on the PHP Chinese website!