Re: can't create database [INFO]
Just a note for everyone. Installing the glibc 2.3.2 helped running Oracle, but the OUI won't run anymore because of problems with the JRE 1.3.1 (Missing link in jre/lib/libjava.so). I tried replacing the 1.3.1 JRE with the one of JDK 1.3.1, but the OUI won't start. Not giving any message, just didn't start. But the database works, so I guess I won't need the installer again for a while ;) -- 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).
Re: can't create database (NOW WORKING!)
Am Die, 2003-03-18 um 15.58 schrieb Schwerdtfeger, Christoph: > 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 > > > &
Re: can't create database
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 > > > > > &g
Re: can't create database
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. > > > > > > > >
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:[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. > > >
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 > > >
RE: can't create database
$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 <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/12/2003 01:45 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: can't create database On Wed, Mar 12, 2003 at 12:44:07PM -0800, [EMAIL PROTECTED] 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 -- Shared Memory Segments keyshmid owner perms bytes nattch status 0x1fa75ea8 2588672oracle64051687424 0 -- Semaphore Arrays keysemid owner perms nsems status -- Message Queues keymsqid owner perms used-bytes messages $ ipcrm shm 2588672 resource(s) deleted $ ipcs -- Shared Memory Segments keyshmid owner perms bytes nattch status -- Semaphore Arrays keysemid owner perms nsems status -- Message Queues keymsqid owner perms used-bytes messages > > 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 <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/12/2003 09:44 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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 > > > > > > [EMAIL PROTECTED] > > > > > > 718-482-4200 x106 > > > > > > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > 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 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 85
Re: can't create database
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 <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/12/2003 01:45 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: can't create database On Wed, Mar 12, 2003 at 12:44:07PM -0800, [EMAIL PROTECTED] 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 -- Shared Memory Segments keyshmid owner perms bytes nattch status 0x1fa75ea8 2588672oracle64051687424 0 -- Semaphore Arrays keysemid owner perms nsems status -- Message Queues keymsqid owner perms used-bytes messages $ ipcrm shm 2588672 resource(s) deleted $ ipcs -- Shared Memory Segments keyshmid owner perms bytes nattch status -- Semaphore Arrays keysemid owner perms nsems status -- Message Queues keymsqid owner perms used-bytes messages > > 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 <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/12/2003 09:44 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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 > > > > > > [EMAIL PROTECTED] > > > > > > 718-482-4200 x106 > > > > > > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > 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 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---
Re: can't create database
On Wed, Mar 12, 2003 at 12:44:07PM -0800, [EMAIL PROTECTED] 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 -- Shared Memory Segments keyshmid owner perms bytes nattch status 0x1fa75ea8 2588672oracle64051687424 0 -- Semaphore Arrays keysemid owner perms nsems status -- Message Queues keymsqid owner perms used-bytes messages $ ipcrm shm 2588672 resource(s) deleted $ ipcs -- Shared Memory Segments keyshmid owner perms bytes nattch status -- Semaphore Arrays keysemid owner perms nsems status -- Message Queues keymsqid owner perms used-bytes messages > > 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 <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/12/2003 09:44 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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 > > > > > > [EMAIL PROTECTED] > > > > > > 718-482-4200 x106 > > > > > > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > 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 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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).
Re: can't create database
Another reason to have a unique oracle ID/home for each instance. It makes this much easier... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] ys.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: can't create database 03/12/2003 01:44 PM Please respond to ORACLE-L 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. 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 <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/12/2003 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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 > > > > > [EMAIL PROTECTED] > > > > > 718-482-4200 x106 > > > > > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 ORACL
Re: can't create database
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. 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 <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/12/2003 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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 > > > > > [EMAIL PROTECTED] > > > > > 718-482-4200 x106 > > > > > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
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 > > > > > [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
Re: can't create database
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] > > > &g
Re: can't create database
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? -- 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 othe
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 > > > > > [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
Re: can't create database
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 > > > > > &
Re: can't create database
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.
Re: can't create database
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? -- 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).
Re: can't create database
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 -- Author: Christoph Schwerdtfeger 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).
AW: can't create database
Title: RE: LMT monitoring Hi Milen, 1) Have you relinked the executables during installation phase(applying stubs patch supplied by Oracle ) ? 2) Create DB creating scripts with dbassist. Then perform each step written in *.SQL & *.sh files separately, while watching ALERT.LOG. This approach can help you localize at which step the problem appears. Best wishes Milen Kulev -Ursprüngliche Nachricht-Von: Milen Pankov [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 11. März 2003 18:00An: Multiple recipients of list ORACLE-LBetreff: 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?
Re: can't create database
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 -- Author: Alan Davey 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).
Re: can't create database
On Tue, Mar 11, 2003 at 09:00:09AM -0800, Milen Pankov wrote: > RE: LMT monitoringcan'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? -- look in the alert log === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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).
RE: can't create database
Title: 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 AMTo: Multiple recipients of list ORACLE-LSubject: 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?
RE: can't create database
Title: RE: LMT monitoring I had the same problem,You have to generate the script with dbassist then run the script. -Original Message-From: Milen Pankov [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 11, 2003 9:00 AMTo: Multiple recipients of list ORACLE-LSubject: 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? === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement =
can't create database
Title: RE: LMT monitoring 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?