Re: oracle abruptly shut down, now error

chr2k4_at_aol.com (Chr2k04) wrote in message news:<bf58ec5f.0305141008.3a34f1d0_at_posting.google.com>...
> Hey,
> I have Linux Mandrake 9.1 with Oracle 9.1.
> It's a local database without any other computers accessing it.
> Other perl scripts work, and I access the database with DBD::Oracle (DBI).
>

Sounds like you missed an environment variable that needs to be set/exported for perldbi. Perhaps something in your rc files or bashrc? Had you previously bounced the box and had the perldbi scripts work afterwards? How far into the script can you get? Do you have more than one perl? Load a module manually?

Wild guesses (sounds like a Cure song, eh?) :-)

> ~Chris
>
>
> Hans Forbrich <forbrich_at_telusplanet.net> wrote in message news:<3EC1BCCC.9CBEF158_at_telusplanet.net>...
> > Chr2k04 wrote:
> >
> > > Hey,
> > >
> > > Today I accidentally shut the power down to my computer while oracle
> > > was running. Now that I started it back up again, I can run SQL
> > > statements from sqlplus, but I cannot run perl scripts accessing the
> > > database with the error "segmentation fault."
> > > Is there anything I have to clean up because of the abrupt shutdown?
> >
> > Hey - right back at you ....
> >
> > SQLPlus works OK? In all modes (TCP & BEQ)? Then I'd say the database
> > is basically OK & you don't really need to do any more on that side.
> > You might want to check the Alert.log
> >
> > Since you don't want to mention the Oracle version, the web server, or
> > the OS, I guess we'll have to play 20 questions here.
> >
> > 1) What is your OS? (Since you say "seg fault", I'd guess Windows
> > version xyz.5)
> > (Since you actually have access to the power button, I'd guess a big
> > PC?)
> >
> > 2) What version of the database?
> >
> > 3) Do other perl scripts, not accessing the DB, also run OK?
> >
> > 4) How do they access the DB - ODBC or other?
> >
> > 5) Are the perl scripts on the same machine? (I'd guess yes)
> >
> > 6) What happens when you try to access the database using SQLPlus from
> > another machine?
> >
> > ... others can ask more - these will keep me happy for now.

jg

--
@home.com is bogus.
http://www.plainsong.net/curebase/