Solved

Remove 1521

Posted on 2015-01-22
10
171 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:mkhandba
  • 5
  • 3
10 Comments
 
LVL 78

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 76

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:mkhandba
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
 

Author Comment

by:mkhandba
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
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 76

Expert Comment

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

Accepted Solution

by:
mkhandba 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 76

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:mkhandba
ID: 40572921
correct, but with some modifications ... means it's not that same, I've added some steps too ;)
0
 

Author Closing Comment

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

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

744 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now