EM 13c - email not working

Setting up EM13c and was wondering why I was not receiving any email notifications of an incident I had set up.

I was clicking on the edit button and going through the setup thinking where is the email option - well it turns out I was staring at it all along and hit a "wood for trees" moment. I think I had seen the email option but thought it was only for setting up the users and not actually for changing whether 13c set out the email. Will put together a more detailed setup guide to 13c once I have all the alerts setup that I need. Watch this space.

Compare columns in a table..

select settings_eil.param_name,  settings_eil.PARAM_VALUE, settings_qa.param_name,  settings_qa.PARAM_VALUE from settings_eil,settings_qa where settings_eil.param_name(+)=settings_qa.param_name order by settings_eil.param_name

expdp as sysdba

Needed to export a table but was not given any login details only the oracle user so at least had sysdba privs (did not want to create another dba directory so just used the DATA_PUMP_DIR) - after a couple of goes found this to work. If anyone knows a better way please let me know. I could have used a procedure from another post but this seemed easiest solution.


[oracle]$ expdp \"/ as sysdba\"  directory=DATA_PUMP_DIR tables=FRM_MAIN.SETTINGS
Export: Release 12.2.0.1.0 - Production on Thu Jul 5 03:42:44 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_TABLE_01":  "/******** AS SYSDBA" directory=DATA_PUMP_DIR tables=FRM_MAIN.SETTINGS
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "FRM_MAIN"."SETTINGS"                       14.25 KB      56 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
  /u01/app/oracle/product/12.2.0/dbhome/rdbms/log/expdat.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Thu Jul 5 03:43:09 2018 elapsed 0 00:00:24


Please note when going from 12.2 to 12.1 use the VERSION=12.1 option on 12.2 otherwise the import will fail and it is not obvious why !!!