Oracle 12CR2发布了，学习的季节也到了，学习的第一步就是得安装数据库，这篇文章介绍如何在Oracle Linux 7.1上安装Oracle 12c Grid Infrastructure for a Standalone Server with a New Database
检查Linux内核与软件包
1.检查linux版本
[root@jytest ~]# cat /etc/oracle-release Oracle Linux Server release 7.1 [root@jytest ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.1 (Maipo)
2.检查内核版本
[root@jytest ~]# uname -r 3.8.13-55.1.6.el7uek.x86_64
3.检查需要的软件包是否安装
rpm -q package_name
也可以指定系统结构信息，例如:
rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep package_name
也可以将查询多个软件包的语句组合在一起，并查看正确的软件版本.
[root@jytest ~]# rpm -q binutils compat-libstdc++ gcc glibc libaio libgcc libstdc++ make sysstat unixodbc binutils-2.23.52.0.1-30.el7.x86_64 package compat-libstdc++ is not installed gcc-4.8.3-9.el7.x86_64 glibc-2.17-78.0.1.el7.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.3-9.el7.x86_64 libstdc++-4.8.3-9.el7.x86_64 make-3.82-21.el7.x86_64 sysstat-10.1.5-7.el7.x86_64 package unixodbc is not installed
禁用Transparent HugePages
对于Red Hat Enterprise Linux kernels:
#cat /sys/kernel/mm/redhat_transparent_hugepage/enabled
其它kernels:
#cat /sys/kernel/mm/transparent_hugepage/enabled
下面是输出示例，显示Transparent HugePages被使用[always]标记被启用
[always] never
如果Transparent HugePages从内核中被删除，那么/sys/kernel/mm/transparent_hugepage或/sys/kernel/mm/redhat_transparent_hugepage文件会不存在。
为了禁用transparent hugepage执行以下操作:
1.向内核心/etc/grub.conf文件中增加以下记录
transparent_hugepage=never
2.重启操作系统
#reboot
创建用户组
[root@jytest /]# groupadd asmadmin [root@jytest /]# groupadd asmdba [root@jytest /]# groupadd asmoper [root@jytest /]# groupadd dba [root@jytest /]# groupadd oper [root@jytest /]# groupadd oinstall [root@jytest /]# groupadd backupdba [root@jytest /]# groupadd dgdba [root@jytest /]# groupadd kmdba [root@jytest /]# groupadd racdba
创建用户
[root@jytest /]# useradd -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle [root@jytest /]# useradd -g oinstall -G asmadmin,asmdba,asmoper,dba grid [root@jytest /]# passwd oracle Changing password for user oracle. New password: BAD PASSWORD: The password is shorter than 8 characters Retype new password: passwd: all authentication tokens updated successfully. [root@jytest /]# passwd grid Changing password for user grid. New password: BAD PASSWORD: The password is shorter than 8 characters Retype new password: passwd: all authentication tokens updated successfully.
以root用户创建“Oracle inventory 目录”
[root@jytest /]# mkdir -p /u01/app/oraInventory [root@jytest /]# chown -R grid:oinstall /u01/app/oraInventory [root@jytest /]# chmod -R 775 /u01/app/oraInventory
以root用户创建“Grid Infrastructure BASE 目录”
[root@jytest /]# mkdir -p /u01/app/grid [root@jytest /]# chown -R grid:oinstall /u01/app/grid [root@jytest /]# chmod -R 775 /u01/app/grid
以root用户创建“Grid Infrastructure Home 目录”
[root@jytest /]# mkdir -p /u01/app/product/12.2.0/crs [root@jytest /]# chown -R grid:oinstall /u01/app/product/12.2.0/crs [root@jytest /]# chmod -R 775 /u01/app/product/12.2.0/crs
以root用户创建“Oracle Base 目录”
[root@jytest /]# mkdir -p /u01/app/oracle [root@jytest /]# chown -R oracle:oinstall /u01/app/oracle [root@jytest /]# chmod -R 775 /u01/app/oracle
以root用户创建“Oracle RDBMS Home 目录”
[root@jytest /]# mkdir -p /u01/app/oracle/product/12.2.0/db [root@jytest /]# chown -R oracle:oinstall /u01/app/oracle/product/12.2.0/db [root@jytest /]# chmod -R 775 /u01/app/oracle/product/12.2.0/db
创建一个tmp目录
[root@jytest /]# mkdir /u01/tmp [root@jytest /]# chmod a+wr /u01/tmp
设置环境变量
[root@jytest /]# su - grid
[grid@jytest ~]$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
TEMP=/u01/tmp
TMPDIR=/u01/tmp
export TEMP TMPDIR
export LD_ASSUME_KERNEL=3.8.13
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/product/12.2.0/crs
export ORACLE_SID=+ASM
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH
umask=022
TEMP=/u01/tmp
TMPDIR=/u01/tmp
export TEMP TMPDIR
export LD_ASSUME_KERNEL=3.8.13
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db
export ORACLE_SID=jy
export ORACLE_UNQNAME=jy
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH
umask=022
修改内核参数编辑/etc/sysctl.conf文件
fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 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 [root@jytest3 ~]# sysctl -p fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 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
修改oarcle参数的shell限制
在/etc/security/limits.conf中添加以下参数：
grid soft nproc 2047 grid hard nproc 16384 grid soft nofile 1024 grid hard nofile 65536 grid soft stack 10240 grid hard stack 32768 grid soft memlock 3145728 grid hard memlock 3145728 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 32768 oracle soft memlock 3145728 oracle hard memlock 3145728
修改shell的默认参数文件，在/etc/profile文件中添加以下内容：
if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi if [ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi
对C shell(csh or tcsh)在/etc/csh.login文件中增加以下代码
if ( $USER == "oracle" ) then limit maxproc 16384 limit descriptors 65536 endif if ( $USER == "grid" ) then limit maxproc 16384 limit descriptors 65536 endif
配置创建ASM磁盘组的asm磁盘
[root@jytest3 ~]# fdisk -l Disk /dev/sdb: 21.5 GB, 21474836480 bytes, 41943040 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk /dev/sdc: 21.5 GB, 21474836480 bytes, 41943040 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk /dev/sda: 53.7 GB, 53687091200 bytes, 104857600 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk label type: dos Disk identifier: 0x000209aa Device Boot Start End Blocks Id System /dev/sda1 * 2048 1026047 512000 83 Linux /dev/sda2 1026048 104857599 51915776 8e Linux LVM Disk /dev/mapper/ol-root: 47.7 GB, 47747956736 bytes, 93257728 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk /dev/mapper/ol-swap: 5368 MB, 5368709120 bytes, 10485760 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes
查看磁盘uuid
[root@jytest3 ~]# /usr/lib/udev/scsi_id -g -u /dev/sdb 36000c295f8b38933c37ef4a42f446599 [root@jytest3 ~]# /usr/lib/udev/scsi_id -g -u /dev/sdc 36000c29739826dc8ef28ef9a3589d3a0
udev绑定
[root@jytest3 ~]# vi /etc/udev/rules.d/99-my-asmdevices.rules
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36000c295f8b38933c37ef4a42f446599", RUN
+="/bin/sh -c 'mknod /dev/asmdisk01 b $major $minor; chown grid:oinstall /dev/asmdisk01; chmod 0660 /dev/asmdisk01'"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36000c29739826dc8ef28ef9a3589d3a0", RUN
+="/bin/sh -c 'mknod /dev/asmdisk02 b $major $minor; chown grid:oinstall /dev/asmdisk02; chmod 0660 /dev/asmdisk02'"
~
[root@jytest3 ~]# /sbin/udevadm trigger --type=devices --action=change
[root@jytest3 ~]# ls -lrt /dev/asm*
brw-rw----. 1 grid oinstall 8, 32 Mar 8 22:24 /dev/asmdisk02
brw-rw----. 1 grid oinstall 8, 16 Mar 8 22:24 /dev/asmdisk01
解压GI安装压缩包：
[grid@jytest3 soft]cd /u01/app/grid/product/12.2.0/crs/ [grid@jytest3 soft]# unzip -q /soft/linuxx64_12201_grid_home.zip 配置vnc 检查系统是否已经安装vncserver软件包
[root@jytest3 system]# rpm -qa|grep tigervnc tigervnc-server-minimal-1.2.80-0.30.20130314svn5065.el7.x86_64 tigervnc-license-1.2.80-0.30.20130314svn5065.el7.noarch
没有安装执行以下命令进行安装
[root@jytest3 /]# cd soft [root@jytest3 soft]# yum -y install tigervnc-server-1.2.80-0.30.20130314svn5065.el7.x86_64.rpm Loaded plugins: langpacks Examining tigervnc-server-1.2.80-0.30.20130314svn5065.el7.x86_64.rpm: tigervnc-server-1.2.80-0.30.20130314svn5065.el7.x86_64 Marking tigervnc-server-1.2.80-0.30.20130314svn5065.el7.x86_64.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package tigervnc-server.x86_64 0:1.2.80-0.30.20130314svn5065.el7 will be installed --> Finished Dependency Resolution http://public-yum.oracle.com/repo/OracleLinux/OL7/UEKR3/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not resolve host: public-yum.oracle.com; Unknown error" Trying other mirror. http://public-yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not resolve host: public-yum.oracle.com; Unknown error" Trying other mirror. Dependencies Resolved ======================================================================================================================================================================= Package Arch Version Repository Size ======================================================================================================================================================================= Installing: tigervnc-server x86_64 1.2.80-0.30.20130314svn5065.el7 /tigervnc-server-1.2.80-0.30.20130314svn5065.el7.x86_64 488 k Transaction Summary ======================================================================================================================================================================= Install 1 Package Total size: 488 k Installed size: 488 k Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Warning: RPMDB altered outside of yum. Installing : tigervnc-server-1.2.80-0.30.20130314svn5065.el7.x86_64 1/1 Verifying : tigervnc-server-1.2.80-0.30.20130314svn5065.el7.x86_64 1/1 Installed: tigervnc-server.x86_64 0:1.2.80-0.30.20130314svn5065.el7 Complete!
之前的版本，如果安装vnc一般都需要使用vncserver命令来设置口令，然后配置/etc/sysconfig/vncservers文件。
在Oracle Linux7中，虽然然还存在这个文件，不过其内容只有如下一行：
root@jytest3 soft]# cat /etc/sysconfig/vncservers # THIS FILE HAS BEEN REPLACED BY /lib/systemd/system/vncserver@.service
复制文件
[root@jytest3 soft]# cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver_root@:2.service
编辑vncserver_root@:2.service文件将文件中的用root替换
[root@jytest3 soft]# cd /etc/systemd/system/
[root@jytest3 system]# vi vncserver_root@:2.service
# The vncserver service unit file
#
# Quick HowTo:
# 1. Copy this file to /etc/systemd/system/vncserver@:.service
# 2. Edit and vncserver parameters appropriately
# ("runuser -l -c /usr/bin/vncserver %i -arg1 -arg2")
# 3. Run `systemctl daemon-reload`
# 4. Run `systemctl enable vncserver@:.service`
#
# DO NOT RUN THIS SERVICE if your local area network is
# untrusted! For a secure way of using VNC, you should
# limit connections to the local host and then tunnel from
# the machine you want to view VNC on (host A) to the machine
# whose VNC output you want to view (host B)
#
# [user@hostA ~]$ ssh -v -C -L 590N:localhost:590M hostB
#
# this will open a connection on port 590N of your hostA to hostB's port 590M
# (in fact, it ssh-connects to hostB and then connects to localhost (on hostB).
# See the ssh man page for details on port forwarding)
#
# You can then point a VNC client on hostA at vncdisplay N of localhost and with
# the help of ssh, you end up seeing what hostB makes available on port 590M
#
# Use "-nolisten tcp" to prevent X connections to your VNC server via TCP.
#
# Use "-localhost" to prevent remote VNC clients connecting except when
# doing so through a secure tunnel. See the "-via" option in the
# `man vncviewer' manual page.
[Unit]
Description=Remote desktop service (VNC)
After=syslog.target network.target
[Service]
Type=simple
# Clean any existing files in /tmp/.X11-unix environment
ExecStartPre=/bin/sh -c '/usr/bin/vncserver -kill %i > /dev/null 2>&1 || :'
ExecStart=/sbin/runuser -l root -c "/usr/bin/vncserver %i"
PIDFile=/root/.vnc/%H%i.pid
ExecStop=/bin/sh -c '/usr/bin/vncserver -kill %i > /dev/null 2>&1 || :'
[Install]
"vncserver_root@:2.service" 45L, 1739C written
启用vncserver配置
[root@jytest3 system]# systemctl enable vncserver_root@:2.service ln -s '/etc/systemd/system/vncserver_root@:2.service' '/etc/systemd/system/multi-user.target.wants/vncserver_root@:2.service'
启动vncserver服务
[root@jytest3 system]# vncserver You will require a password to access your desktops. Password: Verify: xauth: file /root/.Xauthority does not exist New 'jytest3:1 (root)' desktop is jytest3:1 Creating default startup script /root/.vnc/xstartup Starting applications specified in /root/.vnc/xstartup Log file is /root/.vnc/jytest3:1.log
关闭防火墙
[root@jytest3 system]# systemctl stop firewalld [root@jytest3 system]# systemctl disable firewalld rm '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service' rm '/etc/systemd/system/basic.target.wants/firewalld.service'
用vnc登录服务器安装软件
[root@jytest3 Desktop]# xhost + access control disabled, clients can connect from any host [root@jytest3 Desktop]# su - grid Last login: Tue Mar 7 17:50:57 CST 2017 on pts/0 [grid@jytest3 ~]$ cd /soft/grid [grid@jytest3 crs]$ ./gridSetup.sh ERROR: Unable to verify the graphical display setup. This application requires X display. Make sure that xdpyinfo exist under PATH variable. Can't connect to X11 window server using '10.138.135.167:1.0' as the value of the DISPLAY variable.
出现在错误，并且错误信息提示需要设置环境变量DISPLAY，下面设置环境变量DISPLAY
[grid@jytest3 grid]$ exit logout [root@jytest3 Desktop]# xdpyinfo name of display: :1 version number: 11.0 vendor string: The X.Org Foundation vendor release number: 11500000 X.Org version: 1.15.0 maximum request size: 16777212 bytes motion buffer size: 256 bitmap unit, bit order, padding: 32, LSBFirst, 32 image byte order: LSBFirst number of supported pixmap formats: 6 ...省略...只需要记录name of display:的值
[root@jytest3 Desktop]# xhost + access control disabled, clients can connect from any host [root@jytest3 Desktop]# su - grid Last login: Tue Mar 7 17:50:40 CST 2017 on pts/0 [grid@jytest3 ~]$ export DISPLAY=:1(这时设置为name of display的值:1) [grid@jytest3 ~]$ xdpyinfo name of display: :1 version number: 11.0 vendor string: The X.Org Foundation vendor release number: 11500000 X.Org version: 1.15.0 maximum request size: 16777212 bytes motion buffer size: 256 bitmap unit, bit order, padding: 32, LSBFirst, 32 image byte order: LSBFirst number of supported pixmap formats: 6 ...省略... [grid@jytest3 ~]$cd /u01/app/grid/product/12.2.0/crs/ [grid@jytest3 crs]$ ./gridSetup.sh
选择for a Standalone Server (Oracle Restart)
现在可以让安装程序来以root用户自动执行安装所需要执行的脚本，指定root用户的密码
检查磁盘组data是否创建成功
[grid@jytest3 ~]$ asmcmd lsdg State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 512 4096 4194304 40960 40760 0 20380 0 N DATA/
安装数据库软件
[root@jytest3 soft]# unzip linuxx64_12201_database.zip -d [root@jytest3 Desktop]# xhost + access control disabled, clients can connect from any host [root@jytest3 Desktop]# xdpyinfo name of display: :1 version number: 11.0 vendor string: The X.Org Foundation vendor release number: 11500000 X.Org version: 1.15.0 maximum request size: 16777212 bytes motion buffer size: 256 bitmap unit, bit order, padding: 32, LSBFirst, 32 image byte order: LSBFirst number of supported pixmap formats: 6 ...省略...只需要记录name of display:的值 [root@jytest3 Desktop]# su - oracle Last login: Thu Mar 9 04:17:35 CST 2017 on pts/2 [oracle@jytest3 ~]$ export DISPLAY=:1 [oracle@jytest3 ~]$ cd /soft/database [oracle@jytest3 database]$ ./runInstaller
执行脚本
[root@jytest3 /]# ./u01/app/oracle/product/12.2.0/db/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.2.0/db
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
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.
Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] :
yes
Installing Oracle Trace File Analyzer (TFA).
Log File: /u01/app/oracle/product/12.2.0/db/install/root_jytest3_2017-03-09_15-33-03-156667468.log
Finished installing Oracle Trace File Analyzer (TFA)
创建数据库
[oracle@jytest3 database]$ dbca
在创建的过程中出现了以下错误
[Thread-301] [ 2017-03-09 22:15:26.774 CST ] [PostDBCreationStep.executeImpl:1156] Exception while Starting with HA Database Resource PRCR-1079 : Failed to start resource ora.jy.db CRS-5017: The resource action "ora.jy.db start" encountered the following error: ORA-01017: invalid username/password; logon denied . For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/jytest3/crs/trace/ohasd_oraagent_grid.trc". CRS-2674: Start of 'ora.jy.db' on 'jytest3' failed ORA-01017: invalid username/password; logon denied
数据库jy确实没能通过oracle restart自动启动
[grid@jytest3 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE jytest3 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE jytest3 STABLE
ora.asm
ONLINE ONLINE jytest3 Started,STABLE
ora.ons
OFFLINE OFFLINE jytest3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE jytest3 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.driver.afd
1 ONLINE ONLINE jytest3 STABLE
ora.evmd
1 ONLINE ONLINE jytest3 STABLE
ora.jy.db
1 ONLINE OFFLINE Instance Shutdown,ST
ABLE
--------------------------------------------------------------------------------
如是手动启动数据库
[root@jytest3 ~]# su - oracle Last login: Thu Mar 9 22:08:36 CST 2017 on pts/4 [oracle@jytest3 ~]$ echo $ORACLE_SID jy [oracle@jytest3 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu Mar 9 22:17:21 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 2516582400 bytes Fixed Size 8795904 bytes Variable Size 1358956800 bytes Database Buffers 1140850688 bytes Redo Buffers 7979008 bytes Database mounted. Database opened.
[grid@jytest3 trace]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE jytest3 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE jytest3 STABLE
ora.asm
ONLINE ONLINE jytest3 Started,STABLE
ora.ons
OFFLINE OFFLINE jytest3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE jytest3 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.driver.afd
1 ONLINE ONLINE jytest3 STABLE
ora.evmd
1 ONLINE ONLINE jytest3 STABLE
ora.jy.db
1 ONLINE ONLINE jytest3 Open,HOME=/u01/app/o
racle/product/12.2.0
/db,STABLE
--------------------------------------------------------------------------------
到此安装完成!