Change file windows on a volume - RMS-E-ACC, ACP file access failed

[Toine_1]

Hi,

After changing the window size of a database disk, an Oracle 8.1.7 database couldn't be opened anymore.

I have rather large database files 4 Gbyte.
To reduce the window turn rate I increased the file window size from 7 to 72.

$ set volume datadisk1/windows=72

When I tried to open a Oracle 8.1.7 database on Alpha (8.3) I got this error:

…
Redo Buffers 180224 bytes
Database mounted.
ORA-01116: error in opening database file 186
ORA-01110: data file 186: 'DBI_R20:[ORADIR]DBI002_2.RBS'
ORA-27041: unable to open file
%RMS-E-ACC, ACP file access failed
SVRMGR> Server Manager complete

What else should I change to avoid this error?

/Toine

[Hein van den Heuvel · Accepted solution]

I suspect that the BUFFER IO QUOTA for the oracle user was on the low side and now too low. There is a minor possiblity that you are running out of system poool, but that's unlikely

Here is one place I knew this to be documented:

http://www.openvms.compaq.com/doc/731final/4523/4523pro_007.html

"The system resources required for retrieval windows are subtracted from the buffered I/O quota of the process"


Here is what I would do:
1) Switch back to the small windows.
2) Observe process quota and pool before starting oracle (or starting NO MOUNT) :
-- $ SHOW MEMORY / POOL
-- $ SHOW PROCESS / CONT ... hit Q for Quota
3) Start oracle and confirm it works.
4) Repeat quota and pool observation.. how deep did you dig in?
5) Adjust quota (and/or pool) 'way up'
6) Set larger window size
7) Repeat Oracle start (works now?) and quota/pool observations.

Note 1)
The Quota usage would depend on how many database files need to be opened. Does this DB really have (more than) 186 files? Yikes... you may want to try to consolidate that some.

Note 2)
It would be kinda sad to see a window size increase actually helped for an oracle application.
One would hope your DB files are little or not fragmented and that most DB files rarely grow (auto-extend only a active on a few files).

Hope this helps,
Hein.

[Toine_1]

Increasing the window size of a disk didn't reduce the window turn rate. I think this is normal for Oracle 10g on OpenVMS.

Hein thank for your answer that helped.

/Toine