ORA-01878: specified field not found in datetime or interval

https://stackoverflow.com/questions/22305466/oracle-date-compare-broken-because-of-dst

How to configure tomcat server with SSL configuration?

1. Create private key and CSR using OpenSSL

openssl genrsa -out www.mydomain.com.key 2048

openssl req -new -sha256 -key www.mydomain.com.key  -out www.mydomain.com.csr

2. Submit CSR file to your Certificate Authority to generate & share valid CA certificates.

Valid CA certificates would have following files

a.  www.mydomain.com.crt

b.  xxxxCARoot.crt

c.  xxxxTrustxxx.crt

d.  xxxxxxxCA2.crt

3. Bundle CA, CA2 and Trust certificate into single file bundle.crt

4. Generate pkcs12 file using below command and provide keystorePass as 'changeit'

>openssl pkcs12 -export -in www.mydomain.com.crt -inkey www.mydomain.com.key -out www.mydomain.com.p12 -name tomcat -CAfile bundle.crt -caname root -chain

5. Configure tomcat server.xml with below <Connector>

<Connector SSLEnabled="true" keystoreFile="conf/ssl/www.mydomain.com.p12" keystorePass="changeit" keystoreType="PKCS12" port="443" protocol="HTTP/1.1" scheme="https" secure="true" sslProtocol="TLSv1.2"/>

How to change tomcat 8 port to 80

To run Tomcat on a port below 1024 in Ubuntu/Unix, the service needs root privileges.
And that you do not want. Use a port redirection via iptables

iptables -t nat -A PREROUTING -i eth0 -p tcp --dport 80 -j REDIRECT --to-port 8080

MongoDB SSL connection command

$ mongo --host <hostname> --port <port> --username username --password --ssl --sslPEMKeyFile <filename> --sslPEMKeyPassword <value> --sslCAFile <filename>

Manage Tablespaces

Create:
CREATE TABLESPACE DATA05 DATAFILE 'D:\app_db12c\oracle\oradata\orcl\sample01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M;

Extend:
ALTER TABLESPACE DATA05 ADD
  DATAFILE 'D:\app_db12c\oracle\oradata\orcl\sample02.dbf' SIZE 1M
  AUTOEXTEND ON NEXT 1M;

Delete:
DROP TABLESPACE DATA05 INCLUDING CONTENTS AND DATAFILES;