Using SMB/CIFS-Share on Oracle Database Appliance with FIPS enabled

Starting with Oracle Database Appliance release 19.11,the Linux kernel used by Oracle Database Appliance running on bare metal and KVM Database Systems is compliant with the United States Federal Information Processing Standard 140-2 (FIPS 140-2) level one.In accordance with the FIPS standard, the algorithms used by the secure shell (SSH) are limited to those permitted … Using SMB/CIFS-Share on Oracle Database Appliance with FIPS enabled weiterlesen

EM13c – Block the usage of Metric Extensions for specific target type only

Metric Extensions allows extending monitoring for a target type by adding new metrics. These Metric Extensions (ME) can also be any OS commands to enhance OS monitoring.Depending on security requirements this feature can be a risk. Especially if the Enterprise Manager is managed by other department or i.e. outside your organization. Note: Oracle does not … EM13c – Block the usage of Metric Extensions for specific target type only weiterlesen

Monitoring ASR-Gateway with Oracle Enterprise Manager CloudControl 13c

Introduction Oracle have a nice small tool called ASR-Gateway (Oracle Auto Service Request) which (as the name already says) opens automatically a Service Request at Oracle (support.oracle.com) if a hardware component fails on a Engineered System like ExaData or PCA (and the others too 🙂 ). In a customer project, this ASR-Gateway failed sometimes or … Monitoring ASR-Gateway with Oracle Enterprise Manager CloudControl 13c weiterlesen

EM13c – Install (13.3) EM-Agent manually

Introduction To deploy the EM-Agent to the targets (push) you need ssh-access from the OMS-Host to the Monitoring-Host. For security reasons, some security admins disallow ssh-connections to the server. In this case you need to install the EM-Agent manually on the target-system. The installation process for the EM-Agent is done within a few steps. Downloading … EM13c – Install (13.3) EM-Agent manually weiterlesen

Gather historic information about table size and row count

Often the support need to know which tables are growing fast and which are stable. Out of the Box, Oracle don't provide such a statistic on object level. Classic monitoring tools collect this information only on the database-, tablespace- and datafile-level, but not on object level. A small script helps you to answer this question … Gather historic information about table size and row count weiterlesen

EM13c – Setup LDAP-Authentication

Allgemein Durch das Setup der LDAP-Authentifizierung ist es möglich, AD-User im Active Directory zu integrieren. Dies hat den Vorteil, dass sich der Enterprise Manager resp. der DBA nicht um die Passwörter kümmern muss. Die klassischen Repository-Accounts können natürlich weiterhin verwendet und auch neue hinzugefügt werden. Weiterführende Informationen sind unter folgendem Link zu finden: https://docs.oracle.com/cd/E73210_01/EMSEC/GUID-5DD3B11A-1159-40BD-8AEB-41EDE664AB12.htm#EMSEC13008 Konfiguration … EM13c – Setup LDAP-Authentication weiterlesen