Linux Installation Database Oracle 11g

1. Select the database used by bi

As a bi system, the use of a powerful background database software is essential. There are many database products with high performance and stability, such as IBM DB2, Oracle, GP and so on. These databases are commonly used in everyday enterprise-level BI systems. In terms of my personal work experience and the company's recommended use of databases, Oracle is used as a back-end database for our BI solutions.

For Oracle databases, whether it's on the web or in the real world, we can get access to it. Because it's no stranger to us, I'm not going to dwell on how good Oracle is.

In this regard, for the personal BI system, select Oracle data as the background database, of course you can also use other databases, such as DB2 as your back-end database. and its specific installation method can be consulted on the network article.

To install an Oracle 11g database for your own Linux host, it is essential to get the database installation package. We can download the database installation package from Oracle's official website and choose the appropriate version for your database.

Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html

Since my Linux system is 64-bit, I chose the 11g version of Linux x86-64

2. Install Oracle 11g Database

2.1 Preparatory work

The database is installed without the user. Before installing the Oracle database, we will first create a normal user who installs the database. Theoretically, we can use the root user to install the database. But this is dangerous from the operational perspective of the system.

We create user and user groups under DB Host (Linux)

For Oracle users, set the password

The user and user groups are created, and next you need to provide the installation directory for the installation of Oracle

It is important to note that the Oracle installation directory created at this time is owned by the root user and we also need to set these directories to the user and directory permissions

At this point, the task of creating the user and Oracle installation directory is over. We switch users to Oracle, setting the environment variables for Oracle users

At the end of the. bash_profile file, add the following information. Careful readers will find that the following Oracle environment variables added are related to the directories created above.

Export Oracle_base=/opt/oracle Export Oracle_home= $ORACLE _base/product/orahome Export ORACLE_SID=ORCL Export Oracle_owner=oracle Export oracle_term=vt100 Export path= $PATH: $ORACLE _home/bin: $HOME/bin Export path= $ORACLE _home/bin: $ORACLE _home/apache/apache/bin: $PATH Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib:/usr/local/lib Export Ld_library_path Classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib Classpath= $CLASSPATH: $ORACLE _home/network/jlib Export CLASSPATH Path= $PATH:/usr/sbin; Export PATH Path= $PATH:/usr/bin; Export PATH ora_nls33= $ORACLE _home/nls/admin/data

After saving exits, use the following command to make the environment variable effective

2.2 Installation Work

Unzip the downloaded Oracle 11g installation package (I put the installation package in the directory:/home/oracle), to unzip the installation package, it must be extracted with the root user. So I switch users here, unzip the installation package

Unzip the first zip package, which may take several minutes to decompress

Then unzip the second zip package and it may take a few minutes to unzip the process

After the decompression is complete, we can see that there is one more directory under the current directory database

At this point, I will modify the database directory to belong to the user and user group, so that the user Oracle can use and install the Oracle database

Here, the work on unpacking the installation package is over. At this point, we reboot the DB host and use the Oracle user to enter the graphical user interface. Note that the following steps must be made in the graphical user interface.

Re-use Oracle User login to enter the/home/oracle/database directory

Start installing the Oracle database with the following command, and we need to wait patiently for Linux to set up the Oracle graphical installation interface for us

The Oracle graphical interface is then installed

The first step, enter the e-mail address, can also not input, directly click Next

Second, install the option, select Install database software only (install databases software only), click Next

Third step, grid option, select Single Instance Database Installtion (one-instance DB installation), click Next

Fourth step, product language, I choose Chinese (English) and Simplified Chinese, click Next

Fifth, database editing, select Standard Edition (Standards Editor), click Next

The sixth step, the installation location, here Select the environment variables we set earlier values, see above values, click Next

Seventh step, create the inventory, select the DBA Management Group, click Next

Eighth step, operating system group, select DBA, click Next

Linux Installation Database Oracle 11g