Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Remove 1521

Posted on 2015-01-22
10
Medium Priority
?
199 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
  • 5
  • 3
10 Comments
 
LVL 84

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 78

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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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 78

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 78

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
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…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Suggested Courses

926 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