Database Configuration Assistant for 8i 
Author Message
 Database Configuration Assistant for 8i

I am trying to create two databases on an NT (SP 5) server.  One of these
database is to be used for the OEM Repository, and the other is for my
application.  I am able to successfully create one database; however, I
receive "out of memory" errors when creating any database after the first
one.

I have tried shutting down the first instance before creating the second
one.  This actually allows the Database Configuration Assistant to complete
creation of the second database.  The problem here is that I can't have both
instances up and running at the same time after the second is created.
Although the services are running fine, I am unable to connect to the second
database.

The server has 256 MB of memory.  Is this a lack of memory issue or what?
Thanks in advance.



Wed, 18 Jun 1902 08:00:00 GMT
 Database Configuration Assistant for 8i

You don't say how you configured the databases, but it is definitely
possible to run two on a server with 256M.  In fact you can run three or
more.

Van


Quote:
> I am trying to create two databases on an NT (SP 5) server.  One of these
> database is to be used for the OEM Repository, and the other is for my
> application.  I am able to successfully create one database; however, I
> receive "out of memory" errors when creating any database after the first
> one.

> I have tried shutting down the first instance before creating the second
> one.  This actually allows the Database Configuration Assistant to
complete
> creation of the second database.  The problem here is that I can't have
both
> instances up and running at the same time after the second is created.
> Although the services are running fine, I am unable to connect to the
second
> database.

> The server has 256 MB of memory.  Is this a lack of memory issue or what?
> Thanks in advance.



Wed, 18 Jun 1902 08:00:00 GMT
 Database Configuration Assistant for 8i
The databases were configured using the defaults from the Database
Configuration Assistant.  I have another server currently running two
databases right now, so I know it can be done.


Quote:
> You don't say how you configured the databases, but it is definitely
> possible to run two on a server with 256M.  In fact you can run three or
> more.

> Van



> > I am trying to create two databases on an NT (SP 5) server.  One of
these
> > database is to be used for the OEM Repository, and the other is for my
> > application.  I am able to successfully create one database; however, I
> > receive "out of memory" errors when creating any database after the
first
> > one.

> > I have tried shutting down the first instance before creating the second
> > one.  This actually allows the Database Configuration Assistant to
> complete
> > creation of the second database.  The problem here is that I can't have
> both
> > instances up and running at the same time after the second is created.
> > Although the services are running fine, I am unable to connect to the
> second
> > database.

> > The server has 256 MB of memory.  Is this a lack of memory issue or
what?
> > Thanks in advance.



Wed, 18 Jun 1902 08:00:00 GMT
 Database Configuration Assistant for 8i

Quote:

> The databases were configured using the defaults from the Database
> Configuration Assistant.  I have another server currently running two
> databases right now, so I know it can be done.



> > You don't say how you configured the databases, but it is definitely
> > possible to run two on a server with 256M.  In fact you can run three or
> > more.

I hit this problem a few days ago. The box had 128 megs, but still gave
me an "out of memory" error. I drastically increased the virtual memory,
and now I can have both instances running without problem (granted, with
only 128 MB on NT with 8i, they run a little slow due to some heavy
swapping, but the out of memory error hasn't occured again).
Another thing you may want to do is drop the java pool size down from
the default ~20MB to 4 or 5 MB unless you need really need it that high.

Cheers,
GC



Wed, 18 Jun 1902 08:00:00 GMT
 Database Configuration Assistant for 8i

Quote:

>I am trying to create two databases on an NT (SP 5) server.

one oracle instance is sufficient for almost any situation on one computer.
you can keep logical databases apart by choosing differing schema names for
each database and using reasonable security measures.

by anlogy, there is only one ftp server and one web server and one telnet
server on a typical computer. so one oracle server is sufficient, especially
when MTS is used, for thousands of users.

the exception is when you use one oracle instance as the backup-recovery cache
for another instance.

--
Dave Mausner, Senior Manager, Braun Consulting Inc., Chicago.



Wed, 18 Jun 1902 08:00:00 GMT
 Database Configuration Assistant for 8i
Thanks.  Bumping up the page file size worked like a champ.  I know have two
separate instances created on this server.


Quote:

> > The databases were configured using the defaults from the Database
> > Configuration Assistant.  I have another server currently running two
> > databases right now, so I know it can be done.



> > > You don't say how you configured the databases, but it is definitely
> > > possible to run two on a server with 256M.  In fact you can run three
or
> > > more.

> I hit this problem a few days ago. The box had 128 megs, but still gave
> me an "out of memory" error. I drastically increased the virtual memory,
> and now I can have both instances running without problem (granted, with
> only 128 MB on NT with 8i, they run a little slow due to some heavy
> swapping, but the out of memory error hasn't occured again).
> Another thing you may want to do is drop the java pool size down from
> the default ~20MB to 4 or 5 MB unless you need really need it that high.

> Cheers,
> GC



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Create a database by Database Configuration Assistant

2. Things to change after running Database Configuration Assistant?

3. Database Configuration Assistant

4. 9i Database Configuration Assistant hangs on windows 98

5. Database Configuration Assistant?

6. why Database Configuration Assistant hanged at 50%

7. Datavase cannot be created in Oracle8i after installation by using Oracle Database Configuration Assistant:

8. Problems with Database configuration Assistant

9. Problems with Database configuration assistant

10. Error in Oracle Database Cache Configuration Assistant

11. Cannot add database in Client Configuration Assistant

12. Database Administration Assistant doesn't work // *8i, NT, sp4


 
Powered by phpBB® Forum Software