Oracle 12c：为数据库实例启用EM Express
Adamhuan发表于 2017-03-08 07:48:30
有时候，通过DBCA创建的数据库实例，有可能没有开启EM Express。
EM Express，是可以后面手动开启的。
下面的篇章，将呈现做到这件事的细节。
在开启之前，先查看下数据库的当前状态：
监听器：
[oracle@ora12c-1 ~]$ lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 08-MAR-2017 15:29:09 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora12c-1)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 08-MAR-2017 11:36:35 Uptime 0 days 3 hr. 52 min. 34 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/app/oracle/12c/release_2/db_1/network/admin/listener.ora Listener Log File /home/app/oracle/diag/tnslsnr/ora12c-1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora12c-1)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "4a331267bc4346c6e055025056845ad4" has 1 instance(s). Instance "lenka", status READY, has 1 handler(s) for this service... Service "lenka" has 1 instance(s). Instance "lenka", status READY, has 1 handler(s) for this service... Service "lenkaXDB" has 1 instance(s). Instance "lenka", status READY, has 1 handler(s) for this service... Service "pdb_lenka_1" has 1 instance(s). Instance "lenka", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@ora12c-1 ~]$
查询数据库的EM端口情况：
[oracle@ora12c-1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 8 14:30:57 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL>
SQL>
SQL> select dbms_xdb_config.gethttpsport() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
0
SQL> select dbms_xdb_config.gethttpport() from dual;
DBMS_XDB_CONFIG.GETHTTPPORT()
-----------------------------
0
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@ora12c-1 ~]$
开始设置：
[oracle@ora12c-1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 8 15:38:33 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> exec dbms_xdb_config.sethttpsport(5502);
PL/SQL procedure successfully completed.
SQL>
SQL> select dbms_xdb_config.gethttpsport() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5502
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@ora12c-1 ~]$
再次查看系统的状态：
监听器：
[oracle@ora12c-1 ~]$ lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 08-MAR-2017 15:39:46 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora12c-1)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 08-MAR-2017 11:36:35 Uptime 0 days 4 hr. 3 min. 11 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/app/oracle/12c/release_2/db_1/network/admin/listener.ora Listener Log File /home/app/oracle/diag/tnslsnr/ora12c-1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora12c-1)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ora12c-1)(PORT=5502))(Security=(my_wallet_directory=/home/app/oracle/admin/lenka/xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "4a331267bc4346c6e055025056845ad4" has 1 instance(s). Instance "lenka", status READY, has 1 handler(s) for this service... Service "lenka" has 1 instance(s). Instance "lenka", status READY, has 1 handler(s) for this service... Service "lenkaXDB" has 1 instance(s). Instance "lenka", status READY, has 1 handler(s) for this service... Service "pdb_lenka_1" has 1 instance(s). Instance "lenka", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@ora12c-1 ~]$ [oracle@ora12c-1 ~]$
查看系统端口情况：
[root@ora12c-1 ~]# netstat -tupln | grep 5502 tcp6 0 0 :::5502 :::* LISTEN 17919/tnslsnr [root@ora12c-1 ~]#
这时候就可以通过URL访问了：
https://:5502/em
在我的环境中：
https://10.158.1.45:5502/em/login
————————————
Done。