By:Joel Perez( Oracle ACED )
In this article we will show you how to setting up Listener Port Manually on cloud.
Instance Creation:
Login to your Oracle cloud services account, go to the "Oracle Database Cloud Service" page and create a new service.
Service
• Set Service Name as “Primary”
• Set the service Level as “Oracle Database Cloud Service”
• Set Metering Frequency as per your convenience
• Set the Software Release as “Oracle Database 11g Release2”
• Set the Software Edition “Enterprise Edition”
• Set the Database type as “Single Instance”
Click onto continue
Service Details
• Select DB Name (SID) as “ORCL”
• Set an administrative password of your choice and confirm the password (this will be your sys password)
• Set Usable Database Storage as 25 GB
• Select compute shape as “OC3 -1 OCPU, 7.5GB RAM” (this is the bare minimum requirement)
• Set SSH Public key as shown below
Click on Advance Setting ( !This is the option for the new feature! )
•
Enter the Listener Port (1521-5499) !This is the option for the new feature! )
•
Click onto continue
Finally, check the configuration and click on "Create" to create your cloud database.
After a few minutes, “Listener” instance will be created successfully.
Click on the service name (Listener) to open the main page of database.
Before trying to connect to the instance on the cloud machine, you have to enable dblistener access rule.
Steps to enable dblistener access rule are as follows
Open the database service and Access Rule from the menu.
Click on Actions menu for the ora_p2_dblistener rule and enable it
Note:
Listener Port must be same as we assigned earlier during creation.
Open instances of the "Putty" executable and connect SSH to both the machines.
Connect to the instance and check the hostname and pmon on server. Also check whether listener is running or not.
We can check the listener status with traditional method.
lsnrctl status LISTENER
dbaascli
But In Cloud, we canutility to check listener status.
oracle
Make sure you must connect withuser only.
User-specified port number for Oracle Net Listener
When you create a new Database Cloud Service database deployment, you can now specify a custom port number for Oracle Net Listener. The port number must be between 1521 and 5499
So now you know, it is very easy to configure User-specified port number for listener.
We hope this article has proved useful and we invite you to continue reading our next publications focused on Oracle Cloud.
About the Author
Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialized in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries in 5 continents and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish & OTN Portuguese. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA(Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China and more. Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004 and as one of the biggest professional achievement in his career he was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Chief Technologist in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China www.Enmotech.com