I have used the sys user to login to my oracle enterprise manager. Since we have configured the port for HTTPS protocol thus make sure to specify https in the url not the HTTP. In my case the URL for accessing the Oracle EM was Once you are done then you can use that port number to connect with your Oracle Enterprise Manager Database Express. Furthermore this procedure on execution will set the said number as the https port for my pluggable database orclpdb. Here I have specified 5510 as the argument for sethttpsport procedure. Now that you have got an idea about what “sethttpsport” procedure is, let’s move ahead and use it to set a port number for our database orclpdb.
#Oracle database port free
Whatever port number you are specifying here must be free otherwise you will get an error.Ĭlick Here to learn more about PL/SQL Stored Procedure.
![oracle database port oracle database port](https://ronekins.files.wordpress.com/2020/10/portworx-by-ps-stack-logo_full-color.png)
This ALTER SESSION DDL will switch the container to orclpdb. Thus, I need to switch my container from CDB$ROOT to orclpdb. Nevertheless, as I mentioned earlier that I want to set the https port for my pluggable database orclpdb.
![oracle database port oracle database port](https://databaseheartbeat.files.wordpress.com/2021/10/20211013_103932.jpg)
You can verify that like this – show con_name Ĭonsequently, this command will show you the container name with which you are connected with your database. Which means on execution of the above command you will be connected with your database through the root container CDB$ROOT. And we know that in multi-tenant architecture of the Oracle, by default, we are always connected with the database through the root container. This statement will connect you with your database using the sys user. In order to do that you first need to connect with the database. You need to connect with the container for which you want to set the https port. Let’s come back to the process of configuring the port number for Oracle Enterprise Manager.
#Oracle database port how to
You can click here to learn how to install Oracle Database 19c. Moreover it will be same for any Oracle Database version which is based on multi-tenant architecture. Though I am using Oracle 19c, but the process will be same for Oracle 12c or 18c. My Setup for The Demonstration –įor the demonstration I am using Oracle Database 19c which has one root container database CDB$ROOT and one pluggable database ORCLPDB.Īdditionally, I will be configuring the port number for my pluggable database orclpdb. These steps are –īut before I start explaining these steps, let me tell you about the Oracle Database setup that I am using for this demonstration. Manually configuring the https port number for Oracle Enterprise Manager is a 3 step process. How to Configure the Port Number for Oracle Enterprise Manager. Therefore, it’s always advisable to change the default port number of your OEM Express.
![oracle database port oracle database port](https://i.stack.imgur.com/JezOs.jpg)
![oracle database port oracle database port](https://www.mssqltips.com/tipimages2/6559_migrate-oracle-database-to-sql-server-using-ssma-for-oracle.015.png)
As default port numbers are easier to exploit by hackers. Using default port number for Oracle Enterprise Manager is never recommended. You can click here to read how to find out the domain name and the default port number of the database. That URL is made up of two main components, which are – Domain name and Port Number. These are –Īs Oracle Enterprise manager is a web-based database management tool thus we need a proper URL to access it. There are two main reasons for configuring a port for Oracle Enterprise Manager.