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: Schwerdtfeger, <schwerdtfeger_at_softconcept.net>
Date: Tue, 18 Mar 2003 06:58:53 -0800
Message-ID: <F001.0056C745.20030318065853@fatcity.com>


Am Mon, 2003-03-17 um 18.32 schrieb Ray Stell:
> On Mon, Mar 17, 2003 at 07:03:43AM -0800, Joe Johnson wrote:
> > 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.
>
>
> site unseen!
>
>
>
> > 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).
>
> --
> ===============================================================
> Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net

Yes, you missed out the site ;)
But I guess I don't need it anyway.
I just tried "ipcs -sm" before starting the database ... Here is what I did:

-->

[ORACLE_at_oracle:/home/oracle] ipcs -sm  

#comment: nothing was using the shared memory.  

[ORACLE_at_oracle:/home/oracle] sqlplus /nolog  

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Mar 18 15:45:12 2003  

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.  

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount pfile="[Path]init.ora"; ORA-03113: end-of-file on communication channel SQL> disconnect;
Disconnected
SQL> exit;

[ORACLE_at_oracle:/home/oracle] ipcs -sm  

<--

It doesn't matter how often I redo the procedure, the outcoming is the same.
Is there a bug in Oracle 9.2.0.1.0?
I'm now downloading 9.0.1, hoping that will work ...

Btw.: I reinstalled Oracle 9i (without applying the glibc-patch for 8i).

Installed libc versions (if that matters):

libc5          		5.4.46-12
libc5-altdev   		5.4.46-12
libc6          		2.3.1-14
libc6-dev      		2.3.1-14
libstdc++2.9-glibc2.1 	2.91.66-4
libstdc++2.10-glibc2.2	2.95.4-16


-- 
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).
Received on Tue Mar 18 2003 - 08:58:53 CST

Original text of this message

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