ESRI

SdeMon stoppen und starten

export SDEHOME=/usr/local/arcsde/sdeexe10/sdeexe100
$SDEHOME/bin/sdemon -o status -i esri_sde
#$SDEHOME/bin/sdemon -o shutdown  -i esri_sde -p <password>
#sleep 3
#$SDEHOME/bin/sdemon -o start -i esri_sde -p <password>
$SDEHOME/bin/sdemon -o status -i esri_sde

Library in Oracle erzeugen

#/bin/sh

set -x

sqlplus sde/<password> <<EOF
drop library ST_SHAPELIB;
create library ST_SHAPELIB AS '/usr/local/arcsde/sdeexe10/sdeexe100/lib/libst_shapelib.so';
/
exit
EOF

Esri Oracle Listener

LISTENER_umweltp =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      ( ADDRESS = (PROTOCOL = TCP)(HOST = localhost )  (PORT = 6543))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.60.147 )(PORT = 6543))
      (ADDRESS = (PROTOCOL = IPC)(KEY  = EXTPROC6543))
    )
  )
  SID_LIST_LISTENER_umweltp =
   (SID_LIST =
   (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /oracle/product/db/11.2.0.3)
    (PROGRAM = extproc)                        (
     ENVS="EXTPROC_DLLS=/usr/local/arcsde/arcsdexe10/sdeexe100/lib/libst_shapelib.so:/usr/local/arcsde/arcsdexe10/sdeexe100/lib/libst_raster_ora.so")
    )
     )

Esri tnsnames.ora

<SID> =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 6543))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
      ( SERVICE_NAME = <service> )
    )
  )

  LISTENER_UMWELTP =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 6543))

  EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC6543))
   )
  (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
   )
  )

export dbtune

 #!/bin/sh
 set -x
 $SDEHOME/bin/sdedbtune -o export -f ./dbtune_export.<sid> -u sde -p <password> -i esri_sde 

import dbtune

set -x
$SDEHOME/bin/sdedbtune -o import -f ./dbtune.<sid> -u sde -p <password> -i 5151

This wiki is powered by ikiwiki.