Eric Jenkinson

Backup Duplexing with RMAN

RMAN has the ability to write duplexed backup sets creating up to four identical copies of each backup piece in a backup set to different destinations. Duplexing provides an extra layer of protection against disaster, […]

Creating Image File Copy Backups with RMAN

When using RMAN to back up to disk you have two options in how to write the backups. The default is a backup set which uses unused block compression and is in an RMAN-specific format. […]

User Managed Consistent Database Backup (Cold Backup)

While Recovery Manager (RMAN) is highly recommended for database backup and recovery operations your organization may require you to perform backups using a custom process or you might have an interest in knowing what is […]

Using Easy Connect (EZCONNECT) Naming Method to Connect to Oracle Databases

Easy Connection (EZCONNECT) is a method of connecting to an Oracle database that eliminates the need for service name look up. All of the information needed to resolve the connection is included in the connection […]

Creating an Oracle Listener with Oracle Network Configuration Assistant

In order to allow remote connections to an Oracle database the database must be registered with an Oracle Listener. An Oracle Listener is created during the Oracle Database software installation process if a database was […]

ORA-20200: Database/Instance does not exist in STATS$DATABASE_INSTANCE

When attempting to run a Statspack instance report using spreport.sql the following error is generated.

Installing and Configuring Statspack

With the addition of the Active Workload Repository (AWR) and Active Session History (ASH) in Oracle Database 10g and higher it might seem a little odd to still be talking about Statspack. Both AWR and […]

Introduction to Fetching Data from an Oracle Database using Java and JDBC part 2

In this three part series of posts we will look at fetching data from an Oracle Database using Java and JDBC. In this second post we look at the PreparedStatement interface and how to process […]

Introduction to Fetching Data from an Oracle Database using Java and JDBC part 1

In this three part series of posts we will look at fetching data from an Oracle Database using Java and JDBC. In this first post we look at the basics of the Statement interface and […]

Connect to an Oracle TimesTen In-Memory Database using Java and JDBC

This document will detail establishing a connection to an Oracle TimesTen In-Memory Database using Java and JDBC.

Create an ODBC Client DSN for an Oracle TimesTen Database on Linux

This document will detail the steps to create an ODBC Client DSN to a remote Oracle TimesTen Database on Linux.

Configuring an Oracle TimesTen Logical Server Name on UNIX Based Systems

A logical server name is used on the TimesTen client to connect to remote OracleTimes Server processes that do not listen on the default port or for local client/server using shared memory inter-process communications or […]

Configuring an Oracle TimesTen Logical Server Name on Windows

08S01: Communication link failure. System call recv() failed with OS error 104 ECONNRESET

When attempting to establish a connection to a remote Oracle TimesTen database using ttIsqlCS on Linux you receive the following error.

java.sql.SQLException: Problems with loading native library/missing methods: no ttJdbc1121 in java.library.path

When trying to execute a Java program that connects to remote Oracle TimesTen database you receive the following stack trace.

Adding Java Libraries to Oracle JDeveloper 11g R1

Oracle JDeveloper includes a rich set of Java libraries for developing Java applications. However you will find that you will need to add libraries that are not included or you may want to try updated […]

Adding the Oracle JDBC Drivers to a JDeveloper 11gR1 Project

Nearly all of the Java examples presented on Oracle Distilled are developed and tested in Oracle JDeveloper with the exception of those documents targeting Netbeans. This document will detail how to add the Oracle JDBC […]

Creating an ODBC Client DSN for an Oracle TimesTen Database in Windows

This document will detail the steps to create an ODBC DSN to a remote Oracle TimesTen Database in Windows. The client machine has Oracle TimesTen 11g (11.2.1.6.1) Client install and the remote server has Oracle […]

Installing the Oracle TimesTen In-Memory Database 11g (11.2.1.6.1) Client on Windows

Oracle TimesTen In-Memory Database is a memory resident relational database management system that allows applications to access capture or modify information faster than traditional database products. This document will detail the installation steps for Oracle […]

Install Oracle TimesTen In-Memory Database 11g (11.2.1.6.1) 32bit on Windows