Apex : wwv_flow.accept, PLS-00306, wrong number of types of arguments

By | March 13th, 2010|Categories: Database|Tags: , |

Database: 10.2.0.2, Apex 3.2.1. Application works fine, until there's a bit of load of users logging in. They get the following message (derived from error-logging of Apache): [Wed Mar 10 09:21:58 2010] [error]

[ecid: 1268209318:194.13.31.219:1543:0:26453,0] mod_plsql: /pls/apex_app/wwv_flow.accept HTTP-404 ORA-06550: line 22, column 3:PLS-00306: wrong number or types of arguments in call to 'ACCEPT' ORA-06550: line 22, column 3:PLS-00306: wrong number or types of arguments in call to 'ACCEPT' ORA-06550: line 22, column 3:PL/SQL: Statement ignored

ORA-03114 / 03113 while running dbms_java package

By | March 5th, 2010|Categories: Database|Tags: |

Got errors (ora-03114 / ora-03113) while running any dbms_java script on a 10.2.0.2 database. Took a while, but then I found out it only happens when I'm connected through sql*net. Directly on the server gave no problem at all. And... it only occurs on my Test-environment, not in development, and not in production.

Oracle RAC – Troubleshooting Connectivity Issues; by Alex Gorbachev

By | February 7th, 2010|Categories: Oratube, RAC|Tags: , |

Alex as a teacher. Fits him well. Part III of the trilogy about RAC. httpvh://www.youtube.com/watch?v=LH-88ARrroo

After ‘drop unused columns’ table in not usable state. Ora-600 [17016]

By | January 15th, 2010|Categories: Database|Tags: , |

After "alter table DWHINCIDENT.TEST_TABLE drop unused columns checkpoint 100000" And after a while: ERROR at line 1: ORA-00600: internal error code, arguments: [17016], [0x12CB1C820], [], [], [], Table in usable state. New bug !

Oracle RAC – VIP Configuration Mistakes; by Alex Gorbachev

By | December 20th, 2009|Categories: Oratube, RAC|Tags: , |

A video tutorial on VIPs with Oracle RAC httpvh://www.youtube.com/watch?v=VRwLsZ-AE-w

Oracle RAC – Why VIPs; by Alex Gorbachev

By | December 20th, 2009|Categories: Oratube, RAC|Tags: , |

A tutorial of using VIPs with RAC, from Alex Gorbachev httpvh://www.youtube.com/watch?v=c_41It0AZ80

Automatic start / stop in 11g release 2

By | December 14th, 2009|Categories: Database|Tags: |

Installed 11g release 2 , and wanted it to start and stop when booting and stopping the system. Taking into consideration that most of the standard stop-scripts are causing the database to 'crash' without knowing it.

Speeding up gathering statistics a bit in 11g.

By | November 23rd, 2009|Categories: Database|Tags: |

Something about running statistics. Got quite a large database of a few TB, and was curious how fast the statistics are running, and if I could speed it up a little.

Using http://localhost:8080 at APEX(11gr1), horrible performance

By | November 21st, 2009|Categories: Database|Tags: |

I had to install a 11g release 1 on Windows for demonstration purpose of APEX. APEX comes standard with 11g, so that's nice. When using Embedded PLSQL you don't even need Apache... But when I'm using http://localhost:8080/apex/apex_admin, the login-page popped up after a minute or two.And every page I use has the same horrible performance. Using the loopback by the way like http://127.0.0.1:8080/apex/apex_admin on the server gives the same result.

Determining compression-factor 11g release 1

By | November 13th, 2009|Categories: Database|Tags: |

Working on 11g, release 1 (11.1.0.7), managers wanted to know what kind of compression factor we achieved in the datawarehouse. Amount of (compressed) data: just about 1,5 TB. In all my naivity I thought Oracle delivered the package 'DBMS_COMPRESSION' which will show me the rate of achieved compression per table. But first of all, in 11gr1 there was no package like 'DBMS_COMPRESSION', this is only delivered with release 2.