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 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
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 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
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
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. 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
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. 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
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 thedatabase creation it tels me:"not connected to oracle".any ideas?
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).
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
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. -- 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). -- === 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
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] -- 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
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 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
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). -- 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
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
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 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
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
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 ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas 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
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
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 - 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: 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
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-- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
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 thedatabase 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 thedatabase 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 =
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 thedatabase creation it tels me:"not connected to oracle".any ideas?
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
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).