COLUMN object_name FORMAT A40 COLUMN number_of_blocks FORMAT 999,999,999,999 SELECT o.object_name, COUNT(*) number_of_blocks FROM DBA_OBJECTS o, V$BH bh WHERE o.data_object_id =…
Solution: This happens when you havea RAC setup and you are backing up the Snapshot of the controlfile to a…
TESTING A PHYSICAL STANDBY DATABASE IN ORACLE 10G Using SNapshot Standby This procedure is very useful when you have physical…
1. On Server 1 (192.168.1.67) ssh-keygen -t rsa cd .ssh/ scp -r id_rsa.pub root@192.168.1.68:/root/.ssh/authorized_keys 2. On Server 2 (192.168.1.68) ssh-keygen…
A 600 slide presentation by Oracle DB Product Manager Mike Dietrich, to upgrade and migrate to Oracle 12c. Upgrade_and_Migrate_12c
SLOB Sustained Throughput Test: Running SLOB. via SLOB Sustained Throughput Test: Running SLOB.
The restart of a UNIX server call initialization scripts to start processes and daemons. Every platform has a unique directory…
After a memory upgrade in our RAC servers, the Cluster wasn’t coming up after a reboot. We first tried to…
Error: Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; Solution: This error has everything…