After the rac has been installed some time ago, You need to verify whether the Rac is correctly installed and how to start and close the Rac. Start learning Rac today and record your notes again!
First: Verify RAC:
Verification listening:
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,201 3, 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>
Note:
LOCAL_LISTENER
Property |
Description |
Parameter type |
String |
Syntax |
LOCAL_LISTENER = network_name |
Default value |
(ADDRESS = (PROTOCOL=TCP)(HOST= hostname )(PORT=1521)) Wherehostname Is the network name of the local host. |
Modifiable |
ALTER SYSTEM |
Basic |
No |
LOCAL_LISTENER
Specifies 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 inTNSNAMES.ORA
File or other address repository as configured for your system.
REMOTE_LISTENER
Property |
Description |
Parameter type |
String |
Syntax |
REMOTE_LISTENER = network_name |
Default value |
There is no default value. |
Modifiable |
ALTER SYSTEM |
Basic |
Yes |
REMOTE_LISTENER
Specifies 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 inTNSNAMES.ORA
File or other address repository as configured for your system.
That is to say, local_listener is the local listener of a single host server, and remote_listener is the listener parameter of the oracle network remote listener, that is, scan vip.