topic Re: Problem in MC/SG OPS Env in Operating System - HP-UX

Problem in MC/SG OPS Env

pang_3 — Sat, 17 Jul 2004 07:31:58 GMT

I met a problem when i create tablespace in an OPS cluster.
When i execute

Create tablespace TBS_CX_3
DataFile
'/dev/cxvg08/rcxlv4_003' Size 4095M AutoExtend Off,
'/dev/cxvg09/rcxlv4_003' Size 4095M AutoExtend Off,
'/dev/cxvg04/rcxlv2_002' Size 2047M AutoExtend Off
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M
ONLINE

It replies such message

ORA-01157: cannot identify/lock data file 185 - see DBWR trace file
ORA-01110: data file 185: '/dev/cxvg09/rcxlv4_003'

and i checked the device file it's ok,how can i solve it.

thks

Re: Problem in MC/SG OPS Env

Massimo Bianchi — Sat, 17 Jul 2004 07:55:20 GMT

Hi,
please post a

ll /dev/cxvg09/rcxlv4_003

from both nodes,
and the parameters db_files from initSID.ora.

HTH,
Massimo

Re: Problem in MC/SG OPS Env

Julio Yamawaki — Sun, 18 Jul 2004 19:34:59 GMT

HI,

Increase the processes file size limit ("ulimit") and retry.

Regards.

Re: Problem in MC/SG OPS Env

Indira Aramandla — Sun, 18 Jul 2004 21:12:24 GMT

Hi Pang,

Oracle gets a OS file lock using a function "skgfglk"

It would appear that the kernel parameter for the number of connurrent locks is not high enough.

Increase the processes file size limit ("ulimit") and retry.

Indira A