RE: fixing a bad oracle install

This is most likely caused by the LISTENER.ORA not pointing to the correct ORACLE_HOME. Did you move the oracle executables by chance? The uninstall and reinstall would have fixed this.

Pat

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: Wednesday, September 19, 2007 12:55 PM To: ryan_gaffuri_at_comcast.net; oracle-l_at_freelists.org Subject: Re: fixing a bad oracle install

How on earth did you export a database that was down?

On 19/09/2007, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote:
> We were hitting shared memory errors. Googled it and this is common
> when an Oracle install is wrong. I looked into it and the kernel
> parameters were never set(I didnt do the install). This is in Redhat
> 5.0 with Oracle 10.2.0.1. Set the kernetl parameters and stepped
> through the install to make sure ulimit, etc... was correct. Started
up the DB and got the same error.
>
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux-x86_64 Error: 2: No such file or directory
>
> So I shut the DB down. did an export for a quick backup(its just
> development data). Uninstaled the software and then reinstalled.
>
> started up the DB and had the same problem. I had to make a new
> database and import the data to it to start over. I am ok for now, but

> for future reference, is any DB created with a bad install hosed and I

> have to make a new DB? The new DB works fine so far with the imported
data.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l



___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.

To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com
--
http://www.freelists.org/webpage/oracle-l