Oracle database 11gR2 (126.96.36.199.2)
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
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 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 »
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 »
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 »