Installing DBPrism 3.0.2.1.0 (in-Oracle-Lucene) on a WinXP-10gR2

Introduction

This post talks, shares experiences, about installing Marcelo Ochoa’s (MO, Marcelo Ochoa’s personal blog) in-oracle-lucene implementation into an oracle 10.2.0.3 on winxp. MO did a really great job in porting a raw lucene to an oracle database. His essential trick is actually to represent the file system layer, lucene usually lives in, within a blob based storage as well as employing the oracle odci-interface. Any further information is available in the online documentation here Lucene Domain Index.

Downloads

The latest version of the code stack is available as lucene-odi-bin-3.0.2.1.0.zip from http://sourceforge.net/projects/dbprism/files/odi/3.0.2.1.0/. Do not care about the sourceforge project being called DBPrism or this other code stack around being tagged ojvm, this is all history. The latest version to comprise the lucene 3.0.2 core base is lucene-odi, lucene-ojvm currently features the lucene 2.9.2 core base as just a maintainance release.

Another necessary download is ant, as a build and installation runtime environment. I sourced apache-ant-1.8.1-bin.zip from http://ant.apache.org/bindownload.cgi. Finally, iff you plan to compile the java code to windows dll’s for better performance (especially on production hosts), you may need to get Microsoft Visual C++ 2010 Express from http://www.microsoft.com/express/Downloads. Its free and will supply, beneath a lot of other stuff, what is expected, i.e. provides for a C++ compiler and dll linker.

Clearing a hot oracle log file on windows

sometimes, i know not on our installations , one may have forgotten to size and schedule oracle logging appropriately. a typical case is setting LOGGING_LISTENER = ON in the listener.ora and then just loosing sight of it. the next or another day later one will get a call that the system is slow, this time because oracle hardly works to still append to that multi-gigabyte listener.log file. oops, what to do know? one can’t delete the file because it is locked by the owning process. one can neither bounce the listener in a 24×7 environment. an option one has though is to shred the contents of the file by overwriting it with just nothing or NULL on windows (/dev/null on un*x). this will help you out:

type NUL > %my_correct_path%\listener.log

have fun

Passing sqlplus return codes to the cscript ws-host

introduction

there lately was an article, discussing a certain aspect of managing oracle on windows machines with shell scripting, called Redirecting dbv output to a file. this article is going to dive deeper into the scripting matter, especially contemplating an approach to control the execution of sqlplus-scripts, supervised by logic being embedded in the csript/jscript-interpreter of the windows scripting host (wsh).

sqlplus and scripting on windows – wsh and alternatives

the main problem of using sqlplus to feed the database with code and/or data is its inability to incorporate logic control. this is most notably true iff you have to manage more than one script, probably even branching or staging. sqlplus has variables, assignments, a lot of print formatting and so on but misses any concept of if-then-else and friends. you are obviously impelled to find some other, enclosing runtime environment to express your execution flow plans (and exception escapes .

scripting on windows using the msdos-batch command set was always a nightmare, wsh did a lot better on 2003- and xp-systems and now we are told to have powershell (msh formely) with vista and 2008, also see Next sysdba credentials syntax for impdp with Windows PowerShell. i do not want to examine any pro/con of this evolution nor do i want to introduce alternatives in its facets on windows. to me, having a free choice, i would always and anywhere employ python. it does the daily tasks in an amazingly smart fashion, offering an easily adaptable solution for nearly every duty. however, customer admins may have another perspective or another affectation or may just dislike python.

to that end, iff you are looking for a reliable friend that will help you on with programming your sqlplus script execution on a multitude of windows environments, wsh will not be the worst choice. not to be unmentioned though, wsh development has been discontinued by microsoft. it is to be replaced by powershell somewhere in the future. the most widespread wsh version counts 5.6, with a bugfix update to 5.7 for the vista- and 2008-systems.

Windows task scheduler result codes

not that often but quite steady, during the process of configuring or monitoring the execution of tasks with the windows scheduler, one is faced with cryptic error codes in the Last Result column of the schedulers frontend. although the web spreads the rumour that a complete list of shell error codes may exist somewhere at msdn, there is another, web-independent way to decrypt the error codes into comprehensible explanations.

it’s just the net command expanded by the helpmsg switch that does the job. called in such a way, net helpmsg expects an error code input in decimal notation like this:

c:\>net helpmsg 143
The system cannot join or substitute a drive to or for a directory on the same drive.

the decimal value stems, in turn, from the hexadecimal value, 0x8f, as being printed in the Last Result column. most probably, 0x8f or 143, depict a situation, where a task cannot mount a given disk resource. in most cases, however, an error code of 0x1 just points to a defective script under the hood of a task.

by the way, there also is a rudimental logging available with the schedulers frontend. just click Advanced -> View Log in the menue.

have fun