OraFAQ Forum: RAC & Failsafe » RAC SCAN LISTENER

Home » Server Options » RAC & Failsafe » RAC SCAN LISTENER (Oracle 11.2.0.1.0 on Windows 7 Professional on 64-bit OS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RAC SCAN LISTENER [message #611669]

Sun, 06 April 2014 21:18

vilin
Messages: 6
Registered: April 2014

Junior Member

Hi folks,

I am new to this site if I missed a thread already discussing issues similar to this, please point me to it and
in the interim accept my apologies...

when I attempt to start ora.LISTENER_SCAN1.lsnr on a two-node system, I get the following error messages and I am unable to
understand the root causes and there is no resolution in sight! I thank you to immensely if you could help as nothing seems to work.
Pls note that this a production system which I inherited and must be very careful
in what actions I'd take! As this is a private organization, when it comes to it, I will need to send private messages to protect the
entity... Here is error message:

C:\app\11.2.0\grid\NETWORK\ADMIN>crsctl start res ora.LISTENER_SCAN1.lsnr
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac-p1'
CRS-5016: Process "C:\app\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "C:\app\11.2.0\grid\bin\oraagent.exe" for action "start" failed: details at "(:CLSN00010
:)" in "C:\app\11.2.0\grid\log\rac-p1\agent\crsd\oraagent\oraagent.log"
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-APR-2014 18:54:27
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Log messages written to c:\app\administrator\diag\tnslsnr\RAC-P1\listener_scan1\alert\log.xml
TNS-01151: Missing listener name, LISTENER_SCAN1, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
CRS-5016: Process "C:\app\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "C:\app\11.2.0\grid\bin\oraagent.exe" for action "start" failed: details at "(:CLSN00010
:)" in "C:\app\11.2.0\grid\log\rac-p1\agent\crsd\oraagent\oraagent.log"
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-APR-2014 18:54:29
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 2: No such file or directory
CRS-2674: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac-p1' failed
CRS-2527: Unable to start 'ora.LISTENER_SCAN1.lsnr' because it has a 'hard' dependency on 'ora.scan1.vip'
CRS-2525: All instances of the resource 'ora.scan1.vip' are already running; relocate is not allowed because the force option was not specified
CRS-4000: Command Start failed, or completed with errors.

--mod update: code tags added, please do this yourself in future.

[Updated on: Mon, 07 April 2014 00:48] by Moderator

Report message to a moderator

Re: RAC SCAN LISTENER [message #611678 is a reply to message #611669]

Mon, 07 April 2014 00:47

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

If this is a production system, you really should patch it up to the current release. 11.2.0.1 is very old, even 11.2.0.2 introduced many improvements.

Apart from that, the error message you quote suggests that you do not have a SCAN listener configured. What is the contents of your listener.ora file in the grid home?

Report message to a moderator

Re: RAC SCAN LISTENER [message #611888 is a reply to message #611678]

Wed, 09 April 2014 12:13

vilin
Messages: 6
Registered: April 2014

Junior Member

Thanks for your reply and sorry about not getting back to you sooner!

Yes, I realize it's an old version and looking into upgrading.

I resolved the previous errors (crsctl start res ora.LISTENER_SCAN1.lsnr errors out) by copying listenr.ora from %GRID_HOME%/NETWORK/ADMIN into
%OH%/NETWORK/ADMIN... The catch is that the real home for listenr.ora is supposed to be %GRID_HOME%/NETWORK/ADMIN, right??

New issues:"The listener supports no services"

C:\app\11.2.0\grid\BIN>lsnrctl services listener_scan1
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 08-APR-2014 21:55:04
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
The listener supports no services
The command completed successfully

Many thanks,
Will

Report message to a moderator

Re: RAC SCAN LISTENER [message #611891 is a reply to message #611888]

Wed, 09 April 2014 13:17

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

You are attempting to run your listeners off the wrong home. This will destroy the integrity of the Grid Infrastructure, as you have already found. Your best option may be to shutdown everything and restart the cluster. Use the crsctl utiity to stop the entire clusterware stack. Kill anything still running. Make sure everything really is shutdown. Then start the clusterware again. Do not attempt to start or stop anything with any utilities otherthan crsctl or srvctl. If your installation was done competently, all services will start up correctly.

Report message to a moderator

Re: RAC SCAN LISTENER [message #611899 is a reply to message #611891]

Wed, 09 April 2014 18:11

vilin
Messages: 6
Registered: April 2014

Junior Member

Hi,

Thanks for your advice!

I need to explain couple of thing here:

- The ora.LISTERNER_SCAN1,2,3.lsnr will NOT start without placing listener.ora in %OH%/NETWROK/ADMIN-- I
understand the ramifications
- There is no TNS_ADMIN setting.

Questions:
- How should I get "crsctl start res ora.LISTENER_SCAN1.lsnr" to read %GRID_HOME%.../listener.ora?
- Is it not true that %OH%... is for tnsnames.ora + SQLNET.ora & %GRID_HOME%... for listener.ora?
- Would it be advisable to set TNS_ADMIN to %GIRD_HOME%/NETWORK/ADMIN?
- I'd take it that 11.2.0.1.0 release is old and buggy, right?
- Is there a UNIX-like ps -ef |grep scan?

Appreciate your help!
Will

Report message to a moderator

Re: RAC SCAN LISTENER [message #611910 is a reply to message #611899]

Thu, 10 April 2014 01:55

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

The crsctl utility locates resources by reading information stored in the OCR, so presumably you have configured your SCAN listener incorrectly. But you have so far provided no information about how your SCAN listener is configured, in the OCR or anywhere else. The output of commands such as

srvctl config scan_listener 
crsctl status resource ora.LISTENER_SCAN1.lsnr -p
type listener.ora

and so on would help.
You could also try implementing my previous suggestions, rather than ignoring them.

Report message to a moderator

Re: RAC SCAN LISTENER [message #612055 is a reply to message #611910]

Fri, 11 April 2014 09:05

vilin
Messages: 6
Registered: April 2014

Junior Member

Good morning, John:

C:\app\11.2.0\grid>srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521

C:\app\11.2.0\grid>crsctl status resource ora.LISTENER_SCAN1.lsnr -p
NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
ACL=owner:system:rwx,pgrp::r-x,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%\bin\oraagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=60
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=scan_listener) PROPERTY(LISTENER_NAME=PARSE(%NAME%, ., 2))
DEGREE=1
DESCRIPTION=Oracle SCAN listener resource
ENABLED=1
ENDPOINTS=TCP:1521
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=balanced
PORT=1521
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=hard(ora.scan1.vip) dispersion:active(type:ora.scan_listener.type) pullup(ora.scan1.vip)
START_TIMEOUT=180
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.scan1.vip)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_OPI=false
VERSION=11.2.0.1.0

C:\app\11.2.0\grid\NETWORK\ADMIN>type listener.ora
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
# listener.ora.oradb-rac-p2 Network Configuration File: C:\app\11.2.0\grid\network\admin\listener.ora.oradb-rac-p2
# Generated by Oracle configuration tools.

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

LISTENER_SCAN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
)
)

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON # line added by Agent

Thanks,
Wil

Report message to a moderator

Re: RAC SCAN LISTENER [message #612056 is a reply to message #612055]

Fri, 11 April 2014 09:15

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Quote:

Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

Report message to a moderator

Re: RAC SCAN LISTENER [message #612058 is a reply to message #611910]

Fri, 11 April 2014 09:20

vilin
Messages: 6
Registered: April 2014

Junior Member

Hi John,

Not at all, your recommendations are great, and I hope I did not imply that I was ignoring them. It's just that it's a production system and I am being very careful about my next steps...

I will send you the commands' outputs you mentioned above in separate reply... I, however, need to keep some company information private, how would I go about sending you a private message?

"The crsctl utility locates resources by reading information stored in the OCR"...

The following command fails: crsctl start res ora.LISTENER_SCAN.lsnr

For some reason CRS can look up listener.ora if the file exists in %OH%/NETWORK/ADMIN--

I know it's not the right place for it... Pls see the error message:
C:\app\11.2.0\grid\NETWORK\ADMIN>crsctl start res ora.LISTENER_SCAN1.lsnr
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac-p1'
CRS-5016: Process "C:\app\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "C:\app\11.2.0\grid\bin\oraagent.exe" for action "start" failed: details at "(:CLSN00010
:)" in "C:\app\11.2.0\grid\log\rac-p1\agent\crsd\oraagent\oraagent.log"

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-APR-2014 18:54:27

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Log messages written to c:\app\administrator\diag\tnslsnr\RAC-P1\listener_scan1\alert\log.xml
TNS-01151: Missing listener name, LISTENER_SCAN1, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

CRS-5016: Process "C:\app\11.2.0\grid\bin\lsnrctl.exe" spawned by agent "C:\app\11.2.0\grid\bin\oraagent.exe" for action "start" failed: details at "(:CLSN00010
:)" in "C:\app\11.2.0\grid\log\rac-p1\agent\crsd\oraagent\oraagent.log"

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-APR-2014 18:54:29

Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory
CRS-2674: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac-p1' failed
CRS-2527: Unable to start 'ora.LISTENER_SCAN1.lsnr' because it has a 'hard' dependency on 'ora.scan1.vip'
CRS-2525: All instances of the resource 'ora.scan1.vip' are already running; relocate is not allowed because the force option was not specified
CRS-4000: Command Start failed, or completed with errors.

Thanks,
Will

Report message to a moderator