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 […]

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.

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

Connectivity errors are common questions on Oracle related forums and in many cases they are highly misunderstood by the poster of the questions and some responders. Many times the source of confusion lies in the […]

ORA-12543: TNS:destination host unreachable

Connectivity errors are common questions on Oracle related forums and in many cases they are highly misunderstood by the poster of the questions and some responders. This aim of this document is to show a […]

ORA-12545: Connect failed because target host or object does not exist

Connectivity errors are common questions on Oracle related forums and in many cases they are highly misunderstood by the poster of the questions and some responders. This aim of this document is to show a […]

NI cryptographic checksum mismatch error: 12599

In testing of Oracle Enterprise Manager 11g R1 Grid Control we noticed frequent ORA-12599 errors in the alert logs of the monitored databases including the repository database. Upon further investigation we found that the ORA-12599 […]

Message #### not found when attempting to start the listener, tnsping, or SQL*Plus

Problem When attempting to start the listener you receive the following error. Or you may receive the following when attempting to use tnsping. Or you might have attempted a connection using SQL*Plus and received the […]

ORA-12154: TNS:could not resolve the connect identifier specified

Questions on this error seem to be a regular occurrence on Oracle related forums so I decided to add a post about it here. This post will demonstrate the error, how to look up the […]

Setting up Oracle Net Services Tracing on the Client and Server

Tracing the Oracle Net Services provides detailed information to aid in diagnosing connectivity issues. This document will detail the parameters used in tracing Oracle Net Services along with providing an example of tracing a connection […]

Using the OERR Utility to Aid in Error Investigation

Many Oracle products on UNIX have a utility called OERR that can be used to aid error investigation. The OERR utility is not documented so many new to Oracle on UNIX may not be aware […]

Backup Does Not Run When Scheduled in CRON

You have created a script to perform the backup and have tested it to verify that it works as expected. However when the script is executed in CRON it either appears to not run or […]

Convert a Physical Standby Database into a Snaphot Standby Database Using Oracle Enterprise Manager 11gR1 Grid Control

Oracle Database 11g introduced the Snapshot Standby feature in Data Guard. Using this feature you can use your physical standby database to temporary process transactions. If you have a need to test out application fixes […]

Convert a Physical Standby Database into a Snapshot Standby Database Using the Data Guard Command Line Interface

This document will detail the steps to convert a physical standby database to a snapshot database using the Data Guard Command Line Interface. If you would like to know more about snapshot databases or how […]