Practice of installing Oracle 12c under Oracle Linux6, linux612c

Practice of installing Oracle 12c under Oracle Linux6, linux612c

After N installation attempts to vomit blood, I hope to help you and keep a note:

Conclusion: preparations before installation are critical !!! Check and recheck!

Reference: http://docs.oracle.com/cd/E16655_01/install.121/e17741/toc.htm#CEGHFFGG

********************** ORACLE 12C Installation Steps ************* *******************************

0. Software preparation: Oracle Linux 6.4 X86_64 Virtual Machine
Linuxamd64_12c_database_1of2.zip
Linuxamd64_12c_databasesilicate f2.zip




Software Download Method (omitted)
Virtual Machine installation process (Omitted ):
My VM: ip: 192.168.56.101 hostname: ol6
1) configure the local YUM source!
2) disable the Firewall
3) accessible hosts
4) Disable SELinux (getenforce; setenforce 0)
5) set the local IP address and computer name
Vi/etc/hosts
Add: 192.168.56.101 ol6
 
[Root user operation]
1. Check server hardware and memory configuration
1) Check the physical memory:
# Grep MemTotal/proc/meminfo
Minimum 1G
△ 2 GB or more are recommended


2) Check the swap space:
# Grep SwapTotal/proc/meminfo
1-2 GB memory exists, and 1.5 times the memory size is configured.
Between 2 and 16 GB, And the configuration is equal to the amount of memory
The memory is greater than 16 GB and the configuration is equal to 16 GB.


3) Check the available space of the/tmp directory
# Df-h/tmp
Enterprise 6.4 GB
Standard 6.1 GB
Standard Edition 1 6.1 GB

△Recommended: 30 GB


4) Check the remaining disk space
# Df-h


5) Check the size of memory and hard disk swap space:
# Free


6) view the Server System Architecture
# Uname-m


2. Install the required package:
1) Installation
Yum install binutils compat-libcap1 compat-libstdc ++-33 gcc-c ++ glibc-devel ksh libgcc libstdc ++-devel libaio-devel libXext unzip libxlib11 xau libxcb libXi make sysstat
2) Check
Rpm-q binutils compat-libstdc ++-33 gcc-c ++ glibc-devel ksh libaio-devel libgcc libstdc ++-devlibel xext xlibtlibx11 libau libXi make sysstat
/////// ///////////////////////////////
Binutils-2.20.51.0.2-5.11.el6 (x86_64)
Compat-libcap1-1.10-1 (x86_64)
Compat-libstdc ++-33-3.2.3-69.el6 (x86_64)
Compat-libstdc ++-33-3.2.3-69.el6 (i686)
Gcc-4.4.4-13.el6 (x86_64)
Gcc-c ++-4.4.4-13. el6 (x86_64)
Glibc-2.12-1.7.el6 (i686)
Glibc-2.12-1.7.el6 (x86_64)
Glibc-devel-2.12-1.7.el6 (x86_64)
Glibc-devel-2.12-1.7.el6 (i686)
Ksh
Libgcc-4.4.4-13.el6 (i686)
Libgcc-4.4.4-13.el6 (x86_64)
Libstdc ++-4.4.4-13. el6 (x86_64)
Libstdc ++-4.4.4-13. el6 (i686)
Libstdc ++-devel-4.4.4-13.el6 (x86_64)
Libstdc +++ devel-4.4.4-13.el6 (i686)
Libaio-0.3.107-10.el6 (x86_64)
Libaio-0.3.107-10.el6 (i686)
Libaio-devel-0.3.107-10.el6 (x86_64)
Libaio-devel-0.3.107-10.el6 (i686)
LibXext-1.1 (x86_64)
LibXext-1.1 (i686)
LibXtst-1.0.99.2 (x86_64)
LibXtst-1.0.99.2 (i686)
LibX11-1.3 (x86_64)
LibX11-1.3 (i686)
LibXau-1.0.5 (x86_64)
LibXau-1.0.5 (i686)
Libxcb-1.5 (x86_64)
Libxcb-1.5 (i686)
LibXi-1.3 (x86_64)
LibXi-1.3 (i686)
Make-3.81-19.el6
Sysstat-9.0.4-11.el6 (x86_64)
//////////////////////////////////////// ///////////////////////////////////////
Optional: unixODBC-devel pdksh


3. create user groups and users
# The Oracle Inventory group (typically, oinstall)
# The OSDBA group (typically, dba)
# The Oracle software owner (typically, oracle)
# The OSOPER group (optional. Typically, optional)
1) check whether the oinstall group exists:
# More/etc/oraInst. loc
If output is similar:
Inventory_loc =/u01/app/oraInventory
Inst_group = oinstall
Indicates that it already exists!


2) check whether the dba group exists:
# Grep dba/etc/group


3) Check whether oracle users exist:
# Id oracle


4) create groups, users, and installation Directories
Groupadd oinstall
Groupadd dba
Usermod-g oinstall-G dba oracle
Useradd-g oinstall-G dba oracle
Passwd oracle


Mkdir-p/u01/app/
Chown-R oracle: oinstall/u01/app/
Chmod-R 775/u01/app/


4. Configure Kernel Parameters and resource restrictions:
1) cp/etc/sysctl. conf/etc/sysctl. conf. bak
Vi/etc/sysctl. conf


Fs. aio-max-nr = 1048576
Fs. file-max = 6815744
Kernel. shmall = 2097152
Kernel. shmmax = 637997056
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Net. ipv4.ip _ local_port_range = 9000 65500
Net. core. rmem_default = 262144
Net. core. rmem_max = 4194304
Net. core. wmem_default = 262144
Net. core. wmem_max = 1048586
Make the configuration take effect:
/Sbin/sysctl-p


2) Add the following lines to vi/etc/pam. d/login:
Session required pam_limits.so


3) Add the following lines to vi/etc/profile:
If [$ USER = "oracle"] | [$ USER = "grid"]; then
If [$ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Umask 022
Fi


4) vi/etc/security/limits. conf


Add the following information:
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
Oracle soft stack 10240
Oracle hard stack 10240


[Oracle user operations]
6. Configure oracle environment variables:
Vi ~ /. Bash_profile


Umask 022
Export TMP =/tmp; export TMP
Export TMPDIR =/tmp; export TMPDIR
Export NLS_LANG = american_america.AL32UTF8; export NLS_LANG
Export ORACLE_BASE =/u01/app/oracle; export ORACLE_BASE
Export ORACLE_HOME = $ ORACLE_BASE/product/12.1.0/db1; export ORACLE_HOME
Export ORACLE_SID = ora12c; export ORACLE_SID
Export ORACLE_HOSTNAME = ol6; export ORACLE_HOSTNAME
Export PATH = $ ORACLE_HOME/bin: $ PATH




Make the configuration take effect:
Source ~ /. Bash_profile


7. Upload the installation package to/home/oracle and decompress the package:
Unzip linuxamd64_12c_database_1of2.zip
Unzip linuxamd64_12c_databasesilicate f2.zip


8. Switch to the root user, execute xhost +, and then switch to the oracle user:
Su-root
Xhost +
Su-oracle
Cd/home/oracle/database
./RunInstaller
Start installation...


9. Create an instance in DBCA and log on to the instance:
SQL> show user
USER is "SYS"
SQL> select banner from v $ version;


BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0-64bit Production
PL/SQL Release 12.1.0.1.0-Production
CORE 12.1.0.1.0 Production
TNS for Linux: Version 12.1.0.1.0-Production
NLSRTL Version 12.1.0.1.0-Production




--------------------------------------------
Problem 1: When runInstaller is running, the local node name cannot be retrieved.
Cause: the local IP address and computer name are not set.
Solution: vi/etc/hosts
Add: 192.168.56.101 ol6 (local IP address and computer name)


Problem 2: When Using DBCA to create an instance: encountering a ORA-00119 and a ORA-00130
Cause: ORACLE environment variable ORACLE_HOSTNAME = rhl6 setting error
Solution: cat/etc/sysconfig/network
NETWORKING = yes
HOSTNAME = ol6
Modify oracle environment variables: vi ~ /. Bash_profile
ORACLE_HOSTNAME = ol6























-------------------------

Dylan Present.

Oracle Linux 6 installation of oracle 10g tutorial, an appearance

Query version
Disk space limit
Software Package dependency
Host Name and resolution address
User and resource restrictions
System resource restrictions
Do not forget to set oracle environment variables
And shell restrictions
Then unpack and mount the image
Product Installation

Oracle Linux 62

To be honest, there are only a few packages. In addition, ORACLE automation is too early, especially tuning. But for LINUX, it is good to pack a few packages. I also want to contact you to write SHELL, especially if the preset parameters are standard. Can we use the technology as a standard?