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

This article mainly explains "how to enable ORACLE 12C EM Express". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to enable ORACLE 12C EM Express.

Compared with 11G and 10G Enterprise Manager, Enterprise Manager Database Express 12c of ORACLE 12C is much simpler in function, for example, it does not support online viewing of AWR, online operation, backup, operation of SCHEDULER, etc., which reduces the function and greatly reduces the difficulty of its use. Do not need to start dbconsole before, need to configure the database and other tedious operations, but also often have some inexplicable problems have to rebuild EM. It is predicted that the number of users of EM Express may increase in a few years' time (upgrading the database to 12C is a factor, and some people will not buy GC after all). In the Express version of 12C, by default you only need to do the following under the corresponding pdb user to enable EM Express

? Set the http port

Exec DBMS_XDB_CONFIG.SETHTTPPORT (http_port_number)

? Set the https port

Exec DBMS_XDB_CONFIG.SETHTTPSPORT (https_port_number)

Note: Each container must use a unique port for EM Express.

And the operation is to use the xdb component to open the corresponding port to access EM Express through the browser http/https. The listening port can be viewed through lsnrctl status to start an EM Express operation of pdb.

The listening status of the unopened pdb library is as follows

C:\ Users\ XIFENFEI > lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.1.0.1.0-Production on December-July-2013 21:2

2:32

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

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=XIFENFEI-PC) (PORT=1521)

STATUS of LISTENER

-

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 12.1.0.1.0-Produ

Ction

Launch date December-July-2013 21:22:08

Uptime 0 days, 0 hours, 0 minutes, 27 seconds.

Trace level off

Security ON: Local OS Authentication

SNMP OFF

Listener parameter file E:\ oracle\ product\ 112141.0\ dbhome_1\ NETWORK\ ADMIN\ liste

Ner.ora

Listener log file E:\ app\ XIFENFEI\ diag\ tnslsnr\ XIFENFEI-PC\ listener\ aler

T\ log.xml

Listening Endpoint Summary …

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=xifenfei-pc) (PORT=1521))

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (PIPENAME=\\.\ pipe\ EXTPROC1521ipc))

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcps) (HOST=xifenfei-pc) (PORT=5500)) (Security=

My_wallet_directory=E:\ APP\ XIFENFEI\ admin\ cdb\ xdb_wallet) (Presentation=HTTP) (Se

Ssion=RAW))

Service summary..

The service "CLRExtProc" contains 1 instance.

Instance "CLRExtProc", status UNKNOWN, contains 3 handlers for this service.

The service "cdb" contains 1 instance.

Instance "cdb", status READY, contains 1 handler for this service.

The service "cdbXDB" contains 1 instance.

Instance "cdb", status READY, contains 1 handler for this service.

The service "pdb" contains 1 instance.

Instance "cdb", status READY, contains 1 handler for this service.

Command executed successfully

Here we can see that a default port 5500 EM Express is opened, which belongs to root container.

Open the EM Expess of pdb

C:\ Users\ XIFENFEI > sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Friday July 12 21:50:28 2013

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

Connect to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0-64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt

Ions

SQL > show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

-

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

SQL > alter session set container=pdb

The session has changed.

SQL > exec DBMS_XDB_CONFIG.SETHTTPPORT (5505)

The PL/SQL process completed successfully.

C:\ Users\ XIFENFEI > lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.1.0.1.0-Production on December-July-2013 21:5

1:40

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

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=XIFENFEI-PC) (PORT=1521)

STATUS of LISTENER

-

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 12.1.0.1.0-Produ

Ction

Launch date December-July-2013 21:22:08

Uptime 0 days, 0 hours, 29 minutes, 35 seconds.

Trace level off

Security ON: Local OS Authentication

SNMP OFF

Listener parameter file E:\ oracle\ product\ 112141.0\ dbhome_1\ NETWORK\ ADMIN\ liste

Ner.ora

Listener log file E:\ app\ XIFENFEI\ diag\ tnslsnr\ XIFENFEI-PC\ listener\ aler

T\ log.xml

Listening Endpoint Summary.

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=xifenfei-pc) (PORT=1521))

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (PIPENAME=\\.\ pipe\ EXTPROC1521ipc))

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcps) (HOST=xifenfei-pc) (PORT=5500)) (Security=

My_wallet_directory=E:\ APP\ XIFENFEI\ admin\ cdb\ xdb_wallet) (Presentation=HTTP) (Se

Ssion=RAW))

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=xifenfei-pc) (PORT=5505)) (Presentatio

N=HTTP) (Session=RAW))

Service summary..

The service "CLRExtProc" contains 1 instance.

Instance "CLRExtProc", status UNKNOWN, contains 3 handlers for this service.

The service "cdb" contains 1 instance.

Instance "cdb", status READY, contains 1 handler for this service.

The service "cdbXDB" contains 1 instance.

Instance "cdb", status READY, contains 1 handler for this service.

The service "pdb" contains 1 instance.

Instance "cdb", status READY, contains 1 handler for this service.

Command executed successfully

You can see that there is an extra listening port 5505 in the listening, which is used by the EM Epress of pdb.

Approximate screenshot of EM Express function

Root container

Pdb container

You need to note that things at cdb level can be viewed directly in root container. For things related to pdb container level, you need to log in to the EM Express of specific pdb. For example, viewing tablespace data files can only be viewed at pdb level, and information such as redo/controlfile can be viewed at cdb level.

Close EM Express

SQL > alter session set container=pdb

The session has changed.

SQL > exec DBMS_XDB_CONFIG.SETHTTPPORT (0)

The PL/SQL process completed successfully.

SQL > exit

From Oracle Database 12c Enterprise Edition Release 12.1.0.1.0-64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt

Ions disconnect

C:\ Users\ XIFENFEI > lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.1.0.1.0-Production on December-July-2013 23:3

8:30

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

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=XIFENFEI-PC) (PORT=1521)

STATUS of LISTENER

-

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 12.1.0.1.0-Produ

Ction

Launch date December-July-2013 21:22:08

Uptime 0 days, 2 hours, 16 minutes, 25 seconds.

Trace level off

Security ON: Local OS Authentication

SNMP OFF

Listener parameter file E:\ oracle\ product\ 112141.0\ dbhome_1\ NETWORK\ ADMIN\ liste

Ner.ora

Listener log file E:\ app\ XIFENFEI\ diag\ tnslsnr\ XIFENFEI-PC\ listener\ aler

T\ log.xml

Listening Endpoint Summary.

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=xifenfei-pc) (PORT=1521))

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (PIPENAME=\\.\ pipe\ EXTPROC1521ipc))

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcps) (HOST=xifenfei-pc) (PORT=5500)) (Security=

My_wallet_directory=E:\ APP\ XIFENFEI\ admin\ cdb\ xdb_wallet) (Presentation=HTTP) (Se

Ssion=RAW))

Service summary..

The service "CLRExtProc" contains 1 instance.

Instance "CLRExtProc", status UNKNOWN, contains 3 handlers for this service.

The service "cdb" contains 1 instance.

Instance "cdb", status READY, contains 1 handler for this service.

The service "cdbXDB" contains 1 instance.

Instance "cdb", status READY, contains 1 handler for this service.

The service "pdb" contains 1 instance.

Instance "cdb", status READY, contains 1 handler for this service.

Command executed successfully

There is no port 5505 for pdb monitoring, which proves that the EM Express of pdb is closed successfully.

At this point, I believe you have a deeper understanding of "how to enable ORACLE 12C EM Express". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.