Monthly Archives: December 2019

Remove OEM agent and relevant monitoring targets

Once I decommissioned Oracle databases from specific server. It is time to clean up EM 13c agent and all monitoring targets on top of it. At first, shutdown agent.$ emctl stop agent Now, it is time to remove them.$ emcli … Continue reading

Posted in oem, Oracle Database, Uncategorized | Tagged , , , | Leave a comment

Export Oracle database with Data Pump API DBMS_DATAPUMP

This is the alternative way to unload/load data against Oracle database. It could help in scenario DBA prefer to use SQL script or has to utilize PL/SQL tool. Example of export specified database schemas in parallel. SQL> create or replace … Continue reading

Posted in Oracle Database | Tagged , , | Leave a comment