Monthly Archives: December 2014

The 2014 Year in Review

The stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 100,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 4 days for that many people to see […]

Exadata Flash Grid disk and configure as normal Flash

Step-1 Remove or move database or any contents to some another ASM Disk group Step-2 Drop ASM disk group which was create on flash disk Step-3 Drop all the flash grid disk CellCLI> drop griddisk all prefix=flashdisk force GridDisk FlashDisk_FD_00_exa1cel01 successfully dropped GridDisk FlashDisk_FD_01_exa1cel01 successfully dropped GridDisk FlashDisk_FD_02_exa1cel01 successfully dropped GridDisk FlashDisk_FD_03_exa1cel01 successfully dropped GridDisk […]

Viewing Volume and ACFS Information

SELECT AS diskgroup, v.volume_name, v.volume_device, v.mountpath FROM V$ASM_DISKGROUP dg, V$ASM_VOLUME v WHERE dg.group_number = v.group_number and = ‘DATA’; SELECT AS diskgroup, v.volume_name, v.bytes_read, v.bytes_written FROM V$ASM_DISKGROUP dg, V$ASM_VOLUME_STAT v WHERE dg.group_number = v.group_number and = ‘DATA’; SELECT volume_name,size_mb,state,usage,volume_device,mountpath FROM v$asm_volume; SELECT volume_name,reads,writes,read_errs,bytes_read,bytes_written FROM v$asm_volume_stat; SELECT fs_name, vol_device, primary_vol, total_mb, free_mb FROM […]

Warning: VKTM detected a time drift

Cause This problem is due to the Bug 11837095 – “TIME DRIFT DETECTED” APPEARS INTERMITTENTLY IN ALERT LOG” Solution Time drift” error is a ” message which can be ignored, to remove the “Warning: VKTM detected set event 10795 or Apply patch 11837095 SQL> alter system set event=”10795 trace name context forever, level 2” scope=spfile; […]

ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1″ ORA-29280: invalid directory path

Got the following error on a RAC database, after investigation it turns out to be a Oracle Configuration Manager (OCM) error as we don’t use this product its safe to  just disable the jobs Errors in file /u01/app/oracle/diag/rdbms/ANARDEV/ANARDEV1/trace/ANARDEV1_j001_113131.trc: ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1″ ORA-29280: invalid directory path ORA-06512: at “ORACLE_OCM.MGMT_DB_LL_METRICS”, line […]

Find serial number of Exadata Server/Storage

-> show /SP system_identifier /SP Properties: system_identifier = Exadata Database Machine X4-2 AK00247387

Resource Control in Exadata

[root@bakuexa1celadm01 ~]# /opt/oracle.SupportTools/resourcecontrol -show [INFO] Validated hardware and OS. Proceed. [SHOW] Number of cores active per socket: 3 [SHOW] Number of harddisks active – 6. [SHOW] Number of flashdisks active – 8.

Find Hidden Parameters in Oracle

SELECT x.ksppinm name, y.ksppstvl VALUE, decode(ksppity, 1, ‘BOOLEAN’, 2, ‘STRING’, 3, ‘INTEGER’, 4, ‘PARAMETER FILE’, 5, ‘RESERVED’, 6, ‘BIG INTEGER’, ‘UNKNOWN’) typ, decode(ksppstdf, ‘TRUE’, ‘DEFAULT VALUE’, ‘FALSE’, ‘INIT.ORA’) isdefault, decode(bitand(ksppiflg / 256, 1), 1, ‘IS_SESS_MOD(TRUE)’, ‘FALSE’) isses_modifiable, decode(bitand(ksppiflg / 65536, 3), 1, ‘MODSYS(NONDEFERED)’, 2, ‘MODSYS(DEFERED)’, 3, ‘MODSYS(*NONDEFERED*)’, ‘FALSE’) issys_modifiable, decode(bitand(ksppstvf, 7), 1, ‘MODIFIED_BY(SESSION)’, 4, ‘MODIFIED_BY(SYSTEM)’, […]

Exadata Cell Offloading

oracle@anarexadatatest:~$ ps -afe | grep smon  root 1536 1 0 Nov 07 ? 360:16 /u01/app/  oracle 2260 1 0 Nov 07 ? 0:46 asm_smon_+ASM1  oracle 18359 1 0 Dec 03 ? 1:03 ora_smon_ANARDEV1  oracle 74887 1 0 Dec 03 ? 1:05 ora_smon_ANARLIVE1  oracle 36115 30639 0 11:43:29 pts/15 0:00 grep smon oracle@anarexadatatest:~$ oracle@anarexadatatest:~$ export ORACLE_SID=ANARDEV1 […]

Start and Stop Cell Server

1. Start and stop through OS command Stop: Login as a root or celladmin and execute below command to stop services. [root@bakuexa1dbadm01 ~]# service celld stop Stopping the RS, CELLSRV, and MS services… The SHUTDOWN of services was successful. Start: [root@bakuexa1dbadm01 ~]# service celld start Starting the RS, CELLSRV, and MS services… Getting the state […]

How to change password of CISCO switch on Exadata ?

Login you system and telnet to cisco switch $ telnet telnet> enable Prepare to configure switch ciscoswitch-ip# configure terminal exapsw-ip(config)#line vty 0 15 exapsw-ip(config-line)#login Change the password exapsw-ip(config-line)#password newpassword exapsw-ip(config-line)#login exapsw-ip(config-line)#end Save the changes to the switch exapsw-ip#write memory Building configuration… Compressed configuration from 4001 bytes to 1608 bytes[OK] exapsw-ip#

Database is running on Exadata?

You want to know that whether your database is running on Exadata or not than you can check with below query. If this query gives the output >0 than database is running on Exadata. SQL>select count(*) from (select distinct cell_name from gv$cell_state); COUNT(*) ————          3 Note: It means database is running on […]

Exadata Dictionary Views

Get Cell Definition V$CELL GV$CELL Exadata cell effectiveness and statistics V$SYSSTAT V$SEGMENT_STATISTICS V$SQL Historical view of the types and frequencies of the requests being run by a cell. V$CELL_REQUEST_TOTALS Cell Performance Statistics V$CELL_STATE Display Exadata Cell Threads V$CELL_THREAD_HISTORY Backup Related View V$BACKUP_DATAFILE

Cellcli – Help

CellCLI> help HELP [topic]     Available Topics:         ALTER         ALTER ALERTHISTORY         ALTER CELL         ALTER CELLDISK         ALTER GRIDDISK         ALTER IBPORT         ALTER IORMPLAN         ALTER LUN […]


[root@ed02dbadm pwrstat]# ipmitool sensor|grep Watts VPS_CPUS     | 70.000   | Watts    | ok   | na    | na    | na      | na     | na      | na VPS_MEMORY   | 22.000   | Watts    | ok   | na    | na    | na      | na     | na      | na VPS_FANS     | 10.000   | Watts    | ok   | na    | na    | […]

Verifying You InfiniBand Network Topology

cd /opt/oracle.SupportTools/ibdiagtools root@bakuexa1dbadm01:/opt/oracle.SupportTools/ibdiagtools# ./verify-topology [ DB Machine Infiniband Cabling Topology Verification Tool ] [Version IBD VER 2.d ] Found 2 leaf, 0 spine, 0 top spine switches Check if all hosts have 2 HCAs to different switches……………[SUCCESS] Leaf switch check: cardinality and even distribution………….. [ERROR] Leaf Switch with GUID 0x10e04069bba0a0 has fewer than 4 […]


1. Removing files older than 14 Days from the current working directory find . -type f -mtime +14 -exec rm -f {} \; 2. Finding the top 5 largest files from the current working directory find . -ls | sort -nrk 7 | head -5 3. Find files larger than 100MB from the current working […]

Communication error with the OPMN server local port

root@aza # ./opmnctl startall opmnctl: starting opmn and all managed processes… Communication error with the OPMN server local port. Check the OPMN log files Communication error with the OPMN server local port. Check the OPMN log files Communication error with the OPMN server local port. Check the OPMN log files Communication error with the OPMN […]

Exadata Diskgroup is not compatible for database usage

Error: Diskgroup “+DATA” is not compatible for database usage. Database compatible attribute of diskgroup should be the same or lower than the database compatible initialization parameter value. Database compatible parameter is set to “” and the diskgroup database compatibility attribute is set  to “”.   Solution: go to OH/assistants/dbca/templates and edit the line name=”compatible” value=”″    <InitParamAttributes>       <InitParams>          <initParam name=”db_name” […]

Configure cluster interconnects

Perform the following steps to configure cluster interconnects. 1) On each database instance, log in as sysdba and enter the following queries. For example: alter system set cluster_interconnects=’′ scope=spfile sid=’ANARLIVE1′; alter system set cluster_interconnects=’′ scope=spfile sid=’ANARLIVE2′; 2)  Restart the database. 3) You can verify the cluster_interconnects on each system using following sql query: select * […]