linux7.4+oracle11.2.0.4初始化sde10.0空间数据

6 篇文章 0 订阅

arcgis10.0+sde服务器:windows2008x64

sde创建服务连接到linux数据库服务器上。数据库服务器不安装sde服务。但是需要创建sde空间对象,才能使windows上的sde服务可以连接到linux数据库上。

本次通过上传sde for linux版本介质,解压tar包,配置sde环境变量,然后安装相关的软件包解决了sdesetup进行install sde空间对象的问题。

oracle数据库服务器:centos7.4

[sde@ sde]$ cd /app/soft/sde/
[sde@ sde]$ ll
total 0
drwxrwxr-x 2 sde sde 161 Jul 9 21:48 oracle11g_64
[sde@ sde]$ cd oracle11g_64/
[sde@ oracle11g_64]$ ll
total 153924
-rw-rw-r-- 1 sde sde 18699 May 21 2010 01.toc
-rw-rw-r-- 1 sde sde 157460480 May 21 2010 02.tar
-rw-rw-r-- 1 sde sde 5366 May 21 2010 b5.nls
-rw-rw-r-- 1 sde sde 8648 May 21 2010 en.nls
-rw-rw-r-- 1 sde sde 52923 May 21 2010 install
-rw-rw-r-- 1 sde sde 9015 May 21 2010 ja.nls
-rw-rw-r-- 1 sde sde 9011 May 21 2010 jp.nls
-rw-rw-r-- 1 sde sde 10786 May 21 2010 ko.nls
-rw-rw-r-- 1 sde sde 7776 May 21 2010 th.nls
-rw-rw-r-- 1 sde sde 5366 May 21 2010 tw.nls
-rw-rw-r-- 1 sde sde 5335 May 21 2010 zh.nls
[sde@ oracle11g_64]$ chmod +x install
[sde@ oracle11g_64]$ ./install -load
-bash: ./install: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory
[sde@ oracle11g_64]$ exit
logout
[root@ soft]#
[root@ soft]#
[root@ soft]# yum install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc gcc-c++ libaio libaio-devel libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel
Configuration file /etc/yum/pluginconf.d/fastestmirror.conf not found
Unable to find configuration file for plugin fastestmirror
Configuration file /etc/yum/pluginconf.d/langpacks.conf not found
Unable to find configuration file for plugin langpacks
Package binutils-2.25.1-31.base.el7.x86_64 already installed and latest version
No package compat-libstdc++-33 available.
Package elfutils-libelf-0.168-8.el7.x86_64 already installed and latest version
Package elfutils-libelf-devel-0.168-8.el7.x86_64 already installed and latest version
Package glibc-2.17-196.el7.x86_64 already installed and latest version
Package glibc-common-2.17-196.el7.x86_64 already installed and latest version
Package glibc-devel-2.17-196.el7.x86_64 already installed and latest version
Package gcc-4.8.5-16.el7.x86_64 already installed and latest version
Package gcc-c++-4.8.5-16.el7.x86_64 already installed and latest version
Package libaio-0.3.109-13.el7.x86_64 already installed and latest version
Package libaio-devel-0.3.109-13.el7.x86_64 already installed and latest version
Package libstdc++-4.8.5-16.el7.x86_64 already installed and latest version
Package libstdc++-devel-4.8.5-16.el7.x86_64 already installed and latest version
Package 1:make-3.82-23.el7.x86_64 already installed and latest version
Package sysstat-10.1.5-12.el7.x86_64 already installed and latest version
Package unixODBC-2.3.1-11.el7.x86_64 already installed and latest version
Package unixODBC-devel-2.3.1-11.el7.x86_64 already installed and latest version
Nothing to do
[root@ soft]# yum install glibc.i686
Configuration file /etc/yum/pluginconf.d/fastestmirror.conf not found
Unable to find configuration file for plugin fastestmirror
Configuration file /etc/yum/pluginconf.d/langpacks.conf not found
Unable to find configuration file for plugin langpacks
No package glibc.i686 available.
Error: Nothing to do
[root@ soft]# yum install *glibc.i686*
Configuration file /etc/yum/pluginconf.d/fastestmirror.conf not found
Unable to find configuration file for plugin fastestmirror
Configuration file /etc/yum/pluginconf.d/langpacks.conf not found
Unable to find configuration file for plugin langpacks
http-CentOS7.4/filelists_db | 3.1 MB 00:00:00 
No package *glibc.i686* available.
Error: Nothing to do
[root@ soft]# rpm -aq|grep glibc
glibc-2.17-196.el7.x86_64
glibc-headers-2.17-196.el7.x86_64
glibc-common-2.17-196.el7.x86_64
glibc-devel-2.17-196.el7.x86_64
[root@ soft]# yum install *glibc*.i686*
Configuration file /etc/yum/pluginconf.d/fastestmirror.conf not found
Unable to find configuration file for plugin fastestmirror
Configuration file /etc/yum/pluginconf.d/langpacks.conf not found
Unable to find configuration file for plugin langpacks
No package *glibc*.i686* available.
Error: Nothing to do
[root@ soft]# yum install glibc.i686
Configuration file /etc/yum/pluginconf.d/fastestmirror.conf not found
Unable to find configuration file for plugin fastestmirror
Configuration file /etc/yum/pluginconf.d/langpacks.conf not found
Unable to find configuration file for plugin langpacks
No package glibc.i686 available.
Error: Nothing to do
[root@ soft]# yum install ld-linux.so.2
Configuration file /etc/yum/pluginconf.d/fastestmirror.conf not found
Unable to find configuration file for plugin fastestmirror
Configuration file /etc/yum/pluginconf.d/langpacks.conf not found
Unable to find configuration file for plugin langpacks
No package ld-linux.so.2 available.
Error: Nothing to do
[root@ soft]# pwd
/app/soft
[root@ soft]# cd /etc/yum
yum/ yum.repos.d/
[root@ soft]# cd /etc/yum.repos.d/
[root@ yum.repos.d]# ll
total 4
-rw-r--r-- 1 root root 106 Sep 19 2019 centos74.repo
drwxr-xr-x 2 root root 187 Sep 19 2019 default
[root@ yum.repos.d]# more centos74.repo
[http-CentOS7.4]
name=CentOS74 - http
baseurl=http://10.62.250.99//CentOS7/1810/dvd/
gpgcheck=0
enabled=1
[root@ yum.repos.d]# pwd
/etc/yum.repos.d
[root@ yum.repos.d]# pwd
/etc/yum.repos.d
[root@ yum.repos.d]# cd /app/soft/sde
[root@ sde]# ll
total 0
drwxrwxr-x 2 sde sde 161 Jul 9 21:48 oracle11g_64
[root@ sde]# cd oracle11g_64/
[root@ oracle11g_64]# ll
total 153924
-rw-rw-r-- 1 sde sde 18699 May 21 2010 01.toc
-rw-rw-r-- 1 sde sde 157460480 May 21 2010 02.tar
-rw-rw-r-- 1 sde sde 5366 May 21 2010 b5.nls
-rw-rw-r-- 1 sde sde 8648 May 21 2010 en.nls
-rwxrwxr-x 1 sde sde 52923 May 21 2010 install
-rw-rw-r-- 1 sde sde 9015 May 21 2010 ja.nls
-rw-rw-r-- 1 sde sde 9011 May 21 2010 jp.nls
-rw-rw-r-- 1 sde sde 10786 May 21 2010 ko.nls
-rw-rw-r-- 1 sde sde 7776 May 21 2010 th.nls
-rw-rw-r-- 1 sde sde 5366 May 21 2010 tw.nls
-rw-rw-r-- 1 sde sde 5335 May 21 2010 zh.nls
[root@ oracle11g_64]# tar -xvf 02.tar
Help/
.............
[root@ oracle11g_64]# ll
total 153924
-rw-rw-r-- 1 sde sde 18699 May 21 2010 01.toc
-rw-rw-r-- 1 sde sde 157460480 May 21 2010 02.tar
-rw-rw-r-- 1 sde sde 5366 May 21 2010 b5.nls
-rw-rw-r-- 1 sde sde 8648 May 21 2010 en.nls
drwxr-xr-x 10 10018 kmem 289 May 15 2010 Help
-rwxrwxr-x 1 sde sde 52923 May 21 2010 install
-rw-rw-r-- 1 sde sde 9015 May 21 2010 ja.nls
-rw-rw-r-- 1 sde sde 9011 May 21 2010 jp.nls
-rw-rw-r-- 1 sde sde 10786 May 21 2010 ko.nls
drwxr-xr-x 7 root root 66 Jul 9 21:59 sdeexe100
-rw-rw-r-- 1 sde sde 7776 May 21 2010 th.nls
-rw-rw-r-- 1 sde sde 5366 May 21 2010 tw.nls
-rw-rw-r-- 1 sde sde 5335 May 21 2010 zh.nls
[root@ oracle11g_64]# cd sdeexe100/
[root@ sdeexe100]# pwd
/app/soft/sde/oracle11g_64/sdeexe100
[root@ sdeexe100]# ll
total 16
drwxr-xr-x 2 root root 4096 Jul 9 21:59 bin
drwxr-xr-x 2 root root 117 Jul 9 21:59 etc
drwxr-xr-x 2 root root 8192 Jul 9 21:59 lib
drwxr-xr-x 4 10018 kmem 33 Jan 9 2010 locale
drwxr-xr-x 3 root root 20 Jul 9 21:59 tools
[root@ sdeexe100]# pwd
/app/soft/sde/oracle11g_64/sdeexe100
[root@ sdeexe100]# chown -R sde:sde /app/soft/sde
[root@ sdeexe100]# su - sde
su: user sde does not exist
[root@ sdeexe100]# cd /app/soft/sde
[root@ sde]# ll
total 0
drwxrwxr-x 4 sde sde 190 Jul 9 21:59 oracle11g_64
[root@ sde]# su - sde
Last login: Thu Jul 9 20:44:34 CST 2020 on pts/1
[sde@ ~]$ cd /app/soft/sde/oracle11g_64/
[sde@ oracle11g_64]$ ll
total 153924
-rw-rw-r-- 1 sde sde 18699 May 21 2010 01.toc
-rw-rw-r-- 1 sde sde 157460480 May 21 2010 02.tar
-rw-rw-r-- 1 sde sde 5366 May 21 2010 b5.nls
-rw-rw-r-- 1 sde sde 8648 May 21 2010 en.nls
drwxr-xr-x 10 sde sde 289 May 15 2010 Help
-rwxrwxr-x 1 sde sde 52923 May 21 2010 install
-rw-rw-r-- 1 sde sde 9015 May 21 2010 ja.nls
-rw-rw-r-- 1 sde sde 9011 May 21 2010 jp.nls
-rw-rw-r-- 1 sde sde 10786 May 21 2010 ko.nls
drwxr-xr-x 7 sde sde 66 Jul 9 21:59 sdeexe100
-rw-rw-r-- 1 sde sde 7776 May 21 2010 th.nls
-rw-rw-r-- 1 sde sde 5366 May 21 2010 tw.nls
-rw-rw-r-- 1 sde sde 5335 May 21 2010 zh.nls
[sde@ oracle11g_64]$ cd sdeexe100/
[sde@ sdeexe100]$ ll
total 16
drwxr-xr-x 2 sde sde 4096 Jul 9 21:59 bin
drwxr-xr-x 2 sde sde 117 Jul 9 21:59 etc
drwxr-xr-x 2 sde sde 8192 Jul 9 21:59 lib
drwxr-xr-x 4 sde sde 33 Jan 9 2010 locale
drwxr-xr-x 3 sde sde 20 Jul 9 21:59 tools
[sde@ sdeexe100]$ cd bin
[sde@ bin]$ ll
total 18960
-rwxr-xr-x 1 sde sde 5432688 May 15 2010 cov2sde
-rwxr-xr-x 1 sde sde 87296 May 15 2010 giomgr
-rwxr-xr-x 1 sde sde 792264 May 15 2010 gsrvr
-rwxr-xr-x 1 sde sde 5433208 May 15 2010 sde2cov
-rwxr-xr-x 1 sde sde 965640 May 15 2010 sde2shp
-rwxr-xr-x 1 sde sde 1061096 May 15 2010 sde2tbl
-rwxr-xr-x 1 sde sde 70584 May 15 2010 sdeconfig
-rwxr-xr-x 1 sde sde 56920 May 15 2010 sdedbtune
-rwxr-xr-x 1 sde sde 291848 May 15 2010 sdeexport
-rwxr-xr-x 1 sde sde 53568 May 15 2010 sdegdbrepair
-rwxr-xr-x 1 sde sde 82504 May 15 2010 sdegroup
-rwxr-xr-x 1 sde sde 353784 May 15 2010 sdeimport
-rwxr-xr-x 1 sde sde 139880 May 15 2010 sdelayer
-rwxr-xr-x 1 sde sde 52792 May 15 2010 sdelog
-rwxr-xr-x 1 sde sde 54208 May 15 2010 sdemon
-rwxr-xr-x 1 sde sde 286408 May 15 2010 sderaster
-rwxr-xr-x 1 sde sde 574536 May 15 2010 sderemote
-rwxr-xr-x 1 sde sde 78584 May 15 2010 sdesetup
-rwxr-xr-x 1 sde sde 120728 May 15 2010 sdetable
-rwxr-xr-x 1 sde sde 33096 May 15 2010 sdeversion
-rwxr-xr-x 1 sde sde 260784 May 15 2010 sdexinfo
-rwxr-xr-x 1 sde sde 58136 May 15 2010 sdexml
-rwxr-xr-x 1 sde sde 49720 May 15 2010 setup_st_geometry
-rwxr-xr-x 1 sde sde 998240 May 15 2010 shp2sde
-rwxr-xr-x 1 sde sde 898544 May 15 2010 shpinfo
-rwxr-xr-x 1 sde sde 1061288 May 15 2010 tbl2sde
[sde@ bin]$ pwd
/app/soft/sde/oracle11g_64/sdeexe100/bin
[sde@ bin]$ ./sdesetup -h
./sdesetup: error while loading shared libraries: libsdesetup.so: cannot open shared object file: No such file or directory
[sde@ bin]$ pwd
/app/soft/sde/oracle11g_64/sdeexe100/bin
[sde@ bin]$ cd ..
[sde@ sdeexe100]$ pwd
/app/soft/sde/oracle11g_64/sdeexe100
[sde@ sdeexe100]$ cat /home/sde/.bash_profile
# .bash_profile

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

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=ydgc
export LANG=en_US.UTF-8
export NLS_LANG=american_america.ZHS16GBK
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin:/home/oracle/run
export ORACLE_TERM=xterm
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
umask 022
export TMOUT=0
export SDEHOME=/app/soft/sde/oracle11g_64/sdeexe100
export PATH=$ORACLE_HOME/bin:$PATH:$SDEHOME/sdeexe100/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$SDEHOME/sdeexe100/lib:/usr/lib:/lib:$ORACLE_HOME/lib
[sde@ sdeexe100]$ source /home/sde/.bash_profile
[sde@ sdeexe100]$
[sde@ sdeexe100]$
[sde@ sdeexe100]$ ./sdesetup -h
-bash: ./sdesetup: No such file or directory
[sde@ sdeexe100]$ cd bin
[sde@ bin]$ ./sdesetup -h
./sdesetup: error while loading shared libraries: libsdesetup.so: cannot open shared object file: No such file or directory
[sde@ bin]$ echo $LD_LIBRARY_PATH
/app/oracle/product/11.2.0/dbhome_1/lib:/app/oracle/product/11.2.0/dbhome_1/oracm/lib:/lib:/usr/lib:/usr/local/lib:/app/soft/sde/oracle11g_64/sdeexe100/sdeexe100/lib:/usr/lib:/lib:/app/oracle/product/11.2.0/dbhome_1/lib
[sde@ bin]$ vi /home/sde/.bash_profile
# .bash_profile

# Get the aliases and functions
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=ydgc
export LANG=en_US.UTF-8
export NLS_LANG=american_america.ZHS16GBK
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin:/home/oracle/run
export ORACLE_TERM=xterm
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
umask 022
export TMOUT=0
export SDEHOME=/app/soft/sde/oracle11g_64/sdeexe100
export PATH=$ORACLE_HOME/bin:$PATH:$SDEHOME/sdeexe100/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$SDEHOME/sdeexe100/lib:/usr/lib:/lib:$ORACLE_HOME/lib
~
~

~
~
~
"~/.bash_profile" 37L, 1269C written
[sde@ bin]$ source /home/sde/.bash_profile
[sde@ bin]$ ./sdesetup -h
./sdesetup: error while loading shared libraries: libsdesetup.so: cannot open shared object file: No such file or directory
[sde@ bin]$ find /app/soft/sde/oracle11g_64/ -name libsdesetup.so
/app/soft/sde/oracle11g_64/sdeexe100/lib/libsdesetup.so
[sde@ bin]$ vi /home/sde/.bash_profile
# .bash_profile

# Get the aliases and functions
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=ydgc
export LANG=en_US.UTF-8
export NLS_LANG=american_america.ZHS16GBK
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin:/home/oracle/run
export ORACLE_TERM=xterm
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
umask 022
export TMOUT=0
export SDEHOME=/app/soft/sde/oracle11g_64/sdeexe100
export PATH=$ORACLE_HOME/bin:$PATH:$SDEHOME/sdeexe100/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$SDEHOME/sdeexe100/lib
~
~
~
~
~
~
~
"~/.bash_profile" 37L, 1249C written
[sde@ bin]$ source /home/sde/.bash_profile
[sde@ bin]$ ./sdesetup -h
./sdesetup: error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory
[sde@ bin]$ sdesetup -h
sdesetup: error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory
[sde@ bin]$ pwd
/app/soft/sde/oracle11g_64/sdeexe100/bin
[sde@ bin]$ exit
logout
[root@ sde]# yum install openmotif*
Configuration file /etc/yum/pluginconf.d/fastestmirror.conf not found
Unable to find configuration file for plugin fastestmirror
Configuration file /etc/yum/pluginconf.d/langpacks.conf not found
Unable to find configuration file for plugin langpacks
Resolving Dependencies
--> Running transaction check
---> Package motif.x86_64 0:2.3.4-8.1.el7_3 will be installed
--> Processing Dependency: xorg-x11-xbitmaps for package: motif-2.3.4-8.1.el7_3.x86_64
---> Package motif-devel.x86_64 0:2.3.4-8.1.el7_3 will be installed
--> Processing Dependency: libpng-devel(x86-64) for package: motif-devel-2.3.4-8.1.el7_3.x86_64
--> Processing Dependency: libjpeg-devel(x86-64) for package: motif-devel-2.3.4-8.1.el7_3.x86_64
--> Processing Dependency: libXt-devel(x86-64) for package: motif-devel-2.3.4-8.1.el7_3.x86_64
--> Processing Dependency: libXp-devel(x86-64) for package: motif-devel-2.3.4-8.1.el7_3.x86_64
--> Processing Dependency: libXmu-devel(x86-64) for package: motif-devel-2.3.4-8.1.el7_3.x86_64
--> Processing Dependency: libXft-devel(x86-64) for package: motif-devel-2.3.4-8.1.el7_3.x86_64
--> Processing Dependency: libXext-devel(x86-64) for package: motif-devel-2.3.4-8.1.el7_3.x86_64
--> Running transaction check
---> Package libXext-devel.x86_64 0:1.3.3-3.el7 will be installed
--> Processing Dependency: pkgconfig(xextproto) for package: libXext-devel-1.3.3-3.el7.x86_64
--> Processing Dependency: pkgconfig(x11) for package: libXext-devel-1.3.3-3.el7.x86_64
---> Package libXft-devel.x86_64 0:2.3.2-2.el7 will be installed
--> Processing Dependency: pkgconfig(xrender) for package: libXft-devel-2.3.2-2.el7.x86_64
--> Processing Dependency: pkgconfig(freetype2) for package: libXft-devel-2.3.2-2.el7.x86_64
--> Processing Dependency: pkgconfig(fontconfig) for package: libXft-devel-2.3.2-2.el7.x86_64
---> Package libXmu-devel.x86_64 0:1.1.2-2.el7 will be installed
---> Package libXp-devel.x86_64 0:1.0.2-2.1.el7 will be installed
--> Processing Dependency: pkgconfig(xau) for package: libXp-devel-1.0.2-2.1.el7.x86_64
--> Processing Dependency: libXau-devel for package: libXp-devel-1.0.2-2.1.el7.x86_64
---> Package libXt-devel.x86_64 0:1.1.5-3.el7 will be installed
--> Processing Dependency: pkgconfig(sm) for package: libXt-devel-1.1.5-3.el7.x86_64
--> Processing Dependency: pkgconfig(ice) for package: libXt-devel-1.1.5-3.el7.x86_64
---> Package libjpeg-turbo-devel.x86_64 0:1.2.90-5.el7 will be installed
---> Package libpng-devel.x86_64 2:1.5.13-7.el7_2 will be installed
---> Package xorg-x11-xbitmaps.noarch 0:1.1.1-6.el7 will be installed
--> Running transaction check
---> Package fontconfig-devel.x86_64 0:2.10.95-11.el7 will be installed
--> Processing Dependency: pkgconfig(expat) for package: fontconfig-devel-2.10.95-11.el7.x86_64
---> Package freetype-devel.x86_64 0:2.4.11-15.el7 will be installed
---> Package libICE-devel.x86_64 0:1.0.9-9.el7 will be installed
---> Package libSM-devel.x86_64 0:1.2.2-2.el7 will be installed
---> Package libX11-devel.x86_64 0:1.6.5-1.el7 will be installed
--> Processing Dependency: pkgconfig(xcb) >= 1.11.1 for package: libX11-devel-1.6.5-1.el7.x86_64
--> Processing Dependency: pkgconfig(xcb) for package: libX11-devel-1.6.5-1.el7.x86_64
---> Package libXau-devel.x86_64 0:1.0.8-2.1.el7 will be installed
---> Package libXrender-devel.x86_64 0:0.9.10-1.el7 will be installed
---> Package xorg-x11-proto-devel.noarch 0:7.7-20.el7 will be installed
--> Running transaction check
---> Package expat-devel.x86_64 0:2.1.0-10.el7_3 will be installed
---> Package libxcb-devel.x86_64 0:1.12-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================================
Package Arch Version Repository Size
====================================================================================================================================================================================
Installing:
motif x86_64 2.3.4-8.1.el7_3 http-CentOS7.4 1.4 M
motif-devel x86_64 2.3.4-8.1.el7_3 http-CentOS7.4 1.3 M
Installing for dependencies:
expat-devel x86_64 2.1.0-10.el7_3 http-CentOS7.4 57 k
fontconfig-devel x86_64 2.10.95-11.el7 http-CentOS7.4 128 k
freetype-devel x86_64 2.4.11-15.el7 http-CentOS7.4 356 k
libICE-devel x86_64 1.0.9-9.el7 http-CentOS7.4 50 k
libSM-devel x86_64 1.2.2-2.el7 http-CentOS7.4 13 k
libX11-devel x86_64 1.6.5-1.el7 http-CentOS7.4 980 k
libXau-devel x86_64 1.0.8-2.1.el7 http-CentOS7.4 14 k
libXext-devel x86_64 1.3.3-3.el7 http-CentOS7.4 75 k
libXft-devel x86_64 2.3.2-2.el7 http-CentOS7.4 19 k
libXmu-devel x86_64 1.1.2-2.el7 http-CentOS7.4 24 k
libXp-devel x86_64 1.0.2-2.1.el7 http-CentOS7.4 17 k
libXrender-devel x86_64 0.9.10-1.el7 http-CentOS7.4 17 k
libXt-devel x86_64 1.1.5-3.el7 http-CentOS7.4 446 k
libjpeg-turbo-devel x86_64 1.2.90-5.el7 http-CentOS7.4 98 k
libpng-devel x86_64 2:1.5.13-7.el7_2 http-CentOS7.4 122 k
libxcb-devel x86_64 1.12-1.el7 http-CentOS7.4 1.0 M
xorg-x11-proto-devel noarch 7.7-20.el7 http-CentOS7.4 284 k
xorg-x11-xbitmaps noarch 1.1.1-6.el7 http-CentOS7.4 37 k

Transaction Summary
====================================================================================================================================================================================
Install 2 Packages (+18 Dependent packages)

Total download size: 6.4 M
Installed size: 17 M
Is this ok [y/d/N]: y
Downloading packages:
(1/20): expat-devel-2.1.0-10.el7_3.x86_64.rpm | 57 kB 00:00:00 
(2/20): fontconfig-devel-2.10.95-11.el7.x86_64.rpm | 128 kB 00:00:00 
(3/20): freetype-devel-2.4.11-15.el7.x86_64.rpm | 356 kB 00:00:00 
(4/20): libICE-devel-1.0.9-9.el7.x86_64.rpm | 50 kB 00:00:00 
(5/20): libSM-devel-1.2.2-2.el7.x86_64.rpm | 13 kB 00:00:00 
(6/20): libXau-devel-1.0.8-2.1.el7.x86_64.rpm | 14 kB 00:00:00 
(7/20): libX11-devel-1.6.5-1.el7.x86_64.rpm | 980 kB 00:00:00 
(8/20): libXext-devel-1.3.3-3.el7.x86_64.rpm | 75 kB 00:00:00 
(9/20): libXft-devel-2.3.2-2.el7.x86_64.rpm | 19 kB 00:00:00 
(10/20): libXp-devel-1.0.2-2.1.el7.x86_64.rpm | 17 kB 00:00:00 
(11/20): libXmu-devel-1.1.2-2.el7.x86_64.rpm | 24 kB 00:00:00 
(12/20): libXrender-devel-0.9.10-1.el7.x86_64.rpm | 17 kB 00:00:00 
(13/20): libjpeg-turbo-devel-1.2.90-5.el7.x86_64.rpm | 98 kB 00:00:00 
(14/20): libpng-devel-1.5.13-7.el7_2.x86_64.rpm | 122 kB 00:00:00 
(15/20): libXt-devel-1.1.5-3.el7.x86_64.rpm | 446 kB 00:00:00 
(16/20): libxcb-devel-1.12-1.el7.x86_64.rpm | 1.0 MB 00:00:00 
(17/20): motif-2.3.4-8.1.el7_3.x86_64.rpm | 1.4 MB 00:00:00 
(18/20): motif-devel-2.3.4-8.1.el7_3.x86_64.rpm | 1.3 MB 00:00:00 
(19/20): xorg-x11-proto-devel-7.7-20.el7.noarch.rpm | 284 kB 00:00:00 
(20/20): xorg-x11-xbitmaps-1.1.1-6.el7.noarch.rpm | 37 kB 00:00:00 
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 20 MB/s | 6.4 MB 00:00:00 
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : xorg-x11-proto-devel-7.7-20.el7.noarch 1/20
Installing : libICE-devel-1.0.9-9.el7.x86_64 2/20
Installing : libXau-devel-1.0.8-2.1.el7.x86_64 3/20
Installing : freetype-devel-2.4.11-15.el7.x86_64 4/20
Installing : libxcb-devel-1.12-1.el7.x86_64 5/20
Installing : libX11-devel-1.6.5-1.el7.x86_64 6/20
Installing : libXext-devel-1.3.3-3.el7.x86_64 7/20
Installing : libXp-devel-1.0.2-2.1.el7.x86_64 8/20
Installing : libXrender-devel-0.9.10-1.el7.x86_64 9/20
Installing : libSM-devel-1.2.2-2.el7.x86_64 10/20
Installing : libXt-devel-1.1.5-3.el7.x86_64 11/20
Installing : libXmu-devel-1.1.2-2.el7.x86_64 12/20
Installing : expat-devel-2.1.0-10.el7_3.x86_64 13/20
Installing : fontconfig-devel-2.10.95-11.el7.x86_64 14/20
Installing : libXft-devel-2.3.2-2.el7.x86_64 15/20
Installing : xorg-x11-xbitmaps-1.1.1-6.el7.noarch 16/20
Installing : motif-2.3.4-8.1.el7_3.x86_64 17/20
Installing : libjpeg-turbo-devel-1.2.90-5.el7.x86_64 18/20
Installing : 2:libpng-devel-1.5.13-7.el7_2.x86_64 19/20
Installing : motif-devel-2.3.4-8.1.el7_3.x86_64 20/20
Verifying : libXft-devel-2.3.2-2.el7.x86_64 1/20
Verifying : 2:libpng-devel-1.5.13-7.el7_2.x86_64 2/20
Verifying : freetype-devel-2.4.11-15.el7.x86_64 3/20
Verifying : libICE-devel-1.0.9-9.el7.x86_64 4/20
Verifying : libXt-devel-1.1.5-3.el7.x86_64 5/20
Verifying : libXrender-devel-0.9.10-1.el7.x86_64 6/20
Verifying : libjpeg-turbo-devel-1.2.90-5.el7.x86_64 7/20
Verifying : motif-2.3.4-8.1.el7_3.x86_64 8/20
Verifying : motif-devel-2.3.4-8.1.el7_3.x86_64 9/20
Verifying : xorg-x11-proto-devel-7.7-20.el7.noarch 10/20
Verifying : libXau-devel-1.0.8-2.1.el7.x86_64 11/20
Verifying : libXext-devel-1.3.3-3.el7.x86_64 12/20
Verifying : xorg-x11-xbitmaps-1.1.1-6.el7.noarch 13/20
Verifying : expat-devel-2.1.0-10.el7_3.x86_64 14/20
Verifying : libxcb-devel-1.12-1.el7.x86_64 15/20
Verifying : libSM-devel-1.2.2-2.el7.x86_64 16/20
Verifying : libXp-devel-1.0.2-2.1.el7.x86_64 17/20
Verifying : fontconfig-devel-2.10.95-11.el7.x86_64 18/20
Verifying : libX11-devel-1.6.5-1.el7.x86_64 19/20
Verifying : libXmu-devel-1.1.2-2.el7.x86_64 20/20

Installed:
motif.x86_64 0:2.3.4-8.1.el7_3 motif-devel.x86_64 0:2.3.4-8.1.el7_3 

Dependency Installed:
expat-devel.x86_64 0:2.1.0-10.el7_3 fontconfig-devel.x86_64 0:2.10.95-11.el7 freetype-devel.x86_64 0:2.4.11-15.el7 libICE-devel.x86_64 0:1.0.9-9.el7 
libSM-devel.x86_64 0:1.2.2-2.el7 libX11-devel.x86_64 0:1.6.5-1.el7 libXau-devel.x86_64 0:1.0.8-2.1.el7 libXext-devel.x86_64 0:1.3.3-3.el7 
libXft-devel.x86_64 0:2.3.2-2.el7 libXmu-devel.x86_64 0:1.1.2-2.el7 libXp-devel.x86_64 0:1.0.2-2.1.el7 libXrender-devel.x86_64 0:0.9.10-1.el7 
libXt-devel.x86_64 0:1.1.5-3.el7 libjpeg-turbo-devel.x86_64 0:1.2.90-5.el7 libpng-devel.x86_64 2:1.5.13-7.el7_2 libxcb-devel.x86_64 0:1.12-1.el7 
xorg-x11-proto-devel.noarch 0:7.7-20.el7 xorg-x11-xbitmaps.noarch 0:1.1.1-6.el7 

Complete!
[root@ sde]# rpm -aq|grep libXm*
libXfont-1.5.2-1.el7.x86_64
libX11-devel-1.6.5-1.el7.x86_64
libXext-1.3.3-3.el7.x86_64
libXinerama-1.1.3-2.1.el7.x86_64
libXdmcp-1.1.2-6.el7.x86_64
libXau-devel-1.0.8-2.1.el7.x86_64
libXt-devel-1.1.5-3.el7.x86_64
libXdamage-1.1.4-4.1.el7.x86_64
libXxf86misc-1.0.3-7.1.el7.x86_64
libXfixes-5.0.3-1.el7.x86_64
libXrandr-1.5.1-2.el7.x86_64
libXt-1.1.5-3.el7.x86_64
libXcursor-1.1.14-8.el7.x86_64
libXfont2-2.0.1-2.el7.x86_64
libXmu-1.1.2-2.el7.x86_64
libXp-1.0.2-2.1.el7.x86_64
libXp-devel-1.0.2-2.1.el7.x86_64
libXmu-devel-1.1.2-2.el7.x86_64
libXvMC-1.0.10-1.el7.x86_64
libXxf86dga-1.1.4-2.1.el7.x86_64
libXau-1.0.8-2.1.el7.x86_64
libXi-1.7.9-1.el7.x86_64
libXrender-0.9.10-1.el7.x86_64
libXrender-devel-0.9.10-1.el7.x86_64
libXft-2.3.2-2.el7.x86_64
libXpm-3.5.12-1.el7.x86_64
libXcomposite-0.4.4-4.1.el7.x86_64
libX11-common-1.6.5-1.el7.noarch
libXres-1.0.7-2.1.el7.x86_64
libXext-devel-1.3.3-3.el7.x86_64
libX11-1.6.5-1.el7.x86_64
libXft-devel-2.3.2-2.el7.x86_64
libXtst-1.2.3-1.el7.x86_64
libXv-1.0.11-1.el7.x86_64
libXxf86vm-1.1.4-1.el7.x86_64
[root@ sde]# find / -name libXm.so.3
/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm.so.3
[root@ sde]# pwd
/app/soft/sde
[root@ sde]# ll /app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm.so.3
-rw-r--r-- 1 sde sde 415676 Aug 5 2010 /app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm.so.3
[root@ sde]# su - sde
Last login: Thu Jul 9 22:00:42 CST 2020 on pts/1
[sde@ ~]$ pwd
/home/sde
[sde@ ~]$ cd $SDEHOME
[sde@ sdeexe100]$ cd bin
[sde@ bin]$ ll
total 18960
-rwxr-xr-x 1 sde sde 5432688 May 15 2010 cov2sde
-rwxr-xr-x 1 sde sde 87296 May 15 2010 giomgr
-rwxr-xr-x 1 sde sde 792264 May 15 2010 gsrvr
-rwxr-xr-x 1 sde sde 5433208 May 15 2010 sde2cov
-rwxr-xr-x 1 sde sde 965640 May 15 2010 sde2shp
-rwxr-xr-x 1 sde sde 1061096 May 15 2010 sde2tbl
-rwxr-xr-x 1 sde sde 70584 May 15 2010 sdeconfig
-rwxr-xr-x 1 sde sde 56920 May 15 2010 sdedbtune
-rwxr-xr-x 1 sde sde 291848 May 15 2010 sdeexport
-rwxr-xr-x 1 sde sde 53568 May 15 2010 sdegdbrepair
-rwxr-xr-x 1 sde sde 82504 May 15 2010 sdegroup
-rwxr-xr-x 1 sde sde 353784 May 15 2010 sdeimport
-rwxr-xr-x 1 sde sde 139880 May 15 2010 sdelayer
-rwxr-xr-x 1 sde sde 52792 May 15 2010 sdelog
-rwxr-xr-x 1 sde sde 54208 May 15 2010 sdemon
-rwxr-xr-x 1 sde sde 286408 May 15 2010 sderaster
-rwxr-xr-x 1 sde sde 574536 May 15 2010 sderemote
-rwxr-xr-x 1 sde sde 78584 May 15 2010 sdesetup
-rwxr-xr-x 1 sde sde 120728 May 15 2010 sdetable
-rwxr-xr-x 1 sde sde 33096 May 15 2010 sdeversion
-rwxr-xr-x 1 sde sde 260784 May 15 2010 sdexinfo
-rwxr-xr-x 1 sde sde 58136 May 15 2010 sdexml
-rwxr-xr-x 1 sde sde 49720 May 15 2010 setup_st_geometry
-rwxr-xr-x 1 sde sde 998240 May 15 2010 shp2sde
-rwxr-xr-x 1 sde sde 898544 May 15 2010 shpinfo
-rwxr-xr-x 1 sde sde 1061288 May 15 2010 tbl2sde
[sde@ bin]$ sdesetup -h
sdesetup: error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory
[sde@ bin]$ rpm -aq|grep openmotif
[sde@ bin]$ cp /app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm.so.3 ^C
[sde@ bin]$ pwd
/app/soft/sde/oracle11g_64/sdeexe100/bin
[sde@ bin]$ cd ..
[sde@ sdeexe100]$ ll
total 16
drwxr-xr-x 2 sde sde 4096 Jul 9 21:59 bin
drwxr-xr-x 2 sde sde 117 Jul 9 21:59 etc
drwxr-xr-x 2 sde sde 8192 Jul 9 21:59 lib
drwxr-xr-x 4 sde sde 33 Jan 9 2010 locale
drwxr-xr-x 3 sde sde 20 Jul 9 21:59 tools
[sde@ sdeexe100]$ cd lib
[sde@ lib]$ ls
archive_util.spb libsdeora11gsrvr100.so registry_util.sps st_geom_cols_util.sps st_multilinestring.stb st_relation_operators.sps
archive_util.sps libsdesetup.so sde_util.spb st_geometry_operators.spb st_multilinestring.sts st_spref_util.spb
dbtune_util.spb libsde.so sde_util.sps st_geometry_operators.sps st_multipoint.stb st_spref_util.sps
dbtune_util.sps libsg.so sdo_util.spb st_geometry_shapelib_pkg.spb st_multipoint.sts st_surface.stb
instances_util.spb libst_raster_ora.so sdo_util.sps st_geometry_shapelib_pkg.sps st_multipolygon.stb st_surface.sts
instances_util.sps libst_shapelib.so spx_util.spb st_geometry.stb st_multipolygon.sts st_type_export.spb
keyset_util.spb libtiff.so spx_util.sps st_geometry.sts st_multisurface.stb st_type_export.sps
keyset_util.sps libxerces-c.so sref_util.spb st_geomfromtext.stb st_multisurface.sts st_type_user.spb
layer_stats_util.spb libxerces-c.so.27 sref_util.sps st_geomfromtext.sts st_pixeldata.wtb st_type_user.sps
layer_stats_util.sps libxerces-c.so.27.0 st_cref_util.spb st_geom_util.spb st_pixeldata.wts st_type_util.spb
layers_util.spb locator_util.spb st_cref_util.sps st_geom_util.sps st_pointfromtext.stb st_type_util.sps
layers_util.sps locator_util.sps st_curve.stb st_linefromtext.stb st_pointfromtext.sts svr_config_util.spb
libgsrvrora11g100.so lock_util.spb st_curve.sts st_linefromtext.sts st_point.stb svr_config_util.sps
libicudata.so lock_util.sps st_domain_methods_standalone.stb st_linestring.stb st_point.sts version_user_ddl.spb
libicudata.so.40 logfile_util.spb st_domain_methods.stb st_linestring.sts st_polyfromtext.stb version_user_ddl.sps
libicudata.so.40.1 logfile_util.sps st_domain_methods.sts st_mlinefromtext.stb st_polyfromtext.sts version_util.spb
libicui18n.so metadata_util.spb st_domain_operators.spb st_mlinefromtext.sts st_polygon.stb version_util.sps
libicui18n.so.40 metadata_util.sps st_domain_operators.sps st_mpointfromtext.stb st_polygon.sts xml_util.spb
libicui18n.so.40.1 pinfo_util.spb st_domain_stats.stb st_mpointfromtext.sts st_raster_util.wpb xml_util.sps
libicuuc.so pinfo_util.sps st_domain_stats.sts st_mpolyfromtext.stb st_raster_util.wps
libicuuc.so.40 rastercolumns_util.spb st_geomcollection.stb st_mpolyfromtext.sts st_raster.wtb
libicuuc.so.40.1 rastercolumns_util.sps st_geomcollection.sts st_multicurve.stb st_raster.wts
libpe.so registry_util.spb st_geom_cols_util.spb st_multicurve.sts st_relation_operators.spb
[sde@ lib]$ pwd
/app/soft/sde/oracle11g_64/sdeexe100/lib
[sde@ lib]$ cp /app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm.so.3 ./
[sde@ lib]$ cd ../bin
[sde@ bin]$ sdesetup -h
sdesetup: error while loading shared libraries: libg2c.so.0: cannot open shared object file: No such file or directory
[sde@ bin]$
[sde@ bin]$
[sde@ bin]$ exit
logout
[root@ sde]# yum install compat-libf2c*
Configuration file /etc/yum/pluginconf.d/fastestmirror.conf not found
Unable to find configuration file for plugin fastestmirror
Configuration file /etc/yum/pluginconf.d/langpacks.conf not found
Unable to find configuration file for plugin langpacks
Resolving Dependencies
--> Running transaction check
---> Package compat-libf2c-34.x86_64 0:3.4.6-32.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================================
Package Arch Version Repository Size
====================================================================================================================================================================================
Installing:
compat-libf2c-34 x86_64 3.4.6-32.el7 http-CentOS7.4 155 k

Transaction Summary
====================================================================================================================================================================================
Install 1 Package

Total download size: 155 k
Installed size: 576 k
Is this ok [y/d/N]: y
Downloading packages:
compat-libf2c-34-3.4.6-32.el7.x86_64.rpm | 155 kB 00:00:00 
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : compat-libf2c-34-3.4.6-32.el7.x86_64 1/1
Verifying : compat-libf2c-34-3.4.6-32.el7.x86_64 1/1

Installed:
compat-libf2c-34.x86_64 0:3.4.6-32.el7 

Complete!
[root@ sde]# su - sde
Last login: Thu Jul 9 22:14:45 CST 2020 from 172.17.136.10 on pts/2
[sde@ ~]$ cd $SDEHOME/bin
[sde@ bin]$ sdesetup -h


!!! WARNING !!! --> libXm-2.3.4-stub.so

This is a stub library which can be used for linking only. It must *not*
be used as a runtime library. Please make sure this library is not found
in LD_LIBRARY_PATH.

[root@ sde]# find / -name libXm-2.3.4-stub.so
/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm-2.3.4-stub.so
[root@ sde]# ll /app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm-2.3.4-stub.so
-rw-r--r-- 1 sde sde 415676 Aug 5 2010 /app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm-2.3.4-stub.so
[root@ sde]# su - sde
Last login: Thu Jul 9 22:15:33 CST 2020 on pts/1
[sde@ ~]$ sdesetup -h


!!! WARNING !!! --> libXm-2.3.4-stub.so

This is a stub library which can be used for linking only. It must *not*
be used as a runtime library. Please make sure this library is not found
in LD_LIBRARY_PATH.


[sde@ ~]$ pwd
/home/sde
[sde@ ~]$ cd $SDEHOME/lib
[sde@ lib]$ ll libXm*
-rw-r--r-- 1 sde sde 415676 Jul 9 22:14 libXm.so.3
[sde@ lib]$ pwd
/app/soft/sde/oracle11g_64/sdeexe100/lib
[sde@ lib]$ ps -ef|grep ora_smon
sde 2873 1 0 21:12 00:00:06 ora_smon_ydgc
sde 7492 7354 0 22:18 pts/1 00:00:00 grep --color=auto ora_smon
[sde@ lib]$ cd ../bin
[sde@ bin]$ pwd
/app/soft/sde/oracle11g_64/sdeexe100/bin
[sde@ bin]$ sdesetup -o install -d ORACLE11G -D ydgc -u sde -p pwd


!!! WARNING !!! --> libXm-2.3.4-stub.so

This is a stub library which can be used for linking only. It must *not*
be used as a runtime library. Please make sure this library is not found
in LD_LIBRARY_PATH.


[sde@ bin]$ pwd
/app/soft/sde/oracle11g_64/sdeexe100/bin
[sde@ bin]$ mv /app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm-2.3.4-stub.so /app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm-2.3.4-stub.sobak
[sde@ bin]$ sdesetup -H


!!! WARNING !!! --> libXm-2.3.4-stub.so

This is a stub library which can be used for linking only. It must *not*
be used as a runtime library. Please make sure this library is not found
in LD_LIBRARY_PATH.


[sde@ bin]$ ll /usr/lib/libXm.so.4
ls: cannot access /usr/lib/libXm.so.4: No such file or directory
[sde@ bin]$ ll /usr/lib/libXm*
ls: cannot access /usr/lib/libXm*: No such file or directory
[sde@ bin]$ exit
logout
[root@ sde]# find / -name libXm*
/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm.so.3
/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXmu.so
/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm.so
/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXmu-2.3.4-stub.so
/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXmu.so.6
/app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm-2.3.4-stub.sobak
/app/soft/sde/oracle11g_64/sdeexe100/lib/libXm.so.3
/usr/lib64/libXmu.so.6
/usr/lib64/libXmu.so.6.2.0
/usr/lib64/libXmuu.so.1
/usr/lib64/libXmuu.so.1.0.0
/usr/lib64/libXm.so
/usr/lib64/libXm.so.4
/usr/lib64/libXm.so.4.0.4
/usr/lib64/libXmu.so
/usr/lib64/libXmuu.so
/usr/share/doc/libXmu-1.1.2
[root@ sde]# rm -f /app/soft/sde/oracle11g_64/sdeexe100/lib/libXm.so.3
[root@ sde]# pwd
/app/soft/sde
[root@ sde]# cd /app/soft/sde/oracle11g_64/sdeexe100/lib/
[root@ lib]# ln -s /usr/lib64/libXm.so.4 libXm.so.3
[root@ lib]#
[root@ lib]#
[root@ lib]# su - sde
Last login: Thu Jul 9 22:17:08 CST 2020 on pts/1
[sde@ ~]$ pwd
/home/sde
[sde@ ~]$ pwd
/home/sde
[sde@ ~]$ sdesetup -H
sdesetup: option requires an argument -- 'H'

ArcSDE 10.0 Setup
Setup Administration Utility
-----------------------------------------------------


Usage for sdesetup:

-
-h

-o install -d {ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL}
[-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>]
[-D <database>] [-s <datasource>] [-N]
[-i {<master_geodatabase_service>[:<user_schema>] | :sde} ]
[-l <key>] [-q]
-o upgrade -d {ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL}
[-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>]
[-D <database>] [-s <datasource>] [-N]
[-i <master_geodatabase_service>[:<user_schema>]] [-l <key>] [-q]
-o delete -d {ORACLE10G|ORACLE11G}
[-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>]
[-i <master_geodatabase_service>[:<user_schema>]] [-N] [q]
-o list -d {ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL}
[-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>]
[-D <database>] [-s <datasource>]
[-i <master_geodatabase_service>[:<user_schema>]] [-q]
-o update_key
-d {ORACLE10G|ORACLE11G|SQLSERVER| DB2|DB2ZOS|INFORMIX|POSTGRESQL}
-l <key> [-u <DB_Admin_user>] [-p <DB_Admin_password>]
[-H <sde_directory>] [-D <database>] [-s <datasource>] [-N]
[-i <master_geodatabase_service>[:<user_schema>]] [-q]
-o install_st_raster
-d {ORACLE10G|ORACLE11G|SQLSERVER|POSTGRESQL}
[-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>]
[-D <database>] [-s <datasource>] [-N] [-l <key>] [-q]
-o prerequisite_check
-d {ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL}
[-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>]
[-D <database>] [-s <datasource>] [-N] [-q]

Operations:
install Create or update tables and procedures ArcSDE requires
upgrade Upgrade ArcSDE Server
delete Deletes an ArcSDE geodatabase for Oracle
list List installed ArcSDE Release
update_key Add or update ArcSDE authorization key information
install_st_raster Install ST_Raster type
prerequisite_check Performs prerequisite check for setup privileges,
xml support and type library configuration
Options:
-d Underlying RDBMS for ArcSDE.
-D Database name
-h Print Options
-i ArcSDE service and user schema name (default: esri_sde:sde).
Use ':sde' for SQL Server to create an sde-schema geodatabase.
-l ArcSDE authorization key or location to authorization file
-N No verification
-o Operation
-p DBMS DBA User password
-q Quiet
-s Datasource name
-u DBMS DBA User name
-Print Options
[sde@ ~]$ sdesetup -o install -d ORACLE11G -D ydgc -u sde -p pwd

ESRI ArcSDE Server Setup Utility Thu Jul 9 22:27:09 2020
----------------------------------------------------------------
Install or update ArcSDE, GDB schema objects: Are you sure(Y/N): Y

Checking INSTALL privileges for geodatabase ...
Current user has privilege to install geodatabase instance.

Checking geodatabase XML datatype support...
Underlying RDBMS database instance supports XML data type.

Creating ArcSDE schema.....
Successfully created ArcSDE schema.

Installing St_Geometry ....
Successfully installed St_Geometry.

Creating geodatabase schema.....
Successfully created GDB schema.


Successfully installed ArcSDE components.
Refer SDEHOME\etc\sde_setup.log for more details.

[sde@ ~]$ sqlplus sde/pwd

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 9 22:27:42 2020

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from user_tables;

COUNT(*)
----------
61

SQL> select count(*) from user_objects;

COUNT(*)
----------
439

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[sde@ ~]$ mv /app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm-2.3.4-stub.sobak /app/oracle/product/11.2.0/dbhome_1/lib/stubs/libXm-2.3.4-stub.so
[sde@ ~]$ pwd
/home/sde
[sde@ ~]$ ll
total 5532
-rw-rw-r-- 1 sde sde 2886 Jan 2 2020 arcgis-2038.ecp
-rw-rw-r-- 1 sde sde 5652930 Oct 10 2018 libst_shapelib.so
-rw-r--r-- 1 sde sde 1108 Jul 9 20:32 tbs.sql
[sde@ ~]$
[sde@ ~]$
[sde@ ~]$ pwd
/home/sde
[sde@ ~]$
[sde@ ~]$
[sde@ ~]$ sdesetup -o update_key -d ORACLE11G -l /home/sde/arcgis-2038.ecp
Enter DBA password:

ESRI ArcSDE Server Setup Utility Thu Jul 9 22:35:25 2020
----------------------------------------------------------------
Successfully updated authorization key.
[sde@ ~]$
[sde@ ~]$
[sde@ ~]$
[sde@ ~]$
[sde@ ~]$ pwd

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
### 回答1: 要清除SDE空间中的垃圾数据,可以使用以下步骤: 1. 首先,使用ArcCatalog或ArcMap中的Catalog窗口连接到要清除的SDE数据库。 2. 右键单击要清除的SDE图层,选择“属性”选项。在“属性”窗口中,选择“空间参考”选项卡,记录空间参考的名称。 3. 打开ArcToolbox中的“数据管理工具”>“清理”>“清理SDE垃圾数据”工具。 4. 在“清理SDE垃圾数据”工具中,选择要清理的SDE图层,选择要清理的垃圾数据类型(例如,无效的几何体、重复的要素等),并选择要清理的空间参考。 5. 点击“运行”按钮开始清理。 请注意,清除SDE空间中的垃圾数据可能需要一些时间,具体时间取决于数据量的大小和计算机的性能。另外,清除垃圾数据可能会影响到SDE数据的完整性和一致性,因此在进行此操作之前,请务必备份SDE数据。 ### 回答2: Oracle SDE Layers 是一种在 Oracle 数据库中存储和管理空间数据的技术。当使用 SDE Layers 存储空间数据时,有时候会存留一些垃圾数据,这些数据可能是由于删除或修改数据时没有完全清理而产生的。 清除 SDE 空间垃圾数据的方法有以下几种: 1. 使用 ArcSDE command line 工具:可以使用 sdelayer -o delete 命令来删除指定表中的垃圾数据。这个命令将会把那些没有被任何几何要素引用的几何类型和相关的属性记录从表中删除。 2. 使用 ArcGIS 数据完整性检查工具:可以使用 ArcGIS 中提供的数据完整性检查工具来识别并删除表中的垃圾数据。这个工具会检测表中的每一行记录,如果发现某一行记录没有被任何几何要素引用,那么就会将其标记为垃圾数据,并且可以选择性地删除它们。 3. 手动清理:可以通过编写 SQL 查询语句来手动清理 SDE Layers 中的垃圾数据。通过查询数据库中的关联表,找到不再被任何几何要素引用的记录,并将其删除。 无论使用哪种方法,清除 SDE Layers 中的垃圾数据都需要谨慎操作,确保不会误删有效数据。建议在清理之前先备份数据,以防万一。使用适当的工具和技术方法来清除垃圾数据,可以有效提升数据库性能和数据的完整性。 ### 回答3: 清除SDE空间垃圾数据可以通过以下步骤进行: 1. 首先,连接到Oracle数据库中的SDE用户。可以使用SQL*Plus或SQL Developer等数据库工具。 2. 检查SDE用户下的所有空间表,识别存在垃圾数据的表。可以使用以下SQL语句检索所有空间表的名称: ```sql SELECT table_name FROM all_tables WHERE owner = 'SDE' AND table_name LIKE 'SDE%' ``` 3. 对于每个空间表,可以采取以下方法清除垃圾数据: - 方法一:使用ArcGIS工具,如ArcCatalog或ArcMap等,连接到SDE数据库,打开要清理的图层,然后选择"Manage > Purge > Purge All"清除所有垃圾数据。这将删除不再被任何要素类参考的空间数据。 - 方法二:手动执行SQL语句来删除垃圾数据。在执行之前,建议先备份相关的表数据。以下是一个示例SQL语句,用于删除指定表中的垃圾数据,并针对需要进行清理的每个表进行修改: ```sql DELETE FROM sde.table_name WHERE sde_column_name IS NULL ``` 在该语句中,"table_name"是要清除垃圾数据的表的名称,"sde_column_name"是一个包含空间数据的列的名称(例如SHAPE或GEOMETRY)。 4. 在清除垃圾数据后,可以使用SDE命令重新创建空间索引以优化空间查询性能。可以使用以下命令进行重新创建空间索引: ```sql SDELAYER -o alter -l table_name,-1 sde:oracle11g:sde ``` 在该命令中,"table_name"是要重新创建空间索引的表的名称。 5. 最后,验证清除操作是否成功,通过查询相关空间表的数据进行确认。 请注意,清除空间垃圾数据涉及对数据库进行修改和删除操作,因此在执行操作之前,请确保已进行适当的备份,并在生产环境中谨慎操作。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值