The configuration method of Oracle RAC and SCAN providing services at the same time
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
