Shulou(Shulou.com)06/01 Report--

Oracle 19C EM

Oracle Enterprise Manager Database Express

One: Oracle 19C EM installation

Two: JET Oracle EM Express

Three: Flash Oracle EM Express

Four: unable to log in

One: Oracle 19C EM installation

You can choose to install the instance when you create it, or you can install it manually after you install the instance

Two: JET Oracle EM Express

Limited functionality, you can only see Performance

Log in to https://cjcos:5500/em/

Enable PDB EM Express

SQL > show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

-

2 PDB$SEED READ ONLY NO

3 CJCPDB READ WRITE NO

SQL > alter session set container=CJCPDB

Session altered.

SQL > select dbms_xdb_config.gethttpsport () from dual

DBMS_XDB_CONFIG.GETHTTPSPORT ()

-

0

SQL > show con_id con_name

CON_ID

-

three

CON_NAME

-

CJCPDB

SQL > EXEC DBMS_XDB_CONFIG.SETHTTPSPORT (5502)

PL/SQL procedure successfully completed.

SQL > SELECT dbms_xdb_config.gethttpsport FROM dual

GETHTTPSPORT

-

5502

Three: Flash Oracle EM Express

SQL > @? / rdbms/admin/execemx emx

3.1: configuration

Configuration-initialization parameters

Configuration-memory

Configuration-usage of database features

Configuration-current database properties

Configuration-Resource Management

3.1: Stora

Storage-restore management

Save-redo log group

Storage-Archive Lo

Storage-Control Fil

3.3: safe

Security-user

Security-role

3.4: performanc

Performance-performance Center-Summary

Performance-performance Center-activity

Performance-performance Center-workload

Performance-performance Center-monitored SQL

Performance-performance Center-monitored ADDM

Performance-performance Center-monitored containers

Performance-SQL guidance

Performance-SQL performance Analyzer

2 PDB enable Flash Oracle EM Express

Https://cjcos:5502/em/login

Storage-tablespace

Security-profile

Four: unable to log in

Problem: unable to log in by entering user name and password

Solution:

Container Name is not filled in

Reference:

Https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/getting-started-with-database-administration.html#GUID-BA75AD46-D22E-4914-A31E-C395CD6A2BBA

Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together!

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.