Remote Installation of Oracle DB 12c

Recently, we tried to upgrade our company's DataWit Business Intelligence System ETL tool to test the support capability for Oracle Database 12c. Therefore, we need to establish a test environment.

I remotely install the Oracle DB 12c database to a server in the private cloud through the SSH client. The operating system of this server is 64-bit Oracle Enterprise Linux 6.5, and the Minimal mode is selected during installation, therefore, the desktop environment is not installed. The server allocates 2 GB of memory and 4 GB of Swap space. The remaining 20 GB space is reserved to meet the minimum installation requirements. The entire installation process is about 1.5 hours. It is not difficult to pay attention to the details.

1. Prepare 1.1 to obtain Oracle Database 12c before installation

When Oracle sells databases, it sells authorization. You can purchase authorization based on the number of users or the number of CPUs. If you only want to study, you can download the database installation file from the official Oracle website.

The target operating system I selected is Oracle Enterprise Linux 6.5, and the downloaded version is OracleDatabase 12c Release 1 (12.1.0.1.0) for Linux x86-64. As follows:

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-linux-download-1959253.html

Currently, only the 64-bit Linux version of Oracle DB 12c is available. It only supports Oracle Enterprise Linux, Red Hat guest iselinux (Centos), and SUSE Linux Enterprise.

After downloading the file, decompress it to any location on the server, such as the user's home directory. The default decompression path is ~ \ Database directory.

1.2 installation document

Reading the installation documents carefully is the best way to learn, because with the development of database technology, the database is no longer a standalone software. My introduction is limited to the most basic single-instance database installation method. More features and tools can only be installed in the documentation for answers.

Complete installation documentation:

Http://docs.oracle.com/cd/E16655_01/install.121/e17720/olinrpm.htm#LADBI7478

Quick installation documentation:

Http://docs.oracle.com/cd/E16655_01/install.121/e17718/toc.htm

1.3 client tools and Operating Systems

Because it is installed on a Linux system without a desktop environment, and Oracle DB 12c must be installed in a graphical manner, X11 transmission technology is required. This technology enables the client to run graphical programs on the server.

The SSH client tool I selected is PuTTY, which supports X11 technology. When establishing a connection, you need to check the Enable X11 forwarding option on the Connection-SSH-X11 tab.

To implement X11 transmission, the X Window environment must be installed in the operating system of the SSH client. The simplest method is to perform the installation on a machine installed with a Linux desktop environment, such as the Ubuntu or Fedora desktop edition.

If you are running an SSH client on Windows or Mac OS, you need to install the X Window simulator, the most commonly used is Xming. After Xming is installed and started, run Putty.

2. server environment Configuration

Use PuTTY to remotely connect to the server and use the root user to log on to the server and configure the system.

2.1 configure the Hosts file

Edit the/etc/hosts file and add the following rules:

<IP address> <complete machine Name> <machine Name>

For example:

192.168.0.31 OEL6-X64.localdomain OEL6-X64

2.2 install essential programs for the Oralce database server and configure the system

Oracle provides a program for automatically configuring servers. You only need to run the following commands online:

yum install oracle-rdbms-server-12cR1-preinstall -y

After the command is executed, update the system and run the following command:

yum update

The automatic configuration tool installs a series of essential programs, creates Oracle user groups and users, and configures system files.

2.3 set password for oracle users

The oracle user is required during database installation and operation. Therefore, you can create a password for the oracle user by running the following command:

passwd oracle

2.4 modify nproc restrictions

Edit the/etc/security/limits. d/90-nproc.conf file and change the nproc value from 1024 to 16384, as shown below:

soft nproc 16384

2.5 configure SELinux

Modify the/etc/selinux/config file and set SELinux to permissive, as shown below:

SELINUX=permissive

After modification, you must restart the server and then execute the following command:

setenforce Permissive

2.6 disable the iptables service

Run the following command to disable the iptables service:

service iptables stopchkconfig iptables off

2.7 create installation path

Run the following command to create the installation path and modify the access permission:

mkdir -p /u01/app/oracle/product/12.1.0/db_1chown -R oracle:oinstall /u01chmod -R 775 /u01

2.8 configure oracle user environment variables

Modify the/home/oracle/. bash_profile file and add the following content:

# Oracle Settingsexport TMP =/tmpexport TMPDIR = $ TMPexport ORACLE_HOSTNAME = OLE6-X64.localdomain (modify your full host name) export ORACLE_UNQNAME = orcl (change your global name to be used during next installation) export ORACLE_BASE =/u01/app/oracleexport ORACLE_HOME = $ ORACLE_BASE/product/12.1.0/db_1export ORACLE_SID = orcl (change it to your SID and use it during next installation) export PATH =/usr/sbin: $ PATHexport PATH = $ ORACLE_HOME/bin: $ PATHexport LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/libexport CLASSPATH = $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib

3. Oracle DB 12c Installation Process

Re-open a PuTTY program, check the X11 forwarding option, and use an oracle user to log on to the server.

3.1 set the X11 output position

Enter the following command:

Xhost + 
For example:
xhost +vd-ubuntu-dev
If the operation succeeds, the system prompts vd-ubuntu-dev being added to access control list. Otherwise, check the X11 configuration of PuTTY, or because the SSH client system does not have the X11 environment.
3.2 execute the installation process

Run the runInstaller program in the installation path of Oracle DB 12c as follows:

./runInstaller
The system starts self-check, as shown in:






If all of them pass through, a graphical interface will be opened to start installation. You must enter the Email addresses supported by Oracle in the interface. If you have not purchased the authorization for Oracle DB 12c, you can skip this step, as shown below:



If you have not purchased the Oracle DB 12c authorization, you can skip this step:



Select the installation method. Create and configure a database indicates that a database instance is installed and configured, as shown below:



Select the system type. For a Desktop system, select Desktop class. In this example, the Server system is used. Therefore, select Server class as follows:



Select the grid installation option. In this example, the grid operation function is not configured. Therefore, select Single instance database installation. The corresponding option is Single instance database installation, as shown below:



Select a Typical installation or advanced installation. The Typical installation corresponds to the Typical Install option, as shown below:



Configure the installation path, storage type, global database name, and database password. It must correspond to the oracle user's environment variable configuration as follows:



Configure the database repository path and the user group information for installation, as shown below:



Verify system requirements. If the server configuration and installation configuration are not abnormal, you can install them. As follows:



In the installation configuration section, click the Install command to start installation. As follows:



During the installation, the system prompts the root user to execute two scripts. After the script is executed, click OK to continue. As follows:




After installing and configuring the database, the system displays information about the current instance. As follows:


After the installation is complete, you can log on to the Enterprise Manager Web to view the database and instance information. As follows: