How to troubleshoot the Oracle 11g EM website "There is a problem with this site's security certificate"

In IE input HTTPS://LOCALHOST:1158/EM direct error, cannot open; Tip: "Certificate error, this web site security certificate has a problem", the process is as follows:

1. Delete and rebuild Dbconsole

2. Configure the necessary environment variables

1. Delete and rebuild Dbconsole

1.1 Delete Dbconsole Repository information

c:\users\10188535>emca-repos Drop

EMCA started on 2015-9-14 9:28:22

EM Configuration Assistant, 11.2.0.0.2 official version

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:

Database Sid:dw

Listener Port number: 1521

SYS User's password:

Sysman User's password:

Sysman User's password:

Do you want to continue? [Yes (Y)/No (N)]: Y

2015-9-14 9:28:43 Oracle.sysman.emcp.EMConfig Perform

Info: This operation is being logged to D:\app\10188535\cfgtoollogs\emca\dw\emca_2015_09_14_09_28_22.log.

2015-9-14 9:28:44 Oracle.sysman.emcp.ParamsManager Checklistenerstatusfordbcontrol

Warning: An error occurred while initializing the SQL connection. Unable to execute SQL operation

2015-9-14 9:28:44 Oracle.sysman.emcp.EMReposConfig Invoke

Info: Removing the EM Data archive (this may take some time) ...

2015-9-14 9:28:45 Oracle.sysman.emcp.EMReposConfig Invoke

Info: The repository was deleted successfully

Configuration of Enterprise Manager completed successfully

EMCA ended on 2015-9-14 9:28:45

1.2 Rebuilding the Dbcontrol database

c:\users\10188535>emca-config dbcontrol db-repos Create

EMCA started on 2015-9-14 9:29:22

EM Configuration Assistant, 11.2.0.0.2 official version

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:

Database Sid:dw

Listener Port number: 1521

Listener Oracle_home [D:\app\10188535\product\11.2.0\dbhome]: D:\app\10188535\product\11.2.0\dbhome

SYS User's password:

DBSNMP User's password:

Sysman User's password:

Sysman User's password: e-mail address of the notification (optional):

Outgoing (SMTP) server for notifications (optional):

-----------------------------------------------------------------

The following settings have been specified

The database is oracle_home ..... ..... D:\app\10188535\product\11.2.0\dbhome

Local host name .......... A23181215.intra

The listener is oracle_home ...... ..... D:\app\10188535\product\11.2.0\dbhome

Listener port number ...... ....... 1521

Database SID .... DW (......)

The e-mail address of the notification .....

Notification of the outgoing (SMTP) server ..... .....

-----------------------------------------------------------------

Do you want to continue? [Yes (Y)/No (N)]: Y

2015-9-14 9:30:18 Oracle.sysman.emcp.EMConfig Perform

Info: This operation is being logged to D:\app\10188535\cfgtoollogs\emca\dw\emca_2015_09_14_09_29_22.log.

2015-9-14 9:30:20 Oracle.sysman.emcp.EMReposConfig createrepository

Info: Creating an EM Data archive (this operation may take a while) ...

2015-9-14 9:34:47 Oracle.sysman.emcp.EMReposConfig Invoke

Info: The repository was created successfully

2015-9-14 9:34:52 Oracle.sysman.emcp.EMReposConfig uploadconfigdatatorepository

Info: Uploading configuration data to the EM data archive (this operation may take some time) ...

2015-9-14 9:35:38 Oracle.sysman.emcp.EMReposConfig Invoke

Info: The configuration data was uploaded successfully

2015-9-14 9:35:48 Oracle.sysman.emcp.util.DBControlUtil Configuresoftwarelib

Info: The software library has been configured successfully.

2015-9-14 9:35:48 Oracle.sysman.emcp.EMDBPostConfig configuresoftwarelibrary

Info: Provisioning profile is being deployed ...

2015-9-14 9:36:14 Oracle.sysman.emcp.EMDBPostConfig configuresoftwarelibrary

Info: Provisioning file deployment was successful.

2015-9-14 9:36:14 Oracle.sysman.emcp.util.DBControlUtil Securedbconsole

Info: Protecting Database Control (This operation may take some time) ...

2015-9-14 9:36:22 Oracle.sysman.emcp.util.DBControlUtil Securedbconsole

Info: Database Control has been successfully protected.

2015-9-14 9:36:22 Oracle.sysman.emcp.util.DBControlUtil startoms

Info: Starting Database Control (This operation may take some time) ...

2015-9-14 9:38:38 Oracle.sysman.emcp.EMDBPostConfig performconfiguration

Info: The Database Control was successfully started

2015-9-14 9:38:38 Oracle.sysman.emcp.EMDBPostConfig performconfiguration

Info: >>>>>>>>>>> Control URL for Https://A23181215.intra:5500/em <<< <<<<<<<<

2015-9-14 9:38:41 Oracle.sysman.emcp.EMDBPostConfig Invoke

Warning:

WARNING ************************

The management repository is placed in safe mode, in which Enterprise Manager data is encrypted. The encryption key has been placed in the file d:/app/10188535/product/11.2.0/dbhome/a23181215.z

The Te.intra_dw/sysman/config/emkey.ora. Be sure to back up this file, because if this file is lost, the encrypted data will not be available.

***********************************************************

Configuration of Enterprise Manager completed successfully

EMCA ended on 2015-9-14 9:38:41

1.3 Querying Dbconsole Status

C:\users\10188535.zte>emctl status Dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, Oracle Corporation. All rights reserved. https://A23181215.zte.intra:1158/em/console/aboutApplication Oracle Enterprise Manager 11g is not running.

C:\users\10188535.zte>lsnrctl start

Lsnrctl for 32-bit windows:version 11.2.0.1.0-production on 1 April-September-2015 09:42:55

Copyright (c) 1991, Oracle. All rights reserved.

TNS-01106: Listener with Name listener has been started

C:\users\10188535.zte>sqlplus/nolog

Sql*plus:release 11.2.0.1.0 Production on Monday September 14 09:43:14 2015

Copyright (c) 1982, Oracle. All rights reserved.

sql> conn/as sysdba

is connected.

Sql> Startup ORA-01081: Unable to start ORACLE that is already running-please close it first

Sql> exit from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production with the partitioning, OLAP, Data Mi Ning and Real application testing options Disconnect

1.4 Setting Environment variables

Add the environment variable manually on the computer "Advanced system Settings" and then display:

C:\users\10188535>echo%oracle_home%

D:\app\10188535\product\11.2.0\dbhome

C:\users\10188535>echo%oracle_sid%

Dw

C:\users\10188535>echo%oracle_hostname%

A23181215

1.5 Setting environment variables

C:\users\10188535>net Stop Oracledbconsoledw

ORACLEDBCONSOLEDW service is stopping .....

The ORACLEDBCONSOLEDW service has stopped successfully.

C:\users\10188535>net Start Oracledbconsoledw

The ORACLEDBCONSOLEDW service is starting ....... ..... ...................

The ORACLEDBCONSOLEDW service has started successfully.

C:\users\10188535.zte>emctl Status Dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, Oracle Corporation. All rights reserved. Https://A23181215.zte.intra:5500/em/console/aboutApplication Oracle Enterprise Manager 11g is running. ------------------------------------------------------------------Logs is generated in directory D:\app\10188535\ Product\11.2.0\dbhome/a23181215.zte.intra_dw/sysman/log

C:\users\10188535.zte>certutil-setreg Chain\enableweaksignatureflags 8

Software\microsoft\cryptography\oid\encodingtype 0\certdllcreatecertificatechainengine\config\ Enableweaksignatureflags:

New value: Enableweaksignatureflags REG_DWORD = 8 CertUtil:-setreg command completed successfully. The CERTSVC service may need to be restarted for the changes to take effect.

How to troubleshoot the Oracle 11g EM website "There is a problem with this site's security certificate"