DATA\VDS\EXAMPLE01.DBF conflicts with a file used by the target database
RMAN-05001: auxiliary file na... RADATA\VDS\USERS01.DBF conflicts with a file used by the target database
</code>
Lösung:
Wenn man s... covery_dest_file='YES' and name is not null
group by applied,deleted,decode(rectype,11,'YES','NO') order by 5
/
</code>
Falls keine Archivelogs als reclaima
ME')
and a.name like lower ('%repair%')
order by a.name
, g.name
/
--setzen:
ALTER DISKGR... r
and dg.name like upper ('&&DG_NAME')
order by f.file_number
/
=> Hier sind nun noch all Dateie... ROM v$asm_disk
where name like 'DBFAST%'
ORDER BY GROUP_NUMBER;
</code>
Alle Platten vom Storage ... here d.path like upper ('%-_02') ESCAPE '-'
group by d.FAILGROUP,g.name
;
# Erzeugte SQL Statements n
ITEST**
<code sql>
create user BESTDBA identified by "xxxxxxxx";
grant connect, resource to BESTDBA
g... ROD**
<code sql>
create user BESTDBA identified by "xxxxxxx";
grant connect, resource to BESTDBA;
g... SE LINK DP_TRANSFER CONNECT TO BESTDBA IDENTIFIED BY "xxxxxxx" USING 'GPITSTDB';
SQL> select global_... ASE LINK mylink CONNECT TO remote_user IDENTIFIED BY remote_pwd USING 'remote_db';
</code>
Ist das P
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
usr,'n/a') not in ('SYS','SYSMAN','DBSNMP')
GROUP BY TO_CHAR (log_date, 'dd/mm hh24')||'h'
,nv... ,ERR_NR
,substr(ERR_MSG,1,200)
order by 2,1
;
------------------------------------------... usr,'n/a') NOT IN ('SYS','SYSMAN','DBSNMP')
GROUP BY nvl(LOG_USR,'n/a')
,ERR_NR
,substr(ERR_MSG,1,300)
ORDER BY 2,1
/
ttitle left "SQL Error Hour Report" ski
,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
from all_objects
where status !='VALID'
group by owner,object_type order by 2;
-- 1. Alle ungültigen Objekte neu übersetzen
spool alter_obj.sql
sel... tatus !='VALID' and object_type !='SYNONYM' order by owner;
spool off
-- 2. Alle ungültigen Synonyme ... from all_objects where status !='VALID'
order by owner
spool off
</code>
Die obigen erzeugten Sk
>
#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
DB aufgebaut wird.
----
==== Audit Log "LOGOFF BY CLEANUP" Events auswerten====
Ist das Auditing a... nden.
Im Audit Log taucht dann der Event "LOGOFF BY CLEANUP" auf.
Auswerten:
<code sql>
select ... and sysdate
and action_name like 'LOGOFF BY CLEANUP'
order by extended_timestamp
/
</code>
Mit der zeitlichen Information kann dann in weiteren
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
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
.metric_label = 'User-Defined SQL Metrics'
group by m.key_value
, m.target_name
)
group BY udm_name
order by udm_name
/
------------ Mehr Details:
SELECT m.key_value udm_name
... cs'
AND m.metric_guid = t.metric_guid
group by m.key_value
, t.warning_threshold
, t.cri
e => machine) as ip_adress
from v$session
group by machine
/
CONNECTIONS MACHINE ... _adress
from DBA_HIST_ACTIVE_SESS_HISTORY
group by lower(machine)
/
</code>
Nicht alle Name... er (‘primgpi01’),upper (‘primgpi01.local’))
group by userhost,comment_text
order by 1
/
....
1 primgpi01.local Authenticated by: DATABASE; Client addres
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