Re: Please help - ORA 04030: out of process memory...

"Henry" <henry_2303_at_hotmail.com> wrote in message news:<hJqDa.350257$w7k.193583_at_news04.bloor.is.net.cable.rogers.com>...
> Paul,
>
> Thanks. I did not find any notes in the readme file about the minimum size
> od shared_pool_size for the upgrade in the readme file of the 8.1.7.2.1
> patch. But I believe the minimum size is about 52MB (at least that was
> minimum for the installation).
> I tried also 150MB but it did not helped.
>
> Also the "select * from duc$ where PACK='JIS$INTERCEPTOR$';" and subsequent
> delete they added only in 8.1.7.3 version. I'm not sure if I should do it
> also for the older patch...(?)
>
> FYI, patching to the 8.1.7.3 works fine on the same hardware and same init
> file setting. I'n just having lots of problems with this 8.1.7.2.x version.
> Unfortunately this one is certified and has to be used...
>
> Regards,
> Henry
>

Henry,

I had 8.1.7 running on a laptop (W2K Pro) with 80 MB of physical memory - but I am not sure if I ever applied any patchsets to databases on the laptop. We usually just copied clones from a test server to laptops - so that no rebuild was required.

We did not use 8.1.7.2.1 - until after 8.1.7.2.6 was released. This is when I first applied the 8.1.7.2.x to our dev database:

# applied patch set 8.1.7.2.1, 8.1.7.2.6 - 9:01 PM 1/2/2002

those patchsets were applied without issue. This was on a box with 1024 MB physical memory, single instance. There was no java machine in this database.

  shared_pool_size         = 100663296
  large_pool_size          = 4194304
  java_pool_size           = 1048576 
  db_block_buffers         = 49152
  db_block_size            = 8192

Wed Jan 02 21:06:48 2002
alter database open
Wed Jan 02 21:06:49 2002
Thread 1 opened at log sequence 37088
  Current log# 7 seq# 37088 mem# 0: H:\ORACLE\ORADATA\DEV\REDO7A.LOG   Current log# 7 seq# 37088 mem# 1: I:\ORACLE\ORADATA\DEV\REDO7B.LOG Successful open of redo thread 1.
Wed Jan 02 21:06:49 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Jan 02 21:06:51 2002
Updating 8.1.7.1.1 NLS parameters in sys.props$ -- adding 8.1.7.2.1 NLS parameters.
Completed: alter database open
Wed Jan 02 21:08:09 2002
Shutting down instance (immediate)
License high water mark = 1
Wed Jan 02 21:08:09 2002
ALTER DATABASE CLOSE NORMAL
Wed Jan 02 21:08:09 2002
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Jan 02 21:08:12 2002
Thread 1 closed at log sequence 37088
Wed Jan 02 21:08:12 2002
Completed: ALTER DATABASE CLOSE NORMAL
Wed Jan 02 21:08:12 2002
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
archiving is disabled
Wed Jan 02 21:08:13 2002
ARCH shutting down
ARC0: Archival stopped

no errors.

If you can use it - maybe use 8.1.7.2.6 instead of just 8.1.7.2.1?

sorry about the irrelevant large memory stuff - I forget that this box had either 384 or 512 MB of memory.

Paul Received on Wed Jun 04 2003 - 19:09:30 CDT