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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: can't create database

RE: can't create database

From: Richard Ji <richard.ji_at_mobilespring.com>
Date: Wed, 12 Mar 2003 17:33:57 -0800
Message-ID: <F001.005686C7.20030312173357@fatcity.com>


$ORACLE_HOME/bin/sysresv is another method to do just that.

-----Original Message-----
Sent: 12. maaliskuuta 2003 17:51
To: Multiple recipients of list ORACLE-L

Ray,

ipcs *will* tell you the ID's of all Oracle SHM segments.

What it won't tell you is which ones *not* to delete.

You need oradebug for that.

Jared

Ray Stell <stellr_at_cns.vt.edu>
Sent by: root_at_fatcity.com
 03/12/2003 01:45 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: can't create database


On Wed, Mar 12, 2003 at 12:44:07PM -0800, Jared.Still_at_radisys.com wrote:
> I run into this every time I stop 9.2 on Linux.
>
> No need to reboot. Just use ipcrm to remove the
> offending SHM segments.
>
> If you don't know which ones, use ORADEBUG to
> find the segments you shouldn't remove from other
> running databases.

ipcs will tell you the id numbers to feed to ipcrm:

$ ipcs

$ ipcrm shm 2588672
resource(s) deleted

$ ipcs

>
> Or just shutdown all instances and remove any
> SHM owned by Oracle.
>
> Probably a bug, but I haven't checked into it yet.
>
> Jared
>
>
>
>
>
>
> Boyle Candi <candi.boyle_at_siemens.com>
> Sent by: root_at_fatcity.com
> 03/12/2003 09:44 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> cc:
> Subject: Re: can't create database
>
>
> I've had this problem on linux. Best and fastest solution: reboot the
> server. There is a memory issue preventing you from starting oracle. I
> just had it happen about 2 minutes ago on an upgrade to 9i. Reboot, and
> now I can start the db.
>
> -Candi
>
>
> On Wed, 2003-03-12 at 12:07, Schwerdtfeger, Christoph wrote:
> > Am Mit, 2003-03-12 um 17.20 schrieb Ray Stell:
> > > On Wed, Mar 12, 2003 at 07:19:53AM -0800, Schwerdtfeger, Christoph
> wrote:
> > > > Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger:
> > > > > Am Die, 2003-03-11 um 19.47 schrieb Alan Davey:
> > > > > > I had the same error message on NT with Oracle 9.2 recently.
> > > > > >
> > > > > > The first problem was that the init_sid.ora file was created a

> directory different from where the db create scripts were looking for
it.
> The second problem was that one of the init parameters was for
Enterprise
> Edition and I was installing Standard Edition.
> > > > > >
> > > > > > Both problems resulted in the message of 'not connected to
> oracle'.
> > > > > >
> > > > > > Come to think of it, I don't think I've ever had a version of
> the DB Creation wizard work without getting some error.
> > > > > > --
> > > > > >
> > > > > > Alan Davey
> > > > > > adavey_at_competitrack.com
> > > > > > 718-482-4200 x106
> > > > > >
> > > > > >
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: richard.ji_at_mobilespring.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Mar 12 2003 - 19:33:57 CST

Original text of this message

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