Mercurial > dive4elements > river

annotate backend/doc/documentation/de/overview.tex @ 6339:aef238fdd9b6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Backend: Added special ImportWstColumns for official lines. They have to be glued with the main values.
author Sascha L. Teichmann <teichmann@intevation.de>
date Fri, 14 Jun 2013 16:56:30 +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