Enterprise Manager DB Express for Oracle 18c database ( Release 18.0.0.0.0 )..!!

ByJoel Pérez ( Oracle ACE Director )

Enterprise Manager DB Express for Oracle 18c database ( Release 18.0.0.0.0 )..!!

Subscribe to our Blog and enjoy our Weekly Cloud article..!

Enterprise Manager DB Express for 18c database ( Release 18.0.0.0.0 )..!!

Hi Readers

SSH into your DB System node, and open a tunnel for the port we will use on the Enterprise Manager DB Express 18c.

ssh -i <SSH_PRIVATE_KEY> -C -L 5505:localhost:5505 opc@<PUBLIC_IP>

Login as Oracle user.

$sudo su – oracle

 

Set the environment variables for your Database system.

$ . oraenv

ORACLE_SID = [oracle] ? <DATABASE_NAME>

The Oracle base has been set to /u01/app/oracle

 

Connect to your Container database as SYSDBA.

$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 Production on Fri Mar 23 16:59:49 2018

Version 18.1.0.0.0

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

Connected to:

Oracle Database 18c EE High Perf Release 18.0.0.0.0 – Production

Version 18.1.0.0.0

 

Run the following commands and procedures.

SQL> alter user xdb account unlock;

SQL> exec dbms_xdb_config.SetHttpPort(5505);

PL/SQL procedure successfully completed.

SQL> exec dbms_xdb_config.SetGlobalPortEnabled(TRUE);

PL/SQL procedure successfully completed.

 

Use your browser on your local computer to open the console at http://localhost:5505/em.

Enjoy!

 

We hope the content could be useful for your Oracle DBA Tasks!

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com

Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/

Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/

Subscribe to our Blog and enjoy our Weekly Cloud article..!

Post Author Bios:

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/

 

About the author

Joel Pérez ( Oracle ACE Director ) administrator