Re: can't create database [INFO]

2003-03-24 Thread Schwerdtfeger,
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!)

2003-03-19 Thread Schwerdtfeger,
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

2003-03-18 Thread Schwerdtfeger,
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

2003-03-17 Thread 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.
> > > > > > > 
>

RE: can't create database

2003-03-17 Thread Joe Johnson
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

2003-03-17 Thread Schwerdtfeger,
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

2003-03-12 Thread Richard Ji
$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

2003-03-12 Thread Jared . Still
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

2003-03-12 Thread Ray Stell
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

2003-03-12 Thread Ron Thomas

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

2003-03-12 Thread Jared . Still
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

2003-03-12 Thread candi . boyle
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

2003-03-12 Thread schwerdtfeger
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

2003-03-12 Thread schwerdtfeger
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

2003-03-12 Thread Boyle Candi
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

2003-03-12 Thread Schwerdtfeger,
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

2003-03-12 Thread 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.  

Re: can't create database

2003-03-12 Thread Schwerdtfeger,
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

2003-03-12 Thread 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
-- 
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

2003-03-12 Thread Kulev, Milen
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

2003-03-11 Thread 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
-- 
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

2003-03-11 Thread Ray Stell
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

2003-03-11 Thread Stahlke, Mark
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

2003-03-11 Thread Hamid Alavi
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

2003-03-11 Thread Milen Pankov
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?