a
inner join v$asm_diskgroup g on (g.group_number=a.group_number)
where g.name like upper ('&&DG_NAME')
and a.name like lower ('%repair%')
order by a.n... 016-09-05 23:32:18.947 [OCSSD(3111)]CRS-1606: The number of voting files available, 2, is less than the minimum number of voting files required, 3, resulting in CSSD te
E, INDEX, or CLUSTER)
unformatted_blocks Total number of blocks that are unformatted
unformatted bytes Total number of bytes that are unformatted
fs1_blocks Number of blocks that has at least 0 to 25% free space
fs1_bytes Number of bytes that has at least 0 to 25% free space
fs
d disk UFS:/dev/oracleasm/disks/VOT1_02 with disk number:3 and timestamp (33039887 -1916262400)
Identified disk UFS:/dev/oracleasm/disks/VOT1 with disk number:0 and timestamp (33039532 -1177383936)
Identified... :/opt/oracle/VOTNFSDISK/vote_nfs_disk01 with disk number:2 and timestamp (33039765 973622272)
Checking for... d disk UFS:/dev/oracleasm/disks/VOT1_02 with disk number:3 and timestamp (33039887 -1916262400)
Identified
n the last days" skip 2
select dbid
, instance_number
, snap_id
, to_char(end_interval_time,'hh24:m... ime > trunc(sysdate-1)
order by snap_id, instance_number
/
clear break
ttitle off
set feedback off
set ... spool_name_col new_val spool_name
column instance_number new_val inst_nr
column aktdbid new_val databaseid...
,SYS_CONTEXT('USERENV','INSTANCE') as instance_number
FROM dual
/
select dbid as aktdbid
from v$da
atz ist, nicht ändern!
<code bash>
select group_number, name, compatibility, database_compatibility from... a
inner join v$asm_diskgroup g on (g.group_number=a.group_number)
where g.name like upper ('&&DG_NAME')
and a.name like lower ('%repair%')
order by a.n... 2.16.4.el7uek.x86_64.
ACFS-9326: Driver build number = 180522.
ACFS-9212: Driver build version = 1
DICTIONARY to gpi;
connect gpi/gpi
variable num number
begin
select count(*) into :num from v$session;
... lossen.
create or replace function p_test
return number
as
v_count number;
begin
select count(*) into v_count from v$session;
return v_count;
end;
/
Prozedur w... ALOG_ROLE to gpi;
connect gpi/gpi
variable num number
begin
select count(*) into :num from v$session;
Beispiel:
<code sql>
with function iconvert(p_id number)
return number
is
begin
return p_id*2;
end;
select iconvert(2) from dual
/
ICONVERT(2)
... sql>
select * from (
with function iconvert(p_id number)
return number
is
begin
return p_id*2;
end;
select iconvert(2) from dual
)
/
ERROR at l
dbupgrade.cmd -n 4 -l d:\temp\19cUpgrade
......
Number of Cpus = 8
Database Name = GPI
Da... ILENAME: c:\temp\upgrade19c\catupgrd0.log AT LINE NUMBER: 811762
-----------------------------------------... pgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DB...
INFO: Next is a list of all upgraded tables:
...
Number of failures: 0
Table list: "APEX_190100"."WWV_FLO
n mit
<code>
# /usr/sbin/patchadd -p | grep patch_number(without version number)
wie
/usr/sbin/patchadd -p | grep 139574
</code>
Falls nicht gefunden über http:/... mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"DB_DATA"
SQL> SELECT group_number, disk_number, mount_status, header_status, state,
ace procedure kill_other_session( p_sid in number
, p_serial# in number
, p_inst_id in number default null
... v_sql sys.dbms_sql.varchar2a;
v_cursor number;
v_result pls_integer;
v_sys_user_id number
ARAM_UB4 Control file block number
Data Block Integrity Check BLC_DF_N... DBKH_PARAM_UB4 File number
Data Block Integrity Check BLC_BL_N... DBKH_PARAM_UB4 Block number
Dictionary Integrity Check CHECK_MA... n ID
Undo Segment Integrity Check USN_NUMBER DBKH_PARAM_TEXT Un