libsdeora11gsrvr93.so error with SDE 9.3.1

Question

Original User: peasland

I am running Oracle 11g on Linux 64-bit. I installed SDE 9.3.1 with no problems. SDE starts just fine. When I attempt to connect to SDE with ArcCatalog, I get the following error in my sde.log file:

/u01/app/sde/sdeexe93/bin/gsrvr: error while loading shared libraries: libsdeora11gsrvr93.so: cannot open shared object file: No such file or directory

I have verified that the lib file is readable. It is owned by sde after all. The sde user has oinstall as its primary group. LD_LIBRARY_PATH is set correctly in my environment and in my dbinit.sde file.

Any other suggestions?

Cheers,
Brian

class2.png

class.png

BrunoDiGiuseppe_0-1624261779069.png

JayantaPoddar_0-1624259621730.png

VinceAngelo · Answer

What user starts the 'sdemon' application?
 
One way to find out what's wrong with the environment is to replace 'gsrvr'
with a shell script that dumps the environment (and possibly a ldd of the 
superceeded gsrvr).
 
It's just about time to contact Tech Support on this issue.  The only time
I've seen something similar was on a client's HP/UX host where the 64-bit
install binaries had been corrupted by a silent disk failure. 
 
- V

Anonymous User · Answer

Original User: peaslandDoes the giomgr process user's .profile, .bash_profile or .bashrc clear the contents of 
PATH or LD_LIBRARY_PATH?

}

Those files do not clear the env vars. I do not have a .profile file. Here is the contents of my .bashrc file:

# .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
        . /etc/bashrc
fi

Here is my .bash_profile file:

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=.:$PATH:$HOME/bin

export PATH

export SDEHOME=/u01/app/sde/sdeexe93
export ORACLE_HOME=/u01/app/oracle/product/db/11.1.0
export ORACLE_SID=fgodev3

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$SDEHOME/lib

export PATH=$SDEHOME/bin:$ORACLE_HOME/bin:$PATH

To start SDE, I just entered:

sdemon -o start -p password

So I'm not doing anything fancy here. Just set the env vars and startup SDE.

Thanks,
Brian

VinceAngelo · Answer

Does the giomgr process user's .profile, .bash_profile or .bashrc clear the contents of 
PATH or LD_LIBRARY_PATH?
 
By the time the dbinit.sde is consulted, it's too late to set the SDEHOME or LD_LIBRARY_PATH.
My ArcSDE boot script executes $SDEHOME/etc/.profile to establish database-specific
environment variables before executing 'sdemon -o start'. This way I only need to put the 
ORACLE_SID or TWO_TASK (and possibly NLS_LANG) in the dbinit.sde (and can use the
same profile for all Oracle instances, regardless of ArcSDE release).
 
My complete multi-instance Linux boot script framework is buried in the se_toolkit release
tree (in all release bundles, under samples/boot/redhat_etc).
 
- V
 
### $SDEHOME/etc/.profile ###
ORACLE_HOME=/opt/oracle/product/10.2.0/db32
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORACLE_HOME NLS_LANG LD_LIBRARY_PATH
 
### $SDEHOME/etc/dbinit.sde ###
set ORACLE_SID=xxxx10g2
unset TWO_TASK
 
### /etc/init.d/arcsde ###
 
Start_SDE()
{
... 
# .. Set environment variables
#
SDEHOME=$2
PATH=$SDEHOME/bin:$origPATH
LD_LIBRARY_PATH=$SDEHOME/lib:$origLD
SDEVERBOSE=$3
export SDEHOME PATH LD_LIBRARY_PATH SDEVERBOSE
 
# .. Retrieve password
#
if [ -f $SDEHOME/etc/.passwd ]; then
sdepass=`cat $SDEHOME/etc/.passwd`
else
report_error ERROR &&
printf "	--> $SDEHOME/etc/.passwd not found
"
return 1
fi
 
# .. Execute etc/.profile (if present)
#
if [ -f $SDEHOME/etc/.profile -a ! -x $SDEHOME/etc/.profile ]; then
report_error ERROR &&
printf "	--> $SDEHOME/etc/.profile not executable
"
return 1
fi
test -x $SDEHOME/etc/.profile && . $SDEHOME/etc/.profile
 
# .. Execute command
#
sdemon -o start -i $1 -p $sdepass >> $logFile 2>&1
...
}