Create groups and users

 

[root@vmdb12c ~]# groupadd oinstall[root@vmdb12c ~]# groupadd dba[root@vmdb12c ~]# groupadd oper[root@vmdb12c ~]# groupadd backupdba[root@vmdb12c ~]# groupadd dgdba[root@vmdb12c ~]# groupadd kmdba[root@vmdb12c ~]# useradd -g oinstall -G dba,oper,backupdba,dgdba,kmdba oracle[root@vmdb12c ~]# passwd oracleChanging password for user oracle.New password: BAD PASSWORD: it is based on a dictionary wordBAD PASSWORD: is too simpleRetype new password: passwd: all authentication tokens updated successfully.[root@vmdb12c ~]# id oracleuid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(backupdba),505(dgdba),506(kmdba)

Oracle Installation Prerequisites

 

 

[root@vmdb12c yum.repos.d]# wget http://public-yum.oracle.com/public-yum-ol6.repo  --2013-09-01 14:05:42--  http://public-yum.oracle.com/public-yum-ol6.repoResolving public-yum.oracle.com... 137.254.56.43Connecting to public-yum.oracle.com|137.254.56.43|:80... connected.HTTP request sent, awaiting response... 200 OKLength: 2778 (2.7K) [text/plain]Saving to: “public-yum-ol6.repo.3”100%[===========================================================================================================================================================================================>] 2,778       --.-K/s   in 0s      2013-09-01 14:05:42 (280 MB/s) - “public-yum-ol6.repo.3” saved [2778/2778]

[root@vmdb12c ~]# yum install oracle-rdbms-server-12cR1-preinstallLoaded plugins: refresh-packagekit, securitySetting up Install ProcessResolving Dependencies--> Running transaction check---> Package oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-8.el6 will be installed--> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64--> Processing Dependency: ksh for package: oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64--> Processing Dependency: libaio-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64--> Processing Dependency: compat-libstdc++-33 for package: oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64--> Running transaction check---> Package compat-libcap1.x86_64 0:1.10-1 will be installed---> Package compat-libstdc++-33.x86_64 0:3.2.3-69.el6 will be installed---> Package ksh.x86_64 0:20100621-19.el6_4.4 will be installed---> Package libaio-devel.x86_64 0:0.3.107-10.el6 will be installed--> Finished Dependency ResolutionDependencies Resolved===================================================================================================================================================================================================================================== Package                                                                  Arch                                       Version                                                    Repository                                      Size=====================================================================================================================================================================================================================================Installing: oracle-rdbms-server-12cR1-preinstall                                     x86_64                                     1.0-8.el6                                                  ol6_latest                                      15 kInstalling for dependencies: compat-libcap1                                                           x86_64                                     1.10-1                                                     ol6_latest                                      17 k compat-libstdc++-33                                                      x86_64                                     3.2.3-69.el6                                               ol6_latest                                     183 k ksh                                                                      x86_64                                     20100621-19.el6_4.4                                        ol6_latest                                     686 k libaio-devel                                                             x86_64                                     0.3.107-10.el6                                             ol6_latest                                      13 kTransaction Summary=====================================================================================================================================================================================================================================Install       5 Package(s)Total download size: 913 kInstalled size: 2.4 MIs this ok [y/N]: yDownloading Packages:(1/5): compat-libcap1-1.10-1.x86_64.rpm                                                                                                                                                                       |  17 kB     00:00     (2/5): compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm                                                                                                                                                            | 183 kB     00:01     (3/5): ksh-20100621-19.el6_4.4.x86_64.rpm                                                                                                                                                                     | 686 kB     00:02     (4/5): libaio-devel-0.3.107-10.el6.x86_64.rpm                                                                                                                                                                 |  13 kB     00:00     (5/5): oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64.rpm                                                                                                                                              |  15 kB     00:00     -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Total                                                                                                                                                                                                163 kB/s | 913 kB     00:05     warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEYRetrieving key from http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6Importing GPG key 0xEC551F03: Userid: "Oracle OSS group (Open Source Software group) 
    
     " From  : http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6Is this ok [y/N]: yRunning rpm_check_debugRunning Transaction TestTransaction Test SucceededRunning Transaction  Installing : ksh-20100621-19.el6_4.4.x86_64                                                                                                                                                                                    1/5   Installing : libaio-devel-0.3.107-10.el6.x86_64                                                                                                                                                                                2/5   Installing : compat-libstdc++-33-3.2.3-69.el6.x86_64                                                                                                                                                                           3/5   Installing : compat-libcap1-1.10-1.x86_64                                                                                                                                                                                      4/5   Installing : oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64                                                                                                                                                             5/5   Verifying  : compat-libcap1-1.10-1.x86_64                                                                                                                                                                                      1/5   Verifying  : compat-libstdc++-33-3.2.3-69.el6.x86_64                                                                                                                                                                           2/5   Verifying  : libaio-devel-0.3.107-10.el6.x86_64                                                                                                                                                                                3/5   Verifying  : oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64                                                                                                                                                             4/5   Verifying  : ksh-20100621-19.el6_4.4.x86_64                                                                                                                                                                                    5/5 Installed:  oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-8.el6                                                                                                                                                                            Dependency Installed:  compat-libcap1.x86_64 0:1.10-1                      compat-libstdc++-33.x86_64 0:3.2.3-69.el6                      ksh.x86_64 0:20100621-19.el6_4.4                      libaio-devel.x86_64 0:0.3.107-10.el6                     Complete!
    

 

[root@vmdb12c ~]# cat /etc/sysctl.conf          # Kernel sysctl configuration file for Red Hat Linux## For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and# sysctl.conf(5) for more details.# Controls IP packet forwardingnet.ipv4.ip_forward = 0# Controls source route verificationnet.ipv4.conf.default.rp_filter = 1# Do not accept source routingnet.ipv4.conf.default.accept_source_route = 0# Controls the System Request debugging functionality of the kernelkernel.sysrq = 0# Controls whether core dumps will append the PID to the core filename.# Useful for debugging multi-threaded applications.kernel.core_uses_pid = 1# Controls the use of TCP syncookiesnet.ipv4.tcp_syncookies = 1# Disable netfilter on bridges.net.bridge.bridge-nf-call-ip6tables = 0net.bridge.bridge-nf-call-iptables = 0net.bridge.bridge-nf-call-arptables = 0# Controls the default maxmimum size of a mesage queuekernel.msgmnb = 65536# Controls the maximum size of a message, in byteskernel.msgmax = 65536# Controls the maximum shared segment size, in bytes# Controls the maximum number of shared memory segments, in pageskernel.shmall = 4294967296# oracle-rdbms-server-12cR1-preinstall setting for fs.file-max is 6815744fs.file-max = 6815744# oracle-rdbms-server-12cR1-preinstall setting for kernel.sem is '250 32000 100 128'kernel.sem = 250 32000 100 128# oracle-rdbms-server-12cR1-preinstall setting for kernel.shmmni is 4096kernel.shmmni = 4096# oracle-rdbms-server-12cR1-preinstall setting for kernel.shmall is 1073741824 on x86_64# oracle-rdbms-server-12cR1-preinstall setting for kernel.shmmax is 4398046511104 on x86_64kernel.shmmax = 4398046511104# oracle-rdbms-server-12cR1-preinstall setting for net.core.rmem_default is 262144net.core.rmem_default = 262144# oracle-rdbms-server-12cR1-preinstall setting for net.core.rmem_max is 4194304net.core.rmem_max = 4194304# oracle-rdbms-server-12cR1-preinstall setting for net.core.wmem_default is 262144net.core.wmem_default = 262144# oracle-rdbms-server-12cR1-preinstall setting for net.core.wmem_max is 1048576net.core.wmem_max = 1048576# oracle-rdbms-server-12cR1-preinstall setting for fs.aio-max-nr is 1048576fs.aio-max-nr = 1048576# oracle-rdbms-server-12cR1-preinstall setting for net.ipv4.ip_local_port_range is 9000 65500net.ipv4.ip_local_port_range = 9000 65500

 

[root@vmdb12c ~]# cat /etc/security/limits.conf |grep -v ^#oracle   soft   nofile    1024oracle   hard   nofile    65536oracle   soft   nproc    2047oracle   hard   nproc    16384oracle   soft   stack    10240oracle   hard   stack    32768

Cannot Increase "nproc" Value More Than 1024 in Oracle Linux 6 (Doc ID 1487773.1)

 

 

[root@vmdb12c ~]# cat /etc/security/limits.d/90-nproc.conf   # Default limit for number of user's processes to prevent# accidental fork bombs.# See rhbz #432903 for reasoning.#*          soft    nproc     1024*          -    nproc     16384root       soft    nproc     unlimited

Create the directories in which the Oracle software will be installed

 

 

[root@vmdb12c ~]# mkdir -p /u01/app/oracle[root@vmdb12c ~]# chown -R oracle:oinstall /u01/app[root@vmdb12c ~]# chmod -R 775 /u01

Add the following lines at the end of the "/home/oracle/.bash_profile" file

 

 

alias ls="ls -FA"ORACLE_SID=zwc; export ORACLE_SIDORACLE_UNQNAME=zwc; export ORACLE_UNQNAMEORACLE_BASE=/u01/app/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1; export ORACLE_HOMEORACLE_PATH=/u01/app/common/oracle/sql; export ORACLE_PATHORACLE_TERM=xterm; export ORACLE_TERMTNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMINORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANGPATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatchPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binPATH=${PATH}:/u01/app/common/oracle/binexport PATHLD_LIBRARY_PATH=$ORACLE_HOME/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexport LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRECLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexport CLASSPATHTHREADS_FLAG=native; export THREADS_FLAGexport TEMP=/tmpexport TMPDIR=/tmpumask 022

 

Installation

 

 

Create Database

 

[oracle@vmdb12c admin]$ sqlplus system/oracle@192.168.1.14:1527/zwcSQL*Plus: Release 12.1.0.1.0 Production on Sun Sep 1 14:59:14 2013Copyright (c) 1982, 2013, Oracle.  All rights reserved.Last Successful login time: Sun Sep 01 2013 14:58:52 +08:00Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> show pdbs    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 ZHONGWC1                       READ WRITE NO         4 ZHONGWC2                       READ WRITE NOSQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options[oracle@vmdb12c admin]$ sqlplus system/oracle@192.168.1.14:1527/zhongwc1SQL*Plus: Release 12.1.0.1.0 Production on Sun Sep 1 14:59:20 2013Copyright (c) 1982, 2013, Oracle.  All rights reserved.Last Successful login time: Sun Sep 01 2013 14:58:58 +08:00Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> show pdbs    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         3 ZHONGWC1                       READ WRITE NOSQL> alter session set container=zhongwc2;Session altered.SQL> show pdbs    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         4 ZHONGWC2                       READ WRITE NOSQL> create user zwc identified by zwcpwd;User created.SQL> grant dba to zwc;Grant succeeded.SQL> conn zwc/zwcpwd@192.168.1.14:1527/zhongwc1ERROR:ORA-01017: invalid username/password; logon deniedWarning: You are no longer connected to ORACLE.SQL> conn zwc/zwcpwd@192.168.1.14:1527/zhongwc2Connected.SQL>

 

C:\>sqlplus zwc/zwcpwd@192.168.1.14:1527/zhongwc2SQL*Plus: Release 11.2.0.3.0 Production on 星期日 9月 1 15:03:48 2013Copyright (c) 1982, 2011, Oracle.  All rights reserved.连接到:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> show userUSER 为 "ZWC"SQL>