Hello mitchell,
have you looked at the mail on unix that you have created after running your
job?
Set up your job as follows in the cron:
05 00 * * * ORA_ADM/dbash/script1.sh >> ORA_ADM/dbalog/script1.log 2>&1
Then insure that you have
#!/bin/ksh (or the shell of your preference)
as your first line.
Peter
--
Peter Lomax
email: plomax_at_oriole.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
----- Original Message -----
From: "Mitchell" <mitchell_at_comnet.ca>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Sunday, January 21, 2001 11:45 PM
Subject: Re: [cannot connect]
> I have another question related to this
>
> I run following test.sh and could be run and create log at shell but when
I
> setup this as cron job. if carried on at /var/cron/log (this is Solairo
> 2.7)
> but never create log as at command line. What is wrong
>
>
> ## test.sh
> svrmgrl <<EOF
> connect internal
> spool /tmp/archive.log
> archive log list;
> spool off
> exit
> EOF
>
>
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Sunday, January 21, 2001 2:20 PM
>
>
> > Orapwd utility is used to set no of DBA accounts allowed on that
database
> &
> > password for sys account. Have U changed sys user password or set no of
> > allowed DBA accounts to 0 or something ?. Try connecting using svrmgr
as
> > follows.
> >
> > 1. login as the default os user account who owns oracle . ( must be
oracle
> on
> > unix )
> > 2. start server manager.
> > 3. svrmgr> connect internal;
> >
> > must connect this time. Other wise check up what unix user login u have
> looged
> > into . If not oracle account, then connect internal won't work.
> >
> > Jay
> >
> >
> > archana_at_smart-Tech.com.np wrote:
> > hi..
> >
> > I am a novice in oracle, I try connect using internal and it gives an
> error
> > Insufficient privileges.
> > this error came up after I used orapwd utility..
> > can anyone suggest anything.
> >
> > thanks
> > archana
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: archana_at_smart-Tech.com.np
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> >
> >
> > ____________________________________________________________________
> > Get free email and a permanent address at http://www.netaddress.com/?N=1
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: S Jayakumar
> > INET: sjayakumar2000_at_usa.net
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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.com
> --
> Author: Mitchell
> INET: mitchell_at_comnet.ca
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Mon Jan 22 2001 - 01:34:47 CST
