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
lly.
# Was wird erzeugt
cat cman.ora
#----ADDED BY CMAN 18-MAY-2015 09:29:34---
password_cman_gpi = ... sswort ändern<code sql>alter user xxxx identified by hugo;</code>
* Im Trace nach dem "alter user" s... ...a
................."alter user xxxx identified by hugo.........
10:58:02.477553 IP (tos 0x0, ttl 64
,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
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
d sw.resource_plan(+)=pd.group_or_subplan
order by 1
/
</code>
===== Probleme =====
siehe auch [... e) as log_date
from dba_scheduler_job_log
group by owner
, job_name
)
, last_logs as (
se... only active Jobs
and state != 'DISABLED'
order by j.owner,j.job_name
;
</code>
----
===== Quell
Oracle POST-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
... on.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script
WHERE spw_stoplist LIKE 'DEFAULT_STOPLIST'
order by spw_word;
</code>
Auslesen per Package siehe auc... where owner='CTXSYS' and status != 'VALID' order by object_name;
</code>
* Siehe auch dazu Suppo... SYS schema you must"connect / as sysdba" followed by "alter session set CURRENT_SCHEMA=CTXSYS;"
sqlpl... , par_value
from ctxsys.ctx_parameters
order by 1
/
ttitle left "Oracle Text Preferences" ski