Re: ORA-12545 When running the job from Crontab ...

From: Kimberly Smith <KSMITH1_at_gmd.fujitsu.com>
Date: 03 May 2000 14:29:03 -0700
Message-Id: <10486.104887@fatcity.com>

--=_ORCL_5973049_0r0

Content-Type:text/plain; charset="iso-8859-1" Content-Transfer-Encoding:quoted-printable

Are you setting your environment in the script? When running from cron it does not actually run it as the user who submits it so you must set things like ORACLE_HOME/ORACLE_SID/ PATH and any other thing you need. You could just source your .profile if its not interactive.

Kimberly Smith
EDS/Fujitsu
Gresham, Oregon
Work: 503-669-6050
Email: kimberly.smith_at_gmd.fujitsu.com

kimberly.smith_at_eds.com

--=_ORCL_5973049_0r0

content-type:message/rfc822

Date: 03 May 2000 13:11:18
From:Janardhana Babu <jbdonga_at_ucdavis.edu> To:Multiple recipients of list ORACLE-L <ORACLE-L> Subject:ORA-12545 When running the job from Crontab ... Reply-to:UNIX.IOGMD:ORACLE-L_at_fatcity.com Return-Path:root_at_fatcity.cts.com

Message-ID:<F001.00157695.20000503121118_at_fatcity.com> X-Comment:Oracle RDBMS Community Forum
X-Sender:Janardhana Babu <jbdonga_at_ucdavis.edu> Sender:root_at_fatcity.com
Errors-To:ML-ERRORS_at_fatcity.com
Organization:Fat City Network Services, San Diego, California X-ListServer:v1.0f, build 68; ListGuru (c) 1996-2000 Bruce A. Bergman Precedence: bulk
MIME-Version: 1.0
Content-Type:text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding:7bit

Dear List,

When Running a Pro*C job manually, it runs ok. If the same job is run thru crontab, it generates an error ORA-12545. The DB is 8.0.4.2.1 on HP-UX 10.20. I need to help my developers as soon as possible. I could simulate their problem by slightly modifying sample1.pc as follows.

username "scott" changed to "/"
EXEC SQL CONNECT :username IDENTIFIED BY :password; ---> changed to EXEC SQL CONNECT :username;
Commented out interactive question as follows: /* printf("\nEnter employee number (0 to quit): "); gets(temp_char); emp_number = atoi(temp_char); */

The reason for changing the username and password is: This is how my developers are using to login from pro*c programs on all the boxes which is working fine except on this box.

If run this program manually, it runs ok. Gets into the DB and gets out. When run thru crontab, it generates ora-12545 error. Any clues?

Any help is appreciated.

Thanks,
-- Janardhana Babu

-- 
Author: Janardhana Babu
  INET: jbdonga_at_ucdavis.edu

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




--=_ORCL_5973049_0r0--




------------------------------

 From: Steve Boyd <pimaco_oracle_at_yahoo.com>
 Date: Wed, 3 May 2000 17:46:23 -0700 (PDT)
 Subject: Re: Core dump with ora 7445

ORA 7445 errors are like ORA 600 errors.  Check metalink to see if someone else has encountered
this and call Oracle support.  No they are not normal, and probably some bug in the software.  It
happens.

Steve Boyd

--- Jack van Zanen <nlzanen1_at_ey.nl> wrote:
> 
> 
> 
> 
> Hi All,
> 
> 
> We had some coredumps while running an insert statement with following message
> 
> ******************************
> 
> Errors in file /data/oracle8/disk1/PIVT/admin/udump/ora_25466_pivt.trc:
> ORA-07445: exception encountered: core dump [11] [0] [0] [] [] []
> ORA-00001: unique constraint (CABS.PKY_C_SECURITY_RLSHP) violated
> 
> ******************************
> we received a message on the client with the catch all message 'end of file on
> communication channel ........' and a coredump on UNIX.
> 
> I know that Oracle did/does not like the unique key violation, but is it normal
> behaviour to coredump on it??
> I would expect a message to the client saying it is a unique key violation.
> 
> Can anybody shed some light as to why this would happen (Later on we ran the
> proces as a different user and had no problems,
> oracle just returned the violation error to the client)
> 
> The only reason I can think of for now is that Oracle generated the
> message ORA-00001 and had problems delivering it to the client so
> decided to coredump instead but that is just guessing
> 
> TIA
> 
> 
> Jack
> 
> 
> 
> 
> 
> ===================================================================
> De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
> de geadresseerde. Gebruik van deze informatie door anderen dan de
> geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
> en/of verstrekking van deze informatie aan derden is niet toegestaan.
> Ernst & Young staat niet in voor de juiste en volledige overbrenging van de
> inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
> ===================================================================
> The information contained in this communication is confidential and may be
> legally privileged. It is intended solely for the use of the individual or
> entity to whom it is addressed and others authorised to receive it. If you
> are not the intended recipient you are hereby notified that any disclosure,

Received on Wed May 03 2000 - 16:29:03 CDT