Coredump created when executing SqlPlus & SqlLoader from crontab!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Coredump created when executing SqlPlus & SqlLoader from crontab!

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    2

    Unhappy

    Coredump created when executing SqlPlus & SqlLoader from crontab!

    It all started after replacing our server Unix. Data was recovered from a backup don eon the old server.
    We also have some cases of brutal shutdown of the server, without any obvious reason. I don't think it's connceted to the coredump. It's not the same time.

    Execution of shell with following statement ended with a coredump:
    echo exit | sqlplus girard/girard @sqls/cde_jour >! /dev/null
    gave:
    Execution of cde_jour.sh le 01-04-01 a 05:00
    sqlplus: Segmentation violation -- Core dumped

    Was executed from crontab
    0 5 1 * * /bin/csh /u/oracle/cde_jour.sh >/u/oracle/cde_jour.log

    Statements after the sqlplus-command was NEVER executed!
    The reason must be that the shell terminated in coredump at exit from SlqPlus!

    Why does it work manually, but not when executed by crontab?
    We also have problem with application using SqlLoader. Works when executed manual, but fails (not always) when executed by crontab.

    System: Unix - SCO OpenServer(TM) Release 5
    Version Oracle: Version: 7.3.4.0.0.
    Version SqlPlus: SQL*Plus: Release 3.3.4.0.0

    Hoping for a quick answer!

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Can you post /u/oracle/cde_jour.sh here.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width