ng setzen (ORACLE_HOME und ORACLE_SID!)
sqlplus / as sysasm
select * from v$asm_disk;
</code>
===DIA... Features zu nützen.
als Grid user mit sqlplus / as sysasm:
<code sql>
ALTER DISKGROUP DATA01 SET ATT...
</code>
Platte einbinden
<code sql>
sqlplus / as sysasm
alter diskgroup DATA01 add disk 'AFD:DWHD... * Zeichensatz und Password vergeben
* Create as Container abwählen
* Next
- **Prequisite ch
ichtlinien) zuweisen:
Single Instance
* Log on as a batch job
* Log on as a service
RAC
* Act as part of the operating system
* Adjust memory quotas for a process
* Bac... ren lassen
* Datenbank mit <code sql> sqlplus / as sysdba ; @?/rdbms/admin/utlrp.sql </code>neu über
ECT UTL_INADDR.get_host_address('www.pipperr.de') as result FROM dual;
-- NS Lookup auf ein IP Adresse
SELECT UTL_INADDR.get_host_name('10.10.10.1') as result FROM dual;
-- Name des DB Servers
SELECT UTL_INADDR.get_host_name as result FROM dual;
-- die IP Adresse des Datenbank Servers
SELECT UTL_INADDR.get_host_address as result from dual;
</code>
Netze und [[http://www
E,'-'),'IOT',' index organised','heap organised') as TABLE_TYPE
from dba_tables
where table_name ... E,'-'),'IOT',' index organised','heap organised') as TABLE_TYPE
from dba_tables
where upper(table_... OT Tab|Name"
select i.owner
, i.table_name as iot_name_table
, nvl(t.table_name,'-') as overflow_table
, nvl(i.index_name,'-') as index_n
EPEAT_INTERVAL,js.next_run_date,js.next_run_date) as over_next_run_date
, js.state||' - '||js.job_action as job_info
from dba_scheduler_jobs js
... a20
select jc.job_class_name
, jc.service as job_class_service
, cg.consumer_group
, pd.plan as resource_plan
, sw.window_name as job_window
berprüfen mit:
<code sql>
select count(*) as count_log
, min(log_date) as first_log
, max(log_date) as last_log
, trunc(max(log_date)) -trunc(min(log_date)) as log_tage
from dba_scheduler_job_log
/
C
Prüfen ob alle Anwender sich anmelden können, SYS AS SYSDBA über SQL*Net testen
- Prüfen ob das ADRC... Umgebung als sys ausführen
<code sql>
sqlplus / as sysdba
@C:\oracle\cfgtoollogs\GPI\preupgrade\pre... code powershell>
$ENV:ORACLE_SID="GPI"
sqlplus / as sysdba
startup upgrade
exit
</code>
Zur Überw... d 60 Minuten.
<note tip>Prüfen das ein sqlplus / as sysdba sich sehr schnell anmelden kann! In meinen
te in der DB "reparieren"]]
<code bash>
sqlplus / as sysdba
SQL> select owner
,object_type
,count(*) as anzahl
from all_objects
where status!='VALID'
g...
Papierkorb der DB Löschen
<code bash>
sqlplus / as sysdba
SQL>PURGE DBA_RECYCLEBIN;
</code>
Überp... gebung auf die "Alte" Datenbank setzen
sqlplus / as sysdba
sql>spool upgrade_info.log
sql>@/opt/orac
,to_char(LAST_START_DATE, 'DD.MM.YYYY HH24:MI') as LAST_START_DATE
,to_char(NEXT_RUN_DATE, 'DD.MM.YYYY HH24:MI') as NEXT_RUN_DATE
from dba_scheduler_jobs
where jo... b should not run in 11g!
prompt ... to delete use as sys user: exec dbms_scheduler.drop_job(job_name =... id
,to_char(log_date, 'DD.MM.YYYY HH24:MI') as log_date
,owner
,job_name
,stat
ime => 72h
<code bash>
--abfragen:
select g.name as group_name
, a.name
, a.value
, a.SYS... isk must complete.
The misscount parameter (MC), as stated above, is the maximum time, in seconds, th... s user grid mit gesetzter ASM Umgebung
sqlplus / as sysasm
create diskgroup DBFAST NORMAL REDUNDANCY... noten 2 anmelden als sysasm:
<code sql>
sqlplus / as sysasm
alter diskgroup DBFAST mount;
</code>
-
resolve syntax highlight bug FROM my editer .-(
AS SPOOL_NAME_COL
FROM dual
/
spool &&SPOOL_NAME
s...
o.owner
, o.object_name
, c.name as column_name
, u.equality_preds
, u.range_... e)
for column_position
in ('1' as pos1
,'2' as pos2
,'3' as pos3
,'4' as pos4
,'5'
9999
column mesg format A30
SELECT COUNT (*) as anzahl
,TO_CHAR (log_date, 'dd/mm hh24')||'h' as hour
,nvl(LOG_USR,'n/a') as LOG_USR
,ERR_NR
,substr(ERR_MSG,1,200) mesg
F... resolve syntax highlight bug FROM my editer .-(
AS SPOOL_NAME_COL
FROM dual
/
set verify off
SET l