Month: September 2017

Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Rac Voting Disk

The Voting Disk File is a file on the shared cluster system or a shared raw device file.

Voting disk a key component of clusterware and its failure can lead to inoperability of the cluster.

In RAC at any point in time the clusterware must know which nodes are member of the rso that

it can perform load balancing
In case a node fails, it can perform failover of resources as defined in the resource profiles
If a node joins, it can start resources on it as defined in OCR/OLR
If a node joins, it can assign VIP to it in case GNS is in use
If a node fails, it can execute callouts if defined

Adding	crsctl add css votedisk <file>
deleting	crsctl delete css votedisk <file>
querying	crsctl query css votedisk

APPS DBAAppsDBA ScriptsScripts

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

Checking for existence of the ACL ….

DECLARE

ERROR at line 1:

Database ScriptsScripts

DECLARE
i INTEGER;
BEGIN
dbms_output.Put_line(‘Table Name,Row Count,’
|| To_char(SYSDATE, ‘DD-MON-YYYY HH24:MI:SS’));

FOR v_table IN (SELECT ut.table_name
FROM user_tables ut) LOOP
EXECUTE IMMEDIATE ‘select count(*) from ‘|| v_table.table_name INTO i;

dbms_output.Put_line(v_table.table_name
|| ‘,’
|| To_char(i));
END LOOP;
END;