Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Remove 1521

Posted on 2015-01-22
10
Medium Priority
?
195 Views
Last Modified: 2015-02-01
We don't want to use 1521, can any one please assist, how to remove this 1521 from the list:

[oracle@oda01 ~]$ srvctl config scan_listener

SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1530,1521

SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1530,1521

[oracle@oda01 ~]$

 

[oracle@oda02 ~]$ srvctl config scan_listener

SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1530,1521

SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1530,1521

[oracle@oda02 ~]$

We just want to use 1530 only, also please assist, how to make sure and inform others too about this change & modification, so no connections go failed or none of the applications suffered too.

Also if I would like to know more about my ODA environment and would like to go for the best practices, if this can be shared too, will be highly appreciated.

Thanks in advance.
0
Comment
Question by:Mushfique Khan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
10 Comments
 
LVL 83

Expert Comment

by:David Johnson, CD, MVP
ID: 40565320
edit /opt/oracle/11.2.0/network/admin/listener.ora and /opt/oracle/11.2.0/network/admin/tnsnames.ora to only have 1521

you have to set your
top the Oracle listener using the following command:
     lsnrctl stop
    Change the port number in the Oracle listener.ora file. For example, from the default port 1522 to 1521.
    Change the port number in the tnsnames.ora file as in the following example,where host_name is your host name and server_name is your server name.
    Restart the Oracle listener using the following command: lsnrctl start
    Change the port to which the database is listening:
   
 sqlplus / as sysdba
    > alter system set LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))";
    > alter system register;

Open in new window

0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40565433
I don't believe the post above is accurate and I personally wouldn't follow it without more research.

David,
The scan ip address/port is related to a RAC/Cluster install.  There is more to changing the scan port than what you posted.

I'm not a RAC Expert which is why I left the question alone but since you posted, I feel the need to post and Google around for myself.

mkhandba,

See if this link gets you to where you need to be:
https://oraclehandson.wordpress.com/2010/05/21/oracle-11gr2-how-to-change-scan-port/

First it looks like you need srvctl modify scan_listener and need to set remote_listener NOT local_listener as mentioned in the post above.
0
 

Author Comment

by:Mushfique Khan
ID: 40571925
thanks slightwv, but this post was not complete, I figured it out myself.

Please EE Admin, you can remove/delete this question.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

Author Comment

by:Mushfique Khan
ID: 40572595
I've requested that this question be closed as follows:

Accepted answer: 0 points for mkhandba's comment #a40571925

for the following reason:

you can delete it, as found the answer myself.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40572596
Please post the solution and accept that as the answer.
0
 

Accepted Solution

by:
Mushfique Khan earned 0 total points
ID: 40572870
Steps:

1) Log in as the “grid” user (if you have installed Grid & database under single user “oracle” then use “oracle” user)

2) Make a note of current SCAN listener configuration:
[grid@rac-prod01 ~]$ 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@rac-prod01 ~]$

3) Modify SCAN listener port to "1528"

srvctl modify scan_listener -p 1528

4) Restart SCAN listener to make the new port effective
srvctl stop scan_listener
srvctl start scan_listener

5) Finally confirm the change
 [grid@rac-prod01 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1528
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1528
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1528
[grid@rac-prod01 ~]$

Now make sure to check: LOCAL_LISTENER & REMOTE_LISTENER too

alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=<your_vip_node1>))" scope=both sid='INSTANCE_NAME1';

Do the same for the 2nd instance where host is set to the <vip_host_node2> and the sid is set to the 2nd instance name.

alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=<your_vip_node2>))" scope=both sid='INSTANCE_NAME2';
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40572891
Above steps seem to have been copied from:
http://momendba.blogspot.com/2012_05_01_archive.html

The steps are pretty much the same as the blog entry in the link I posted.
0
 

Author Comment

by:Mushfique Khan
ID: 40572921
correct, but with some modifications ... means it's not that same, I've added some steps too ;)
0
 

Author Closing Comment

by:Mushfique Khan
ID: 40582269
because couldn't get the answer and found myself.
0

Featured Post

Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Fine Tune your automatic Updates for Ubuntu / Debian
If you’re involved with your company’s wide area network (WAN), you’ve probably heard about SD-WANs. They’re the “boy wonder” of networking, ostensibly allowing companies to replace expensive MPLS lines with low-cost Internet access. But, are they …
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
Suggested Courses

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question