Solving “Oracle 12c unable to access port 5500” Issue

Introduction

In this tutorial, we will address how to solve the issue of “Oracle 12c unable to access port 5500”. This is an essential skill for DevOps roles involved in Oracle database management. By following these steps, you will be able to resolve the port access issue and ensure smooth connectivity to your Oracle database.

Accessing the Oracle Database with Required Privileges

First, access the Oracle database with the necessary permissions:

sqlplus / as sysdba

Checking Port 5500 from SYSDBA Oracle

Execute the following SQL command to check the current HTTPS port configuration:

SQL> select dbms_xdb_config.gethttpsport from dual;

Terminal Output

markdownCopy codeGETHTTPSPORT
------------
5500

If the port is not set to 5500, you can set it using the following command:

Setting HTTPS Port to 5500

Execute the following PL/SQL command to set the HTTPS port to 5500:

SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

Terminal Output

PL/SQL procedure successfully completed.

Starting the Listener Service

To ensure that the listener service is running, use the lsnrctl command from the command line:

[oracle@DBOracle ~]$ lsnrctl start LISTENER

Checking Port 5500 Listening in Linux

Verify that port 5500 is listening by using the netstat command:

$ netstat -nplt | grep 5500

Accessing the Oracle Database Web Interface

Now, you should be able to access the Oracle database web interface. Open your web browser and navigate to:

https://192.168.1.114:5500/em/

Conclusion

In this article, we covered how to solve the “Oracle 12c unable to access port 5500” issue. By following these steps, you should now be able to configure and access port 5500 for your Oracle database. This ensures efficient management and connectivity for your database applications. Thank you for reading the DevopsRoles page!