Solved

Remove 1521

Posted on 2015-01-22
10
176 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 79

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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle sql query 7 51
nexus filter logs 3 29
Use of Exception to end a Loop 3 20
Can't ping New Linux Servers 40 28
Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
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 shows how to recover a database from a user managed backup

862 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

23 Experts available now in Live!

Get 1:1 Help Now