Custom SCAN Listener Exadata

Exadata Cloud Server & Cloud @ Customer

Oracle has now given option to specify the custom SCAN listener port during the Cluster creation in ExaCS/ExaCC Services. Wow this is interesting !!!

Few weeks back there was a big discussion with one of my client and they exactly ask the same question like if we can specify custom port or not ?

From my point of view here is what my though process. Main purpose of Cloud and Exadata on Cloud is to standardize all the ports & parameters so it can be well automated and reduce the maintenance task. Few of them like if I want to list here, although list is long ….

• All Oracle Homes are owned by oracle user viz on On-prem we have different users for each Oracle homes .
• For Oracle Home we have fix space in Exadata and thus it basically pushed for Consolidation and Sharing of Oracle Homes.
• There will be single SCAN listener port which will be handling multiple databases may be 150–200 count but we can have complete range of port in case of on-prem.

So idea is we need to basically un-learn the trivial way and adapt or learn the Cloud way. Those who are not aware of SCAN listener check link http://oracle-help.com/oracle-rac/scan-listener-in-oracle-rac/

Now till now SCAN listener port was fixed to 1521 in ExaCS/ExaCC and when you create VM Clusters there was no option to change this port. Recently option has been added and now while creating the VMclusters in Exadata we can change it from standard 1521 port to port of our choice from the range 1024–8999. If not mentioned then it will take 1521 only.

How to specify ?

When you are creating VM Cluster Network, there you share Data Center Network details which includes Netwmask, DB Server Starting IP, Gateway, Domain name, Backup Network Details, NTP & DNS Server details. Later in the Advanced Options you will see SCAN Listener Port Details as shown

Finally its Customized standardization and further you can connect to database with below 2 options

1 -Create a temporary SSH tunnel from your computer to the database. This method provides access only for the duration of the tunnel.

2- Open the port used as the Oracle SCAN listener by updating the security list used for the cloud VM cluster or DB system resource in the Exadata Cloud Service instance. More durable access to the database

Hope you find this info helpful !!!