annotate backend/doc/documentation/de/overview.tex @ 6061:e9a76ffa0f9a

Use maxOverlap to get the correct gauge for the MainValues Previously just the first matching gauge was taken even if it's range ended with the minimum value. This code is clearly intended to get one gauge for one range so the best match should be taken.
author Andre Heinecke <aheinecke@intevation.de>
date Wed, 22 May 2013 18:10:48 +0200
parents 7e48f7a64182
children 92c8cc7e064b
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.
5040
d55ba61e9970 documentation: Typo fix.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 3682
diff changeset
5 Die im Folgenden\\ beschriebenen Werkzeuge zum Importieren der fachlichen und
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
6 geod�tischen 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
7 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
8 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
9
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 \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
11 \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
12 \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
13 \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
14 \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
15
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16 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
17 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
18 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
19
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20 \subsection{Vorbereitungen}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
21
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
22 \subsubsection{Entpacken des Datenimporters}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
23
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
24 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
25 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
26 und ausgef�hrt wird.
41ab66c2fb28 Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 5040
diff changeset
27 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
28 Zielsystem selbst heruntergeladen haben, sind ggf. weitere Werkzeuge notwendig.
5041
41ab66c2fb28 Doc: minor fixes.
Felix Wolfsteller <felix.wolfsteller@intevation.de>
parents: 5040
diff changeset
29 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
30 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
31
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32 \begin{itemize}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
33 \item WinSCP \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
34 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
35 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
36 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
37 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
38 \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
39
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
40 \item Putty \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
41 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
42 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
43 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
44 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
45 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
46 {http://www.putty.org/}.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47 \end{itemize}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
48
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
49 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
50 der Software selbst notwendig sind!
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
51
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
52 \subsection{Systemanforderungen}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
53 \label{Systemanforderungen}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
54 \begin{itemize}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
55 \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
56 \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
57 \end{itemize}
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
58
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
59 \subsection{Installationsanleitung}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
60 \label{Installationsanleitung}
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
61
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
62 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
63 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
64
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
65 \begin{lstlisting}
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
66 cd ~
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
67 tar xvfz flys-importer.tar.gz
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
68 cd flys-importer
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
69 \end{lstlisting}
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
70
5075
e34c9687299d Tex Syntax fixes
Andre Heinecke <aheinecke@intevation.de>
parents: 5071
diff changeset
71 \subsubsection{Java}
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
72 Der flys-importer ben�tigt Java Version 6 um diese zu installieren laden Sie
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
73 bitte von \url{http://www.oracle.com/technetwork/java/javase/downloads/jdk6downloads-1902814.html}
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.
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
90 Dazu installieren Sie zuerst einige Abh�ngigkeiten und anschlie�end die
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
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
98 zypper ref # Paketlist neu laden
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
99 zypper in python libgeos0 libproj0 proj netcdf libnetcdf4 \
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
100 xerces-c libxerces-c-3_0 unixODBC postgresql-libs
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
101 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
102 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
103 \end{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
104
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
105 %\subsubsection Oracle Instantclient\\
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
106 %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
107 %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
108 %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
109 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
110 %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
111 %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
112 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
113 %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
114 %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
115 %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
116 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
117 % \begin{itemize}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
118 % \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
119 % \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
120 % \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
121 % \end{itemize}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
122 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
123 %Zu finden sind die
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
124 % Pakete unter:\\
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
125 %\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
126 %{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 %
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 %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
130 %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
131 %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
132 % 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
133 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
134 % \begin{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
135 % 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
136 % 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
137 % 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
138 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
139 % 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
140 % 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
141 % 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
142 % 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
143 % ln -s ../libnnz11.so .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
144 % 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
145 % 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
146 % ln -s ../libociei.so .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
147 % ln -s ../libocijdbc11.so .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
148 % ln -s ../libsqlplusic.so .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
149 % ln -s ../libsqlplus.so .
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
150 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
151 % 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
152 % ldconfig
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
153 % \end{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
154 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
155 %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
156 % 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
157 % \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
158 %
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
159 \subsubsection{Vorbereiten der Datenbank}
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
160 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
161 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
162 diese Datenbank eingespielt werden:
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
163
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
164 \begin{enumerate}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
165 \item oracle.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
166 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
167 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
168
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
169 \item oracle-minfo.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
170 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
171 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
172
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
173 \item oracle-spatial.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
174 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
175 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
176
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
177 \item oracle-spatial\_idx.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
178 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
179 hinzugef�gt.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
180
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
181 \end{enumerate}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
182
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
183 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
184 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
185 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
186 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
187 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
188 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
189
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
190 \begin{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
191 export LD_LIBRARY_PATH=opt/instantclient\_11\_2/lib:$LD_LIBRARY_PATH
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
192 export PATH=opt/instantclient\_11\_2:$PATH
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
193 \end{lstlisting}
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
194
5877
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
195 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
196 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
197 Sie folgenden Befehl aus:
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
198
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
199 \begin{lstlisting}
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
200 export NLS_LANG=.AL32UTF8
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
201 \end{lstlisting}
7e48f7a64182 document how to read schema with correct encoding
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
202
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
203 Nun erstellen Sie das Schema:
3667
9b08db037ee5 Fixes and structural changes in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3661
diff changeset
204
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
205 \begin{lstlisting}
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
206 sqlplus benutzername/passwort @schema/oracle.sql
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
207 sqlplus benutzername/passwort @schema/oracle-minfo.sql
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
208 sqlplus benutzername/passwort @schema/oracle-spatial.sql
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
209 sqlplus benutzername/passwort @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
210 \end{lstlisting}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
211
5065
a56efdfcab17 Simplify installation instruction and move it to overview as it
Andre Heinecke <aheinecke@intevation.de>
parents: 3682
diff changeset
212

http://dive4elements.wald.intevation.org