系統硬體限制檢查

磁碟空間限制 Linux x86-64

1 GB of space in the /tmp directory.

~]# df -h /tmp

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/vg_r720-lv_root

50G 19G 28G 41% /

~]# df –h

Filesystem Size Used Avail Use% Mounted on

/dev/mapper/vg_r720-lv_root

50G 19G 28G 41% /

tmpfs 16G 104K 16G 1% /dev/shm

/dev/sda2 485M 37M 423M 8% /boot

/dev/sda1 200M 268K 200M 1% /boot/efi

/dev/mapper/vg_r720-lv_home

13T 282G 12T 3% /home

記憶體、swap最小限制

最小記憶體: 1 GB of RAM

建議記憶體: 2 GB of RAM or more

~]# grep MemTotal /proc/meminfo

MemTotal: 32814212 kB

~]# grep SwapTotal /proc/meminfo

SwapTotal: 16474104 kB

作業系統支援

~]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 6.3 (Santiago)

~]# uname -m

~]x86_64

~]# uname -r

2.6.32-279.el6.x86_64

檢查軟體包補丁

官方文件中Linux 6所需要具備的包：

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)

加上UnixODBC Driver Manager： unixODBC-2.2.14-11.el6 (64-bit) or later

unixODBC-devel-2.2.14-11.el6 (64-bit) or later

我這裡選擇配置yum安裝相關包：

~]# yum -y install binutils compat-libcap1 compat-libstdc++ gcc gcc-c++ glibc glibc glibc-devel glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel libXext libXtst libX11 libXau libxcb libXi make sysstat

Loaded plugins: product-id, refresh-packagekit, security, subscription-manager

Updating certificate-based repositories.

Unable to read consumer identity

Setting up Install Process

Package binutils-2.20.51.0.2-5.34.el6.x86_64 already installed and latest version

Package compat-libcap1-1.10-1.x86_64 already installed and latest version

No package compat-libstdc++ available.

Package gcc-4.4.6-4.el6.x86_64 already installed and latest version

Package gcc-c++-4.4.6-4.el6.x86_64 already installed and latest version

Package glibc-2.12-1.80.el6.x86_64 already installed and latest version

Package glibc-2.12-1.80.el6.x86_64 already installed and latest version

Package glibc-devel-2.12-1.80.el6.x86_64 already installed and latest version

Package glibc-devel-2.12-1.80.el6.x86_64 already installed and latest version

Package ksh-20100621-16.el6.x86_64 already installed and latest version

Package libgcc-4.4.6-4.el6.x86_64 already installed and latest version

Package libstdc++-4.4.6-4.el6.x86_64 already installed and latest version

Package libstdc++-devel-4.4.6-4.el6.x86_64 already installed and latest version

Package libaio-0.3.107-10.el6.x86_64 already installed and latest version

Package libaio-devel-0.3.107-10.el6.x86_64 already installed and latest version

Package libXext-1.1-3.el6.x86_64 already installed and latest version

Package libXtst-1.0.99.2-3.el6.x86_64 already installed and latest version

Package libX11-1.3-2.el6.x86_64 already installed and latest version

Package libXau-1.0.5-1.el6.x86_64 already installed and latest version

Package libxcb-1.5-1.el6.x86_64 already installed and latest version

Package libXi-1.3-3.el6.x86_64 already installed and latest version

Package 1:make-3.81-20.el6.x86_64 already installed and latest version

Package sysstat-9.0.4-20.el6.x86_64 already installed and latest version

]# rpm -ivh compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm

warning: compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY

Preparing...                ########################################### [100%]

        package compat-libstdc++-33-3.2.3-69.el6.x86_64 is already installed

]# rpm -qa|grep -i unix

unixODBC-2.2.14-11.el6.x86_64

unixODBC-devel-2.2.14-11.el6.x86_64

關閉selinux、iptables防火牆

~]# iptables -F

~]# iptables -t nat -F

~]# /etc/init.d/iptables stop

~]# chkconfig iptables off

~]# chkconfig --list iptables

iptables        0:off   1:off   2:off   3:off   4:off   5:off   6:off

~]# grep SELINUX= /etc/selinux/config |grep ^[^#]

SELINUX=disabled

配置/etc/hosts檔案

~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.8.121 uwaydb

~]# hostname uwaydb

~]# cat /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=uwaydb

系統配置

修改/etc/sysctl.conf，新增如下內容：
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

生效：
~]#sysctl –p

修改/etc/security/limits.conf，新增如下內容：
oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    2047
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768

建立使用者、組

~]# /usr/sbin/groupadd -g 54321 oinstall

~]# /usr/sbin/groupadd -g 54322 dba

~]# /usr/sbin/groupadd -g 54323 oper

~]# /usr/sbin/groupadd -g 54324 backupdba

~]# /usr/sbin/groupadd -g 54325 dgdba

~]# /usr/sbin/useradd -u 54321 -g oinstall -G dba,backupdba,dgdba oracle

~]# id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54324(backupdba),54325(dgdba)

建立安裝目錄及授權

~]# mkdir -p /home/oracle/product/12.1.0/db_1

~]# chown -R oracle:oinstall /home/oracle/

~]# chmod -R 775 /home/oracle/

#此處由於主機分割槽規劃的原因，其他目錄空間不夠充裕，所以選擇了安裝在/home/oracle，不是特殊情況不建議

配置oracle環境變數

~]# su - oracle

~]$ vi .bash_profile

export PATH

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/home/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1

export ORACLE_SID=uway12c

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

alias sqlplus="rlwrap sqlplus"

alias rman="rlwrap rman"

解壓安裝介質

~]$ ls linuxamd64_12c_database_* -l

-rw-r--r-- 1 root root 1361028723 12鏈30 10:22 linuxamd64_12c_database_1of2.zip

-rw-r--r-- 1 root root 1116527103 12鏈30 10:22 linuxamd64_12c_database_2of2.zip

~]$ unzip linuxamd64_12c_database_1of2.zip

~]$ unzip linuxamd64_12c_database_2of2.zip

~]$ du -sh database/

2.6G database/

安裝oracle軟體

開啟Xmanager – Passive工具

~]$ export DISPLAY=192.168.9.43:0.0

~]$ xhost +

access control disabled, clients can connect from any host

]$ ./runInstaller

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB. Actual 27261 MB Passed

Checking swap space: must be greater than 150 MB. Actual 16087 MB Passed

Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-12-30_11-43-22PM. Please wait ...

根據提示root使用者下執行2個指令碼

~]# /home/oracle/oraInventory/orainstRoot.sh

Changing permissions of /home/oracle/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /home/oracle/oraInventory to oinstall.

The execution of the script is complete.

~]# /home/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= /home/oracle/product/12.1.0/db_1

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

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

dbca建庫

]$ dbca

點選自定義配置：這裡主要更改了redolog的size為2G

檢查安裝是否成功

檢視程式

不難發現比11g多了很多程式

~]$ ps -ef|grep ora_ |grep -v grep

oracle 737 1 0 03:05 ? 00:00:03 ora_w003_uwaydb

oracle 2959 1 0 04:05 ? 00:00:03 ora_w004_uwaydb

oracle 5314 1 0 05:05 ? 00:00:02 ora_w005_uwaydb

oracle 7107 1 0 06:05 ? 00:00:02 ora_w006_uwaydb

oracle 8860 1 0 07:04 ? 00:00:03 ora_w007_uwaydb

oracle 8897 1 0 07:05 ? 00:00:02 ora_w008_uwaydb

oracle 12457 1 0 09:05 ? 00:00:01 ora_w009_uwaydb

oracle 27399 1 0 17:15 ? 00:00:00 ora_p02o_uwaydb

oracle 27401 1 0 17:15 ? 00:00:00 ora_p02p_uwaydb

oracle 27403 1 0 17:15 ? 00:00:00 ora_p02q_uwaydb

oracle 27405 1 0 17:15 ? 00:00:00 ora_p02r_uwaydb

oracle 27429 1 0 17:16 ? 00:00:00 ora_j000_uwaydb

oracle 27431 1 0 17:16 ? 00:00:00 ora_j001_uwaydb

oracle 27433 1 0 17:16 ? 00:00:00 ora_j002_uwaydb

oracle 32006 1 0 02:36 ? 00:00:11 ora_pmon_uwaydb

oracle 32008 1 0 02:36 ? 00:00:11 ora_psp0_uwaydb

oracle 32010 1 0 02:36 ? 00:04:31 ora_vktm_uwaydb

oracle 32014 1 0 02:36 ? 00:00:06 ora_gen0_uwaydb

oracle 32016 1 0 02:36 ? 00:00:02 ora_mman_uwaydb

oracle 32020 1 0 02:36 ? 00:00:02 ora_diag_uwaydb

oracle 32022 1 0 02:36 ? 00:00:03 ora_dbrm_uwaydb

oracle 32024 1 0 02:36 ? 00:01:22 ora_dia0_uwaydb

oracle 32026 1 0 02:36 ? 00:00:03 ora_dbw0_uwaydb

oracle 32028 1 0 02:36 ? 00:00:02 ora_dbw1_uwaydb

oracle 32030 1 0 02:36 ? 00:00:02 ora_dbw2_uwaydb

oracle 32032 1 0 02:36 ? 00:00:03 ora_lgwr_uwaydb

oracle 32034 1 0 02:36 ? 00:00:16 ora_ckpt_uwaydb

oracle 32036 1 0 02:36 ? 00:00:01 ora_lg00_uwaydb

oracle 32038 1 0 02:36 ? 00:00:04 ora_smon_uwaydb

oracle 32040 1 0 02:36 ? 00:00:00 ora_lg01_uwaydb

oracle 32042 1 0 02:36 ? 00:00:00 ora_reco_uwaydb

oracle 32044 1 0 02:36 ? 00:00:01 ora_lreg_uwaydb

oracle 32046 1 0 02:36 ? 00:02:37 ora_mmon_uwaydb

oracle 32048 1 0 02:36 ? 00:01:16 ora_mmnl_uwaydb

oracle 32050 1 0 02:36 ? 00:00:00 ora_d000_uwaydb

oracle 32052 1 0 02:36 ? 00:00:00 ora_s000_uwaydb

oracle 32064 1 0 02:36 ? 00:00:00 ora_tmon_uwaydb

oracle 32066 1 0 02:36 ? 00:00:01 ora_tt00_uwaydb

oracle 32068 1 0 02:36 ? 00:00:02 ora_smco_uwaydb

oracle 32073 1 0 02:36 ? 00:00:00 ora_aqpc_uwaydb

oracle 32077 1 0 02:36 ? 00:00:46 ora_p000_uwaydb

oracle 32079 1 0 02:36 ? 00:00:49 ora_p001_uwaydb

oracle 32082 1 0 02:36 ? 00:00:47 ora_p002_uwaydb

oracle 32084 1 0 02:36 ? 00:00:51 ora_p003_uwaydb

oracle 32086 1 0 02:36 ? 00:00:03 ora_p004_uwaydb

oracle 32088 1 0 02:36 ? 00:00:03 ora_p005_uwaydb

oracle 32090 1 0 02:36 ? 00:00:01 ora_p006_uwaydb

oracle 32092 1 0 02:36 ? 00:00:01 ora_p007_uwaydb

oracle 32094 1 0 02:36 ? 00:00:01 ora_p008_uwaydb

oracle 32096 1 0 02:36 ? 00:00:01 ora_p009_uwaydb

oracle 32098 1 0 02:36 ? 00:00:01 ora_p00a_uwaydb

oracle 32100 1 0 02:36 ? 00:00:01 ora_p00b_uwaydb

oracle 32102 1 0 02:36 ? 00:00:01 ora_p00c_uwaydb

oracle 32104 1 0 02:36 ? 00:00:01 ora_p00d_uwaydb

oracle 32106 1 0 02:36 ? 00:00:01 ora_p00e_uwaydb

oracle 32108 1 0 02:36 ? 00:00:01 ora_p00f_uwaydb

oracle 32110 1 0 02:36 ? 00:00:01 ora_p00g_uwaydb

oracle 32112 1 0 02:36 ? 00:00:01 ora_p00h_uwaydb

oracle 32114 1 0 02:36 ? 00:00:01 ora_p00i_uwaydb

oracle 32116 1 0 02:36 ? 00:00:01 ora_p00j_uwaydb

oracle 32118 1 0 02:36 ? 00:00:01 ora_p00k_uwaydb

oracle 32120 1 0 02:36 ? 00:00:01 ora_p00l_uwaydb

oracle 32122 1 0 02:36 ? 00:00:05 ora_w000_uwaydb

oracle 32124 1 0 02:36 ? 00:00:01 ora_p00m_uwaydb

oracle 32126 1 0 02:36 ? 00:00:01 ora_p00n_uwaydb

oracle 32128 1 0 02:36 ? 00:00:01 ora_p00o_uwaydb

oracle 32130 1 0 02:36 ? 00:00:01 ora_p00p_uwaydb

oracle 32132 1 0 02:36 ? 00:00:01 ora_p00q_uwaydb

oracle 32134 1 0 02:36 ? 00:00:01 ora_p00r_uwaydb

oracle 32136 1 0 02:36 ? 00:00:01 ora_p00s_uwaydb

oracle 32138 1 0 02:36 ? 00:00:01 ora_p00t_uwaydb

oracle 32142 1 0 02:36 ? 00:00:01 ora_p00u_uwaydb

oracle 32144 1 0 02:36 ? 00:00:01 ora_p00v_uwaydb

oracle 32146 1 0 02:36 ? 00:00:01 ora_p00w_uwaydb

oracle 32148 1 0 02:36 ? 00:00:01 ora_p00x_uwaydb

oracle 32150 1 0 02:36 ? 00:00:01 ora_p00y_uwaydb

oracle 32152 1 0 02:36 ? 00:00:01 ora_p00z_uwaydb

oracle 32154 1 0 02:36 ? 00:00:01 ora_p010_uwaydb

oracle 32156 1 0 02:36 ? 00:00:01 ora_p011_uwaydb

oracle 32158 1 0 02:36 ? 00:00:01 ora_p012_uwaydb

oracle 32160 1 0 02:36 ? 00:00:58 ora_cjq0_uwaydb

oracle 32162 1 0 02:36 ? 00:00:01 ora_p013_uwaydb

oracle 32168 1 0 02:36 ? 00:00:01 ora_p014_uwaydb

oracle 32172 1 0 02:36 ? 00:00:01 ora_p015_uwaydb

oracle 32176 1 0 02:36 ? 00:00:01 ora_p016_uwaydb

oracle 32178 1 0 02:36 ? 00:00:01 ora_p017_uwaydb

oracle 32182 1 0 02:36 ? 00:00:01 ora_p018_uwaydb

oracle 32186 1 0 02:36 ? 00:00:01 ora_p019_uwaydb

oracle 32190 1 0 02:36 ? 00:00:01 ora_p01a_uwaydb

oracle 32194 1 0 02:36 ? 00:00:01 ora_p01b_uwaydb

oracle 32198 1 0 02:36 ? 00:00:01 ora_p01c_uwaydb

oracle 32200 1 0 02:36 ? 00:00:01 ora_p01d_uwaydb

oracle 32202 1 0 02:36 ? 00:00:01 ora_p01e_uwaydb

oracle 32206 1 0 02:36 ? 00:00:01 ora_p01f_uwaydb

oracle 32208 1 0 02:36 ? 00:00:01 ora_p01g_uwaydb

oracle 32210 1 0 02:36 ? 00:00:01 ora_p01h_uwaydb

oracle 32212 1 0 02:36 ? 00:00:01 ora_p01i_uwaydb

oracle 32214 1 0 02:36 ? 00:00:01 ora_p01j_uwaydb

oracle 32216 1 0 02:36 ? 00:00:01 ora_p01k_uwaydb

oracle 32218 1 0 02:36 ? 00:00:01 ora_p01l_uwaydb

oracle 32220 1 0 02:36 ? 00:00:01 ora_p01m_uwaydb

oracle 32222 1 0 02:36 ? 00:00:01 ora_p01n_uwaydb

oracle 32224 1 0 02:36 ? 00:00:01 ora_p01o_uwaydb

oracle 32228 1 0 02:36 ? 00:00:01 ora_p01p_uwaydb

oracle 32232 1 0 02:36 ? 00:00:01 ora_p01q_uwaydb

oracle 32236 1 0 02:36 ? 00:00:01 ora_p01r_uwaydb

oracle 32240 1 0 02:36 ? 00:00:01 ora_p01s_uwaydb

oracle 32242 1 0 02:36 ? 00:00:01 ora_p01t_uwaydb

oracle 32244 1 0 02:36 ? 00:00:01 ora_p01u_uwaydb

oracle 32246 1 0 02:36 ? 00:00:01 ora_p01v_uwaydb

oracle 32248 1 0 02:36 ? 00:00:01 ora_p01w_uwaydb

oracle 32250 1 0 02:36 ? 00:00:01 ora_p01x_uwaydb

oracle 32252 1 0 02:36 ? 00:00:01 ora_p01y_uwaydb

oracle 32254 1 0 02:36 ? 00:00:01 ora_p01z_uwaydb

oracle 32256 1 0 02:36 ? 00:00:01 ora_p020_uwaydb

oracle 32258 1 0 02:36 ? 00:00:01 ora_p021_uwaydb

oracle 32260 1 0 02:36 ? 00:00:01 ora_p022_uwaydb

oracle 32262 1 0 02:36 ? 00:00:01 ora_p023_uwaydb

oracle 32264 1 0 02:36 ? 00:00:01 ora_p024_uwaydb

oracle 32266 1 0 02:36 ? 00:00:01 ora_p025_uwaydb

oracle 32268 1 0 02:36 ? 00:00:01 ora_p026_uwaydb

oracle 32270 1 0 02:36 ? 00:00:01 ora_p027_uwaydb

oracle 32272 1 0 02:36 ? 00:00:01 ora_p028_uwaydb

oracle 32274 1 0 02:36 ? 00:00:01 ora_p029_uwaydb

oracle 32276 1 0 02:36 ? 00:00:01 ora_p02a_uwaydb

oracle 32278 1 0 02:36 ? 00:00:01 ora_p02b_uwaydb

oracle 32280 1 0 02:36 ? 00:00:01 ora_p02c_uwaydb

oracle 32282 1 0 02:36 ? 00:00:01 ora_p02d_uwaydb

oracle 32284 1 0 02:36 ? 00:00:01 ora_p02e_uwaydb

oracle 32286 1 0 02:36 ? 00:00:01 ora_p02f_uwaydb

oracle 32288 1 0 02:36 ? 00:00:01 ora_p02g_uwaydb

oracle 32290 1 0 02:36 ? 00:00:01 ora_p02h_uwaydb

oracle 32292 1 0 02:36 ? 00:00:01 ora_p02i_uwaydb

oracle 32294 1 0 02:36 ? 00:00:01 ora_p02j_uwaydb

oracle 32296 1 0 02:36 ? 00:00:01 ora_p02k_uwaydb

oracle 32298 1 0 02:36 ? 00:00:01 ora_p02l_uwaydb

oracle 32300 1 0 02:36 ? 00:00:01 ora_p02m_uwaydb

oracle 32302 1 0 02:36 ? 00:00:01 ora_p02n_uwaydb

oracle 32344 1 0 02:37 ? 00:00:00 ora_qm02_uwaydb

oracle 32348 1 0 02:37 ? 00:00:00 ora_q002_uwaydb

oracle 32350 1 0 02:37 ? 00:00:00 ora_q003_uwaydb

oracle 32367 1 0 02:37 ? 00:00:03 ora_w001_uwaydb

oracle 32455 1 0 02:42 ? 00:00:05 ora_w002_uwaydb

檢視監聽

~]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 31-DEC-2013 17:18:25

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=uwaydb)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 31-DEC-2013 00:46:41

Uptime 0 days 16 hr. 31 min. 44 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /home/oracle/product/12.1.0/db_1/network/admin/listener.ora

Listener Log File /home/oracle/diag/tnslsnr/uwaydb/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=uwaydb)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=uwaydb)(PORT=5500))(Security=(my_wallet_directory=/home/oracle/admin/uwaydb/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "uway1" has 1 instance(s).

Instance "uwaydb", status READY, has 1 handler(s) for this service...

Service "uway2" has 1 instance(s).

Instance "uwaydb", status READY, has 1 handler(s) for this service...

Service "uwaydb" has 1 instance(s).

Instance "uwaydb", status READY, has 1 handler(s) for this service...

Service "uwaydbXDB" has 1 instance(s).

Instance "uwaydb", status READY, has 1 handler(s) for this service...

The command completed successfully

檢視資料庫結構

發現CDB，PDB資料庫都有自己的system、sysaux、default tablespace、temp是獨立的，但undo、control、redo是共享的

SQL> set line 150 pages 9999

SQL> select * from

2 (select name from v$datafile

3 union all

4 select name from v$tempfile

5 union all

6 select member from v$logfile

7 union all

8 select name from v$controlfile)

9 order by name;

NAME

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

/home/oracle/oradata/uwaydb/control01.ctl

/home/oracle/oradata/uwaydb/control02.ctl

/home/oracle/oradata/uwaydb/pdbseed/sysaux01.dbf

/home/oracle/oradata/uwaydb/pdbseed/system01.dbf

/home/oracle/oradata/uwaydb/pdbseed/temp01.dbf

/home/oracle/oradata/uwaydb/redo01.log

/home/oracle/oradata/uwaydb/redo02.log

/home/oracle/oradata/uwaydb/redo03.log

/home/oracle/oradata/uwaydb/sysaux01.dbf

/home/oracle/oradata/uwaydb/system01.dbf

/home/oracle/oradata/uwaydb/temp01.dbf

/home/oracle/oradata/uwaydb/undotbs01.dbf

/home/oracle/oradata/uwaydb/users01.dbf

/home/oracle/oradata/uwaydb/uway1/sysaux01.dbf

/home/oracle/oradata/uwaydb/uway1/system01.dbf

/home/oracle/oradata/uwaydb/uway1/temp01.dbf

/home/oracle/oradata/uwaydb/uway1/uway1_users01.dbf

/home/oracle/oradata/uwaydb/uway2/sysaux01.dbf

/home/oracle/oradata/uwaydb/uway2/system01.dbf

/home/oracle/oradata/uwaydb/uway2/temp01.dbf

/home/oracle/oradata/uwaydb/uway2/uway2_users01.dbf

21 rows selected.

檢視pdbs的狀態

dbca時，我配置了2個pdb

SQL> select DBID, NAME, OPEN_MODE, CREATE_SCN from v$pdbs;

DBID NAME OPEN_MODE CREATE_SCN

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

4078180925 PDB$SEED READ ONLY 220

604043406 UWAY1 READ WRITE 1586567

4218752610 UWAY2 READ WRITE 1587773

SQL> select status from v$instance;

STATUS

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

OPEN

跟之前的版本，不太一樣

原文連線：http://blog.itpub.net/27000195/viewspace-1428132/

RHEL 6.3 x86_64 install oracle 12c db

系統硬體限制檢查

磁碟空間限制 Linux x86-64

記憶體、swap最小限制

作業系統支援

檢查軟體包補丁

關閉selinux、iptables防火牆

配置/etc/hosts檔案

系統配置

建立使用者、組

建立安裝目錄及授權

配置oracle環境變數

解壓安裝介質

安裝oracle軟體

dbca建庫

檢查安裝是否成功

檢視程式

檢視監聽

檢視資料庫結構

檢視pdbs的狀態

相關文章