答复: fixing a bad oracle install

From: jametong <jametong_at_gmail.com>
Date: Thu, 20 Sep 2007 09:23:38 +0800
Message-ID: <46f1cbfe.15bb720a.32e9.ffff8810@mx.google.com>

 

I Think a Relink all should meet this .

Jametong  

DBA Team. B2B. 阿里巴巴中国

---

Phone   : 0571-85022088-12372
Fax     : 0571-85022958
Mobile  : 135-8803-9828
Mail    : jame.tongjw_at_alibaba-inc.com
          jametong_at_gmail.com
Msn     : kt_tongjiawang_at_hotmail.com
Yahoo   : jametong

Alitalk : jametong
Skype : jametong

---

-----邮件原件-----
发件人: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 代 表 Elliott, Patrick
发送时间: 2007年9月20日 2:23
收件人: niall.litchfield_at_gmail.com; ryan_gaffuri_at_comcast.net; oracle-l_at_freelists.org
主题: 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


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 19 2007 - 20:23:38 CDT