Joords Oracle DBA blog

What are Oracle JDBC drivers ? [Using Service Name instead of SID] JDBC is an API that allows Java programs to access any tabular data source. In order to interact with an Oracle Database from a Java program using JDBC interface, Oracle provides its own Oracle JDBC drivers. Oracle provides drivers that enable users to make JDBC connections to Oracle databases. The two most common methods of connecting to Oracle databases via JDBC are the Oracle Thin JDBC driver and the Oracle OCI JDBC driver. The Oracle Thin driver requires no software other than the driver jar file. This driver connects to Oracle databases via TCP/IP. The Oracle OCI (Oracle Call Interface) driver requires Oracle client software to be installed on the user's machine in order to connect to the database. This driver uses native methods and is platform specific. The Java classes to connect to Oracle are contained in the Oracle JDBC driver jar file. For recent releases, these are numbered based on the Java v...

In Oracle 11g Oracle Application Express (APEX) is now a standard component in the Oracle 11g RDBMS. The APEX component is intergration with the Oracle Database and ensures that the application builts with Oracle APEX benefit from the reliability, security, scalability and availability offered by the Oracle database. Oracle Real Application Cluster (RAC) is recommended for applications that require High Availability (HA), scalability, and workload management. How can we intergrate the High Availability (HA), scalability, and workload management functionality to the APEX module in a RAC environment In this blog I descibe, how to use and configure APEX module in a RAC database environment. In a normal High Availability for database enviroment is the Oracle HTTP server an unprotected feature by the Oracle Clusterware.