8
</code>
===Quelle : Daten exportieren===
Parfile für den Export anlegen:
<code bash>
vi ~/full_export_GPIDB1.dpctl
DIRECTORY=DATA_PUMP_DIR
LOGFILE=expdp_08-08-2013_19_49_GPIDB1.log
DUMPFILE=expdp_08-08-2013_19_49_GPIDB1%u.dmp
FILESIZE=20G
REUSE_DUMP... e bash>
$ORACLE_HOME/bin/expdp "'/ as SYSDBA'" parfile=~/full_export_GPIDB1.dpctl
</code>
Logfile auf F
S
( RECORDS DELIMITED BY NEWLINE
LOGFILE 'DWH_OP_COMMAND':'readCronTab.log'
BADFILE 'DWH_OP_COMMAND':'readCronTab.bad'
NODISCARDFILE
SKIP 0
FIELDS TERMINATED BY ';' OPTIO... de>
==Probem KUP-01005: syntax error: found "logfile": expecting one of: "column" ==
alle FIELD Anwei
'cman21c-b'
cman21c-a: successful removal of the file 'pcsd settings'
cman21c-b: successful removal of the file 'pcsd settings'
Sending 'corosync authkey', 'pace... n21c-b'
cman21c-a: successful distribution of the file 'corosync authkey'
cman21c-a: successful distribution of the file 'pacemaker authkey'
cman21c-b: successful distrib
Info Script was called with parameter $1 - log to file" > /tmp/etl_job.log
echo "--Info Script was c... _control"
</code>
Auf OS Seite den erzeugen Logfile überprüfen (ob der Paramter auch wirklich richtig... Info Script was called with parameter %1 - log to file" > C:\temp\etl_job.log
echo "--Info Script wa... ershell.exe -ExecutionPolicy Bypass -NoLogo -NoProfile -NonInteractive -File C:\oracle\dbScript\info.ps1
Ablauf:
* Den Gateway Initialization Parameter File einrichten
* Oracle Net für das Gateway konfigu... tm#OTGIS110
===Gateway Initialization Parameter File einrichten===
Für das Gateway wird eine Art Inst... e bash>
lsnrctl status LISTENER
..
Listener Log File /opt/oracle/diag/tnslsnr/racdb01/listener... achten!
==Fehler - ORA-28541: Error in HS init file on line 20.===
<code sql>
SYS@GPIDB1-racdb01>se
=> Übersicht => "Save Response File" => Install
- Install Product =>... MIN
Trace Level OFF
Instance Config file /opt/oracle/product/21c/client_1/network/adm... ect: ..
...
</code>
Nach dem Start kann das Logfile unter **$ORACLE_BASE/diag/netcman/cman21c/cman_gp...
.. /opt/oracle/product/21c/client_2/bin/tnslsnr ifile=/opt/oracle/product/21c/client_2/network/admin/cm
set of the database
CHARSET=AL32UTF8
# Database file directory
# If not specified, database files are stored under Oracle base/oradata
DBFILE_DEST=
# DB Domain name
DB_DOMAIN=
</code>
alter