RHEL6.5安装 Oracle 11g + udev + ASM安装部署详解
[日期:2017-05-26]
来源:Linux社区 作者:sound
[字体:大 中 小]
创建数据库中...
数据库安装完成
以grid用户查看集群状态及监听状态
[grid[@rhel6](https://my.oschina.net/u/1450058):
/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[@rhel6](https://my.oschina.net/u/1450058):
/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, [Oracle](https://www.oschina.net/action/GoToLink?url=https%3A%2F%2Fwww.linuxidc.com%2Ftopicnews.aspx%3Ftid%3D12). 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[@rhel6](https://my.oschina.net/u/1450058) 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公社资源站下载:
------------------------------------------分割线------------------------------------------
免费下载地址在 http://linux.linuxidc.com/
用户名与密码都是www.linuxidc.com
具体下载目录在 /2017年资料/5月/26日/RHEL6.5安装 Oracle 11g + udev + ASM安装部署详解/
下载方法见 http://www.linuxidc.com/Linux/2013-07/87684.htm
------------------------------------------分割线------------------------------------------
更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12