Home > Oracle Rac > Add a second port to SCAN Listener

Add a second port to SCAN Listener

1) check the scan listener status

make sure the ORACLE_HOME is set to the GRID_HOME


oracle@rac1:>lsnrctl stat LISTENER_SCAN3

LSNRCTL for HPUX: Version 11.2.0.2.0 - Production on 21-MAR-2012 15:39:52

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN3
Version                   TNSLSNR for HPUX: Version 11.2.0.2.0 - Production
Start Date                21-MAR-2012 12:20:20
Uptime                    0 days 3 hr. 19 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0.2/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2.0.2/grid/log/diag/tnslsnr/cruz/listener_scan3/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN3)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.223.61)(PORT=1521)))
Services Summary...
Service "SYSLET" has 2 instance(s).
Instance "SYSLET1", status READY, has 1 handler(s) for this service...
Instance "SYSLET2", status READY, has 1 handler(s) for this service...
The command completed successfully

2) we can see the scan is listening on port 1521, now let’s add second port


oracle@rac1:> srvctl modify scan_listener -p “TCP:1521/TCP:1522″

3) stop and start the scan listener to get the new value in place


oracle@rac1:>srvctl stop scan_listener
oracle@rac11:>srvctl start scan_listener

4) check the scan listener status again


oracle@rac1:>lsnrctl stat LISTENER_SCAN3

LSNRCTL for HPUX: Version 11.2.0.2.0 - Production on 21-MAR-2012 15:39:52

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN3
Version                   TNSLSNR for HPUX: Version 11.2.0.2.0 - Production
Start Date                21-MAR-2012 12:20:20
Uptime                    0 days 3 hr. 19 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0.2/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2.0.2/grid/log/diag/tnslsnr/cruz/listener_scan3/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN3)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.223.61)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.223.61)(PORT=1521)))
Services Summary...
Service "SYSLET" has 2 instance(s).
Instance "SYSLET1", status READY, has 1 handler(s) for this service...
Instance "SYSLET2", status READY, has 1 handler(s) for this service...
The command completed successfully

Advertisements
Categories: Oracle Rac
  1. mikey
    July 31, 2012 at 12:25 pm

    How to rename SCAN in Cluster?

    If you need to change your scan name from topgun.orahelp.com to ripoff.orahelp.com

    Stop the SCAN: Source Grid home, srvctl stop scan_listener, and srvctl stop scan then.

    [grid@linux1 ~]$ srvctl stop scan_listener
    [grid@linux1 ~]$ srvctl stop scan
    

    Configure the new SCAN in your DNS, or /etc/hosts, or GNS and make sure that lookups are working for the new name.

    [root@linux2 ~]# nslookup ripoff.orahelp.com
    Server:         192.168.1.18
    Address:        192.168.1.18#53
    
    Name:   ripoff.oraclehelp.com
    Address: 192.168.1.44
    Name:   ripoff.oraclehelp.com
    Address: 192.168.1.45
    Name:   ripoff.oraclehelp.com
    Address: 192.168.1.46
    [root@linux2 ~]#
    

    Configure the Cluster to take the new VIPs
    As root user on one of the cluster nodes (not needed on both the nodes):

    [root@linux1 ~]# /oracle/product/11.2.0/grid/bin/srvctl modify scan -n ripoff.oraclehelp.com
    [root@linux1 ~]# 
    

    As grid user on one of the cluster nodes (not needed on both the nodes):

    [grid@linux1 ~]$ srvctl modify scan_listener -u
    [grid@linux1 ~]$ srvctl start scan_listener
    

    Verify that configuration is right and three SCAN listeners are started.

    [grid@linux1 ~]$ srvctl config scan
    SCAN name: ripoff.oraclehelp.com, Network: 1/192.168.1.0/255.255.255.0/eth0
    SCAN VIP name: scan1, IP: /ripoff.oraclehelp.com/192.168.1.44
    SCAN VIP name: scan2, IP: /ripoff.oraclehelp.com/192.168.1.45
    SCAN VIP name: scan3, IP: /ripoff.oraclehelp.com/192.168.1.46
    [grid@linux1 ~]$ 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
    [grid@linux1 ~]$
    
  2. mikey
    July 31, 2012 at 1:17 pm

    How to rename SCAN Port in Cluster?

    As grid user, source the grid environment to make sure $GRID_HOME/bin is in PATH and
    1. Modify SCAN listener port:

    [grid1@linux1 ~]$ srvctl modify scan_listener -p 1522
    

    2. Restart SCAN listener so the new port will be effective:

    [grid@linux1 ~]$ srvctl stop scan_listener
    [grid@linux1 ~]$ srvctl start scan_listener
    

    3. Confirm the change:

    [grid@linux1 ~]$ srvctl config scan_listener
    SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1522
    SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1522
    SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1522
    [grid@linux1 ~]$
    
  3. matty
    August 22, 2012 at 8:03 pm

    Hi Mike,
    I was running through your example and encountered this issue, don’t know if you have encountered this one or not and what is the workaround. I did search oracle support but no luck.

    srvctl modify scan_listener -p “TCP:1521/TCP:1525”
    PRCS-1035 : Invalid number of TCP ports (2) for SCAN Listener

    However, I was able to do:
    srvctl modify scan_listener -p “TCP:1521/TCPS:1525”

    • mikey
      August 22, 2012 at 10:41 pm

      Matty
      What version of oracle are you running, is it 11.2.0.3 and have you applied the security patch with secures the listener

      Not sure why you are getting that error , I will try it out tomorrow when I get to work

      Mike

      • matty
        August 22, 2012 at 10:47 pm

        thanks for the response

        it’s 11.2.0.3.0 on redhat 5.7 and I haven’t applied the security patch to the listener, I guess I can try that.

        but using tcps works: srvctl modify scan_listener -p “TCP:1521/TCPS:1525″

      • mikey
        August 22, 2012 at 11:03 pm

        Matty

        I will try tomorrow on 11.2.0.3 and see if I get the same error, I tried it on earlier version, also are you sure the port it not in use .
        I was hoping the issue you were getting was due to the fact you had applied the securing of listener patch

        Will update tomorrow once I try it

        Thanks mike

  4. mikey
    August 23, 2012 at 3:49 pm

    Hi matty
    Right i have tried this in 11.2.0.2 and its works fine , I have got a feeling that something has changed in 11.2.0.3 , I can test it as i have got the security patch securing the listener installed and that using TCPS on port 1523

    Here is the output on 11.2.0.2 , I will try and add another port on 11.2.0.3 and see what happens failing that i will raise a call with oracle

    oracle@rac1:/u01/app/11.2.0.2/grid/network/admin > srvctl modify scan_listener -p “TCP:1521/TCP:1523”
    oracle@rac1:/u01/app/11.2.0.2/grid/network/admin > srvctl stop scan_listener
    oracle@rac1:/u01/app/11.2.0.2/grid/network/admin > srvctl start scan_listener

    racle@davis:/u01/app/11.2.0.2/grid/network/admin > lsnrctl status listener_scan2

    LSNRCTL for HPUX: Version 11.2.0.2.0 – Production on 23-AUG-2012 15:43:27

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
    STATUS of the LISTENER
    ————————
    Alias LISTENER_SCAN2
    Version TNSLSNR for HPUX: Version 11.2.0.2.0 – Production
    Start Date 23-AUG-2012 15:42:39
    Uptime 0 days 0 hr. 0 min. 48 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /u01/app/11.2.0.2/grid/network/admin/listener.ora
    Listener Log File /u01/app/11.2.0.2/grid/log/diag/tnslsnr/davis/listener_scan2/alert/log.xml
    Listening Endpoints Summary…
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.119.55)(PORT=1523)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.119.55)(PORT=1521)))
    Services Summary…
    Service “SYSNPP” has 2 instance(s).
    Instance “SYSNPP1”, status READY, has 2 handler(s) for this service…
    Instance “SYSNPP2”, status READY, has 2 handler(s) for this service…

    Thanks
    mike

  5. mikey
    August 28, 2012 at 9:46 am

    Bug 13798847 – ADD MULTILPLE PORTS TO SCAN_LISTENER FAILS
    This will be fixed in 11.2.0.4 or 12g

    • matty
      August 28, 2012 at 2:06 pm

      thanks Mikey! I had a feeling that that it was a bug since you were able to do it in 11.2.0.2.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: