Using an undocumented command, ALTER SYSTEM DUMP, you can create a formatted block dump of a data block. Below is the syntax of the ALTER SYSTEM DUMP command.
Author: Eric Jenkinson
Connect to an Oracle Database using Java and JDBC
This document will detail establishing a connection to an Oracle Database using Java and JDBC. Errors that could arise in making JDBC connections will be examined at the end of the document.
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 […]
Installing Berkeley DB 11gR2 11.2.5.0.26 on Oracle Enterprise Linux
Berkeley DB is a general purpose embedded database engine that provides data management features found in enterprise class databases. Berkeley DB is used in various applications ranging from cell phones to e-commerce systems. Included in […]
Installing Berkeley DB 11gR2 11.2.5.0.26 on Windows
Berkeley DB is a general purpose embedded database engine that provides data management features found in enterprise class databases. Berkeley DB is used in various applications ranging from cell phones to e-commerce systems ranging in […]
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 […]
Configuring the Loopback Adapter on Microsoft Windows
One of the most missed configuration issue when installing Oracle Database on Windows systems is failure to configure the Loopback adapter prior to installing the software on DHCP clients. Many Oracle products such as Database […]
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 […]
Convert a Physical Standby Database into a Snapshot Standby Database
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 […]
Changing the Data Guard Protection Mode Using Oracle Enterprise Manager 11gR1 Grid Control
Oracle Enterprise Manager 11gR1 Grid Control provides a web based interface for managing a Data Guard environment. Many Data Guard management functions can be accomplished with just a few clicks of the mouse and changing […]
Changing the Data Guard Protection Mode Using the Data Guard Command Line Interface
Using the Data Guard Command Line Interface to change the Data Guard Protection mode is a simple and efficient process. This document will detail the steps using DGMGL to change to all three Data Guard […]
Changing the Data Guard Protection Mode
Oracle Data Guard provides three modes to protect the data in the primary database. While each provide a high degree of data protection they each have a different effect on both the availability and performance […]