How to get the Tablespace details in Oracle

oracle

This article helps you to get more information about Tablespace in Oracle along with a few commands which helps in your day to day activity. How to get the list of available Tablespaces SQL> select tablespace_name, sum(bytes)/power(1024,2), sum(maxbytes)/power(1024,2), AUTOEXTENSIBLE from dba_data_files group by tablespace_name, AUTOEXTENSIBLE; This list down all the tablespaces that are available in […]

SVN Commands in Linux

svn

This article helps you to understand various SVN commands and its usage in Linux environment. How To get the location of SVN: $ whereis svnsvn: /opt/CollabNet_Subversion/bin/svn (or) $ which svnsvn: /opt/CollabNet_Subversion/bin/svn How to get the SVN help $ svn helpusage: svn <subcommand> [options] [args]Subversion command-line client, version 1.8.14.Type ‘svn help <subcommand>’ for help on a […]

How to Disable and Enable triggers in oracle

oracle

In this post, we are discussing on how to enable, disable and drop triggers in oracle.   Enable ONE Trigger in a table Syntax ALTER TRIGGER <trigger-name> ENABLE; Example ALTER TRIGGER NarayanaTutorial_Trigger ENABLE;   Enable ALL Triggers in a table Syntax ALTER TABLE <table-name> ENABLE ALL TRIGGERS; Example ALTER TABLE NarayanaTutorial_TABLE ENABLE ALL TRIGGERS;     Disable […]

ORA-28040: No matching authentication protocol Oracle 12c

ORA-28040: No matching authentication protocol after upgrade to 12c. From oracle 12.X, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. It defines the minimum version of authentication protocol permitted to access the database. Prior to version 12c the default setting for SQLNET.ALLOWED_LOGON_VERSION (the equivalent parameter prior to 12c) was 8. In 12c the default […]

How to disable dangerous http methods in apache tomcat server

How to disable dangerous http methods in apache tomcat server Some of the http methods are dangerous and using these http methods may easily hack the application like executing the remote script execution, sql injection, click jacking etc… So dangerous http methods need to be restricted. We need to disable dangerous http method in both […]