reg Oracle client software

[san_deep]

hi All,
i am trying to import the metadata of the table by load->import ->Orchestrate Schema Definition.
After giving the Credentials there i am getting the error as "Cannot get the Schema Definition for requested Database Table".

When Checking the "output from server command" it s giving the error as :-
"*** Error executing command:
orchdbutil show TABLE NAME -dbtype oracle -server HCENTRIC -dboptions *********"

the following is the env file i am using:-
"
set +u

if [ -z "$DSHOME" ] && [ -f "/.dshome" ]
then
DSHOME=`cat /.dshome`
export DSHOME
fi

if [ -z "$DSHOME" ]
then
DSHOME=/drpnet/devel/apps/dsadm/Ascential/DataStage/DSEngine; export DSHOME
fi

if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=/drpnet/devel/apps/dsadm/Ascential/DataStage/PXEngine; export APT_ORCHHOME
fi

if [ -z "$UDTHOME" ]
then
UDTHOME=/drpnet/devel/apps/dsadm/Ascential/DataStage/ud41; export UDTHOME
UDTBIN=/drpnet/devel/apps/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN
fi

"dsenv" 71 lines, 2048 characters

"

can any one of you please guide me in resolving the issues i am facing above
>also how to define the Oracle client software in ds?
>Also i am getting error due to NLS setting as:-
"An NLS character map <ISO-8859-1> is specified, but NLS_LANG is not set;
the NLS character map must be set to an ICU codepage which is equivalent to
the character set specified by NLS_LANG"
whether Oracle client software this is there or not.

thanks in advance for your time n support.

[ray.wurlod]

Search the forum for techniques. Oracle client software must be installed and configured - for example you will need Oracle environment variables such as ORACLE_HOME and possibly ORACLE_SID in your dsenv file. You will also need tnsnames.ora properly set up. Consult your Oracle DBA for advice - this part is not a DataStage question.

The message about NLS is self-explanatory - if you are using NLS in DataStage then the environment variable NLS_LANG needs to be set to a compatible map (code page). You may find that you also have to set the environment variable LANG_C.