linux 6.4 平臺(tái)下 Oracle 12c 單實(shí)例 安裝手冊(cè)

1．準(zhǔn)備工作

1.1 安裝需要的RPM 包

binutils⑵.20.51.0.2⑸.11.el6 (x86_64)

glibc⑵.12⑴.7.el6 (x86_64)

libgcc⑷.4.4⑴3.el6 (x86_64)

libstdc++⑷.4.4⑴3.el6 (x86_64)

libaio-0.3.107⑴0.el6 (x86_64)

libXext⑴.1 (x86_64)

libXtst⑴.0.99.2 (x86_64)

libX11⑴.3 (x86_64)

libXau⑴.0.5 (x86_64)

libxcb⑴.5 (x86_64)

libXi⑴.3 (x86_64)

make⑶.81⑴9.el6

sysstat⑼.0.4⑴1.el6 (x86_64)

compat-libcap1⑴.10⑴ (x86_64)

compat-libstdc++⑶3⑶.2.3⑹9.el6 (x86_64)

gcc⑷.4.4⑴3.el6 (x86_64)

gcc-c++⑷.4.4⑴3.el6 (x86_64)

glibc-devel⑵.12⑴.7.el6 (x86_64)

ksh  <== 任何版本的 ksh 都可以。

libstdc++-devel⑷.4.4⑴3.el6 (x86_64)

libaio-devel-0.3.107⑴0.el6 (x86_64)

compat-libstdc++⑶3⑶.2.3⑹9.el6 (i686)

glibc⑵.12⑴.7.el6 (i686)

glibc-devel⑵.12⑴.7.el6 (i686)

libgcc⑷.4.4⑴3.el6 (i686)

libstdc++⑷.4.4⑴3.el6 (i686)

libstdc++-devel⑷.4.4⑴3.el6 (i686)

libaio-0.3.107⑴0.el6 (i686)

libaio-devel-0.3.107⑴0.el6 (i686)

libXext⑴.1 (i686)

libXtst⑴.0.99.2 (i686)

libX11⑴.3 (i686)

libXau⑴.0.5 (i686)

libxcb⑴.5 (i686)

libXi⑴.3 (i686)

這里建議配置好YUM，用yum 來(lái)1次安裝。

1.2 修改內(nèi)核參數(shù)/etc/sysctl.conf

在sysctl.conf 中加入以下內(nèi)容：

kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576

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 = 1048576

kernel.panic_on_oops = 30

以下2個(gè)參數(shù)直接使用默許值便可：

kernel.shmmax = 68719476736

kernel.shmall = 4294967296

用root用戶履行sysctl -p 使修改生效。

1.3 設(shè)置 Oracle 用戶的Shell 限制

在 /etc/security/limits.conf中添加以下內(nèi)容：

oracle  soft    nproc   2047

oracle  hard   nproc  16384

oracle  soft    nofile   1024

oracle  hard   nofile   65536

oracle  soft    stack   10240

oracle  hard   stack   10240

注：limits.conf 文件產(chǎn)生更改時(shí)，這些更改立即生效。但是，如果 Oracle 用戶已登錄，則這些更改將在注銷這些用戶并重新登錄以后生效。必須先完成此操作，然后再使用這些帳戶進(jìn)行安裝。

1.4 設(shè)置PAM

確保加載了最新版本的 PAM，然后在 /etc/pam.d/login 文件中添加或編輯以下行：

session required pam_limits.so

1.5 設(shè)置ulimit

驗(yàn)證當(dāng)前 ulimit，如果需要?jiǎng)t增大。可以采取多種方式完成此操作，推薦方法是在 /etc/profile 中添加以下行：

if [ $USER = "oracle" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
       ulimit -u 16384 
       ulimit -n 65536
    else
       ulimit -u 16384 -n 65536
    fi
fi

1.6 創(chuàng)建Oracle用戶和組

groupadd oinstall

groupadd dba

groupadd oper

useradd -g oinstall -G dba oracle

passwd oracle

1.7 創(chuàng)建目錄

mkdir -p /u01/app/oracle/product/12.1.0/db_1 
chown -R oracle.oinstall /u01 
chmod -R 777 /u01

1.8 設(shè)置oracle用戶的環(huán)境變量

修改/home/oracle/.bash_profile 文件添加以下內(nèi)容：

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1; export ORACLE_HOME

ORACLE_SID=dave; export ORACLE_SID

SHLIB_PATH=$LD_LIBRARY_PATH;export SHLIB_PATH
NLS_LANG=American_America.zhs16gbk;export NLS_LANG
ORA_NLS10=$ORACLE_HOME/nls/data;export ORA_NLS10

TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN

ORACLE_TERM=xterm; export ORACLE_TERM

PATH=/usr/sbin:$PATH; export PATH

PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;export CLASSPATH

Source 參數(shù)使生效：

[oracle@Ora12c ~]$ source ~/.bash_profile

2．開(kāi)始安裝

運(yùn)行runinstaller。

[root@Ora12c database]#/u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory tooinstall.

The execution of the script is complete.

[root@Ora12c database]#/u01/app/oracle/product/12.1.0/db_1/root.sh

Performing root user operation for Oracle 12c

The following environment variables are set as:

   ORACLE_OWNER= oracle

   ORACLE_HOME=  /u01/app/oracle/product/12.1.0/db_1

Enter the full pathname of the local bin directory:[/usr/local/bin]:

   Copyingdbhome to /usr/local/bin ...

   Copyingoraenv to /usr/local/bin ...

   Copyingcoraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file asneeded by

Database Configuration Assistant when a database iscreated

Finished running generic part of root script.

Now product-specific root actions will beperformed.

[root@Ora12c database]#

3. 查詢數(shù)據(jù)庫(kù)信息

[oracle@Ora12c ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Apr24 12:00:39 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics andReal Application Testing options

SQL> set lin 140    

SQL> select * from v$version;

BANNER                                                                              CON_ID

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

OracleDatabase 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production              0

PL/SQLRelease 12.1.0.1.0 - Production                                                    0

CORE    12.1.0.1.0      Production                                                       0

TNSfor Linux: Version 12.1.0.1.0 - Production                                            0

NLSRTLVersion 12.1.0.1.0 - Production                                                    0

SQL> SELECT CDB FROM V$DATABASE;

CDB

---

YES

SQL> select PDB_NAME,CON_UID,pdb_id,status fromdba_pdbs;

PDB_NAME                CON_UID     PDB_ID STATUS

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

PDBCNDBA              426143573          3 NORMAL

PDB$SEED            4088301206          2 NORMAL

SQL> select con_id,dbid,NAME,OPEN_MODE fromv$pdbs;

   CON_ID       DBID NAME                           OPEN_MODE

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

         24088301206 PDB$SEED                      READ ONLY

        3  426143573 PDBCNDBA                       READ WRITE

SQL> show con_name

CON_NAME

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

CDB$ROOT

SQL> alter session set container=pdbcndba;

Session altered.

SQL> show con_name

CON_NAME

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

PDBCNDBA

SQL> show con_name

CON_NAME

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

PDBCNDBA

SQL> create table cndba as select * fromall_users;

Table created.

SQL> alter session set container=CDB$ROOT;

Session altered.

SQL> select count(1) from cndba;

select count(1) from cndba

                    *

ERROR at line 1:

ORA-00942: table or view does not exist

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

版權(quán)所有，文章允許轉(zhuǎn)載，但必須以鏈接方式注明源地址，否則追究法律責(zé)任!

About  Dave:

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

QQ:      251097186

Email:    tianlesoftware@gmail.com

Blog:     http://blog.csdn.net/tianlesoftware

Weibo:    http://weibo.com/tianlesoftware

Twitter:  http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

Dave 的QQ群：

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

注意:加群必須注明表空間和數(shù)據(jù)文件關(guān)系 | 不要重復(fù)加群

CNDBA_1: 104207940 (滿)    CNDBA_2: 62697716 (滿)   CNDBA_3: 283816689

CNDBA_4: 391125754   CNDBA_5: 62697850    CNDBA_6: 62697977   CNDBA_7: 142216823（滿）

生活不易，碼農(nóng)辛苦
如果您覺(jué)得本網(wǎng)站對(duì)您的學(xué)習(xí)有所幫助,可以手機(jī)掃描二維碼進(jìn)行捐贈(zèng)