Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle abruptly shut down, now error

Re: oracle abruptly shut down, now error

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Wed, 14 May 2003 20:46:12 GMT
Message-ID: <3EC2A9A6.835C04EA@telusplanet.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US