a small island in the net
When using a database link that goes through Oracle Gateways to another vendor database (like SQL Server) you might get an error in SQL Developer that says “Bigger type length than Maximum”. Apparently this is a bug in thin JDBC driver. Workaround is to use thick/OCI driver. Select it in preferences and use TNS to … Read more
The frustration because of lack of command history in sqlplus (or RMAN) finally reached it’s limit. I just couldn’t stand it anymore so with help from google i found this post here which mentions rlwrap utility. rlwrap records history for all lines you enter into a specific program (in our case sqlplus). To use rlwrap, … Read more
If you are for some reason moving your database from 32-bit to 64-bit server, a simple copy-paste is not enough. PL/SQL packages are compiled with one word size on 32-bit server and need to be recompiled on 64-bit or the following error might appear: ORA-06553: PLS-801: INTERNAL ERROR [56319]. Metalink note 62290.1 describes in detail … Read more
This wait event is connected to heterogeneous services. Whenever we do something on a HS system from our Oracle session, we need to wait for remote system to do it’s work and produce a response. For Oracle it is an idle event as it’s not Oracle who does the work. However it should be remembered … Read more
Few days ago we noticed one of our jobs in the database was not executing regularly. Job was defined through dbms_scheduler, and should be running each day. However it did not. Looking on the Enterprise Manager we could see that the job was still running from it’s last run (few days ago). That would explain … Read more