How to close em in oracle

Method: 1. Use "emctl status dbconsole" to check em status; 2. Use "emctl stop dbconsole" to stop em from running; 3. Use "emca -deconfig dbcontrol db-repos drop" to close em. .

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to close em in oracle

1. First check the status of em

$ emctl status dbconsole

2. If it is running, stop it first Run, this is a good habit

$ emctl stop dbconsole

3. Then, execute the command

$ emca -deconfig dbcontrol db -repos drop

In fact, after completing this command, the following script is no longer needed, because I personally tested that all the following statements return the error that the object has been deleted.

However, it is not ruled out that sometimes there will be residues, so it is written as a script and saved so that it can be used at any time.

Create subsequent cleanup script

$ vim dropEM.sql

Then copy the following SQL statement to dropEM.sql and save it

drop public synonym setemviewusercontext;
drop public synonym mgmt_target_blackouts;
drop role mgmt_user;
drop user mgmt_view cascade;
drop user sysman cascade;

In sqlplus Call this script

SQL> @dropEM.sql

to completely delete EM.

Extended knowledge:

The default startup port of ORACLE 12C EM is 5500. In order to prevent abnormal attacks, it is recommended to close the service corresponding to this port to avoid the risk of attack. .

First check the services running on the Oracle server. The command is as follows:

Use lsnrctl status to check the listening status.

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to close em in oracle. For more information, please follow other related articles on the PHP Chinese website!