DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Apr 2001


    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
    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:
    Version SqlPlus: SQL*Plus: Release

    Hoping for a quick answer!

  2. #2
    Join Date
    May 2000
    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