n21c-a
* Last change: Wed Jan 10 19:57:57 2024 by hacluster via crmd on cman21c-a
* 2 nodes confi... source ocf:heartbeat:MailTo - Notifies recipients by email in the event of resource takeover )
Was n... l Business Machines, Inc.
#
# This code inspired by the oralsnr resource script
# written by Dejan Muhamedagic
#
# An example usage in /etc/ha.d/haresou
mands
* GROUP syntax for rules
* BANDWIDTH in bytes per second at service level
----
==== Lize... NUX.X64_213000_client.zip (64-bit) (1,075,931,428 bytes) (sha256sum - 595d8b59901c68979e2ff06521091685... 43745_210000_Linux-x86-64.zip 876.1 MB (918682641 bytes)
SHA-256 E55AF80672AC89C8D0A5EE531F4B9CD9AB823... lly.
# Was wird erzeugt
cat cman.ora
#----ADDED BY CMAN 18-MAY-2015 09:29:34---
password_cman_gpi =
CHAR2** Spalten definiert.
Der Default Wert ist "BYTE" , das heißt beim Anlegen einer VARCHAR2 Spalte... d für die Längen Angabe der Spalte die Anzahl der Bytes verwendet.
Das heißt aus der DDL Angabe "varc... ird eine Spalte mit dem Datentyp VARCHAR2 und der Byte Längen Angabe ("data_length" in der dba_tab_col... DATA_LENGTH -- Length of the column (in bytes)
, col.CHAR_LENGTH -- Display
,directory_path
from dba_directories
order by 1
,2
/
</code>
Siehe auch passendes Scr... type, owner
from dba_objects
group by object_type,owner
)
where owner not in ('SYS',... 'SYSMAN','OLAPSYS','OWBSYS','OWBSYS_AUDIT')
group by owner,obj_type,obj_count
order by owner,obj_type
/
column grantee format a25
column GRANTOR format
ons":0,"Total connections refused":0,"Received IN bytes":0,"Received OUT bytes":0,"Sent IN bytes":0,"Sent OUT bytes":0},{"Gateway ID":1,"Gateway state":"READY","Number of active connections":0,"P
egen:
<code sql>
create user cman_tdm identified by "SecretPWD2023";
grant connect to cman_tdm;
</co... tigen:
<code sql>
create user gpipperr identified by "GanzAnderesPWD2023";
grant connect,resource to g... 92: functionality (Logon as SYSDBA) not supported by Oracle Connection
Manager in Traffic Director mod... 92: functionality (Logon as SYSDBA) not supported by Oracle Connection
Manager in Traffic Director mod
>
#create minimal user
create user gpi identifed BY gpi;
grant create session to gpi;
#alter the ta...
where client like upper('&&SCHEMA_NAME.')
order by 1
/
</code>
Dieser User darf sich an welches Sc... ies
where proxy like upper('&&USER_NAME.')
order by 1
/
</code>
=== Angemeldeten User in der DB prüf... _trail b on (a.proxy_sessionid=b.sessionid)
order by a.timestamp
/
</code>
=== Selects über Proxy a
DATABASE LINK MSSQL01 CONNECT TO "sa" IDENTIFIED BY "ora123Login" using 'MSSQL01';
</code>
Nun kann ... *
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrie... s
where parameter in ('NLS_CHARACTERSET')
order by 2
/
NLS DB Character Set Setting
---------... ase link dg4Netbox connect to "dbuser" identified by "dbuser_pwd" using 'dg4NetBoxTNS';</code> auf die
the Job User
create user job_control identified by job$100;
grant connect,resource to job_control;
g... ,username
FROM user_credentials
ORDER BY credential_name
/
</code>
----
===Einen Job d... ain
,enabled
FROM user_credentials
ORDER BY credential_name
/
</code>
Tip: Welche Domain v... r_job_run_details
WHERE job_name='ETL_JOB'
order by actual_start_date
/
</code>
Testen wir mal was
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
LOGFILE 'DWH_OP_COMMAND':'readCr... ODISCARDFILE
SKIP 0
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' MISSING FIELD VALUES ARE NULL
( line_no RECNUM
...
So ist es richtig!
<code bash>
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' MISSING FIELD VALU