1753472 Members
4874 Online
108794 Solutions
New Discussion юеВ

Problem in MC/SG OPS Env

 
pang_3
Occasional Advisor

Problem in MC/SG OPS Env

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
3 REPLIES 3
Massimo Bianchi
Honored Contributor

Re: Problem in MC/SG OPS Env

Hi,
please post a

ll /dev/cxvg09/rcxlv4_003


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


HTH,
Massimo
Julio Yamawaki
Esteemed Contributor

Re: Problem in MC/SG OPS Env

HI,

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

Regards.
Indira Aramandla
Honored Contributor

Re: Problem in MC/SG OPS Env

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
Never give up, Keep Trying