Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to configure EM in the Oracle12c environment", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to configure EM in the Oracle12c environment" this article.

In the Oracle12c environment, EM does not need to be installed and configured separately, just check EM express when creating the database. Because many functions are transferred to SQL developer, the EM of 12c is called EM express.

If EM express is not checked when installing the database, you can configure it manually by following these steps (refer to the official documentation):

Step1.Configure and start the Oracle Net Listener (the listener).

Step2.init.ora (when the listener is running on a non standard port)

Init.ora local_listener=inst1

Where inst1 is a TNSNAMES entry defined in tnsnames.ora that points to the listener.

For example: tnsnames.ora

Inst1= (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=host_name) (PORT=1234)) (CONNECT_DATA= (SERVICE_NAME=service_name) (SERVER=DEDICATED)

Step3. Enable the TCP dispatcher by adding the following entry to the init.ora file for the database you want to manage using EM Express:

Dispatchers= "(PROTOCOL=TCP) (SERVICE=XDB)"

For example: dispatchers= "(PROTOCOL=TCP) (SERVICE=ORCLXDB)" For example:

Step4. Restart the database so that the changes made in the init.ora file take effect.

Configure 5500 for EM Express

Netstat-aon | findstr "5500"-check to make sure the port is not occupied

SQL > show parameter dispatchers

SQL > exec DBMS_XDB_CONFIG.SETHTTPSPORT (5500)

How to access EM express after database installation:

Execute: lsnrctl status

Find something similar to the following:

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcps) (HOST=hostname) (PORT=5500)) (Security=. This section has the corresponding sid information)

Then the URL of the EM express of the database is: https://hostname:5500/em

If PROTOCOL=tcps is tcp, replace https with http,URL and don't forget to add / em at last, otherwise a "need to verify" window will pop up and prompt for your user name and password.

View the em port through the database:

Select dbms_xdb_config.gethttpsport () from dual

Select dbms_xdb_config.gethttpport () from dual

Set the em port:

You can change the em port from 5500 to 5502 with the following command

Exec dbms_xdb_config.setHTTPSport ()

Exec DBMS_XDB_CONFIG.setHTTPPort (5502)

The above is all the content of the article "how to configure EM in Oracle12c environment". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.