I strongly suspect the problem involves environmental variables.
One way to test this is from your interactive session do -
env | sort -o /tmp/int.env
Within your cron script do
env | sort -o /tmp/cron.env
Next do
cd /tmp
diff int.env cron.env
Then make you cron environment match your interactive environment.
HTH & YMMV
HAND!
"Bahar, Rivaldi
(BBASSI-CHQ)" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
assi.com> Subject: RE: Unable to lock file
Sent by:
[EMAIL PROTECTED]
03/28/2003 02:03
PM
Please respond to
ORACLE-L
The error is not specific to that database.
At other time, the same error occured when starting other database.
(I shutdown some small databases for daily cold backup).
That's my question too, so far, why I'm able to start manually
at daytime. May be less number of locks ?
Thanks.
-----Original Message-----
Sent: Friday, March 28, 2003 4: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.
[EMAIL PROTECTED]
-----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.
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
****************************************************************************
************************************
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
****************************************************************************************************************
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
