What is route metric? The term metric as applied to networking, is used to assign priority to network routes. The higher the metric, the lower the priority of the route. To set route metric in RHEL without NetworkManager 1. The correct way to set the route metric under CentOS/RHEL 7 is to modify the appropriate ifcfg-[interface] file located in /etc/sysconfig/network-scripts/ directory where [interface] is the name of the interface the metric is related to. A directive similar to the … [Read more...] about How to set a persistent route metric on a network device in CentOS/RHEL 7
New Oracle Net features in version 12c
CONCEPT Oracle Net is the communication software that enables a network session between a client application and an Oracle database. After a network session is established, Oracle Net acts as a data courier for the client application and the database. New Features The following are the new features in Oracle Net Services: Larger Session Data Unit Sizes Oracle Net 12c supports large session data unit (SDU) sizes, with a new upper limit of 2 MB. The larger SDU size can be used to achieve … [Read more...] about New Oracle Net features in version 12c
How to Disable Oracle Net Tracing on a Server Process without Stopping the Process
When Oracle Net server tracing is invoked using sqlnet.ora (see example below) tracing on the affected server processes will continue throughout the process lifetime. If tracing needs to be stopped without stopping the server process the following method can be used. Example: static server tracing using sqlnet.ora: trace_level_server = 16 trace_directory_server = /tmp diag_adr_enabled = off Dynamic Oracle Net Server Tracing Use dynamic server tracing to disable tracing without … [Read more...] about How to Disable Oracle Net Tracing on a Server Process without Stopping the Process
Dynamic Oracle Net Server Tracing
Dynamic tracing V/s Static Tracing Oracle Net tracing is controlled by sqlnet.ora parameters which are static for the lifetime of RDBMS server processes. Since there is a single sqlnet.ora file for an instance, trace settings apply to all server processes. This can pose difficulties in live production environments. Dynamic server tracing allows for tracing at a per-process level and can be enabled ad hoc on any running server process. This is useful for tracing individual server-side processes … [Read more...] about Dynamic Oracle Net Server Tracing
Oracle Database : What Is The Search Order For The LDAP.ORA File
Different versions of Oracle, have different search order for the LDAP.ORA file. Version 8i: TNS_ADMIN can not used. Search path order is $ORACLE_HOME/network/admin Version 9i: TNS_ADMIN can be used. Search path order is TNS_ADMIN if set, Then ORACLE_HOME/network/admin Version 10.1: TNS_ADMIN can not used. Search path order is LDAP_ADMIN if set, ORACLE_HOME/ldap/admin and then ORACLE_HOME/network/admin Version 10.2: TNS_ADMIN can be used. Search path order is LDAP_ADMIN if set, … [Read more...] about Oracle Database : What Is The Search Order For The LDAP.ORA File
What is the Search Order for TNS files – listener.ora, sqlnet.ora, tnsnames.ora
This post explains how Oracle Net searches for the configuration files listener.ora, sqlnet.ora, tnsnames.ora and cman.ora. Oracle Net Services configuration files are not always located in the $ORACLE_HOME/network/admin directory. Depending on the file, Oracle Net uses a different search order to locate the file. Search order for the sqlnet.ora 1. The directory specified by the TNS_ADMIN environment variable, if set. 2. The $ORACLE_HOME/network/admin directory. 3. In RAC, the sqlnet.ora … [Read more...] about What is the Search Order for TNS files – listener.ora, sqlnet.ora, tnsnames.ora
How to Trace Dynamic Registration from PMON or LREG (Oracle 12c)
The post describes how to capture tracing for the PMON or LREG process. It is intended to help troubleshoot issues where dynamic service registration is failing or where the LSNRCTL services summary is not displaying services properly. 11g tracing option From 11.1.0.7 onwards, tracing can be enabled using the following command: alter system set events='immediate trace name listener_registration level 3'; When finished collecting pmon traces,turn this off using: alter system set … [Read more...] about How to Trace Dynamic Registration from PMON or LREG (Oracle 12c)
Oracle SQL : Script To Convert Hexadecimal Input Into a Decimal Value
Description This script creates a function to convert Hexadecimal value to decimal. Example SQL> select hextodec('BABA11') from dual; HEXTODEC('BABA11') ------------------ 12237329 Starting from Oracle 8i, there is a new format model('X') for the to_number function which can be used to accomplish the same task. For the above example, you could issue the following: SQL> select to_number('BABA11','XXXXXX') from dual; … [Read more...] about Oracle SQL : Script To Convert Hexadecimal Input Into a Decimal Value
How to Setup a Simple NGINX Web Server in Microsoft Azure
Use these instructions to configure a CentOS/RHEL virtual machine (VM) as a web server in Microsoft Azure. This simple web server can process HTTP requests. The setup So we are using the below environment for the purpose of this post. Microsoft Azure CentOS/RHEL 6 or 7 VM (Cloud Access or Azure On-Demand) NGINX Installing an NGINX Web Server Before You Begin Installing an NGINX web server requires access to certain RHEL repositories. Make sure you have access to EPEL repositories … [Read more...] about How to Setup a Simple NGINX Web Server in Microsoft Azure
How to Setup a Simple Apache httpd Web Server in Microsoft Azure
Use these instructions to configure a CentOS/RHEL virtual machine (VM) as a web server in Microsoft Azure. This simple web server can process HTTP requests. The setup So we are using the below environment for the purpose of this post. Microsoft Azure CentOS/RHEL 6 or 7 VM (Cloud Access or Azure On-Demand) Apache httpd Installing an Apache httpd Web Server Before You Begin Installing an Apache httpd web server requires access to certain RHEL repositories. Make sure you have access … [Read more...] about How to Setup a Simple Apache httpd Web Server in Microsoft Azure