RE: can't create database

Hi,

This site has a good description of how to use the ipcs and ipcrm commands to clean up these left-over memory segments following the shutdown. I've found that using the technique shown on this site minimizes the need to reboot when this problem occurs.

Hope this helps,

Joe Johnson, OCP
Senior Database Administrator
Greenbrier & Russel, Inc.
Madison, Wisconsin USA

"Let us linger here a while in the foolishness of things"

-Unknown  

> -----Original Message-----
> From: Schwerdtfeger, "Christoph [mailto:schwerdtfeger_at_softconcept.net]
> Sent: Monday, March 17, 2003 2:59 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: can't create database
>
>
> Am Mit, 2003-03-12 um 21.14 schrieb candi.boyle_at_siemens.com:
> > 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
> > > > > > >
> > > > > > >
> > > > > > > On 3/11/2003 12:44 PM, Stahlke, Mark
> > <mstahlke_at_denvernewspaperagency.com> wrote:
> > > > > > > >RE: LMT monitoring
> > > > > > > >Is this on Linux?
> > > > > > > >If yes, then it sounds like you need to install
> the glibc stubs
> > patch.
> > > > > > > >If no, then I don't know what the problem might be.
> > > > > > > >
> > > > > > > >-----Original Message-----
> > > > > > > >From: Milen Pankov [mailto:m_pankov_at_hotmail.com]
> > > > > > > >Sent: Tuesday, March 11, 2003 10:00 AM
> > > > > > > >To: Multiple recipients of list ORACLE-L
> > > > > > > >Subject: can't create database
> > > > > > > >
> > > > > > > >
> > > > > > > >can't create a database with oracle 8.1.7.
> > > > > > > >the installation went fine, but when i start
> dbassist on the 2%
> > of
> > > > > > > >the
> > > > > > > >database creation it tels me:
> > > > > > > >"not connected to oracle".
> > > > > > > >any ideas?
> > > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > > > > >
> > > > > > Hi there.
> > > > > >
> > > > > > I have a similiar problem with Oracle 9.2.0.1.0
> under Linux (Debian,
> > > > > > Woody, Kernel 2.4.20-686-smp).
> > > > > > The installation worked fine - at least no error
> message was shown,
> > > > > > but when I start the dbca to create a database, I
> get an ORA-03113.
> > > > > > I've searched over the internet (newsgroups and
> webpages), but I
> > didn't
> > > > > > find a solution for my problem.
> > > > > > I searched for the libc-patch, but I think it's
> deprecated for
> > Oracle
> > > > > > 9i.
> > > > > > Many ppl said, like you, I just should generate the
> scripts with the
> >
> > > > > > wizard and create the database manually, so I did -
> or at least I
> > tried.
> > > > > >
> > > > > > So, I just wanted to test, if the login works, but
> it didn't.
> > > > > > Is startet "sqlplus /nolog" and tried "connect
> SYS/change_on_install
> > as
> > > > > > SYSDBA" ("conn / as SYSDBA" has the same effect,
> ORACLE_SID set as
> > said
> > > > > > in the script) and I get:
> > > > > >
> > > > > > Connected to an idle instance.
> > > > > >
> > > > > > Ok, I think this is just normal and I tried to
> start the database
> > using
> > > > > > "startup nomount pfile="Correct path to init.ora";
> > > > > >
> > > > > > And then, all I get is an ORA-03113: end-of-file on
> communication
> > > > > > channel
> > > > > >
> > > > > > If I try to do a "conn /" afterwards, I get
> > > > > > ORA-01034: ORACLE not available
> > > > > > ORA-27101: shared memory realm does not exist
> > > > > > Linux Error: 2: No such file or directory
> > > > > >
> > > > > > Any suggestions, what could be wrong? I installed
> the Enterprise
> > > > > > Version, so it can't be an Enterprise setting ...
> it has to be a
> > problem
> > > > > > in the "init.ora", right?
> > > > > >
> > > > > > System specs if required:
> > > > > > Pentium II, 800 (2x - multi processor)
> > > > > > 1024MB RAM
> > > > > > 4GB Swap
> > > > > > 19GB diskspace free
> > > > > > Debian Linux (woody)
> > > > > > Kernel 2.4.20-686-smp
> > > > > >
> > > > > > Any help would be appreciated.
> > > > > >
> > > > > > --
> > > > > > Christoph Schwerdtfeger <schwerdtfeger_at_softconcept.net>
> > > > > >
> > > > > > SoftConcept GmbH
> > > > > > Borriesstrasse 35
> > > > > > D-32257 B?nde
> > > > > >
> > > > > > Tel: (05223) 4970-20
> > > > > > E-Mail: schwerdtfeger_at_softconcept.net
> > > > > >
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > >
> > > > > Ok, I just deinstalled Oracle 9i and installed 8.1.7
> which ran - after
> > > > > applying the patch - without any problems ... dunno why.
> > > > > Maybe I should try to apply the 8.1.7-glibc patch to the 9i?
> > > >
> > > >
> > > > Try Oracle 9.2.0. I have installed it on many linux platforms
> > > > without any tricks. I think you said you were using 9.0.x.
> > > > I never had any desire to go there, so I don't know what
> > > > may be at issue.
> > > >
> > >
> > > I AM using Oracle 9.2.0 - or trying to use it.
> > > As I wrote, Oracle 8i (8.1.7) worked without any problems, but 9i
> > > (9.2.0.1.0 - EE) is a pain in the a$$.
> > >
> > > I do it the same way as with the 8.1.7.
> > > I don't have any problems during the installation (ok, a
> problem with
> > > the ins_ctx.mk, but this is fixed by adding "$(LDLIBFLAG)dl").
> > > I use the dbca to create a script for the database and login via
> > > "sqlplus /nolog" and do a "conn / as sysdba" and I get a
> > > Connected to an idle instance
> > >
> > > But, if I try to "startup nomount pfile="...";", I get an
> ORA-03113.
> > >
> > > I have applied the 8.1.7-glibc patch at the 9.2.0 version
> of Oracle,
> > > just for testing, but it didn't change anything.
> > > I've also done a "relink /all" ... didn't help.
> > >
> > > This is my init.ora:
> > >
> > > db_block_size=8192
> > > db_cache_size=25165824
> > > db_file_multiblock_read_count=16
> > >
> > > open_cursors=300
> > >
> > > control_files=("/home/oracle/oradata/sc/control01.ctl",
> > > "/home/oracle/oradata/sc/control02.ctl",
> > > "/home/oracle/oradata/sc/control03.ctl")
> > >
> > > db_domain=""
> > > db_name=sc
> > >
> > > background_dump_dest=/home/oracle/admin/sc/bdump
> > > core_dump_dest=/home/oracle/admin/sc/cdump
> > > user_dump_dest=/home/oracle/admin/sc/udump
> > >
> > > # I tried to comment this one out, didn't changed
> > > # a thing
> > > timed_statistics=TRUE
> > >
> > > dispatchers="(PROTOCOL=TCP) (SERVICE=scXDB)"
> > >
> > > hash_join_enabled=TRUE
> > > query_rewrite_enabled=FALSE
> > > star_transformation_enabled=FALSE
> > >
> > > java_pool_size=83886080
> > > large_pool_size=8388608
> > >
> > > # I raised the shared_pool_size, but with no luck.
> > > shared_pool_size=83886080
> > >
> > > # My /proc/sys/kernel/sem:
> > > # 500 32000 500 500
> > > # So this shouldn't be a problem
> > > processes=150
> > >
> > > fast_start_mttr_target=300
> > >
> > > remote_login_passwordfile=EXCLUSIVE
> > >
> > > pga_aggregate_target=25165824
> > > sort_area_size=524288
> > >
> > > # Tried to set the compatibility
> > > # to 8.1.0 ... didn't work ...
> > > compatible=9.2.0.0.0
> > >
> > > undo_management=AUTO
> > > undo_retention=10800
> > > undo_tablespace=UNDOTBS1
> > >
> > > Any help would be greatly apreciated.
> > > Thanks in advance
> > >
> > > --
> > > Christoph Schwerdtfeger <schwerdtfeger_at_softconcept.net>
> > >
> > > SoftConcept GmbH
> > > Borriesstrasse 35
> > > D-32257 Bünde
> > >
> > > Tel: (05223) 4970-20
> > > E-Mail: schwerdtfeger_at_softconcept.net
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Schwerdtfeger, "Christop
> > > INET: schwerdtfeger_at_softconcept.net
> > >
> > > 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: Boyle Candi
> > INET: candi.boyle_at_siemens.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
>
> Didn't work ...
>
> I just rebooted the system and did a "free".
> And this is the output:
>
> total used free shared buffers cached
> Mem: 1034000 75684 958316 0 4796 41956
> -/+ buffers/cache: 28932 1005068
> Swap: 4145128 0 4145128
>
> I guess this should be about enough, just to start a database.
> Then I connect to oracle (conn / as sysdba) and do a startup.
>
> I get an ORA-03113 again. Any other guesses or tips?
>
> Btw.: When I do a "free" again, 190MB of RAM are used, but still no
> swap.
>
> Thanks in advance
>
> --
> Christoph Schwerdtfeger <schwerdtfeger_at_softconcept.net>
>
> SoftConcept GmbH
> Borriesstrasse 35
> D-32257 Bünde
>
> Tel: (05223) 4970-20
> E-Mail: schwerdtfeger_at_softconcept.net
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Schwerdtfeger, "Christop
> INET: schwerdtfeger_at_softconcept.net
>
> 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: Joe Johnson
  INET: jjohnson_at_gr.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).