Oracle Listener refused connection ORA-12519 troubleshooting

Platform

Oracle database 11gR2 (11.2.0.2.2)

Problem

New database connection attempts to Oracle database 11gR2 fail with following Oracle error:

Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found   [SQLCode: 12519], [SQLState: 66000] None None

Read more »

Oracle 11gR2 client installation on Windows 7 troubleshooting

Problem

Installation of Oracle 11gR2 client on Windows 7 32-bit using Oracle Universal Installer (OUI) failing on prerequisite with below mentioned error. Read more »

Oracle database restrictions and workarounds at daily DBA work

Oracle introduces hundreds of new database features in every database release. At the same time some tiny small restrictions in the code exist for a long time that bother database developers and DBAs at their daily work. Below I explore some of the common Oracle restrictions I often encounter during database administration. I give the workarounds for most of them and compare some with Microsoft SQL Server implementations. Read more »

How to make exp utility work on Oracle 11gR2

The fact that Oracle Data Pump does not work from a client installation only still forces many developers and DBAs to work with old Export (exp) and Import (imp) utilities. In spite of Original Export being unsupported  for general use as of Oracle database 11g, in reality it’s still available and can be used. However, there are a few issues with exp utility on Oracle database 11gR2 that have to be fixed before using it. Read more »

Oracle 11gR2 vs 10gR2 installation on Linux RHEL 5/OEL 5

In the last weeks I was involved in a series of Oracle database 10gR2 and 11gR2 server installations on Linux RHEL 5/OEL 5 (x86_64).

Below I will give a quick comparison of the new installation features of Oracle 11gR2 Server to Oracle10gR2.
Read more »

« Previous Page

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email