Shulou(Shulou.com)06/01 Report--

1, tnsnames.ora on two nodes:

RACTEST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = racscan.test.com) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = RACTEST.test.com)

)

)

RAC1_LOCAL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = rac1vip.test.com) (PORT = 1529))

)

RAC2_LOCAL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = rac2vip.test.com) (PORT = 1529))

)

RAC_REMOTE =

(DESCRIPTION=

(ADDRESS_LIST=

(ADDRESS= (PROTOCOL=tcp) (HOST=rac1vip.test.com) (PORT=1529))

(ADDRESS= (PROTOCOL=tcp) (HOST=rac2vip.test.com) (PORT=1529))

)

)

RAC_BALANCE=

(DESCRIPTION=

(ADDRESS_LIST=

(LOAD_BALANCE=YES)

(FAILOVER=YES)

(ADDRESS= (PROTOCOL=tcp) (HOST=rac1vip.test.com) (PORT=1529))

(ADDRESS= (PROTOCOL=tcp) (HOST=rac2vip.test.com) (PORT=1529))

)

(CONNECT_DATA=

(SERVICE_NAME=RACTEST.test.com)

)

)

2,listener.ora on two nodes:

Node1:RAC=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = rac1vip.test.com) (PORT = 1529))

)

SID_LIST_RAC=

(SID_LIST=

(SID_DESC = (ORACLE_HOME = / dbfs/app/oracle/product/11.2.0/dbhome_1) (SID_NAME=RACTEST1)

)

Node2:RAC=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = rac2vip.test.com) (PORT = 1529))

)

SID_LIST_RAC=

(SID_LIST=

(SID_DESC = (ORACLE_HOME = / dbfs/app/oracle/product/11.2.0/dbhome_1) (SID_NAME=RACTEST2)

)

3. Parameters:

Node1:

SQL > show parameter local_listener

NAME TYPE VALUE

-

Local_listener string RAC1_LOCAL

SQL > show parameter remote_listener

NAME TYPE VALUE

-

Remote_listener string racscan.test.com:1521

-

Node2:

SQL > show parameter local_listener

NAME TYPE VALUE

-

Local_listener string RAC2_LOCAL

SQL > show parameter remote_listener

NAME TYPE VALUE

-

Remote_listener string racscan.test.com:1521

4, parameter file:

Pfile:

[oratest@rac1 dbs] $cat initRACTEST1.ora

Spfile='+DATA/RACTEST/spfileractest.ora'

[oratest@rac2 dbs] $cat initRACTEST2.ora

Spfile='+DATA/RACTEST/spfileractest.ora'

Create a spfile based on pfile:

Create spfile='+DATA/RACTEST/spfileractest.ora' from pfile

5. Parameter modification command:

Alter system set local_listener='RAC1_LOCAL' sid='RACTEST1' scope=both

Alter system set local_listener='RAC2_LOCAL' sid='RACTEST2' scope=both

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.