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
Unable to import orchestrate schema definition from database
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Unable to import orchestrate definition from Datastage
ORACLE_HOME is set in dsenv file as given below :DSguru2B wrote: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`
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
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Re: Unable to import orchestrate definition from Datastage
parameswar wrote:Yes, Oracle client is installed in DS Server. ORACLE_HOME is set in dsenv file as given below :DSguru2B wrote: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`
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
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Hi, I have set oracle_home as ORACLE_HOME=/u00/app/oracle/product/10.2.0 export $ORACLE_HOMEDSguru2B wrote: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.
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