Friday, the 13th.

Could someone persuade Oracle to reinstate the good old Metalink, please?!
Yesterday, I got just "An error has occurred. Please try again later" the whole day. And I was not the only one.
Today it worked for about an hour for me (between 09:00 and 10:00 GMT+1), then it started with http-501 errors, and now this:


Update: My favourites are gone! Years of careful reading, searching and safekeeping: gone! According to the Well Known Problems I should NOT have logged on before Nov, 9th, because the updates were pending. If you did, you favourites are regarded as up-to-date, and will not be migrated. According to metaklunk2, I should have logged on. Shouldn't. Should. Sigh.

So it's like my own fault?!? Right. Don't think so. Unhappy customer here, Oracle.

Go, google, go!

Go - a new programming language. Let's hope it will not be the same disaster as Java became. Google should be large enough to withstand Microsoft. Are we waiting for Yet Another Programming Language? Only the future will tell. I see annoying things like 'garbage collection', which leads me to believe it will be just a "lazy" a language as Java.
And the supposedly simple printf is beyond comprehension. Print would be simple. Printf has too much letters.

Administration in Run-Time Only APEX

Simple, but you have to know...

connect system
alter session set current_schema = FLOWS_030100;

begin
 apex_instance_admin.set_parameter('PRINT_BIB_LICENSED','ADVANCED');
apex_instance_admin.set_parameter('PRINT_SVR_HOST','tobi01.home.local');
apex_instance_admin.set_parameter('PRINT_SVR_PORT','8123');
apex_instance_admin.set_parameter('PRINT_SVR_SCRIPT','/xmlpserver/convert');
apex_instance_admin.set_parameter('PRINT_SVR_PROTOCOL','http');
end;
/

The doc states you have to have a session as sysdba, but system works for this version, too.

ORA-24062 ( Subscriber table inconsistent with queue table)

Surprisingly little search results in either google, the oracle fora, or metalink for this error. Ran into this today, and could drop an recreate the queues:

SQL> BEGIN
 2    SYS.DBMS_AQADM.STOP_QUEUE(QUEUE_NAME =>'TAB_OWNER.TB_BTR_Q_OPDR');
 3    SYS.DBMS_AQADM.DROP_QUEUE(QUEUE_NAME =>'TAB_OWNER.TB_BTR_Q_OPDR');
 4  END;
 5  /
BEGIN
*
ERROR at line 1:
ORA-24062: Subscriber table TAB_OWNER.AQ$_TB_BTR_Q_TBL_S inconsistent with
queue table TAB_OWNER.TB_BTR_Q_TBL
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4932
ORA-06512: at "SYS.DBMS_AQADM", line 240
ORA-06512: at line 2

The solution is drastic: for each error, reporting the table, force a drop of that table:

SQL> exec SYS.DBMS_AQADM.DROP_QUEUE_TABLE (
 QUEUE_table => 'TAB_OWNER.TB_BTR_Q_TBL',
 force=>TRUE);

PL/SQL procedure successfully completed.

After that, recreate the queues and queue tables.

HP-UX: UnsatisfiedLinkError exception loading native library: njni10

Ran into this today whilst applying patch 10.1.4.3 on Identity Management installs. Causes the Directory Intergration Platform (DIP) upgrade to fail. As there are some nice features, quite important. I want that to run, and run correctly!

Three things to check/do:

export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export SHLIB_PATH=$ORACLE_HOME/lib32

Then you can rerun the configuration wizards again, assuring you have enough resources - use the setmemwindow:

setmemwindow -i 20 $ORACLE_HOME/cfgtoollogs/configToolCommands

So not just only when running DBCA, or NETCA, or DBUA; there it was an OID install (the infrastucture).
Edit: maybe check the existance of the files first? Search libnjni10.so; should be in lib as well as lib32, but different sizes.

Upgrade IDM from 10.1.2 to 10.1.4: dba_registry invalid OID

After you upgrade Oracle identity management from 10.1.2(.2) to 10.1.4.0, you will notice that Oracle Internet Directory is listed as Invalid:

idm01@xxxxxxx:/home/idm01> sqlplus / as sysdba
SQL> set lines 132 pages 99
SQL> col version format a10
SQL> col status format a15
SQL> col comp_name for a65
SQL> select COMP_NAME,VERSION,STATUS from dba_registry;
COMP_NAME                                                          VERSION         STATUS
------------------------------------------------------- ---------- ---------------
Oracle Application Server Portal                        10.1.2.0.2 VALID
Oracle Application Server Single Sign-On                10.1.4.0.1 VALID
.
Oracle Internet Directory                               10.1.2.0.2 INVALID

The solution is to:
Check $ORACLE_HOME/ldap/admin/LOGS/ldapupgrade.log in the OID (infrastructure) install for errors.
Check for invalid objects and compile them:

select owner,object_name,object_type from dba_objects
where owner='ODS' and status='INVALID';

returned package ridelplg as invalid.

Finally, run this code:

alter session set current_schema = SYS;

declare
 rc integer;
begin
 rc := ods.ldapUpgUtls.validateODS();
 if rc = 0 then
    DBMS_IAS_VERSION.SET_COMPONENT_VALID(COMPONENT_ID=>'OID');
 else
    DBMS_IAS_VERSION.SET_COMPONENT_INVALID(COMPONENT_ID=>'OID');
 end if;
end;
/

According to Metalink Doc ID: 374304.1, you should first call

execute DBMS_IAS_VERSION.SET_COMPONENT_UPGRADED(COMPONENT_ID=>'OID');

This, however, reset your version to 10.1.2.0.2 (whereas it was 10.1.2.2.0 when I started...). It should be 10.1.4.0.1.
Edit: After applying patch 10.1.4.3, it states version as 10.1.4.3.0.

Actieve DonorRegistratiesysteem

Ik heb zojuist mijn steun gegeven aan de campagne 2 Miljoen Handtekeningen. Het doel van deze campagne is de invoer van het Actieve DonorRegistratiesysteem (ADR).

Bij deze zou ik jou willen vragen om de petitie ook te ondertekenen op de site www.2miljoenhandtekeningen.nl
Mocht je eerst meer willen weten over de campagne of het ADR dan kun je al die informatie ook op de site vinden.

Daarnaast het verzoek mail te sturen naar al jouw vrienden om de campagne bij een groot publiek onder de aandacht te brengen.
Namens mij en de Stichting 2 Miljoen Handtekeningen, alvast hartelijk bedankt!