Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
You can also change the port of Enterprise Manager Database Express 12c after installation.
You can find the current port as follows.
|
1 2 |
[oracle@oradb trace]$ lsnrctl status | grep HTTP (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oradb)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.2.0/dbhome_1/admin/UDW/xdb_wallet))(Presentation=HTTP)(Session=RAW)) |
You can also find it via SQL Plus with the following query.
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SQL> select dbms_xdb.getHttpPort() from dual; DBMS_XDB.GETHTTPPORT() ---------------------- 0 SQL> select dbms_xdb_config.getHttpsPort() from dual; DBMS_XDB_CONFIG.GETHTTPSPORT() ------------------------------ 5500 |
You can change the current port for http and https as follows.
|
1 2 3 4 5 6 7 |
https: SQL> exec dbms_xdb_config.sethttpsport(5500); http: SQL> exec dbms_xdb_config.sethttpport(8080); |
Author: dbtut
We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.