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... logs.msdn.microsoft.com/walzenbach/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008/
Be
t.
Ermitteln mit:
<code sql>
select name
, to_char(sysdate,'dd.mm.yyyy hh24:mi')
, current_scn
from v$database
/
NAME TO_CHAR(SYSDATE, CURRENT_SCN
--------- -------------... date "+%Y%m%d-%H%M%S"`
expdp … FLASHBACK_TIME=\"to_timestamp\(\'$TIMESTAMP_EXPORT\',\'yyyymmdd-hh24m... CT table_name FROM GPI_EXP_TAB)"
FLASHBACK_TIME="to_timestamp('20140820-112640','yyyymmdd-hh24miss')"
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...
----
--
====Probleme====
===TNS-04012: Unable to start Oracle Connection Manager instance===
<code bash>
CMCTL:cman1> startup
TNS-04012: Unable to start Oracle Connection Manager instance.
</code>
'
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
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
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