Oracle connectivity issues after machine reboot

[iliyas]

Hi,

DataStage v8.1 is installed on a Solaris box and we had a accidental reboot of this machine. After the reboot, we are not able to connect to the Oracle database which used to work perfectly fine before. We are encountering the following error message.

>##E IIS-DSEE-TOSH-00205 12:35:46(006) <main_program> PATH search failure:
>##E IIS-DSEE-TFOG-00006 12:35:46(007) <main_program> Error loading "orchoracle": Could not load "orchoracle": ld.so.1: osh: fatal: /oracle/oracle9/lib32/libclntsh.so.10.1: wrong ELF class: ELFCLASS32.
>##E IIS-DSEE-TOSH-00384 12:35:46(008) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers

Can you please help us to resolve this issue.

[ray.wurlod]

Welcome aboard. Have you done all the things suggested in the error messages, in particular checked your shared library and command search lists?

[iliyas]

Yes. I've made all the entries related to ORACLE_HOME in PATH and LD_LIBRARY_PATH. One input here is that the OS is Solaris 9 (SPARC) and the Database is Oracle 10.2.0.1. So, please let me know whether I have to include default "lib" which will have 64-bit binaries or do I need to include "lib32" because the DS is a 32-bit system. Please find the snippet of dsenv file that I have.

#!/bin/sh
####################################################################
#
# dsenv - DataStage environment file
#
# Licensed Materials - Property of IBM (c) Copyright IBM Corp. 1997, 2007 All Rights Reserved.
# This is unpublished proprietary source code of IBM Corporation
# The copyright notice above does not evidence any actual or
# intended publication of such source code.
#
# This script is sourced by the DataStage dsrpcd daemon to establish
# proper environment settings for DataStage client connections.
#
# This script may also be sourced by bourne shells to establish
# proper environment settings for local DataStage use.
#
####################################################################

# PLATFORM SPECIFIC SECTION

set +u

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

if [ -z "$DSHOME" ]
then
DSHOME=/opt/IBM/InformationServer/Server/DSEngine; export DSHOME
fi

if [ -z "$DSRPCD_PORT_NUMBER" ]
then
true
##DSRPCD_PORT_NUMBER_TAG##
fi

if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=/opt/IBM/InformationServer/Server/PXEngine; export APT_ORCHHOME
fi

#if [ -z "$UDTHOME" ]
#then
UDTHOME=/opt/IBM/InformationServer/Server/DSEngine/ud41 ; export UDTHOME
UDTBIN=/opt/IBM/InformationServer/Server/DSEngine/ud41/bin ; export UDTBIN
#fi

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

#if [ -z "$ASBHOME" ]
#then
#ASBHOME=`dirname \`dirname $DSHOME\``/ASBNode
#export ASBHOME
#fi


ORACLE_HOME=/oracle/oracle9; export ORACLE_HOME
NLS_LANG=AMERICAN_AMERICA.UTF8
TNS_ADMIN=$ORACLE_HOME/network/admin

if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME

#LANG="<langdef>";export LANG
#LC_ALL="<langdef>";export LC_ALL
#LC_CTYPE="<langdef>";export LC_CTYPE
#LC_COLLATE="<langdef>";export LC_COLLATE
#LC_MONETARY="<langdef>";export LC_MONETARY
#LC_NUMERIC="<langdef>";export LC_NUMERIC
#LC_TIME="<langdef>";export LC_TIME
#LC_MESSAGES="<langdef>"; export LC_MESSAGES

LD_LIBRARY_PATH=$ASBHOME/apps/jre/lib/sparcv9/server:$ASBHOME/apps/jre/lib/sparcv9:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/sunos-all-sparc_64:`dirname $DSHOME`/bra
nded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:/oracle/oracle9/lib32:$LD_LIBR
ARY_PATH
export LD_LIBRARY_PATH


PATH=$PATH:$ORACLE_HOME/lib32:$ORACLE_HOME/bin
export PATH
fi

[swarnkar]

have you had restart the ds server after changes have been made to dsenv ?

At times it works as dsenv will refresh values of all the variables.


Regards,
Nitin Swarnkar

[swarnkar]

have you had restart the ds server after changes have been made to dsenv.

At times it works as dsenv will refresh values of all the variables.


Regards,
Nitin Swarnkar