Connecting to an oracle table using oracle enterprise stage!

msarkar00 · Post by **msarkar00** » Tue Dec 19, 2006 11:01 am

*** 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??

us1aslam1us · Post by **us1aslam1us** » Tue Dec 19, 2006 11:05 am

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

Sam

ray.wurlod · Post by **ray.wurlod** » Tue Dec 19, 2006 2:43 pm

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.

johnthomas · Post by **johnthomas** » Tue Dec 19, 2006 3:09 pm

HINTS

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

keshav0307 · Post by **keshav0307** » Tue Dec 19, 2006 7:05 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Dec 19, 2006 10:35 pm

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