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:[EMAIL PROTECTED] > > > 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 [EMAIL PROTECTED]: > > > > 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 > > > > > > > > > [EMAIL PROTECTED] > > > > > > > > > 718-482-4200 x106 > > > > > > > > > > > > > > > > > > > > > > > > > > > On 3/11/2003 12:44 PM, Stahlke, Mark > > > > <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > > > > > > > > > >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 <[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > SoftConcept GmbH > > > > > > > > Borriesstrasse 35 > > > > > > > > D-32257 B?nde > > > > > > > > > > > > > > > > Tel: (05223) 4970-20 > > > > > > > > E-Mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > -- > > > > > > > > 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 <[EMAIL PROTECTED]> > > > > > > > > > > SoftConcept GmbH > > > > > Borriesstrasse 35 > > > > > D-32257 B?nde > > > > > > > > > > Tel: (05223) 4970-20 > > > > > E-Mail: [EMAIL PROTECTED] > > > > > > > > > > -- > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > > -- > > > > > Author: Schwerdtfeger, "Christop > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (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 <[EMAIL PROTECTED]> > > > > > > SoftConcept GmbH > > > Borriesstrasse 35 > > > D-32257 B?nde > > > > > > Tel: (05223) 4970-20 > > > E-Mail: [EMAIL PROTECTED] > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Schwerdtfeger, "Christop > > > INET: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] (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: --> [EMAIL PROTECTED]:/home/oracle] ipcs -sm ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status ------ Semaphore Arrays -------- key semid owner perms nsems status #comment: nothing was using the shared memory. [EMAIL PROTECTED]:/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; [EMAIL PROTECTED]:/home/oracle] ipcs -sm ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status 0x4977d408 7176194 oracle 640 339738624 0 ------ Semaphore Arrays -------- key semid owner perms nsems status 0x0a62aa6c 98304 oracle 640 154 <-- 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 <[EMAIL PROTECTED]> SoftConcept GmbH Borriesstrasse 35 D-32257 B�nde Tel: (05223) 4970-20 E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schwerdtfeger, "Christop INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
