Oracle - SQL - MySQL DBA - Life Long Learning Experience

Enterprise Manager OMS Start Failure Issue ============================== OEM12c Issue -   The Oracle base for ORACLE_HOME=/u01/app/oracle/product/middleware3/oms is /opt/oracle oracle@mdccloud2r:/u01/app/oracle/product/gc_inst1/em/EMGC_OMS1> emctl status oms Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved. Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/log4j/Logger         at oracle.sysman.emctl.wls.OMSController.<clinit>(OMSController.java:101) Caused by: java.lang.ClassNotFoundException: org.apache.log4j.Logger         at java.net.URLClassLoader$1.run(URLClassLoader.java:202)         at java.security.AccessController.doPrivileged(Native Method)         at java.net.URLClassLoader.findClass(URLClassLoader.java:190)         at java.lang.ClassLoader.loadClass(ClassLoader.java:306)         at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.

Transparent Data Encryption This encrypts the physical data + log files + backup (all at the server end).   Only protects the data at rest and stops access if the physical files / backups are copied off. Uses windows data protection key (os level) to decrypt service master key (instance level) to encrypt database master key (database level).   This creates certificate in the master database used to encrypt database.   This certificate + password is needed then to restore database anywhere else.   This will not encrypt the network traffic. Will not protect against sql injection or elevated privileges. Will not protect against the entire image of the OS / datafiles being stolen as technically the database is still accessible if elevated privileges are obtained against the same OS / Instance. What this will do is prevent the data files / logs or backups being copied off and restored to another server or data files being accessed outside of the instance. T

Hi Guys , It doesn't always click or remember exactly what needs to be done when struggling to connect from remote SQL Server Client . With Very little to do, we can get this going .  See below and try it yourself ;) On the Server start Management Studio and open a query window  , execute below code as follows : use master ; EXEC sp_configure 'remote admin connections', 1; GO RECONFIGURE GO

Following are the things to be taken into consideration after setting up ODA RAC database . I have tested this and using the DB2(shape) , no CDB , no EM Express , it doesn't take any longer than 10 min. So wonderful is life with ODA . P.S : Similar things applies to Exadata.