Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle abruptly shut down, now error
Chr2k04 wrote:
> 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).
>
> ~Chris
Recap: (and I'm playing out my assumptions here as well)
Conclusion:
Action: (just some ideas - you're outside my area but I'm sure others will help)
/Hans
> 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.
Received on Wed May 14 2003 - 15:46:12 CDT