系统硬件限制检查
磁盘空间限制 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
Copyright (c) 1991, 2013, Oracle. All rights reserved.
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/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27000195/viewspace-1428132/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27000195/viewspace-1428132/