DSXchange

*** Error executing command: orchdbutil show D3_CUSTOMERS_INTERFACE_ALL -dbtype oracle -server psdev -dboptions *********
##I TFCN 000001 16:55:21(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.2
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TUTL 000031 16:55:21(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TCDU 000005 16:55:21(002) <main_program> Unable to access database {0}DB type 'oracle' presumed to be oracle.
##E TCDU 000002 16:55:21(003) <main_program> Unable to access database {0}Oracle: not present
##E TCDU 000006 16:55:21(004) <main_program> Unable to access database {0}Unable to load library 'orchoracle'.

Could anyone help??

Do an exact search on "Unable to access database" you will have good responses in previous posts.

Sam

The messages you've posted suggest that the Oracle client software is not installed or not properly configured on one or more of the DataStage processing nodes.

HINTS

You may need the 32 oracle client installed in your server . Also
check your environment setting in
/var/dstage/Ascential/DataStage/DSEngine/dsenv

and if it is installed then check the path is defined in the environment.

Paths. Command directory search path (PATH) and shared library directory search path (LD_LIBRARY_PATH or SHLIB_PATH or LIBPATH depending on your operating system).