Jobs and Environment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Jobs and Environment

  1. #1
    Join Date
    Nov 2001
    Posts
    118

    Jobs and Environment

    Hi Everyone,

    I have this strange problem concerning jobs on two identical Orcale 9i Databases on two different Solaris servers.

    When I create a job, one machine keeps the NLS environment parameters set on the server (as it should), but the other takes the environment from the client and uses this for the job to run on the server (which then promptly throws an error).

    This problem is independent of the clients used.

    The date format is the actual problem, but does anyone know how to tell the server to ignore the environment parameters of the client?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you set NLS parameters at client side then it will be used, compare the environment variables

  3. #3
    Join Date
    Nov 2001
    Posts
    118
    Hi Pando,

    That's the strange thing about it. The problem lies somewhere on the server side, because independently of the local client environment settings (tested with several clients), one server responds correctly and the other takes the client environment.

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