Unable to import orchestrate schema definition from database

[parameswar]

Hi,
I am new to configuration in datastage.
When I am trying to connect to Oracle from DS Server , I am unable to connect. I am getting the error :

"SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory".

Please help me how ORACLE_HOME is to be set in Oracle software directory.


Regards,
Sahoo

[DSguru2B]

Do you have oracle client installed on your datastage server? If yes then you need to set ORACLE_HOME to point to it in the dsenv file presend in DSHOME directory.
DSHOME = cd `/.dshome`

[parameswar]

Do you have oracle client installed on your datastage server? If yes then you need to set ORACLE_HOME to point to it in the dsenv file presend in DSHOME directory.
DSHOME = cd `/.dshome`

ORACLE_HOME is set in dsenv file as given below :

DSHOME=`cat /.dshome`
export DSHOME
DSHOME=/home/dsadm/Ascential/DataStage/DSEngine; export DSHOME
APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine; export APT_ORCHHOME
HOME=${HOME:-/}; export HOME
..................
...
Shall I include DSHOME = cd `/.dshome` and delete DSHOME=`cat /.dshome`

Thanks
Parameswar

[parameswar]

Do you have oracle client installed on your datastage server? If yes then you need to set ORACLE_HOME to point to it in the dsenv file presend in DSHOME directory.
DSHOME = cd `/.dshome`

Yes, Oracle client is installed in DS Server. ORACLE_HOME is set in dsenv file as given below :

DSHOME=`cat /.dshome`
export DSHOME
DSHOME=/home/dsadm/Ascential/DataStage/DSEngine; export DSHOME
APT_ORCHHOME=/home/dsadm/Ascential/DataStage/PXEngine; export APT_ORCHHOME
HOME=${HOME:-/}; export HOME
..................
...
Shall I include DSHOME = cd `/.dshome` and delete DSHOME=`cat /.dshome`

Thanks
Parameswar

[DSguru2B]

No. Dont change anything. It actually is cat `/.dshome`. That was a typo on my end. Anywho, I dont see ORACLE_HOME set in your dsenv file. cat `/.dshome` is not for oracle home.

[parameswar]

No. Dont change anything. It actually is cat `/.dshome`. That was a typo on my end. Anywho, I dont see ORACLE_HOME set in your dsenv file. cat `/.dshome` is not for oracle home.

Hi, I have set oracle_home as ORACLE_HOME=/u00/app/oracle/product/10.2.0 export $ORACLE_HOME

And it is included in SHLIB_PATH as ..:$ORACLE_HOME:$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/ctx/lib:$ORACLE_HOME/rdbms/lib32 ........

Please helpme , whether it is right or anyother thing I have to include for ORACLE_HOME.

Thanks,
Parameswar

[DSguru2B]

After making the changes, you need to stop and start the datastage engine.