Oracle-L: RE: Unable to lock file

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Mon, 31 Mar 2003 10:13:50 -0800
Message-ID: <F001.005766A3.20030331101350@fatcity.com>

Shutdown will NOT rebuild the kernel, you must do that manually. On HP use SAM as it does all of the work for you. Also, take a look at the owner and group associated with that file. I've seen that cause the same problems, especially the 'file already in use' one. If that doesn't fix the problem, try running an fuser command (MUST be root) against the file to find the process id that is using the file.

Dick Goulet

-----Original Message-----
Sent: Monday, March 31, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L

Shutdown will automatically rebuild the kernel. Please correct me if I'm wrong.

-----Original Message-----
Sent: Friday, March 28, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L

On HP you must rebuild the kernel for the change to take effect.

Allan

-----Original Message-----
Sent: Friday, March 28, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L

Rivaldi

That requires way more Unix knowledge than I have and we don't run HP anyway.

If it was simply the number of locks, why would you be able to start the database manually? In your cron job, is this the last database that is started? If it is the number of locks, I would think the last database started would consistently have the problem. Just some thoughts for you to consider.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, March 28, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L

Dennis,
I had set user profile prior to submit the job. It works fine for other databases.
Is there any unix command to know the number of files locks currently used ?
I have nflocks = 1000 (unix command : kmtune -q nflocks) and wondering how many locks currently available.

Thanks
Rivaldi

-----Original Message-----
Sent: Friday, March 28, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L

Rivaldi

Try to figure out what is different when cron starts the instance vs. your starting the instance. Some parameter is getting set or not getting set. For most Unix versions the "env" command dumps all environment variables. Do that for your interactive session and then add that to the script cron is executing and then manually execute the script.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L

Hi Listers,

Oracle 8174, HP 11.00

I got the following error when starting up the database thru crontab job at 2 am in the morning. It happened after we shutdown the unix machine.

Errors in file /u07/app/oracle/admin/sfmsprod/bdump/dbw0_1705_sfmsprod.trc:

ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/u05/oradata/sfmsprod/fmidx_02.dbf'
ORA-27086: skgfglk: unable to lock file - already in use

HP-UX Error: 46: No locks available

I increased the nflocks parameter from 200 to 1000 as Metablink said. But still got the error.
Any idea why ?
At 8 am when I get in the office, I startup the database manually and everything
was OK.

Thanks.
Rivaldi

This e-mail, including any attachments, may include confidential and/or proprietary information,
and is intended for use only by the person or entity to which it is addressed. If the reader of this
e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have
received this e-mail in error, please notify the sender by replying to this message and delete
this e-mail immediately.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Bahar, Rivaldi (BBASSI-CHQ)
INET: rivaldi.bahar_at_bbassi.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Bahar, Rivaldi (BBASSI-CHQ)
INET: rivaldi.bahar_at_bbassi.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

__
This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Nelson, Allan
INET: anelson_at_midf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Bahar, Rivaldi (BBASSI-CHQ)
INET: rivaldi.bahar_at_bbassi.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Goulet, Dick
INET: DGoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------