Re: oracle abruptly shut down, now error

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

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 - 13:08:11 CDT