RHEL6.5安装 Oracle 11g + udev + ASM安装部署详解
[日期:2017-05-26] | 来源:Linux社区 作者:sound | [字体:大 中 小] |
创建数据库中...
数据库安装完成
以grid用户查看集群状态及监听状态
[grid:
/home/grid
]$crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rhel6
ora.DSG.dg
ONLINE ONLINE rhel6
ora.LISTENER.lsnr
ONLINE ONLINE rhel6
ora.asm
ONLINE ONLINE rhel6 Started
ora.ons
OFFLINE OFFLINE rhel6
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE rhel6
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE rhel6
ora.orcl.db
1 ONLINE ONLINE rhel6 Open
------------------------------------------------------------------------
[grid:
/home/grid
]$lsnrctl status
LSNRCTL
for
Linux: Version 11.2.0.4.0 - Production on 24-MAY-2017 08:28:36
Copyright (c) 1991, 2013, . All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR
for
Linux: Version 11.2.0.4.0 - Production
Start Date 24-MAY-2017 07:15:42
Uptime 0 days 1 hr. 12 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/u01/app/11
.2.0
/grid/network/admin/listener
.ora
Listener Log File
/u01/app/grid/diag/tnslsnr/rhel6/listener/alert/log
.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6)(PORT=1521)))
Services Summary...
Service
"+ASM"
has 1 instance(s).
Instance
"+ASM"
, status READY, has 1 handler(s)
for
this service...
Service
"orcl"
has 1 instance(s).
Instance
"orcl"
, status READY, has 1 handler(s)
for
this service...
Service
"orclXDB"
has 1 instance(s).
Instance
"orcl"
, status READY, has 1 handler(s)
for
this service...
The
command
completed successfully
以oracle用户登录连接数据库,查询表空间
[oracle database]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed May 24 08:27:56 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL>
select
* from V$TABLESPACE;
TS
# NAME INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
0 SYSTEM YES NO YES
1 SYSAUX YES NO YES
2 UNDOTBS1 YES NO YES
4 USERS YES NO YES
3 TEMP NO NO YES
6 EXAMPLE YES NO YES
6 rows selected.
在此,Rhel Linux环境下的udev + ASM Oracle 11gR2安装部署完成,状态正常。
完整PDF文档可以到Linux公社资源站下载:
------------------------------------------分割线------------------------------------------
免费下载地址在
用户名与密码都是
具体下载目录在 /2017年资料/5月/26日/RHEL6.5安装 Oracle 11g + udev + ASM安装部署详解/
下载方法见
------------------------------------------分割线------------------------------------------
更多Oracle相关信息见 专题页面
本文永久更新链接地址: