Oracle 19C EM
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!
