(RADIATOR) ORA-03113 when first FindQuery is prepared / is "foreground" a solution?

[Mike McCauley]

Hello Rainer ,


On Thu, 26 Jun 2003 08:05 pm, Huber, Rainer wrote:
> Hi List!
>
> I've played around with IP-Addressassignement by RADIUS - I've used
> Addressallocator SQL
>
> The Environment is
> 	Solaris 8
> 	Perl 5.6.1
> 	Perl DBI 1.21
> 	DBD-Oracle-1.12 (Problem with java stuff solved by preloading the
> libthread.so.1)
> 	Radiator 2.19
>
> Since the first time I started my config, I got a ORA-03113, when the first
> request arrived that triggers a FindQuery (sql prepare is the problem). All
> following requests work well and there are no problems with the database
> connection at all. At first I integrated the IP-Assignment into an existing
> config and I thought that the error is in one of the hooks or in modules
> we've
> set up, but then I also got the error with a quite simple setup
>
> On startup of the process, the reclaimquerie is executed, which works well
> (lets say with Handler A). As already mentionened, only the first SELECT
> failes (Handler A is available (Hash), but it seems to be unuseable for any
> reason).
> I also took a look at the DBI-Trace 5, but I could not find a reason for
> the unuseable dbh.
>
> I've played around with the parameters in the config file and suddenly
> there was no ORA any more, after I've enabled the "Foreground" parameter.
> => Surprise
>
> Hugh pointed me to the List archive and I've found the following thread
> covering my problem
> http://www.open.com.au/archives/radiator/2001-05/threads.html#00065
>
> I see three possibilities to "solve" the problem:
> *) ignore the ORA
> *) start radiator with the "Foregroud" option set and with
>    a & and nohup in the init script
>
> Due to the messages I found I assume that you (who have also this problem)
> ignore the ORA - am i right?
>
> @High/Mike: Is there any differece in the behaviour of radiator when
> Foreground is acivated (performance, ...)

Should be no difference, providing there is no logging to stdout.


>
> I'll also try to extract the radius part of the oracle client libraries,
> which is implented in java and which needs the libthread.so.1 => maybe this
> has a side effect on radiator   (=> see README.java in the DBD-Oracle CPAN
> module for more information about this)
>
> Any other suggestions?
>
>
> regards,
> Rainer Huber
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.