Solved

Remove 1521

Posted on 2015-01-22
10
184 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
[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 81

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: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
Report: Liquid Web beats Amazon, Rackspace & More

A study by performance analyst firm Cloud Spectator finds that Liquid Web beats rivals Amazon, Rackspace and DigitalOcean when it comes to website and cloud application performance.

 

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
 
LVL 77

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
This article is a collection of issues that people face from time to time and possible solutions to those issues. I hope you enjoy reading it.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

738 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