Mercurial > dive4elements > river

annotate backend/doc/documentation/de/overview.tex @ 8605:b0e5a2ce0b09

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
(issue1750) Fix id handling with oracle On oracle the id is returned as BigDecimal. This could probably be done better with hibernate but checking the Object also works.
author Andre Heinecke <andre.heinecke@intevation.de>
date Fri, 20 Mar 2015 18:42:00 +0100
parents 73946c0007ff
children 3e212106455c
rev   line source
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
1 \section{�bersicht}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
3 Diese Dokumentation beschreibt die von Intevation entwickelten Werkzeuge zum
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
4 Importieren der hydrologischen, morphologischen und geod�tischen Daten der BfG.
6669
5820eb9197c9 Importer doc: small language corrections to Overview
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6633
diff changeset
5 Die im Folgenden beschriebenen Werkzeuge zum Importieren der Daten sind speziell auf das Verzeichnissystem der BfG ausgerichtet.
3668
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
6 Dabei wird angenommen, dass sich das Verzeichnis eines Gew�ssers auf oberster
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
7 Ebene in drei Unterverzeichnisse aufgliedert:
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
8
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
9 \begin{itemize}
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
10 \item Geodaesie
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
11 \item Hydrologie
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
12 \item Morphologie
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
13 \end{itemize}
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
14
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15 Desweiteren beziehen sich die Befehle, die auf der Kommandozeile abgesetzt
3678
6185c15efccf Added hint for root permission in documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3672
diff changeset
16 werden, auf ein SuSE-Linux-Enterprise-Server Version 11. Bitte beachten Sie
6185c15efccf Added hint for root permission in documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3672
diff changeset
17 auch, dass einige der Befehle \textit{root}-Rechte ben�tigen.
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 \subsection{Vorbereitungen}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
21 \subsubsection{Entpacken des Datenimporters}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
22
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
23 Damit die Software performant und korrekt ausgef�hrt werden kann, ist es
5041
41ab66c2fb28 Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 5040
diff changeset
24 erforderlich, dass sie auf dem selben System wie die Datenbank installiert
41ab66c2fb28 Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 5040
diff changeset
25 und ausgef�hrt wird.
41ab66c2fb28 Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 5040
diff changeset
26 Sollten Sie das Paket nicht auf dem
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27 Zielsystem selbst heruntergeladen haben, sind ggf. weitere Werkzeuge notwendig.
5041
41ab66c2fb28 Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 5040
diff changeset
28 Wenn Sie von einem Windows System auf das Zielsystem zugreifen
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
29 wollen, k�nnen Sie beispielsweise folgende Werkzeuge verwenden:
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
30
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
31 \begin{itemize}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32 \item WinSCP \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
33 WinSCP ist ein Open Source Werkzeug zum Transferieren von Dateien zwischen zwei
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
34 Systemen. Um das heruntergeladene Paket auf das Zielsystem zu transferieren,
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
35 k�nnen Sie WinSCP benutzen. F�r weitere Informationen und den Gebrauch von
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
36 WinSCP lesen Sie bitte unter folgender Adresse nach:
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
37 \href{http://winscp.net/}{http://winscp.net/}.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39 \item Putty \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
40 Putty ist ein Open Source Werkzeug, mit dem Sie sich von einem Windows System
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
41 per SSH auf das Zielsystem verbinden k�nnen. Anschlie�end k�nnen Sie �ber die
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
42 Kommandozeile auf dem Zielsystem die Befehle, die in diesem Dokument beschrieben
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
43 sind, ausf�hren. F�r weitere Informationen zu Putty und dessen Gebrauch lesen
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
44 Sie bitte unter folgender Adresse nach: \href{http://www.putty.org/}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
45 {http://www.putty.org/}.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 \end{itemize}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
48 Bitte beachten Sie, dass diese Werkzeuge nicht zur Installtion und zum Betrieb
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
49 der Software selbst notwendig sind!
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
50
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
51 \subsection{Systemanforderungen}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
52 \label{Systemanforderungen}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
53 \begin{itemize}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
54 \item Oracle oder PosgreSQL Datenbank inkl. Schema f�r FLYS
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
55 \item SUSE Enterprise Linux 11.2 SP 1
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
56 \end{itemize}
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
57
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
58 \subsection{Installationsanleitung}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
59 \label{Installationsanleitung}
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
60
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
61 Nachdem Sie das Paket nun in das Heimatverzeichnis des Nutzers auf das
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
62 Zielsystem kopiert haben, entpacken Sie es mit folgenden Befehlen:
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
63
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
64 \begin{lstlisting}
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
65 cd ~
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
66 tar xvfz flys-importer.tar.gz
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
67 cd flys-importer
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
68 \end{lstlisting}
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
69
5075
e34c9687299d Tex Syntax fixes
Andre Heinecke <aheinecke@intevation.de>
parents: 5071
diff changeset
70 \subsubsection{Java}
6669
5820eb9197c9 Importer doc: small language corrections to Overview
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6633
diff changeset
71 Der flys-importer ben�tigt Java Version 6. Um diese zu installieren laden Sie
7433
73946c0007ff Importer doc: fix some layout issues.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6670
diff changeset
72 bitte von
73946c0007ff Importer doc: fix some layout issues.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6670
diff changeset
73 \url{http://www.oracle.com/technetwork/java/javase/downloads/index.html}
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
74 eine aktulle Java Version als -rpm.bin herunter. Zum Beispiel: jdk-6u41-linux-x64-rpm.bin
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
75
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
76 Nach dem Herunterladen, �ffnen Sie eine konsole und wechseln in das Downloadverzeichnis.
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
77 F�hren Sie nun folgende Befehle aus:
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
78
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
79 \begin{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
80 su - # login als root
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
81 sh jdk-6u41-linux-x64-rpm.bin
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
82 <bestaetigen mit enter>
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
83 update-alternatives --install /usr/bin/java java /usr/java/jdk1.6.0_41/bin/java 5
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
84 update-alternatives --install /etc/alternatives/jre jre /usr/java/jdk1.6.0_41/jre 5
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
85 update-alternatives --config java
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
86 \end{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
87
5075
e34c9687299d Tex Syntax fixes
Andre Heinecke <aheinecke@intevation.de>
parents: 5071
diff changeset
88 \subsubsection{Python und GDAL}
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
89 Installieren Sie nun die restlichen ben�tigten Pakete.
7433
73946c0007ff Importer doc: fix some layout issues.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6670
diff changeset
90 Installieren Sie zuerst einige Abh�ngigkeiten und anschlie�end die
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
91 von der Intevation GmbH bereitgestellten speziellen Versionen von proj und libgeos
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
92
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
93 Um die Abh�ngigkeiten zu installieren f�hren Sie bitte folgende Befehle aus:
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
94
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
95 \begin{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
96 zypper ar http://download.opensuse.org/repositories/home:/intevation:/bfg/SLE_11/ "intevation:bfg"
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
97 rpm --import http://download.opensuse.org/repositories/home:/intevation:/bfg/SLE_11/repodata/repomd.xml.key
6669
5820eb9197c9 Importer doc: small language corrections to Overview
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6633
diff changeset
98 zypper ref # Paketliste neu laden
6670
474a47624587 Importer doc: small formating corrections to overview.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6669
diff changeset
99 zypper in python libgeos0 libproj0 proj netcdf \
474a47624587 Importer doc: small formating corrections to overview.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6669
diff changeset
100 libnetcdf4 xerces-c libxerces-c-3_0 unixODBC \
474a47624587 Importer doc: small formating corrections to overview.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6669
diff changeset
101 postgresql-libs
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
102 zypper mr -d "intevation:bfg"
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
103 zypper ref # Paketliste neu laden
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
104 \end{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
105
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
106 %\subsubsection Oracle Instantclient\\
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
107 %Der Oracle Instantclient 11.2.0.2.0 wird ben�tigt, damit der Importer mittels Python
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
108 %und GDAL in die bestehende Oracle Datenbqlnk schreiben kann. Wenn Sie
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
109 %eine PosgreSQL Datenbank verwenden, k�nnen Sie diesen Schritt �berspringen.
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
110 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
111 %Zur Anbindung von Oracle ist es erforderlich, folgende Archive von
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
112 %Oracle herunterzuladen (Sie ben�tigen daf�r ein Oracle Benutzerkonto):
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
113 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
114 %Der Oracle Instantclient 11.2 wird ben�tigt, damit der Importer mittels Python
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
115 %und GDAL in die bestehende Oracle Datenbank schreiben kann. Dazu ist es
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
116 %erforderlich, folgende Archive von Oracle herunterzuladen.
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
117 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
118 % \begin{itemize}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
119 % \item instantclient-basic-linux-x86-64-11.2.0.2.0.zip
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
120 % \item instantclient-sdk-linux-x86-64-11.2.0.2.0.zip
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
121 % \item instantclient-sqlplus-linux-x86-64-11.2.0.2.0.zip
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
122 % \end{itemize}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
123 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
124 %Zu finden sind die
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
125 % Pakete unter:\\
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
126 %\href{http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
127 %{http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
128 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
129 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
130 %Um diese Pakete zu installieren, �ffnen Sie eine Konsole und wechseln
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
131 %in das Verzeichnis in welches Sie die heruntergeladenen Pakete
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
132 %gespeichert haben. (z.B.: cd /home/benutzername/Downloads )
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
133 % Anschlie�end f�hren Sie folgende Befehle auf der Kommandozeile aus:
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
134 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
135 % \begin{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
136 % unzip instantclient-basic-linux-x86-64-11.2.0.2.0.zip -d /opt
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
137 % unzip instantclient-sdk-linux-x86-64-11.2.0.2.0.zip -d /opt
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
138 % unzip instantclient-sqlplus-linux-x86-64-11.2.0.2.0.zip -d /opt
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
139 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
140 % mkdir /opt/instantclient_11_2/lib
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
141 % cd /opt/instantclient_11_2/lib
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
142 % ln -s ../libclntsh.so.11.1 .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
143 % ln -s ../libclntsh.so.11.1 libclntsh.so
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
144 % ln -s ../libnnz11.so .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
145 % ln -s ../libocci.so.11.1 .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
146 % ln -s ../libocci.so.11.1 libocci.so
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
147 % ln -s ../libociei.so .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
148 % ln -s ../libocijdbc11.so .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
149 % ln -s ../libsqlplusic.so .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
150 % ln -s ../libsqlplus.so .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
151 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
152 % echo "/opt/instantclient_11_2/lib/" > /etc/ld.so.conf.d/oci.conf
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
153 % ldconfig
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
154 % \end{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
155 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
156 %Sollten keine Fehler aufgetreten sein, haben Sie den \textit{Oracle
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
157 % Instantclient 11.2} erfolgreich entpackt und im Dateisystem unter
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
158 % \textit{/opt/instantclient\_11\_2} abgelegt.
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
159 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
160 \subsubsection{Vorbereiten der Datenbank}
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
161 Bevor die Importer verwendet werden k�nnen, ist es notwendig, dass eine leere
5877
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
162 Oracle Datenbank vorhanden ist. Anschlie�end m�ssen folgende SQL-Skripte in
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
163 diese Datenbank eingespielt werden:
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
164
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
165 \begin{enumerate}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
166 \item oracle.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
167 In diesem SQL Skript befindet sich das Schema zum Speichern der hydrologischen
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
168 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
169
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
170 \item oracle-minfo.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
171 In diesem SQL Skript befindet sich das Schema zum Speichern der morphologischen
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
172 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
173
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
174 \item oracle-spatial.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
175 In diesem SQL Skript befindet sich das Schema zum Speichern der geod�tischen
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
176 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
177
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
178 \item oracle-spatial\_idx.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
179 Mittels diesem SQL Skript werden die Indizes zum geod�tischen Datenbankschema\\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
180 hinzugef�gt.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
181
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
182 \end{enumerate}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
183
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
184 Zum Einspielen dieser Schemata setzen Sie folgende Befehle auf der Kommandozeile
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
185 ab. Beachten Sie, dass $sqlplus$ im Pfad liegen muss, und der Linux-Nutzer
5041
41ab66c2fb28 Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 5040
diff changeset
186 dieses Kommando ausf�hren k�nnen muss. Au�erdem sind $benutzername$ und $passwort$
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
187 entsprechend Ihres Datenbank-Zugangs anzupassen.
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
188 SQLPlus befindet sich in /opt/instantclient\_11\_2 um es verf�gbar zu machen
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
189 f�hren Sie im Importer Verzeichnis folgende Befehle aus:
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
190
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
191 \begin{lstlisting}
6670
474a47624587 Importer doc: small formating corrections to overview.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6669
diff changeset
192 export LD_LIBRARY_PATH=opt/instantclient_11_2/lib:$LD_LIBRARY_PATH
474a47624587 Importer doc: small formating corrections to overview.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6669
diff changeset
193 export PATH=opt/instantclient_11_2:$PATH
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
194 \end{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
195
5877
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
196 Damit alle in den UTF8-codierten SQL-Skripten vorhandenen Zeichen (also z.B.\
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
197 auch Umlaute) korrekt in die Datenbank eingelesen werden k�nnen, f�hren
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
198 Sie folgenden Befehl aus:
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
199
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
200 \begin{lstlisting}
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
201 export NLS_LANG=.AL32UTF8
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
202 \end{lstlisting}
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
203
6631
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
204 Nun verbinden Sie sich mit der Datenbank
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
205 \begin{lstlisting}
6633
e7d058a2e3b2 Importer docs: Improved layout.
Tom Gottfried <tom@intevation.de>
parents: 6631
diff changeset
206 sqlplus user/password@connect_identifier
6631
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
207 \end{lstlisting}
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
208
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
209 und erstellen das Schema:
3667
9b08db037ee5 Fixes and structural changes in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3661
diff changeset
210
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
211 \begin{lstlisting}
6631
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
212 @schema/oracle.sql
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
213 @schema/oracle-minfo.sql
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
214 @schema/oracle-spatial.sql
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
215 @schema/oracle-spatial_idx.sql
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
216 \end{lstlisting}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
217
6633
e7d058a2e3b2 Importer docs: Improved layout.
Tom Gottfried <tom@intevation.de>
parents: 6631
diff changeset
218 Hierbei ist
e7d058a2e3b2 Importer docs: Improved layout.
Tom Gottfried <tom@intevation.de>
parents: 6631
diff changeset
219 \begin{lstlisting}
e7d058a2e3b2 Importer docs: Improved layout.
Tom Gottfried <tom@intevation.de>
parents: 6631
diff changeset
220 user/password@connect_identifier
e7d058a2e3b2 Importer docs: Improved layout.
Tom Gottfried <tom@intevation.de>
parents: 6631
diff changeset
221 \end{lstlisting}
e7d058a2e3b2 Importer docs: Improved layout.
Tom Gottfried <tom@intevation.de>
parents: 6631
diff changeset
222 so etwas wie
e7d058a2e3b2 Importer docs: Improved layout.
Tom Gottfried <tom@intevation.de>
parents: 6631
diff changeset
223 \begin{lstlisting}
e7d058a2e3b2 Importer docs: Improved layout.
Tom Gottfried <tom@intevation.de>
parents: 6631
diff changeset
224 ICH/geheim@127.0.0.1:1234/DB.TEST.FIRMA.DE
e7d058a2e3b2 Importer docs: Improved layout.
Tom Gottfried <tom@intevation.de>
parents: 6631
diff changeset
225 \end{lstlisting}
6631
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
226
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
227 Um sqlplus zu verlassen verwenden Sie
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
228 \begin{lstlisting}
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
229 exit
9aa1c946b87d Fixed documentation for Oracle schema.
Tom Gottfried <tom@intevation.de>
parents: 6630
diff changeset
230 \end{lstlisting}
http://dive4elements.wald.intevation.org