Install Oracle 11.2.0.3____oracle on CentOS 7

Source: Internet
Author: User
Tags centos sqlplus

Some simple process is not listed here, there are many online, here is the main write down some of the problems encountered, as well as solutions

The environment of CentOS 7 is

$ uname-a
Linux Oracle 3.10.0-123.13.1.el7.x86_64 #1 SMP Tue DEC 9 23:06:09 UTC 2014 x86_64 x86_64 x86_64 gnu/linux
Note installation requires a desktop system (X-windows + KDE or Gnome) to be installed or the installer will not run.

Then modify the system parameters such as shared memory and so on as needed. This is not written, there are many online. However, according to my test, CentOS7 seemingly does not need to modify is also possible, Oracle in the installation of the inspection did not report the problem (and not the same as before). Of course, in order to tune the performance of the database, or modify the good.


Install GCC because the following Oracle link will use the

Yum Install GCC

The installation result is

GCC--version
gcc (gcc) 4.8.2 20140120 (Red Hat 4.8.2-16)
Copyright (C) 2013 Free Software Foundation, Inc.
This is free software; The source for copying conditions.  There is NO
warranty, not even to merchantability or FITNESS for A particular.


(note here, because the difference between 3.4 and 4.8 of the installed parameters, link will fail, the solution is later)

1. Download, need to download two files

P10404530_112030_linux-x86-64_1of7.zip

P10404530_112030_linux-x86-64_2of7.zip

2. Unzip and extract the two files into the same directory

3. Run installer. Intermediate dependency Check that step, you can skip. Because Oracle wants to check if the GCC,GLIBC is installed, and so on older versions (3.4)

4. Everything goes well ahead. To link that step, a mistake. Log display

Error in invoking target ' agent NMHS '

Found the solution on the Internet:

VI $ORACLE _home/sysman/lib/ins_emagent.mk
Search for the line 
$ (mk_emagent_nmectl) Change
it to:
$ ( MK_EMAGENT_NMECTL)-lnnz11
5. Retry Retry. That's OK.

6. After that, there is no problem. Normal installation, execute root script, and so on.

7. Reboot the server after installation.

8. After reboot, check the Oracle user's environment variables:

Declare-x oracle_home= "/home/oracle/app/oracle/product/11.2.0/dbhome_1"
declare-x ORACLE_SID= "ORCL"
9. Enter $oracle_home/network/admin, check Listener.ora:


[Oracle@oracle admin]$ cat Listener.ora 
# Listener.ora Network Configuration File:/home/oracle/app/oracle/product /11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

Sid_list_listener = 
(sid_list = ( 
  Sid_desc = 
    (sid_name = ORCL)    
    (oracle_home =/home/oracle/app/oracle/ product/11.2.0/dbhome_1) 
  )

LISTENER =
  (description_list = (
    DESCRIPTION =
      (address = ( PROTOCOL = TCP) (HOST = 10.16.33.212) (PORT = 1521))

Adr_base_listener =/home/oracle/app/oracle

Focus on checking if the sid,host,port,oracle_home is correct. If the incorrect client reports Error-ora-12514:tns: The listener is currently unable to recognize the service error requested in the connection descriptor.

If there is no problem, go to $oracle_home/bin and start the listener:

[oracle@oracle bin]$./lsnrctl lsnrctl for linux:version 11.2.0.3.0-production on 16-DEC-2014 11:22  : Copyright (c) 1991, Oracle.

All rights reserved. Welcome to Lsnrctl, type ' help ' for information. 
lsnrctl> Start starting/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr:please Wait ... Tnslsnr for linux:version 11.2.0.3.0-production System parameter file is/home/oracle/app/oracle/product/11.2.0/dbhome _1/network/admin/listener.ora Log Messages Written to/home/oracle/app/oracle/diag/tnslsnr/oracle/listener/alert/ Log.xml listening on: (Description= (Address= (protocol=tcp) (host=10.16.33.212) (port=1521)) connecting to (
Description= (address= (protocol=tcp) (host=10.16.33.212) (port=1521)) STATUS of the LISTENER------------------------ Alias                     LISTENER Version         & nbsp         Tnslsnr for linux:version 11.2.0.3.0-production Start Date         &NBS P      16-dec-2014 11:22:07 Uptime                    0 Day S 0 hr. 0 min. 0 sec Trace level         &nbsp     off security                  on:local OS authentication SNMP                      off Listener Parameter File  /HOME/ORACL E/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora listener Log File        /home/ Oracle/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml listening Endpoints Summary ...   DESCRIPTION= (
Address= (PROTOCOL=TCP) (host=10.16.33.212) (port=1521)) Services Summary ...
Service "ORCL" has 1 instance (s).
  Instance "ORCL", Status UNKNOWN, has 1 handler (s) for this service ...
 The command completed successfully lsnrctl> 
Start normally, start the database using Sqlplus:

[Oracle@oracle bin]$./sqlplus '/As Sysdba '
sql> startup
Oracle instance started.


Total System Global area 960372736 bytes
Fixed size 2234160 bytes
Variable Size 5578 44688 bytes
Database buffers 394264576 bytes Redo buffers 6029312 bytes
database mount Ed.
Database opened.

Centos7 brought SELinux and turned it off.

Centos7 with the next generation of firewall firewalld, turn off, otherwise the client connection will report TNS timeout anomaly.

[root@oracle ~]# service Firewalld stop
redirecting to/bin/systemctl stop  Firewalld.service


===============================================

Now other machines should be able to connect properly and use Oracle.

Another: The most convenient thing for Oracle is to install it on Oracle's own Enterprise Linux. Those dependencies, system parameters, and so on don't need to be set up.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.