Shulou(Shulou.com)05/31 Report--

RAC in what is the difference between lsnrctl and srvctl, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Case: (environment: hp Mini, 10G rac) A customer found that he could not connect to the database this morning.

Process:

Login server found that a server cluster monitoring is off, lsnrctl status found that monitoring is stuck, can not be shut down normally, restart

Check the monitoring log and report an error TNS-12545, and the other server listens normally, so there is no hurry. Steady. Take your time.

$crs_stat-t

Name Type Target State Host

Ora.XFF.cs application ONLINE ONLINE rac1

Ora....db1.srv application ONLINE ONLINE rac2

Ora.devdb.db application ONLINE ONLINE rac2

Ora....b1.inst application ONLINE ONLINE rac1

Ora....b2.inst application ONLINE ONLINE rac2

Ora....SM1.asm application ONLINE ONLINE rac1

Ora....C1.lsnr application OFFLINE OFFLINE

Ora.rac1.gsd application ONLINE ONLINE rac1

Ora.rac1.ons application ONLINE ONLINE rac1

Ora.rac1.vip application ONLINE ONLINE rac1

Ora....SM2.asm application ONLINE ONLINE rac2

Ora....C2.lsnr application ONLINE ONLINE rac2

Ora.rac2.gsd application ONLINE ONLINE rac2

Ora.rac2.ons application ONLINE ONLINE rac2

Ora.rac2.vip application ONLINE ONLINE rac2

Since you can see that the listening is off from the cluster, find the listening process and kill it.

$ps-ef | grep tnslsnr

Grid 3232 10 10:59? 00:00:00 / g01/11ggrid/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1-inherit

Kill-15 3232

Lsnrctl start starts listening, and the listening status returns to normal, but the listening status in the cluster is still offline.

Reason: the listening of srvctl operation is listener_rac1, while the default listening of lsnrctl operation is not online, or the listening feedback of lsnrctl operation is not CRS?

Srvctl config listener-n rac1

Solution:

Lsnrctl stop-turn off snooping

Srvctl start listener-n rac1-enable the listening service (rac1 hostname)

Later, however, I did a test on the 11g library and did not find this problem.

Return to normal at this time, attach listener.ora

LISTENER_RAC1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = rac1-vip) (PORT = 1521) (IP = FIRST))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.11) (PORT = 1521) (IP = FIRST))

)

)

SID_LIST_LISTENER_RAC1 =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = / u01/app/oracle/product/10.2.0/db_1)

(PROGRAM = extproc)

)

)

Suggestion: if RAC restarts monitoring, it is recommended to use srvctl.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.