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"