Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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