auf.
Übersicht:
{{ :dba:oracle_gateway_linux_to_mssql.png | Oracle Database Gateway unter Oracle ... abase is installed and used.
It is not necessary to obtain a separate license for the machine running... >
yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
</code>
Treiber installieren:
<c... r bcp and sqlcmd
ACCEPT_EULA=Y yum install mssql-tools
</code>
=== IP Zugriff sicherstellen ===
zip) auspacken reicht nicht, dort fehlt die CMAN Tools!</note>
**Ablauf:**
* Basis Betriebssyste... ipg.OiipgPropertyLoader**
<code bash>
Preparing to launch Oracle Universal Installer from /tmp/OraIn... nce cman_gpi is not yet started
Connections refer to (DESCRIPTION=(address=(protocol=tcp)(host=cman21c... r die CIDR-Suffix den [[http://www.heise.de/netze/tools/netzwerkrechner/| Heise online Rechner]]|
|DST
'
Sending 'corosync authkey', 'pacemaker authkey' to 'cman21c-a', 'cman21c-b'
cman21c-a: successful di... file 'pacemaker authkey'
Sending 'corosync.conf' to 'cman21c-a', 'cman21c-b'
cman21c-a: successful di... om /etc/oratab)
# OCF_RESKEY_user (optional; user to run the listener)
# OCF_RESKEY_cmanname (optional; defaults to LISTENER)
# OCF_RESKEY_cmanport (mandatory; for t
ctive connections":0,"Peak active connections":0,"Total connections":0,"Total connections refused":0,"Received IN bytes":0,"Received OUT bytes":0,"Sent IN... ctive connections":0,"Peak active connections":0,"Total connections":0,"Total connections refused":0,"Received IN bytes":0,"Received OUT bytes":0,"Sent IN
rol identified by job$100;
grant connect,resource to job_control;
grant unlimited tablespace to job_control;
-- grant the main rights CREATE JOB, CREATE... reate job, create credential, create external job to job_control;
</code>
ETL Linux User im OS der... "--Info Script was called with parameter $1 - log to file" > /tmp/etl_job.log
echo "--Info Script
_tdm identified by "SecretPWD2023";
grant connect to cman_tdm;
</code>
Applications-User anlegen un... d by "GanzAnderesPWD2023";
grant connect,resource to gpipperr ;
GRANT UNLIMITED TABLESPACE TO gpipperr ;
--
alter user gpipperr grant connect through cma... All rights reserved.
Enter password:
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - D
ading table "GPITEST"."ILOCDB02"
ORA-12899: value too large for column STICHWORT (actual: 14, maximum:... L_DECL_LENGTH);
--dbms_output.put_line('-- try to execute command '||v_sql);
BEGIN
-- not ch... ec.CHAR_COL_DECL_LENGTH > 1 then
-- uncomment to execute
-- EXECUTE IMMEDIATE v_sql;
-- sh... others THEN
dbms_output.put_line('-- Error to execute command '||v_sql||' : '||SQLERRM );
EN
rant read,write,execute on directory DB_COMMAND to DWH_ADMIN;
</code>
==Problem KUP-04087: no execute access to directory object ==
Execute Rechte nicht vergess