Just for hopefully helping someone else...
I fixed it, it was a silly mistake of my part, I forgot to edit the nsd-oracle file. I just set the right SID, ORACLE_HOME and ORACLE_BASE and it was it, now everything is running ok (at least by the moment - oracle 10.1.0.3.0, openacs-5-1, aolserver4 and debian-testing).
Regards