将database的信息注册到CRS里

[oracle@etsdb05 admin]$ srvctl add database -d etstest -o $ORACLE_HOME -p +ORA_DATA/ETSTEST/spfileetstest.ora

 [oracle@etsdb05 admin]$ srvctl add instance -d etstest -i etstest1 -n etsdb05

[oracle@etsdb05 admin]$ srvctl add instance -d etstest -i etstest2 -n etsdb04

[oracle@etsdb05 admin]$ srvctl start –d database etstest

启动之后再次查询各服务的状况

./crs_stat –t

11gr2将listener 监听注册到CRS服务中

11g rac的listener 配置文件的信息是由在安装grid的过程中AGENT自行添加的，而且listner仅制定了PROTOCOL=IPC的信息，其实在11gr2中引入了endpoints_listener.ora

将IPC的信息是指向了endpoints_listener.ora

[oracle@etsdb04 ~]$ srvctl  config scan

SCAN name: rac-scan, Network: 1/10.98.0.0/255.255.0.0/eth0

SCAN VIP name: scan1, IP: /rac-scan/10.98.10.110

[oracle@etsdb04 ~]$ srvctl add listener -l LISTENER -o $GRID_HOME -p 1521 -k 1

[oracle@etsdb04 ~]$ srvctl start listener -l LISTENER

[oracle@etsdb04 admin]$ lsnrctl status LISTENER

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-SEP-2012 11:27:47

Copyright (c) 1991, 2009, 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.1.0 - Production

Start Date                29-SEP-2012 11:04:41

Uptime                    0 days 0 hr. 23 min. 6 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /orahome/grid/network/admin/listener.ora

Listener Log File         /orahome/11.2/diag/tnslsnr/etsdb04/listener/alert/log.xml

Listening Endpoints Summary...

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

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

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

Services Summary...

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

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

Service "etstest" has 2 instance(s).

  Instance "etstest1", status UNKNOWN, has 1 handler(s) for this service...

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

Service "etstestXDB" has 1 instance(s).

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

The command completed successfully

[oracle@etsdb04 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 29 10:54:21 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> show parameter listener

NAME                                 TYPE        VALUE

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

listener_networks                    string

local_listener                       string

remote_listener                      string      rac-scan:1521

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.98.10.104)(PORT=1521))))' scope=both sid='etstest2';

System altered.

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.98.10.105)(PORT=1521))))' scope=both sid='etstest1';

System altered.

SQL> show parameter listener

NAME                                 TYPE        VALUE

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

listener_networks                    string

local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD

                                                 DRESS=(PROTOCOL=TCP)(HOST=10.9

                                                 8.10.104)(PORT=1521))))

remote_listener                      string      rac-scan:1521

[oracle@etsdb04 admin]$ cat listener.ora

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))   # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent

SID_LIST_LISTENER =

(SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = etstest)

      (ORACLE_HOME = /orahome/grid)

      (SID_NAME = etstest1)

    )

  )

[oracle@etsdb04 admin]$ cat endpoints_listener.ora

LISTENER_ETSDB04=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=etsdb04-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.98.10.4)(PORT=1521)(IP=FIRST))))               # line added by Agent

[root@tyan147 bin]# ./crs_stat

NAME=ora.LISTENER.lsnr

TYPE=ora.listener.type

TARGET=ONLINE

STATE=ONLINE on tyan147

NAME=ora.LISTENER_SCAN1.lsnr

TYPE=ora.scan_listener.type

TARGET=ONLINE

STATE=ONLINE on tyan148

NAME=ora.tyan147.LISTENER_TYAN147.lsnr

TYPE=application

TARGET=ONLINE

STATE=ONLINE on tyan147

NAME=ora.tyan148.LISTENER_TYAN148.lsnr

TYPE=application

TARGET=ONLINE

STATE=ONLINE on tyan148

详细请见：