Friday, February 12, 2021

 This Blog give the answer of following question which i faced after installing Oracle 12c , Oracle 19c 

Question 1. How to open enterprise manger  like oracle 11g

Question 2. Why emctl not found in $ORACLE_HOME/bin directory

Question 3. How to setup web console / enterprise manager express in Oracle 12c 

Question 4. How to install enterprise manager separately in Oracle 12c


Step by Step i give the answer of these above questions. After installing oracle 12c i faced these issue.

I hope most of you have either already noticed or going to be notice that enterprise manager controller emctl command has been removed from Oracle 12c / Oracle 19c.  This is because from Oracle 12c (cloud) Enterprise Manager come in separate bundle. 

So After completing setup of  Oracle 12c / Oracle 19c , when i tried to run emctl command it show the following error

[oracle@lap ~]$ emctl
bash: emctl: command not found...
[oracle@lap ~]$ find /u01 -type f -name emctl
[oracle@lap ~]$ 
So after little bit research i found the reason that emctl is not shipped with Database package. But we can run express edition of enterprise manager. which have limited functionality basically you can view the report.

So enable enterprise manager express in Oracle 12c or Oracle 19c you need to follow following steps...

Step 1. First check http and https port using gethttpport or gethttpsport funtion of DBMS_XDB_CONFIG package

For http port 

SQL> select dbms_xdb_config.gethttpport from dual;

GETHTTPPORT
-----------
          0

For https port 

SQL> select dbms_xdb_config.gethttpsport from dual;

GETHTTPSPORT
------------
           0

if output of above query are 0 then we need to configure the port and if output are any number than 0 than we don't need to configure these port again.

Step 2. Configure http or https port or both if it not set already i.e. output of above sql query are 0.  For setting http port we use dbms_xdb_config.sethttpport and https port we use  dbms_xdb_config.sethttpsport 


SQL> exec dbms_xdb_config.setHTTPsPort (5500);


PL/SQL procedure successfully completed.


SQL> exec dbms_xdb_config.setHTTPPort(5511);


PL/SQL procedure successfully completed.

Run the first 2 queries again and check for the required output.
SQL> select dbms_xdb_config.gethttpport from dual;


GETHTTPPORT
-----------
       5511


SQL> select dbms_xdb_config.gethttpsport from dual;


GETHTTPSPORT
------------
 5500
This show my enterprise manager express has been configured at my system. To open web console we need to use 

http://localhost:5500/em 
 
or 

 https://localhost:5511/em 

Oracle 12c web console required flash support to open login page for that we need to install flash-plugin.

 Note : Since Adobe no longer supports Flash Player after 31 December 2020 and blocked Flash content from running in Flash Player beginning 12 January 2021, Adobe strongly recommends all users immediately uninstall Flash Player to help protect their systems. 

No comments:

Post a Comment