Mercurial > dive4elements > river

annotate backend/doc/documentation/de/overview.tex @ 8794:c1cea6c95967

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improve Postgres-DB setup. We depend on 9.1 (having CREATE EXTENSION) since a while.
author Tom Gottfried <tom@intevation.de>
date Thu, 10 Dec 2015 17:40:02 +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