oracle rac 11g启动,Oracle RAC 验证以及Oracle 11G R2 启动与关闭

在前段时间已经安装完rac,那么安装完成后,要做的就是验证Rac是否是正确安装以及如何启动与关闭Rac。今天开始学习Rac,再次记录

在前段时间已经安装完rac,那么安装完成后,,要做的就是验证Rac是否是正确安装以及如何启动与关闭Rac。今天开始学习Rac,再次记录一下笔记!

第一:验证RAC:

验证监听:

node 1:

SQL> show parameter local_listener

NAME TYPE VALUE

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

local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=

192.168.4.114)(PORT=1521))

SQL> show parameter remote_listener

NAME TYPE VALUE

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

remote_listener string rac-two-cluster-scan.grid.exam

ple.com:1521

SQL>

node 2:

SQL> show parameter local_listener

NAME TYPE VALUE

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

local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=

192.168.4.113)(PORT=1521))

SQL> show parameter remote_listener

NAME TYPE VALUE

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

remote_listener string rac-two-cluster-scan.grid.exam

ple.com:1521

SQL>

ple.com:1521

SQL> !lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-FEB-2014 20:54:52

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

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

Alias                    LISTENER

Version                  TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                19-FEB-2014 20:03:17

Uptime                    0 days 0 hr. 51 min. 35 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/rac-one/listener/alert/log.xml

Listening Endpoints Summary...

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

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

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

Services Summary...

Service "+ASM" has 1 instance(s).

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

Service "Rac" has 1 instance(s).

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

Service "RacXDB" has 1 instance(s).

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

The command completed successfully

SQL>

注:

LOCAL_LISTENER

PropertyDescription

Parameter type

String

Syntax

LOCAL_LISTENER =network_name

Default value

(ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1521))wherehostnameis the network name of the local host.

Modifiable

ALTER SYSTEM

Basic

No

LOCAL_LISTENERspecifies a network name that resolves to an address or address list of Oracle Net local listeners (that is, listeners that are running on the same machine as this instance). The address or address list is specified in theTNSNAMES.ORAfile or other address repository as configured for your system.

REMOTE_LISTENER

PropertyDescription

Parameter type

String

Syntax

REMOTE_LISTENER =network_name

Default value

There is no default value.

Modifiable

ALTER SYSTEM

Basic

Yes

REMOTE_LISTENERspecifies a network name that resolves to an address or address list of Oracle Net remote listeners (that is, listeners that are not running on the same machine as this instance). The address or address list is specified in theTNSNAMES.ORAfile or other address repository as configured for your system.

也就是说:local_listener是单主机服务器本地监听,remote_listener是oracle网络远程监听器也就是scan vip的监听参数。

logo.gif

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值