Re: Is my Oracle instance still running?

jim_pku_at_yahoo.com (Jim Cheng) wrote in
news:6028007c.0410241036.1c028dd0_at_posting.google.com:

> My Oracle 9i database is running well on Linux for a while (several
> days), then it seems to go down. I could not connect to the database
> using sqlplus. If I restart the database, the problem will be solved
> temporarily (only for several days). Then the problem repeats.
>
> dvserver% sqlplus system/mypasswd_at_MYDB
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Sun Oct 24 10:57:51 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
>
>
> My questions are:
> 1). Is my Oracle Instance still running?

I don't think so.

> 2). What are the possible reasons and how to solve the problem?

What are the last 80 or so last lines in alertSID.log file? Received on Sun Oct 24 2004 - 14:24:21 CDT