Oracle Database 12c Release 1 Installation On Oracle Linux 6.4 x86_64
来源：互联网 发布：大学生身高体重数据 编辑：程序博客网 时间：2024/05/21 09:20
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) <build@oss.oracle.com>" 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
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>
- Oracle Database 12c Release 1 Installation On Oracle Linux 6.4 x86_64
- Oracle Enterprise Manager Cloud Control 12c Release 1 Installation on Oracle Linux
- Installation Oracle GoldenGate 12c on Oracle Database 12c
- Install Oracle Database 12c Release 1 on OEL5
- Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 5
- Oracle Database 10g Release 2 (10.2.0.1) Installation On Red Hat Enterprise Linux 5 (RHEL5)
- Oracle Database 11g Release 1 (11.1) Installation On Fedora 8
- MySql 5.5.20 Installation on Oracle Linux Server release 5.7
- [B15660-02]Oracle® Database Installation Guide 10g Release 2 (10.2) for Linux x86_silent installation
- Oracle Database 11g Release 2 installation On CentOS 6.6(x64 platform)
- Oracle Database 11g Release 2 Installation on RHEL/CentOS 6.x/5.x/4.x
- Oracle Database 12c Release 1 Complete Checklist
- Oracle Database 12c Release 1 云盘链接
- Oracle RAC 12c Database on Linux Using VirtualBox
- [B15660-02]Oracle® Database Installation Guide 10g Release 2 (10.2) for Linux x86
- [ E10857-01]Oracle® Database Quick Installation Guide 11g Release 2 (11.2) for Linux x86
- Installing Oracle 10g Release 2 Standard Edition on Red Hat Enterprise Linux 6.0 (x86_64)
- Oracle Database 11g Release 2 RAC On Oracle Linux 5.8 Using VirtualBox
- UVA 11552 Fewest Flops
- 程序员编程艺术算法归纳
- spring配置事务之xml方式
- ABAP 内表用法小结
- Iptables原理详解
- Oracle Database 12c Release 1 Installation On Oracle Linux 6.4 x86_64
- 谈谈Facebook的聊天系统架构
- android从内部存储写入、安装apk提示解析包错误，或者提示Permission Denied，文件不可用解决办法
- 百度技术沙龙-自然语言处理技术及应用笔记整理
- countif函数的使用方法汇总
- 23个My SQL 常用的查询语句
- leetcode-005：Longest Palindromic Substring
- SAP中日期时间函数收集
- IE中文件下载的提示框中去掉了"打开此类文件前总是询问"的复选框之后怎么恢复
