Below are the steps for enabling the oracle Enterprise Manager Express 12c
[oracle@bach1 ~]$
[oracle@bach1 ~]$ . oraenv
ORACLE_SID = [cdb12c] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bach1 ~]$
[oracle@bach1 ~]$
[oracle@bach1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Mar 11 16:47:11 2018
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> select name, cdb, con_id from v$database;
NAME CDB CON_ID
--------- --- ----------
CDB12C YES 0
SQL>
SQL>
SQL> select instance_name, status, con_id from v$instance;
INSTANCE_NAME STATUS CON_ID
---------------- ------------ ----------
cdb12c OPEN 0
SQL>
SQL> show parameter dispatchers
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=cdb12c
XDB)
max_dispatchers integer
SQL>
SQL>
>> Execute the DBMS_XDB.setHTTPSPort procedure to set the HTTPS port 5500 and the DBMS_XDB.setHTTPPort procedure to set the HTTP port 5510 for EM Express
SQL>
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
PL/SQL procedure successfully completed.
SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(5510);
PL/SQL procedure successfully completed.
SQL>
SQL> select name, con_id from v$database;
NAME CON_ID
--------- ----------
CDB12C 0
SQL>
SQL>
SQL>
SQL> SELECT DBMS_XDB_CONFIG.gethttpsport FROM dual;
GETHTTPSPORT
------------
5500
SQL>
SQL>
SQL>
SQL> set pages 500
SQL> set lines 500
SQL>
SQL> select NAME, OPEN_MODE from v$pdbs;
NAME OPEN_MODE
-------------------------------------------------------------------------------------------------------------------------------- ----------
PDB$SEED READ ONLY
PDB1 READ WRITE
PDB2 READ WRITE
PDB3 READ WRITE
PDB4 READ WRITE
PDB5 READ WRITE
PDB6 READ WRITE
PDB7 READ WRITE
PDB8 READ WRITE
PDB9 READ WRITE
PDB10 READ WRITE
11 rows selected.
SQL>
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL>
>> Set global port enable
SQL>
SQL> exec dbms_xdb_config.setglobalportenabled(TRUE);
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
Login to EM
No comments:
Post a Comment